SAP Table T161

Purchasing Document Types

T161 (Purchasing Document Types) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link T161 to other SAP tables.

T161 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BSTYP Purchasing Document Category BSTYP CHAR 1 0
A Request for quotation
B Purchase requisition
F Purchase order
I Info record
K Contract
L Scheduling agreement
Q Service entry sheet
W Source list
BSART Purchasing Document Type ESART CHAR 4 0
BSAKZ Control indicator for purchasing document type BSAKZ CHAR 1 0
T Transport
R Purchase requisition for outline agreement
PINCR Item Number Interval PINCR NUMC 5 0
NUMKI Number range in the case of internal number assignment NUMKI CHAR 2 0
NUMKE Number range in the case of external number assignment NUMKE CHAR 2 0
BREFN Field Selection Key BREFN T162 CHAR 20 0
REFBA Reference document type RFBSA T161 CHAR 4 0
ABVOR Prepopulate Standard Release Order Quantity in Contract ABVOR CHAR 1 0
NULL No
A Yes, pre-set with 1
STAFO Update group for statistics update STAFO TMCB CHAR 6 0
UPINC Item Number Interval for Subitems UPINC NUMC 5 0
STAKO Document with time-dependent conditions STAKO CHAR 1 0
X Yes
NULL No
PARGR Partner Determination Procedure PARGR TVPG CHAR 4 0
NUMKA Number range in case of internal number assignment for ALE NUMKA CHAR 2 0
HITYP Hierarchy category: vendor hierarchy HITYP_LH TLHIT CHAR 1 0
LPHIS Indicator for scheduling agreement release documentation LPHIS CHAR 1 0
X Yes
NULL No
GSFRG Overall release of purchase requisitions GSFRG CHAR 1 0
X Yes
NULL No
VARIANTE Layout TC_VAR CHAR 10 0
SHENQ Only shared lock in case of contract release order SHENQ CHAR 1 0
X Yes
NULL No
KZALE Distributed contract (ALE) KZALE CHAR 1 0
X Yes
NULL No
ABGEBOT Competitive bidding procedure using global percentage bids ABGEBOT CHAR 1 0
X Yes
NULL No
KORNR Correction of miscellaneous provisions KORNR CHAR 1 0
NULL No corrections of miscellaneous provisions
1 Correction of misc. provisions in invoice verification
UMLIF Stock transfer: Take vendor data into account UMLIF CHAR 1 0
X Yes
NULL No
KOETT Contract with delivery schedule KOETT CHAR 1 0
X Yes
NULL No
AR_OBJECT Document type SAEOBJART TOADV CHAR 10 0
KOAKO Contract allowed as release order against contract KOAKO CHAR 1 0
X Yes
NULL No
OICSEGI Quantity schedule creation permitted OIA_CSEGI CHAR 1 0
NULL 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 OIH_RFQREQ CHAR 1 0
NULL 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 WVVKZ CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
XLOKZ Cross-System Transit XLOKZ CHAR 1 0
1 Internal company code transit
2 Cross-company code transit
NULL No cross-system transit
CP_AKTIVE Commitment Plan is Active CP_ACTIVE CHAR 1 0
CPTYPE Category of Commitment Plan CP_TYPE CHAR 1 0
FLS_RSTO Store Return with Inbound and Outbound Delivery FLS_RSTO CHAR 1 0
X Yes
NULL No
MSR_ACTIVE Advanced Returns Management Active MSR_ACTIVE CHAR 1 0
X Adv. Returns Is Active
NULL Adv. Returns Is Not Active
RDP_PROFILE Risk Distribution Plan Profile LOGTRM_RDP_PROFILE L2TC_RDP_PROFILE CHAR 8 0
NUMKC Number Range for SRM Central Contract NUMKC CHAR 2 0
/SAPMP/CEACT Fast Data Entry of Characteristics Is Active /SAPMP/CEACT CHAR 1 0
X Fast Data Entry of Characteristics Is Active
NULL Fast Data Entry of Characteristics Is Not Active
/SAPMP/PDACT Activate Inheritance /SAPMP/PDACT CHAR 1 0
NULL Inheritance Is Active
X Inheritance Has Been Deactivated
/SAPMP/PPROT Log of Characteristic Value Inheritance /SAPMP/PPROT CHAR 1 0
X Issue of an Error List
NULL No Error List
/SAPMP/PUSER Inheritance: Overwrite User Values /SAPMP/PUSER CHAR 1 0
X Values Set by Users May Be Overwritten
NULL Values Set by Users Will Not Be Overwritten
/SAPMP/PAUSW Inheritance of Characteristics Selection List /SAPMP/PAUSW CHAR 1 0
X A Selection List Is Provided for the Characteristics
NULL Characteristics Can Be Chosen from a List
/SAPMP/ATNAM Characteristic name MILL_SE_ATNAM1 CHAR 30 0
/SAPMP/GAUF Global/Local Group May Be Undone /SAPMP/GAUF CHAR 1 0
X Removal of Global/Local Group Is Permitted
NULL Removal of Global/Local Group Is Not Permitted
TOLSL Tolerance Key for Overdraw Tolerance METOLSL TME_TOLS CHAR 4 0
MILL_OMKZ Mill: Use reference characteristics in Purchasing MILL_MM_OMKZ CHAR 1 0
X Yes
NULL No

T161 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T161 AR_OBJECT T161 MANDT TOADV SAP ArchiveLink: Global document types MANDT
T161 AR_OBJECT T161 AR_OBJECT TOADV SAP ArchiveLink: Global document types AR_OBJECT
T161 BREFN T161 MANDT T162 Field Selection, Purchasing Document MANDT
T161 BREFN T161 BREFN T162 Field Selection, Purchasing Document FLREF
T161 HITYP T161 MANDT TLHIT Vendor Hierarchy Category MANDT
T161 HITYP T161 HITYP TLHIT Vendor Hierarchy Category HITYP
T161 MANDT T161 MANDT T000 Clients MANDT
T161 PARGR T161 MANDT TVPG Partner Function Groups MANDT
T161 PARGR T161 PARGR TVPG Partner Function Groups PARGR
T161 RDP_PROFILE T161 MANDT L2TC_RDP_PROFILE Risk Distribution Plan: Profile table MANDT
T161 RDP_PROFILE T161 RDP_PROFILE L2TC_RDP_PROFILE Risk Distribution Plan: Profile table PROFILE
T161 REFBA T161 MANDT T161 Purchasing Document Types MANDT
T161 REFBA T161 BSTYP T161 Purchasing Document Types BSTYP
T161 REFBA T161 REFBA T161 Purchasing Document Types BSART
T161 STAFO T161 STAFO TMCB Update groups STAFO
T161 STAFO T161 MANDT TMCB Update groups MANDT
T161 TOLSL * TME_TOLS Tolerance Key for overdraw tolerance MANDT
T161 TOLSL T161 TOLSL TME_TOLS Tolerance Key for overdraw tolerance TOLSL