MEAN extraction

[Former Member]

Hi experts.

I want to extract MEAN table , found 0MAT_UNIT_ATTR , but there is no field LFNUM ( Consecutive Number) it means I can`t extract data with extra unit (lower window with cursor) . Is there any standard extractors?

[gurunathkumar_dadamu · Accepted solution]

Hi Maxim,

Please enhance your standard extractor 0MAT_UNIT_ATTR by adding the filed LFNUM.

1. Go to RSA6--> double click on 0MAT_UNIT_ATTR--> check the extract structure--> add the LFNUM filed in this structure.

2. use BADI  RSU5_SAPI_BADI or user exit RSAP0001.

3. write Select query on MEAN table to get the data for LFNUM based on the material no.

Please let me know if you any issues.

Regards,

Gurunath Kumar D

[Former Member · Accepted solution]

Could U help me with abap (raW version), try to select from MEAN all records, but it select only rec with zLFNUM ='0001'   :

CLEAR NEW_BIW_MARM_S.
i = 1.
     LOOP AT i_t_data ASSIGNING <BIW_MARM_S>  .
       LS_FIELD = <BIW_MARM_S>.
       SELECT SINGLE LFNUM HPEAN MEINH FROM MEAN INTO (<BIW_MARM_S>-zLFNUM, <BIW_MARM_S>-zHPEAN, <BIW_MARM_S>-ZMEINH)
       WHERE  MATNR = <BIW_MARM_S>-MATNR
          AND EAN11 = <BIW_MARM_S>-EAN11        .
       LS_FIELD-zLFNUM = <BIW_MARM_S>-zLFNUM.
       LS_FIELD-zHPEAN = <BIW_MARM_S>-zHPEAN.
       LS_FIELD-ZMEINH = <BIW_MARM_S>-ZMEINH.
       LS_FIELD-zrecord = i.
       i = i + 1.
     
          append LS_FIELD to BIW_MARM_S.
       ENDIF.
      ENDLOOP.

[gurunathkumar_dadamu · Accepted solution]

Hi Maxim,

your coding is working correct.please check matnr,ean11 combination in MEAN table. in your case it is working correct if you need other than LFNUM = 0001 you have to remove ean11 condition in your where condition in select single and also you have to use loop in loop.

Please let me know if you any issues.

Regards,

Gurunath Kumar D

[Former Member · Accepted solution]

Main problem that in source 3 rec and I need to get 4 rec in result (by count of rec in MEAN) Can`t understand where and hoe to append in to result.