SAP table T161T (Texts for Purchasing Document Types)

SAP table T161T has 4 primary key fields being MANDT,SPRAS,BSART,BSTYP.

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
SPRAS Language Key LANG 1 0 T002 SPRAS
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
BATXT Short Description of Purchasing Document Type CHAR 20 0 BATXT

T161T foreign key relationships

Table Field Check Table Check Field
0 T161T BSART T161 Purchasing Document Types MANDT
1 T161T MANDT T000 Clients MANDT
0 T161T SPRAS T002 Language Keys (Component BC-I18) SPRAS