This website is not affiliated with, sponsored by, or approved by SAP AG.

query with message type

Logistics : SD and its sub-modules (Inquires, Quotes, Order Entry, SIS, Sales Contacts, Dist. & Billing)

Moderators: Snowy, thx4allthefish, mike_ac, Lost Identity

Post Reply
Posts: 12
Joined: Fri Jan 22, 2010 2:43 am

query with message type

Post by costertje » Tue Nov 06, 2018 8:01 am


I'm trying to make a query with sales document numbers and a specific messagetype. I've tried to make a join with the tables:
VBAP-VBAK-VBPA-VEDA-NAST but the join isn't working. Maybe I must use different tables or maybe the join is not correct.

Can anyone tell me how I can join the NAST table with the sales document tables?


Posts: 1895
Joined: Thu May 08, 2003 11:44 am
Location: YYZ

Re: query with message type

Post by YYZ_SAP » Wed Nov 07, 2018 9:13 am


I believe table NAST has an object number, which could represent the sales document.
Table NAST also has an application area; V1 for sales documents
Just some pointers I hope.

Jan Pel

Post Reply