SAP table VBEX (SD Document: Export Control: Data at Item Level)

SAP table VBEX has 4 primary key fields being MANDT,VBELN,POSNR,GEGRU.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
VBELN Sales and Distribution Document Number CHAR 10 0 * VBELN
POSNR Item number of the SD document NUMC 6 0 * POSNR
GEGRU Legal Regulation for Legal Control CHAR 2 0 T606G GEGRU
ALNUM Export control class according the legal reg. for legal ctrl CHAR 14 0 T606H ALNUM
EMBGR Grouping for Legal Control CHAR 14 0 T606B EMBGR
GEART License type CHAR 4 0 T606 GEART
GENNR Internal license number CHAR 10 0 EMBK GENNR
EXKUA Exchange rate for export license on requested delivery date DEC 9 5 EXKUA
EXWAE Currency of export license CUKY 5 0 * EXWAE
MODCO Indicator: Manual Change / by System for Export Control CHAR 1 0 MODCO
System created entry
A Entry changed manually, can be overwritten by the system
B Entry changed manually, cannot be overwritten by the system
AHBAS Basis document category for foreign trade processing CHAR 3 0 AHBAS
1AH Receipt / Import: Foreign Trade document - Import
1BE Receipt/Import: Purchase Order Document
1LA Receipt/Import: Inbound Delivery
1LI Receipt/Import: Vendor Master
1WE Receipt/Import: Goods Receipt Document
2AH Dispatch / Export: Foreign Trade Document - Export
2FA Dispatch/Export: Billing Document
2KU Dispatch/Export: Customer Master
2LI Dispatch/Export: Outbound Delivery Document
2VA Dispatch/Export: Sales Document
SECGK Legal Control: Special Characteristics Code for Goods CHAR 5 0 T606D SECGK
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE

VBEX foreign key relationships

Table Field Check Table Check Field
0 VBEX ALNUM T606H Legal Control: Export Control Classes MANDT
0 VBEX ALNUM T606H Legal Control: Export Control Classes ALNUM
1 VBEX EMBGR T606B Legal Control: Grouping Materials MANDT
0 VBEX GEART T606 Legal Control: License Types GEGRU
1 VBEX GEGRU T606G Legal Control: Legal Regulations GEGRU
0 VBEX GENNR EMBK Legal Control: License Master - Header Data GENNR
1 VBEX MANDT T000 Clients MANDT
0 VBEX SECGK T606D Legal Control: Special Characteristic Code for Goods MANDT
0 VBEX SECGK T606D Legal Control: Special Characteristic Code for Goods ALNUM