SAP table V_T161 (Generated Table for View)

SAP table V_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
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
NUMKA Number range in case of internal number assignment for ALE CHAR 2 0 NUMKA
LPHIS Indicator for scheduling agreement release documentation CHAR 1 0 LPHIS
GSFRG Overall release of purchase requisitions CHAR 1 0 GSFRG
SHENQ Only shared lock in case of contract release order CHAR 1 0 SHENQ
BATXT Short Description of Purchasing Document Type CHAR 20 0 BATXT
VARIANTE Layout CHAR 10 0 TC_VAR
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
AR_OBJECT Document type CHAR 10 0 TOADV SAEOBJART
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
CP_ACTIVE Commitment Plan is Active CHAR 1 0 CP_ACTIVE
CPTYPE Category of Commitment Plan CHAR 1 0 CP_TYPE
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
XLOKZ Cross-System Transit CHAR 1 0 XLOKZ
No cross-system transit
1 Internal company code transit
2 Cross-company code transit
NUMKC Number Range for SRM Central Contract CHAR 2 0 NUMKC
RDP_PROFILE Risk Distribution Plan Profile CHAR 8 0 L2TC_RDP_PROFILE LOGTRM_RDP_PROFILE
RFX_PROCESSING_CD RFQ Awarding Type (Internal/External) CHAR 1 0 RFX_PROCESSING_CD
E External
I Internal
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
SGT_CONT_SEG_IGNORE Allow Blank Segment in Purchase Contract CHAR 1 0 SGT_CONT_SEG_IGNORE

V_T161 foreign key relationships

Table Field Check Table Check Field
0 V_T161 AR_OBJECT TOADV SAP ArchiveLink: Global document types MANDT
0 V_T161 AR_OBJECT TOADV SAP ArchiveLink: Global document types AR_OBJECT
1 V_T161 BREFN T162 Field Selection, Purchasing Document MANDT
1 V_T161 BREFN T162 Field Selection, Purchasing Document FLREF
0 V_T161 MANDT T000 Clients MANDT
1 V_T161 RDP_PROFILE L2TC_RDP_PROFILE Risk Distribution Plan: Profile table MANDT
1 V_T161 RDP_PROFILE L2TC_RDP_PROFILE Risk Distribution Plan: Profile table PROFILE
0 V_T161 RFQ_PROCESS_TYPE MMPUR_RFQ_PR_TY Process Types for RFQ and Supplier Quotation MANDT
1 V_T161 STAFO TMCB Update groups MANDT
1 V_T161 STAFO TMCB Update groups STAFO