SAP Table

T161 Purchasing Document Types

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

If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.

/ Fields

T161 columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyBSTYP Purchasing Document Category CHAR 1 0 BSTYP
KeyBSART Purchasing Document Type CHAR 4 0 ESART
BSAKZ Control indicator for purchasing document type CHAR 1 0 BSAKZ
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
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
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
OIRFQREQ Precedence for RFQ or default requisition for TDP PO CHAR 1 0 OIH_RFQREQ
WVVKZ Indicator for Further Processing of Summarized Documents CHAR 1 0 WVVKZ
XLOKZ Cross-System Transit CHAR 1 0 XLOKZ
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
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
QTN_FOL_DOC_ACTIVE_AUTOM Indicator for Follow on Documents of Quote CHAR 1 0 QUOTE_FOLLOW_DOC_INDICATOR
QTN_FOL_DOC_MANUALLY Indicator for Follow on Documents of Quote CHAR 1 0 QUOTE_FOLLOW_DOC_INDICATOR
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
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
/SAPMP/PDACT Activate Inheritance CHAR 1 0 /SAPMP/PDACT
/SAPMP/PPROT Log of Characteristic Value Inheritance CHAR 1 0 /SAPMP/PPROT
/SAPMP/PUSER Inheritance: Overwrite User Values CHAR 1 0 /SAPMP/PUSER
/SAPMP/PAUSW Inheritance of Characteristics Selection List CHAR 1 0 /SAPMP/PAUSW
/SAPMP/ATNAM Characteristic name CHAR 30 0 MILL_SE_ATNAM1
/SAPMP/GAUF Global/Local Group May Be Undone CHAR 1 0 /SAPMP/GAUF
TOLSL Tolerance Key for Overdraw Tolerance CHAR 4 0 TME_TOLS METOLSL
FSH_VAS_ACT VAS Active Flag CHAR 1 0 FSH_VAS_ACT
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
FSH_VAS_DETDT Date for VAS Determination CHAR 1 0 FSH_VAS_DETDT
FSH_EXCL_RETURN Exclude Return Items CHAR 1 0 FSH_EXCL_RETURN
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
/ Relationships

T161 foreign keys.

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