topic Re: Smartforms in Application Development and Automation Discussions

Smartforms

former_member612655 — Thu, 26 Dec 2019 05:06:31 GMT

Hi Experts,

My requirement is based on the sales document number i need to display all material details. for that i designed a query as shown in below. But problem is i am getting only single material details repeatedly as shown in above fig. Can you please help to resolve this problem by getting all material details based corresponding so number

SELECT single

*VBELN

MATNR

ARKTX

MEINS

netpr

kwmeng

netwr

mwsbp

FROM VBAP

INTO  wa_vbap

*for all entries in wa_vbak

WHERE  VBELN = I_vbeln.

Regards,
Bhavani.

Re: Smartforms

former_member1716 — Thu, 26 Dec 2019 06:02:37 GMT

bhavani123,

You have written a Select Single Query from VBAP table to get entries, in this case you will only get one entry irrespective of the number of entries in there.

I would recommend you to change your query as below:

SELECT SINGLE
VBELN
MATNR
ARKTX
MEINS
netpr
kwmeng
netwr
mwsbp
FROM VBAP
INTO  table @data(lt_vbap)
WHERE  VBELN = I_vbeln.
if sy-subrc eq 0.
SORT LT_VBAP by VBELN MATNR.
endif.

The above query will have all the materials related to the Sales order in the internal table LT_VBAP, now you just loop the table inside the smartform and map the fields accordingly so that during each iteration all the line items are picked progressivley.

Regards!

Re: Smartforms

former_member612655 — Thu, 26 Dec 2019 06:43:08 GMT

Thank you Sathish Kumar

Re: Smartforms

former_member612655 — Thu, 26 Dec 2019 06:59:35 GMT

But i am getting error like

Field "table" is unknown. It is neither in one of specified tables nor defined by a "Data" Statement. "Data" Statement.

Re: Smartforms

former_member1716 — Thu, 26 Dec 2019 07:09:19 GMT

bhavani123,

May be because you are using older version, this syntax is only with newer versions.

Recommend you to follow the traditional way declaring the table up front and the use it in your query.

Re: Smartforms

former_member612655 — Fri, 27 Dec 2019 04:53:38 GMT

Can you please help me by sending the select query because i developed a query as shown in below but still i am getting only single material number details.

SELECT
VBELN
MATNR
ARKTX
MEINS
netpr
kwmeng
netwr
mwsbp
FROM VBAP
INTO table it_vbap
**for all entries in wa_vbak
WHERE VBELN = I_vbeln.

Re: Smartforms

Sandra_Rossi — Fri, 27 Dec 2019 05:59:52 GMT

satishkumarbalasubramanian Your code doesn't compile, commas are missing and I_VBELN is not prefixed with @.

Re: Smartforms

Sandra_Rossi — Fri, 27 Dec 2019 06:02:19 GMT

How can you tell that the error is from this particular query and not from anywhere else? (maybe the fault is from the loop or the smart form or between them).

Re: Smartforms

Chintu6august — Fri, 27 Dec 2019 09:14:09 GMT

Hi,

Clear work area before your select query.

Re: Smartforms

former_member1716 — Fri, 27 Dec 2019 10:31:42 GMT

Thanks for the catch sandra.rossi

Hello bhavani123,,

Please find the code below,

SELECT SINGLE
VBELN,
MATNR,
ARKTX,
MEINS,
netpr,
kwmeng,
netwr,
mwsbp
FROM VBAP
INTO  table @data(lt_vbap)
WHERE  VBELN = @I_vbeln.
if sy-subrc eq 0.
SORT LT_VBAP by VBELN MATNR.
endif.

Regards!