topic Re: Idoc data in Application Development and Automation Discussions

Idoc data

Former Member — Tue, 13 Sep 2016 13:05:49 GMT

Hello,

I have one function module in which the table parameter 'ABC' is defined of type LTAP_VB.

This Parameter 'ABC' is already filled with different material types(MTART) like 'XYZ', 'SDF' etc and other data.

In my source code of the FM, i have a logic as below:

loop at ABC into wa_abc.

select * from mara where matnr = wa_abc-matnr and (mtart = 'XYZ' or mtart = 'SDF').

endloop.

then i need to create an idoc only for the materials which have MTART as 'XYZ' and 'SDF' . but not for other material types.

CALL Function 'L_IDOC_CREATE_WMTOID01'

Exporting

.....

....

Tables

ABC = ABC.

the issue is the table ABC is already having all the material types and thus creates the idocs for all the material types. But i need to create IDOC only for material types XYZ or SDF only. Please let me know if something is missing in my code.

Regards, Guru.

Re: Idoc data

BrijeshGandhi — Tue, 13 Sep 2016 13:29:50 GMT

Hello Gururaj,

Create one temporary table gt_xyz_sdf and move the materials which have MTART as 'XYZ' and 'SDF' .

Finally pass the newly created table to Function Module.

Thanks,

Brijesh Gandhi

Re: Idoc data

Former Member — Tue, 13 Sep 2016 14:10:30 GMT

Hi Brijesh, tried creating a new new table with mtart values fetched. But finally i cant assign to function module as the structure in the table don't have mtart field. so there is type mismatch.

Re: Idoc data

Former Member — Tue, 13 Sep 2016 14:28:16 GMT

I have a FM with table parameter ABC of structure LTAP_VB.

on execution of the tcode, the table ABC is getting filled with all types of MTART in it.

my logic :

Read table ABC into wa_abc.

select * from mara where matnr = wa_abc-matnr and ( matnr = 'xyz' or matnr = 'SDF' ).

then calling the below FM

CALL L_IDOC_CREATE_WMTOID01

Tables

ABC = ABC.

For example if ABC is already having two materials with mtart as XYZ and OPU. But i want idoc to be created only for mtart XYZ and not for OPU as I'm fetching data from mara table .

Regards,

Guru

Re: Idoc data

BrijeshGandhi — Wed, 14 Sep 2016 05:46:41 GMT

Hello Gururaj,

You can apply following logic, no need to create any new table :


loop at  ABC into wa_abc.
     select * from mara  where matnr = wa_abc-matnr and (mtart = 'XYZ' or mtart = 'SDF').
        If sy-subrc = 0.
              CALL  L_IDOC_CREATE_WMTOID01
                    Tables
                         T_LTAP = ABC.
        endif.
endloop.

Re: Idoc data

Former Member — Wed, 14 Sep 2016 06:53:54 GMT

Please do not use Select statement inside Loop.

Use this instead.

IF abc[] is not initial.

SELECT matnr FROM mara INTO table lt_mara

FOR ALL ENTRIES IN abc

WHERE matnr = abc-matnr.

LOOP at abc INTO wa_abc.

****HAVE BINARY SORT on table lt_mara****

READ TABLE lt_mara WITH KEY matnr = wa_abc.

if SY-SUBRC IS INITIAL.

*****CALL YOUR FM.*****

ENDIF.

ENDLOOP.

Re: Idoc data

Former Member — Wed, 14 Sep 2016 07:17:49 GMT

Hi Gururaj,

Please define another internal table of type LTAP_VB (same as ABC) say 'ABC_NEW'. Then use the below algorithm:

If ABC[] is not initial.

select * from mara into it_mara for all entries in abc where matnr = abc-matnr and (mtart = 'XYZ' or mtart = 'SDF').

if sy-subrc = 0.

loop at abc into wa_abc.

read table it_matnr with key matnr = wa_abc-matnr. (sort and do binary search)

if sy-subrc = 0.

append wa_abc to abc_new.

endif.

endloop.

endif.

Endif.

if abc_new[] is not initial.

call the FM L_IDOC_CREATE_WMTOID01 with the internal table ABC_NEW.

endif.

Please let me know if this worked or not.

Regards,

Shayeree