SAP table T161 (Purchasing Document Types)

SAP table T161 has 3 primary key fields being MANDT,BSTYP,BSART.

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 Purchasing Document Type CHAR 4 0 ESART
BSAKZ Control indicator for purchasing document type CHAR 1 0 BSAKZ
C Subordinate Document
H Hierarchy
R Purchase requisition for outline agreement
T Transport
PINCR Item Number Interval NUMC 5 0 PINCR
NUMKI Number Range of Internal Number Assignment CHAR 2 0 NUMKI
NUMKE Number Range of External Number Assignment CHAR 2 0 NUMKE
BREFN Field Selection Key CHAR 20 0 T162 BREFN
REFBA Reference document type CHAR 4 0 T161 RFBSA
ABVOR Prepopulate Standard Release Order Quantity in Contract CHAR 1 0 ABVOR
No
A Yes, pre-set with 1
STAFO Update Group for statistics update CHAR 6 0 TMCB STAFO
UPINC Item Number Interval for Subitems NUMC 5 0 UPINC
STAKO Document with time-dependent conditions CHAR 1 0 STAKO
PARGR Partner Determination Procedure CHAR 4 0 TVPG PARGR
NUMKA Number range in case of internal number assignment for ALE CHAR 2 0 NUMKA
HITYP Hierarchy Category: Supplier Hierarchy CHAR 1 0 TLHIT HITYP_LH
LPHIS Indicator for scheduling agreement release documentation CHAR 1 0 LPHIS
GSFRG Overall release of purchase requisitions CHAR 1 0 GSFRG
VARIANTE Layout CHAR 10 0 TC_VAR
SHENQ Only shared lock in case of contract release order CHAR 1 0 SHENQ
KZALE Distributed contract (ALE) CHAR 1 0 KZALE
ABGEBOT Competitive bidding procedure using global percentage bids CHAR 1 0 ABGEBOT
KORNR Correction of miscellaneous provisions CHAR 1 0 KORNR
No corrections of miscellaneous provisions
1 Correction of misc. provisions in invoice verification
UMLIF Stock Transfer: Take Supplier Data into Account CHAR 1 0 UMLIF
KOETT Contract with delivery schedule CHAR 1 0 KOETT
AR_OBJECT Document type CHAR 10 0 TOADV SAEOBJART
KOAKO Contract allowed as release order against contract CHAR 1 0 KOAKO
OICSEGI Quantity schedule creation permitted CHAR 1 0 OIA_CSEGI
no creation QS, but update reference QS if exist
0 no create,only check vs exist.+related QS,useful in call-off
1 manually creation of Qty.schedule permitted
2 manually/autom. creation QS ONLY if exchange related (=def.)
3 manually/automatically creation QS for all documents
4 like 2,if differs (date+item qty.) autom.change all exist QS
5 like 3,if differs (date+item qty.) autom.change all exist QS
OIRFQREQ Precedence for RFQ or default requisition for TDP PO CHAR 1 0 OIH_RFQREQ
New defaulting at Purchase Order creation
1 Requisition takes precedence over RFQ
2 RFQ takes precedence over Requisition
WVVKZ Indicator for Further Processing of Summarized Documents CHAR 1 0 WVVKZ
XLOKZ Cross-System Transit CHAR 1 0 XLOKZ
No cross-system transit
1 Internal company code transit
2 Cross-company code transit
CP_AKTIVE Commitment Plan is Active CHAR 1 0 CP_ACTIVE
CPTYPE Category of Commitment Plan CHAR 1 0 CP_TYPE
FLS_RSTO Store Return with Inbound and Outbound Delivery CHAR 1 0 FLS_RSTO
MSR_ACTIVE Advanced Returns Management Active CHAR 1 0 MSR_ACTIVE
Adv. Returns Is Not Active
X Adv. Returns Is Active
RDP_PROFILE Risk Distribution Plan Profile CHAR 8 0 L2TC_RDP_PROFILE LOGTRM_RDP_PROFILE
NUMKC Number Range for SRM Central Contract CHAR 2 0 NUMKC
QTN_FOL_DOC_DRAFT_AUTOM Indicator for Follow on Documents of Quote CHAR 1 0 QUOTE_FOLLOW_DOC_INDICATOR
Blank
X Selection
QTN_FOL_DOC_ACTIVE_AUTOM Indicator for Follow on Documents of Quote CHAR 1 0 QUOTE_FOLLOW_DOC_INDICATOR
Blank
X Selection
QTN_FOL_DOC_MANUALLY Indicator for Follow on Documents of Quote CHAR 1 0 QUOTE_FOLLOW_DOC_INDICATOR
Blank
X Selection
RFQ_PROCESS_TYPE External Processing for RFQ and Supplier Quotation CHAR 4 0 MMPUR_RFQ_PR_TY MM_RFQ_PROCESS_TYPE
SCNR_BASED_WFL Flexible Workflow CHAR 1 0 MMPUR_SCBSD_WFL
RFX_PROCESSING_CD RFQ Awarding Type (Internal/External) CHAR 1 0 RFX_PROCESSING_CD
E External
I Internal
AIC_VCM_TYPE Adv. Intercompany Stock Transfer Value Chain Type CHAR 30 0 VCM_CHAIN_TYPE MMPUR_AIC_VCM_TYPE_STO
ITMAC Trade Compliance is active CHAR 1 0 /SAPSLL/ITMAC
/SAPMP/CEACT Fast Data Entry of Characteristics Is Active CHAR 1 0 /SAPMP/CEACT
Fast Data Entry of Characteristics Is Not Active
X Fast Data Entry of Characteristics Is Active
/SAPMP/PDACT Activate Inheritance CHAR 1 0 /SAPMP/PDACT
Inheritance Is Active
X Inheritance Has Been Deactivated
/SAPMP/PPROT Log of Characteristic Value Inheritance CHAR 1 0 /SAPMP/PPROT
No Error List
X Issue of an Error List
/SAPMP/PUSER Inheritance: Overwrite User Values CHAR 1 0 /SAPMP/PUSER
Values Set by Users Will Not Be Overwritten
X Values Set by Users May Be Overwritten
/SAPMP/PAUSW Inheritance of Characteristics Selection List CHAR 1 0 /SAPMP/PAUSW
Characteristics Can Be Chosen from a List
X A Selection List Is Provided for the Characteristics
/SAPMP/ATNAM Characteristic name CHAR 30 0 MILL_SE_ATNAM1
/SAPMP/GAUF Global/Local Group May Be Undone CHAR 1 0 /SAPMP/GAUF
Removal of Global/Local Group Is Not Permitted
X Removal of Global/Local Group Is Permitted
TOLSL Tolerance Key for Overdraw Tolerance CHAR 4 0 TME_TOLS METOLSL
FSH_VAS_ACT VAS Active Flag CHAR 1 0 FSH_VAS_ACT
Not Active
X Active
FSH_VAS_KALSM Determination Procedure CHAR 6 0 FSH_VAS_KALSM
FSH_VAS_DEL Criteria for VAS Deletion during Determination CHAR 1 0 FSH_VAS_DEL
New VAS determination, delete all VAS items
1 New VAS determination, retain manually entered VAS items
FSH_VAS_DETDT Date for VAS Determination CHAR 1 0 FSH_VAS_DETDT
Document Date
1 Delivery Date
FSH_EXCL_RETURN Exclude Return Items CHAR 1 0 FSH_EXCL_RETURN
Flag is not set
X Flag is set; event has occurred
FSH_VAR_KALSM Determination Procedure CHAR 6 0 FSH_VAR_KALSM
FSH_DPR_DETPRO Determination Procedure for Distribution Curve CHAR 6 0 FSH_DPR_DETPRO
FSH_PO_IDOC Generic Article Creation in Purchase Documents CHAR 1 0 FSH_PO_IDOC
FSH_VAS_CORR Correlate VAS Confirmed Quantity CHAR 1 0 FSH_VAS_CORR
FSH_AUTO_DC Automatic distribution indicator CHAR 1 0 FSH_AUTO_DC
FSH_VM_ACT Allow Creation of Purchase Contract with GA Without Variants CHAR 1 0 FSH_VM_ACT
RFM_CONTRACT_CONS Allow contract consumption by structured article components CHAR 1 0 RFM_CONTRACT_CONS
RFM_CONTRACT_DETR Allow contract determination for structured art. components CHAR 1 0 RFM_CONTRACT_DETR
MILL_OMKZ Mill: Use reference characteristics in Purchasing CHAR 1 0 MILL_MM_OMKZ
SGT_CONT_SEG_IGNORE Allow Blank Segment in Purchase Contract CHAR 1 0 SGT_CONT_SEG_IGNORE
WRF_ENABLE_DATELINE Enable Dateline CHAR 1 0 WRF_ENABLE_DATELINE

T161 foreign key relationships

Table Field Check Table Check Field
0 T161 AIC_VCM_TYPE VCM_CHAIN_TYPE VCM: Value Chain VALUE_CHAIN_TYPE
0 T161 AIC_VCM_TYPE VCM_CHAIN_TYPE VCM: Value Chain VERSION
1 T161 AR_OBJECT TOADV SAP ArchiveLink: Global document types MANDT
1 T161 AR_OBJECT TOADV SAP ArchiveLink: Global document types AR_OBJECT
0 T161 BREFN T162 Field Selection, Purchasing Document MANDT
0 T161 BREFN T162 Field Selection, Purchasing Document FLREF
1 T161 HITYP TLHIT Vendor Hierarchy Category MANDT
0 T161 MANDT T000 Clients MANDT
1 T161 PARGR TVPG Partner Function Groups PARGR
0 T161 RDP_PROFILE L2TC_RDP_PROFILE Risk Distribution Plan: Profile table MANDT
0 T161 RDP_PROFILE L2TC_RDP_PROFILE Risk Distribution Plan: Profile table PROFILE
1 T161 REFBA T161 Purchasing Document Types MANDT
0 T161 RFQ_PROCESS_TYPE MMPUR_RFQ_PR_TY Process Types for RFQ and Supplier Quotation MANDT
1 T161 STAFO TMCB Update groups MANDT
1 T161 STAFO TMCB Update groups STAFO
0 T161 TOLSL TME_TOLS Tolerance Key for overdraw tolerance MANDT
0 T161 TOLSL TME_TOLS Tolerance Key for overdraw tolerance TOLSL