SAP Table V_OI0_TVAK

Generated Table for View

V_OI0_TVAK (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_OI0_TVAK to other SAP tables.

V_OI0_TVAK table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AUART Sales Document Type AUART CHAR 4 0
BEZEI Description BEZEI20 CHAR 20 0
TRVOG Transaction group TRVOG_VA CHAR 1 0
0 Order
1 Inquiry
2 Quotation
3 Scheduling agreement
4 Contract
5 Item proposal
B Customer independent requirements
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
PARGR Partner Determination Procedure PARGR TVPG CHAR 4 0
KOPGR Screen sequence group for document header & item BIFGR TVHB CHAR 4 0
SPERR Sales document block SPEVB CHAR 1 0
NULL No block
A Only automatic creation allowed, e.g. for rebate processing
X The sales document type is blocked
VBKLT Sales document indicator (for display in TVAK only) VBKLT_VA CHAR 1 0
NULL No classification
B Delivery order
C Scheduling agreement with delivery order
D Invoice correction request
E Delivery order correction
F Repair processing: Leading serviceable material
G Repair processing: Leading service product
H Scheduling agreement with external service agent processing
I Consignment issue by external service agent
K Correct consignment issue by external service agent
R Order for Billing Between Company Codes (RRICB)
OIPIPEVAL Validation indicator for pipeline fields (X=ON, blank=OFF) OID_PIPEV CHAR 1 0
X Yes
NULL No
OIISOILPD IS-Oil plant determination indicator: x=yes blank=no OID_BYPASS CHAR 1 0
NULL Entry not selected / not active / function switched off
X Entry selected / active / function switched on
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
OICFKARTDI Differential invoice billing type proposal OICFKARTDI TVFK CHAR 4 0
OIPARVW1 Partner Function PARVW TPAR CHAR 2 0
OIPARVW2 Partner Function PARVW TPAR CHAR 2 0
OIPARVW3 Partner Function PARVW TPAR CHAR 2 0
OIPARVW4 Partner Function PARVW TPAR CHAR 2 0
OIPARVW5 Partner Function PARVW TPAR CHAR 2 0
OIPARVW6 Partner Function PARVW TPAR CHAR 2 0
OIPARVW7 Partner Function PARVW TPAR CHAR 2 0
OIPARVW8 Partner Function PARVW TPAR CHAR 2 0
OIPARVW9 Partner Function PARVW TPAR CHAR 2 0
OISUBHEAD Subscreen number (header) OID_SSCRHD CHAR 4 0
OISUBITEM Subscreen number (item level) OID_SSCRIT CHAR 4 0
OIUSEREXIT Number of the routine used for copying GRPNO NUMC 3 0
OIU_FKARA PRA Order related billing type OIU_FKARA TVFK CHAR 4 0
UEVOR F-code default for overview screen UEVOR_VA CHAR 20 0
NULL Remain on initial screen until a function is selected
UER1 Press ENTER to go to General Overview
UER2 Press ENTER to go to Items Overview
UBST Press ENTER to go to Ordering Party Overview
UKAU (from Version 4.0, no longer available, diverted to VER1)
OID1 Press ENTER to go to Double-line Overview (only IS-Oil)
OIDX Press ENTER to go to "Flexible Structure" Overview (IS-Oil)
OIDA Press ENTER to go to ENJOY Version Overview (only IS-Oil)
MILL_SE_UE Characteristic Overview / Fast Entry
UMSR Overview of Returns
ICOMO_U1 Press ENTER for OGSD Overview Screen Telesales (Double Line)
ICOMO_U2 Press ENTER for OGSD Overview Screen: Telesales
ICOMO_U3 Press ENTER for OGSD Overview Screen: Telesales/CRM

V_OI0_TVAK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
V_OI0_TVAK KOPGR V_OI0_TVAK MANDT TVHB Sales Document: Screen Sequence Group MANDT
V_OI0_TVAK KOPGR TTAB OBJEKT_BCF TVHB Sales Document: Screen Sequence Group OBJEKT
V_OI0_TVAK KOPGR V_OI0_TVAK KOPGR TVHB Sales Document: Screen Sequence Group BIFGR
V_OI0_TVAK MANDT V_OI0_TVAK MANDT T000 Clients MANDT
V_OI0_TVAK OICFKARTDI TVFK MANDT TVFK Billing: Document Types MANDT
V_OI0_TVAK OICFKARTDI V_OI0_TVAK OICFKARTDI TVFK Billing: Document Types FKART
V_OI0_TVAK OIPARVW1 V_OI0_TVAK MANDT TPAR Business Partner: Functions MANDT
V_OI0_TVAK OIPARVW1 V_OI0_TVAK OIPARVW1 TPAR Business Partner: Functions PARVW
V_OI0_TVAK OIPARVW2 V_OI0_TVAK MANDT TPAR Business Partner: Functions MANDT
V_OI0_TVAK OIPARVW2 V_OI0_TVAK OIPARVW2 TPAR Business Partner: Functions PARVW
V_OI0_TVAK OIPARVW3 V_OI0_TVAK MANDT TPAR Business Partner: Functions MANDT
V_OI0_TVAK OIPARVW3 V_OI0_TVAK OIPARVW3 TPAR Business Partner: Functions PARVW
V_OI0_TVAK OIPARVW4 V_OI0_TVAK MANDT TPAR Business Partner: Functions MANDT
V_OI0_TVAK OIPARVW4 V_OI0_TVAK OIPARVW4 TPAR Business Partner: Functions PARVW
V_OI0_TVAK OIPARVW5 V_OI0_TVAK OIPARVW5 TPAR Business Partner: Functions PARVW
V_OI0_TVAK OIPARVW5 V_OI0_TVAK MANDT TPAR Business Partner: Functions MANDT
V_OI0_TVAK OIPARVW6 V_OI0_TVAK MANDT TPAR Business Partner: Functions MANDT
V_OI0_TVAK OIPARVW6 V_OI0_TVAK OIPARVW6 TPAR Business Partner: Functions PARVW
V_OI0_TVAK OIPARVW7 V_OI0_TVAK MANDT TPAR Business Partner: Functions MANDT
V_OI0_TVAK OIPARVW7 V_OI0_TVAK OIPARVW7 TPAR Business Partner: Functions PARVW
V_OI0_TVAK OIPARVW8 V_OI0_TVAK OIPARVW8 TPAR Business Partner: Functions PARVW
V_OI0_TVAK OIPARVW8 V_OI0_TVAK MANDT TPAR Business Partner: Functions MANDT
V_OI0_TVAK OIPARVW9 V_OI0_TVAK MANDT TPAR Business Partner: Functions MANDT
V_OI0_TVAK OIPARVW9 V_OI0_TVAK OIPARVW9 TPAR Business Partner: Functions PARVW
V_OI0_TVAK OIU_FKARA SYST MANDT TVFK Billing: Document Types MANDT
V_OI0_TVAK OIU_FKARA V_OI0_TVAK OIU_FKARA TVFK Billing: Document Types FKART
V_OI0_TVAK PARGR V_OI0_TVAK MANDT TVPG Partner Function Groups MANDT
V_OI0_TVAK PARGR V_OI0_TVAK PARGR TVPG Partner Function Groups PARGR