SAP table T161A (Linkage of Requisition Doc. Type to Purchasing Document Type)

SAP table T161A has 6 primary key fields being MANDT,BANBS,BANPT,BSTTP,BSTBS,BSTPT.

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
BANBS Purchase Requisition Document Type CHAR 4 0 T161 BANBS
BANPT Purchase requisition item category CHAR 1 0 T163 BANPT
BSTTP 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
BSTBS Document Type: Purchase Order CHAR 4 0 T161 BSTBS
BSTPT Purchase order item category CHAR 1 0 T163 BSTPT
KONTI Indicator: No account assignment CHAR 1 0 KONTI
LFPET Indicator: Contract release order/SA delivery schedule CHAR 1 0 LFPET
DIAKZ Dialog Indicator CHAR 1 0 DIAKZ

T161A foreign key relationships

Table Field Check Table Check Field
0 T161A BANBS T161 Purchasing Document Types MANDT
1 T161A BANPT T163 Item Categories in Purchasing Document MANDT
1 T161A BANPT T163 Item Categories in Purchasing Document PSTYP
0 T161A BSTBS T161 Purchasing Document Types MANDT
1 T161A BSTPT T163 Item Categories in Purchasing Document MANDT
1 T161A BSTPT T163 Item Categories in Purchasing Document PSTYP
0 T161A MANDT T000 Clients MANDT