T161 SAP (Purchasing Document Types) Table details
Dictionary Type: Table
Description: Purchasing Document Types
Description: Purchasing Document Types
Table field list including key, data, relationships and ABAP select examples
T161 is a standard SAP Table which is used to store Purchasing Document Types data and is available within R/3 SAP systems depending on the version and release level.
The T161 table consists of various fields, each holding specific information or linking keys about Purchasing Document Types data available in SAP. These include BSTYP (Purchasing Document Category), BSART (Purchasing Document Type), BSAKZ (Control indicator for purchasing document type), PINCR (Item Number Interval).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: G - Customising table which is protected against SAP UpdateDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
Text table = T161T
SAP T161 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BSTYP | Purchasing Document Category | BSTYP | CHAR | 1 | BSTYP | ||||
BSART | Purchasing Document Type | ESART | CHAR | 4 | BSART | BSA | |||
BSAKZ | Control indicator for purchasing document type | BSAKZ | CHAR | 1 | BSAKZ | ||||
PINCR | Item Number Interval | PINCR | NUMC | 5 | PINCR | ||||
NUMKI | Number range in the case of internal number assignment | NUMKI | CHAR | 2 | NUMKR | ||||
NUMKE | Number range in the case of external number assignment | NUMKE | CHAR | 2 | NUMKR | ||||
BREFN | Field Selection Key | BREFN | CHAR | 20 | T162 | BREFN | |||
REFBA | Reference document type | RFBSA | CHAR | 4 | T161 | BSART | |||
ABVOR | Prepopulate Standard Release Order Quantity in Contract | ABVOR | CHAR | 1 | ABVOR | ||||
STAFO | Update group for statistics update | STAFO | CHAR | 6 | TMCB | ALPHA | STAFO | MCF | |
UPINC | Item Number Interval for Subitems | UPINC | NUMC | 5 | PINCR | ||||
STAKO | Document with time-dependent conditions | STAKO | CHAR | 1 | XFELD | ||||
PARGR | Partner Determination Procedure | PARGR | CHAR | 4 | TVPG | PARGR | |||
NUMKA | Number range in case of internal number assignment for ALE | NUMKA | CHAR | 2 | NUMKR | ||||
HITYP | Hierarchy category: vendor hierarchy | HITYP_LH | CHAR | 1 | TLHIT | HITYP_LH | HITYP_LH | ||
LPHIS | Indicator for scheduling agreement release documentation | LPHIS | CHAR | 1 | XFELD | ||||
GSFRG | Overall release of purchase requisitions | GSFRG | CHAR | 1 | XFELD | ||||
VARIANTE | Layout | TC_VAR | CHAR | 10 | CHAR10 | ||||
SHENQ | Only shared lock in case of contract release order | SHENQ | CHAR | 1 | XFELD | ||||
KZALE | Distributed contract (ALE) | KZALE | CHAR | 1 | XFELD | ||||
ABGEBOT | Competitive bidding procedure using global percentage bids | ABGEBOT | CHAR | 1 | XFELD | ||||
KORNR | Correction of miscellaneous provisions | KORNR | CHAR | 1 | KORNR | ||||
UMLIF | Stock transfer: Take vendor data into account | UMLIF | CHAR | 1 | XFELD | ||||
KOETT | Contract with delivery schedule | KOETT | CHAR | 1 | XFELD | ||||
AR_OBJECT | Document type | SAEOBJART | CHAR | 10 | TOADV | SADC10_DV | DOK | ||
KOAKO | Contract allowed as release order against contract | KOAKO | CHAR | 1 | XFELD | ||||
OICSEGI | Quantity schedule creation permitted | OIA_CSEGI | CHAR | 1 | OIA_CSEGI | ||||
OIRFQREQ | Precedence for RFQ or default requisition for TDP PO | OIH_RFQREQ | CHAR | 1 | OIH_RFQREQ | ||||
WVVKZ | Indicator for Further Processing of Summarized Documents | WVVKZ | CHAR | 1 | FLAG | ||||
XLOKZ | Cross-System Transit | XLOKZ | CHAR | 1 | XLOKZ | ||||
CP_AKTIVE | Commitment Plan is Active | CP_ACTIVE | CHAR | 1 | CHAR1 | ||||
CPTYPE | Category of Commitment Plan | CP_TYPE | CHAR | 1 | CHAR1 | ||||
FLS_RSTO | Store Return with Inbound and Outbound Delivery | FLS_RSTO | CHAR | 1 | XFELD | ||||
MSR_ACTIVE | Advanced Returns Management Active | MSR_ACTIVE | CHAR | 1 | MSR_ACTIVE | ||||
RDP_PROFILE | Risk Distribution Plan Profile | LOGTRM_RDP_PROFILE | CHAR | 8 | L2TC_RDP_PROFILE | LOGTRM_RDP_PROFILE | |||
NUMKC | Number Range for SRM Central Contract | NUMKC | CHAR | 2 | NUMKR | ||||
.INCLU--AP | 0 | ||||||||
/SAPMP/CEACT | Fast Data Entry of Characteristics Is Active | /SAPMP/CEACT | CHAR | 1 | /SAPMP/CEACT | ||||
/SAPMP/PDACT | Activate Inheritance | /SAPMP/PDACT | CHAR | 1 | /SAPMP/PDACT | ||||
/SAPMP/PPROT | Log of Characteristic Value Inheritance | /SAPMP/PPROT | CHAR | 1 | /SAPMP/PPROT | ||||
/SAPMP/PUSER | Inheritance: Overwrite User Values | /SAPMP/PUSER | CHAR | 1 | /SAPMP/PUSER | ||||
/SAPMP/PAUSW | Inheritance of Characteristics Selection List | /SAPMP/PAUSW | CHAR | 1 | /SAPMP/PAUSW | ||||
/SAPMP/ATNAM | Characteristic name | MILL_SE_ATNAM1 | CHAR | 30 | ATNAM | FEA | MERK | ||
/SAPMP/GAUF | Global/Local Group May Be Undone | /SAPMP/GAUF | CHAR | 1 | /SAPMP/GAUF | ||||
.INCLU--AP | 0 | ||||||||
TOLSL | Tolerance Key for Overdraw Tolerance | METOLSL | CHAR | 4 | TME_TOLS | METOLSL | |||
.INCLU--AP | 0 | ||||||||
MILL_OMKZ | Mill: Use reference characteristics in Purchasing | MILL_MM_OMKZ | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table T161 using ABAP code
The following ABAP code Example will allow you to do a basic selection on T161 to SELECT all data from the tableDATA: WA_T161 TYPE T161.
SELECT SINGLE *
FROM T161
INTO CORRESPONDING FIELDS OF WA_T161
WHERE...
How to access SAP table T161
Within an ECC or HANA version of SAP you can also view further information about T161 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects