SAP table T161P (Check of Document Type, Document Category, Item Category)

SAP table T161P has 4 primary key fields being MANDT,BSART,BSTYP,PSTYP.

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
BSART Purchasing Document Type CHAR 4 0 T161 ESART
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
PSTYP Item category in purchasing document CHAR 1 0 T163 PSTYP
/SAPMP/EINFO Characteristic Values from Purchasing Info Record CHAR 1 0 /SAPMP/EINFO
No Data Transfer
1 Transfer Primarily from Purchasing Info Record
2 Transfer Primarily from the Global Item

T161P foreign key relationships

Table Field Check Table Check Field
0 T161P BSART T161 Purchasing Document Types MANDT
1 T161P MANDT T000 Clients MANDT
0 T161P PSTYP T163 Item Categories in Purchasing Document MANDT
0 T161P PSTYP T163 Item Categories in Purchasing Document PSTYP