SE16H Join VBAP and VBAK

Although many SAP consultants say the new transaction code SE16H is for S/4HANA, however I found it exist in the latest version of SAP ERP too.

Input the items table name first VBAP

To create the Outer Join Definition, click the Maint. of Relationships button next to it. 

Sales Document is my single test data

Output field are the test fields I wish to display

Definition of Secondary Tables section

Name of Outer Join Definition is the Header table VBAK

Create button for initial creation

Change button for subsequent changes

Definition of Secondary Tables is the table I wish to retrieve

Output is the Secondary Tables fields I wish to display

Selected Secondary Table section

I need to select the item table of Definition of Secondary Tables and click the Magnifying Glass so that VBAK will appear on the Selected Secondary Table.

Table Field - VBELN is the field name I wish to select and matched.

Method - I chose REFERENCE as I want VBAK-VBELN to reference the VBAP-VBELN

Reference Fld/Constant - table dictionary field name VBELN

From table - I want to use VBAP

Option - I want Exact match

Click Save button when finished

SE16H Join VBAP and VBAK

Testing Result 

Last three fields are from VBAK which are successfully displayed via Outer Joined SE16H


 

ABAP Tips

 

See Also
Unicode Checks

Get help for your ABAP problems
Do you have a ABAP Question?

ABAP Books
ABAP Certification, BAPI, Java, Web Programming, Smart Forms, Sapscripts Reference Books

More ABAP Tips

Main Index
SAP Basis, ABAP Programming and Other IMG Stuff

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG. 
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk. 
 The content on this site may not be reproduced or redistributed without the express written permission of 
www.erpgreat.com or the content authors.