list with 'sales order' + 'Item' + 'Incoterms' + 'with shipped orders'

[Former Member]

Hello all

anyway I can get a list with 'sales order' + 'Item' + 'Incoterms' + 'with shipped orders'.

Thanks

[Lakshmipathi · Accepted solution]

Dear Sharmishta

Go to SE16 and enter table VBAP.

Thanks

G. Lakshmipathi

[Former Member · Accepted solution]

Hello there

I don't think I see any incoterms fields in VBAP [like in LIKP], neither is there a WADAT_IST(goods movement date)

could you maybe explain where are the incoterms /shipped date in VBAP ?

Thx.

[Former Member · Accepted solution]

a step ahead, but 2 steps back..

I have done a join of VBAP and LIKP with sqvi, chosen the required fields ,but on executing the join, I recieve 'no data selected'.

eventhough VBAP and LIKP are full of data.

so I am still at odds with list with 'sales order' + 'Item' + 'Incoterms' + 'with shipped orders'.

Can someone pl. throw some light here ?

Thanks

[Lakshmipathi · Accepted solution]

Dear Sharmishta

As you rightly said through Table Join VBAP and LIKP, you should be able to get the required data. But I dont know why you are not getting. Can you check with the same table join by giving ONLY the delivery number as output.

Thanks

G. Lakshmipathi

[Former Member · Accepted solution]

HI!

The incoterms are part of the sales order- billing data. They would be there in the VBKD table. You can do a join between, VBAK, VBAP VBKD and VBUP.

VBAK becasue for selecting the parameters like creation date, sales area. VBAP for line items, VBKD for incoterms, and VBUP for checking if delivery is done or not.

Regards,

Abhishek

http://abhishek.purwar.googlepages.com

[Former Member · Accepted solution]

Abhishek and all , this advise has really helped. Finally, if I want to also go for the ‘shipping dates’(keeping the above combination intact), what then ?

Thanks People

[Manoj_Mahajan78]

Sharmishtha,

I think Above clarification will solve your issue..

Join all 4 tables listed above.

Regds'

MM