issue in smartfrom

[Former Member]

please help me...

In smart form po, based on ekko-ebeln get the multiple line items in ekpo.

based on ekpo pack no pass into esll get some lineitems , my requirement is again pass the esll-subpack no in esll get the

line items how to write select query.

[Former Member]

please help me...

In smart form po, based on ekko-ebeln get the multiple line items in ekpo.

based on ekpo pack no pass into esll get some lineitems , my requirement is again pass the esll-subpack no in esll get the

line items how to write select query.

smartform po issue.txt.zip

[former_member218424]

This message was moderated.

[Former Member]

thanks it working fine

[former_member218424]

This message was moderated.

[Former Member]

Hi,

1). Use the following function module ' MS_FETCH_SPEC_FOR_LIST'

here we have to pass the pack no is enough

2). use the view 'ML_ESLL' here pass the ebeln and ebelp we get complete data related to pack no.

[Former Member]

This message was moderated.

[Former Member]

hi,

hear pack no and sub pack  no different and also one pack no multiple sub pack no is there .

eg: pack no : 123

      subpck.  124,125. like

[Former Member]

here it_service1 contain two sub_pack numbers,based on these sub_pack numbers I want to remaining here sub_pack numbers is more one pack number multiple subpack numbers

[VijayaKrishnaG]

Hi Praveen,

For this kind of requirements FOR ALL ENTRIES is not suggestible or recommended. It is better to use INNER JOINS to get accurate data with good performance.

Regards,

Vijay

[VijayaKrishnaG]

Hi Praveen,

Try this,

SELECT EKKO~EBELN

        EKPO~EBELP EKPO~PACKNO

        ESLL~INTROW

        FROM EKKO INNER JOIN EKPO ON EKPO~EBELN = EKKO~EBELN

                  INNER JOIN ESLL ON ESLL~PACKNO = EKPO~PACKNO

   INTO TABLE LT_DATA

  WHERE EKKO~EBELN IN S_EBELN.      " Input

Regards,

Vijay

[VijayaKrishnaG]

Hi Praveen,

Have you got solved your issue? Do not leave the threads opened.

Regards,

Vijay