Regarding Script

[Former Member]

Hi,

i need to desing return sales order form for that i copied rvorder01 from. transaction va03 is used to print the form. in zrvorder01 i have to maintain the window in which i need to print the following data.

Price KOMVD-KBETR CURR Price

Unit Price KOMVD-KOEIN CUKY Unit Price

Value KOMVD-KWERT CURR Value

Output tax KOMVD-KWERT CURR Output tax

and in another window

Partner SDPARTNERLIST-PARTNER CHAR Ship to party number

Partner Name SDPARTNERLIST-NAME1 CHAR Ship to party name

Partner Street SDPARTNERLIST-STREET CHAR Ship to party Address

Partner Postal Code SDPARTNERLIST-POST CODE1 Ship to party Post Code

Partner City SDPARTNERLIST-CITY1 Ship to party city

but KOMVD and SDPARTNERLIST are structures. can any one tell me how to fetch the data for this.

Thanks & Regards

Munna

[Former Member]

For KOMVD (Sales order item info) you can pick data from VBAP table

and

for SDPARTNERLIST (Ship to Party info) use the KUNNR field from VBAK (Sales order header table) and using KUNNR field reference KNA1 table to get address info.

This shud solve your problem.

PS: Reward points if you find this helpful.

Regards.

[Former Member]

Hi,

Price KOMVD-KBETR CURR Price

Unit Price KOMVD-KOEIN CUKY Unit Price

Value KOMVD-KWERT CURR Value

Output tax KOMVD-KWERT CURR Output tax

and in another window

Partner SDPARTNERLIST-PARTNER CHAR Ship to party number

Partner Name SDPARTNERLIST-NAME1 CHAR Ship to party name

Partner Street SDPARTNERLIST-STREET CHAR Ship to party Address

Partner Postal Code SDPARTNERLIST-POST CODE1 Ship to party Post Code

Partner City SDPARTNERLIST-CITY1 Ship to party city

the above fields in KOMVD structure not available in table VBAP and the fileds in SDPARTNERLIST structures not available in table KNA!

let me know how to search these fields.

Thanks & Regards

Munna