Syntax SEL

[Former Member]

hello all,

sorry for asking this simple question, but i cant find any documentation for the complete syntax of BW (since im newbie in BW)
I Want to seek help, regarding on the meaning of this line of code.

"

   sel 'MC04P_0ARB'   mc04p_0arb_tab    mc04p_0arbsetup.

[Former Member]

Wow what?

BW = ABAP.

Paste some more code if you can as this is jibberish...

[Former Member]

im currently checking an urgent issue which need to determine what table extracting data for RSA3..

so im indeed need a help for this..

In application '4'

**************************************************************

CASE s_estruc.
*           extractstruc   internal table    setup table
*-- MM-PUR
        sel 'MC02M_0HDR'   mc02m_0hdr_tab    mc02m_0hdrsetup.
        sel 'MC02M_0ITM'   mc02m_0itm_tab    mc02m_0itmsetup.
        sel 'MC02M_0SCL'   mc02m_0scl_tab    mc02m_0sclsetup.
        sel 'MC02M_0SGR'   mc02m_0sgr_tab    mc02m_0sgrsetup.
        sel 'MC02M_0SCN'   mc02m_0scn_tab    mc02m_0scnsetup.
        sel 'MC02M_0CGR'   mc02m_0cgr_tab    mc02m_0cgrsetup.
        sel 'MC02M_0ACC'   mc02m_0acc_tab    mc02m_0accsetup.
*-- Application '03' (Inventory Management)
        sel 'MC03BF0'      mc03bf0_tab       mc03bf0setup.
        sel 'MC03BX0'      mc03bx0_tab       mc03bx0setup.
        sel 'MC03UM0'      mc03um0_tab       mc03um0setup.
*-- Application '04'
        sel 'MC04P_0MAT'   mc04p_0mat_tab    mc04p_0matsetup.
        sel 'MC04P_0ARB'   mc04p_0arb_tab    mc04p_0arbsetup.
        sel 'MC04P_0COM'   mc04p_0com_tab    mc04p_0comsetup.
        sel 'MC04PE0MAT'   mc04pe0mat_tab    mc04pe0matsetup.
        sel 'MC04PE0ARB'   mc04pe0arb_tab    mc04pe0arbsetup.
        sel 'MC04PE0COM'   mc04pe0com_tab    mc04pe0comsetup.
*-- Application '05' (Quality Management)
        sel 'MC05Q1_0INSP' mc05q1_0insp_tab  mc05q1_inspsetup.
        sel 'MC05Q2_0INSP' mc05q2_0insp_tab  mc05q2_inspsetup.
        sel 'MC05QV0UDN'   mc05qv0udn_tab    mc05qv0udnsetup.
        sel 'MC05Q00NTF'   mc05q00ntf_tab    mc05q00ntfsetup.
        sel 'MC05Q00ITM'   mc05q00itm_tab    mc05q00itmsetup.
        sel 'MC05Q00CSE'   mc05q00cse_tab    mc05q00csesetup.
        sel 'MC05Q00TSK'   mc05q00tsk_tab    mc05q00tsksetup.
        sel 'MC05Q00ACT'   mc05q00act_tab    mc05q00actsetup.
*-- Application '06' (Invoice verification)
        sel 'MC06M_0ITM'    mc06m_0itm_tab    mc06m_0itmsetup.
*-- Application '08 (Transportation)
        sel 'MC08TR0FKP' mc08tr0fkp_tab  mc08tr0fkpsetup.
        sel 'MC08TR0FKZ' mc08tr0fkz_tab  mc08tr0fkzsetup.
        sel 'MC08TR0TK' mc08tr0tk_tab  mc08tr0tksetup.
        sel 'MC08TR0TLP' mc08tr0tlp_tab  mc08tr0tlpsetup.
        sel 'MC08TR0TS' mc08tr0ts_tab  mc08tr0tssetup.
*-- Application '11' (Sales)
        sel 'MC11VA0HDR' mc11va0hdr_tab  mc11va0hdrsetup.
        sel 'MC11VA0STH' mc11va0sth_tab  mc11va0sthsetup.
        sel 'MC11VA0ITM' mc11va0itm_tab  mc11va0itmsetup.
        sel 'MC11VA0STI' mc11va0sti_tab  mc11va0stisetup.
        sel 'MC11VA0SCL' mc11va0scl_tab  mc11va0sclsetup.
        sel 'MC11V_0ITM' mc11v_0itm_tab  mc11v_0itmsetup.
        sel 'MC11V_0SCL' mc11v_0scl_tab  mc11v_0sclsetup.
        sel 'MC11V_0SSL' mc11v_0ssl_tab  mc11v_0sslsetup.
*       SEL 'MC11V_0SSL' MC11V_0SSL_TAB  MC11V_0SCLSETUP.
        sel 'MC11VA0KON' mc11va0kon_tab  mc11va0konsetup.
*-- Application '12' (Shipping)
        sel 'MC12VC0HDR' mc12vc0hdr_tab  mc12vc0hdrsetup.
        sel 'MC12VC0ITM' mc12vc0itm_tab  mc12vc0itmsetup.
        sel 'MC12VC0SCL' mc12vc0scl_tab  mc12vc0sclsetup.
*-- Application '13' (Billing)
        sel 'MC13VD0HDR' mc13vd0hdr_tab  mc13vd0hdrsetup.
        sel 'MC13VD0ITM' mc13vd0itm_tab  mc13vd0itmsetup.
        sel 'MC13VD0KON' mc13vd0kon_tab  mc13vd0konsetup.
*-- Application '17' (plant maintainance)
        sel 'MC17I00NTF' mc17i00ntf_tab  mc17i00ntfsetup.
        sel 'MC17I00ITM' mc17i00itm_tab  mc17i00itmsetup.
        sel 'MC17I00CSE' mc17i00cse_tab  mc17i00csesetup.
        sel 'MC17I00TSK' mc17i00tsk_tab  mc17i00tsksetup.
        sel 'MC17I00ACT' mc17i00act_tab  mc17i00actsetup.
        sel 'MC17I30HDR' mc17i30hdr_tab  mc17i30hdrsetup.
        sel 'MC17I30OPR' mc17i30opr_tab  mc17i30oprsetup.

*-- Application '18' (customer service)
        sel 'MC18I00NTF' mc18i00ntf_tab  mc18i00ntfsetup.
        sel 'MC18I00ITM' mc18i00itm_tab  mc18i00itmsetup.
        sel 'MC18I00CSE' mc18i00cse_tab  mc18i00csesetup.
        sel 'MC18I00TSK' mc18i00tsk_tab  mc18i00tsksetup.
        sel 'MC18I00ACT' mc18i00act_tab  mc18i00actsetup.
        sel 'MC18I30HDR' mc18i30hdr_tab  mc18i30hdrsetup.
        sel 'MC18I30OPR' mc18i30opr_tab  mc18i30oprsetup.
*-- Application (40)
        sel 'MC40RP0REV' mc40rp0rev_tab  mc40rp0revsetup.
*-- Retail POS-Data Cashier
        sel 'MC43RK0CAS' mc43rk0cas_tab  mc43rk0cassetup.
*-- Retail POS-Date Receipts
        sel 'MC44RB0REC' mc44rb0rec_tab  mc44rb0recsetup.
*-- Agency Business
        sel 'MC45W_0HDR' mc45w_0hdr_tab  mc45w_0hdrsetup.
        sel 'MC45W_0ITM' mc45w_0itm_tab  mc45w_0itmsetup.
        sel 'MC45W_0LST' mc45w_0lst_tab  mc45w_0lstsetup.
        sel 'MC45PD0LST' mc45pd0lst_tab  mc45pd0lstsetup.
        sel 'MC45CD0LST' mc45cd0lst_tab  mc45cd0lstsetup.
        sel 'MC45VD0LST' mc45vd0lst_tab  mc45vd0lstsetup.
        sel 'MC45VS0LST' mc45vs0lst_tab  mc45vs0lstsetup.
      WHEN  'MC45W_0CWB'.
        mcapp = s_estruc+2(2).
        CALL METHOD exit->fill_data
          EXPORTING
            i_estruc                     = s_estruc
            i_t_select                   = s_t_select[]
            flt_val                      = mcapp
            i_maximum_size               = s_maximum_size
            i_source                     = i_isource
          IMPORTING
            e_t_data                     = e_t_data[]
            e_flg_no_more_data           = s_flg_no_more_data
          CHANGING
            c_cursor                     = g_cursor
          EXCEPTIONS
            error_passed_to_mess_handler = 1.
***** please insert your application specific data *****
      WHEN OTHERS.
        mcapp = s_estruc+2(2).
        CALL METHOD exit->fill_data
          EXPORTING
            i_estruc                     = s_estruc
            i_t_select                   = s_t_select[]
            flt_val                      = mcapp
            i_maximum_size               = s_maximum_size
            i_source                     = i_isource
          IMPORTING
            e_t_data                     = e_t_data[]
            e_flg_no_more_data           = s_flg_no_more_data
          CHANGING
            c_cursor                     = g_cursor
          EXCEPTIONS
            error_passed_to_mess_handler = 1.
    ENDCASE.                           " s_estruc

[Former Member]

Ah, ok you're looking at MCEX_BW_LO_API.

'sel' is a macro.  If you double-click it, the source code will open.

BTW, the main tables for app 4 are AFKO, AFPO, AFVC.

[Former Member]

thanks for that..
just to add how can i check the process of this macro .. since DEFINE SEL in undebuggable..

[Former Member]

As far as I know, macros can't be debugged.

[Former Member]

so meaning theres no way to determine this process ?

[Former Member]

Not by debugging.  You can check the sourcecode, but macros are a P.I.T.A. if you ask me.

Even SAP thinks it's kinda crappy (from SAP help):

Macros must not include more than a few lines, and should be used sparingly, since it is very difficult to analyze macro errors. Instead of macros, use internal procedures or include programs.

Now, this macro points to the concerning tables which are read, nothing more nothing less.

Apparently it's  implemented to reuse some code and then use the table names as placeholders.

The magic happens outside of this macro.