topic Re: issue in smartfrom in Application Development and Automation Discussions

issue in smartfrom

Former Member — Tue, 27 Jan 2015 11:31:10 GMT

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.

Re: issue in smartfrom

former_member218424 — Tue, 27 Jan 2015 11:44:01 GMT

This message was moderated.

Re: issue in smartfrom

Former Member — Tue, 27 Jan 2015 11:48:54 GMT

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.

Re: issue in smartfrom

Former Member — Tue, 27 Jan 2015 11:55:38 GMT

This message was moderated.

Re: issue in smartfrom

VijayaKrishnaG — Tue, 27 Jan 2015 12:03:35 GMT

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

Re: issue in smartfrom

Former Member — Tue, 27 Jan 2015 12:05:37 GMT

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

Re: issue in smartfrom

Former Member — Tue, 27 Jan 2015 12:11:25 GMT

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

Re: issue in smartfrom

Former Member — Tue, 27 Jan 2015 12:14:05 GMT

thanks it working fine

Re: issue in smartfrom

former_member218424 — Tue, 27 Jan 2015 12:22:38 GMT

This message was moderated.

Re: issue in smartfrom

VijayaKrishnaG — Tue, 27 Jan 2015 13:43:21 GMT

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

Re: issue in smartfrom

VijayaKrishnaG — Wed, 04 Feb 2015 13:51:51 GMT

Hi Praveen,

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

Regards,

Vijay