SAP Table V_T161

Generated Table for View

V_T161 (Generated Table for View) 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 V_T161 to other SAP tables.

Source: V_T161 (Generated Table for View)

V_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
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
NUMKA Number range in case of internal number assignment for ALE NUMKA CHAR 2 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
SHENQ Only shared lock in case of contract release order SHENQ CHAR 1 0
X Yes
NULL No
BATXT Short Description of Purchasing Document Type BATXT CHAR 20 0
VARIANTE Layout TC_VAR CHAR 10 0
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
AR_OBJECT Document type SAEOBJART TOADV CHAR 10 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
CP_ACTIVE Commitment Plan is Active CP_ACTIVE CHAR 1 0
CPTYPE Category of Commitment Plan CP_TYPE CHAR 1 0
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
XLOKZ Cross-System Transit XLOKZ CHAR 1 0
1 Internal company code transit
2 Cross-company code transit
NULL No cross-system transit
NUMKC Number Range for SRM Central Contract NUMKC CHAR 2 0
RDP_PROFILE Risk Distribution Plan Profile LOGTRM_RDP_PROFILE L2TC_RDP_PROFILE CHAR 8 0

V_T161 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
V_T161 AR_OBJECT V_T161 MANDT TOADV SAP ArchiveLink: Global document types MANDT
V_T161 AR_OBJECT V_T161 AR_OBJECT TOADV SAP ArchiveLink: Global document types AR_OBJECT
V_T161 BREFN V_T161 MANDT T162 Field Selection, Purchasing Document MANDT
V_T161 BREFN V_T161 BREFN T162 Field Selection, Purchasing Document FLREF
V_T161 MANDT V_T161 MANDT T000 Clients MANDT
V_T161 RDP_PROFILE V_T161 MANDT L2TC_RDP_PROFILE Risk Distribution Plan: Profile table MANDT
V_T161 RDP_PROFILE V_T161 RDP_PROFILE L2TC_RDP_PROFILE Risk Distribution Plan: Profile table PROFILE
V_T161 STAFO V_T161 MANDT TMCB Update groups MANDT
V_T161 STAFO V_T161 STAFO TMCB Update groups STAFO