Linking Tables VBAK & VBAP

[Former Member]

Hi

I want to join tables VBAK & VBAP to know the number of Line Items for a Particular Order Type.

I want to join VBAK-AUARTY to VBAP-POSNR.

Can someone provide an idea.

Thanks in Advance

Kalyan

[Former Member]

pls check VBAK-AUARTY or VBAK-AUART.

link between two tables is VBAK-VBELN = VBAP-VBELN.

[Former Member]

Link: http://www.sap-img.com/

Topic:

Free ABAP eBook Download

SAP MM, SD, FI, PS, PP, PM, HR, System Tables

Regards,

Rajesh Banka

Reward points if helpful.

[Former Member]

Link is as below:

VBAK-VBELN=VBAP-VBELN

Regards,

Rajesh Banka

Reward points if helpful.

[Shiva_Ram]

Hi,

You can use transaction code SE16, and use the table VBAP. Enter the order number to see the line items.

Alternatively you can create an ABAP query using transaction code SQ02 and SQ01 and any user can use the query to fetch the details.

Regards

Edited by: Shiva Ram on Jan 29, 2008 2:07 PM