SAP table T163LV (Determination of Confirmation Control Key)

SAP table T163LV has 5 primary key fields being MANDT,BSTYP,BSART,WERKS,LGORT.

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
BSTYP Purchasing Document Category CHAR 1 0 BSTYP
A Request for quotation
B Purchase requisition
C Central Contract
F Purchase order
I Info record
K Contract
L Scheduling agreement
N Central Request for Quotation
O Quotation
Q Service entry sheet
R Request for Quotation
S Simplified service entry sheet
T Central Quotation
W Source list
BSART Order Type (Purchasing) CHAR 4 0 T161 BSART
WERKS Plant CHAR 4 0 T001W WERKS_D
LGORT Storage location CHAR 4 0 T001L LGORT_D
BSTAE Confirmation Control Key CHAR 4 0 T163L BSTAE

T163LV foreign key relationships

Table Field Check Table Check Field
0 T163LV BSART T161 Purchasing Document Types MANDT
1 T163LV BSTAE T163L Confirmation Control Keys BSTAE
0 T163LV LGORT T001L Storage Locations MANDT
0 T163LV LGORT T001L Storage Locations WERKS
1 T163LV MANDT T000 Clients MANDT
0 T163LV WERKS T001W Plants/Branches WERKS