SAP Table OILTVAK

IS-Oil APPEND fields to TVAK (SD document types)

OILTVAK (IS-Oil APPEND fields to TVAK (SD 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 OILTVAK to other SAP tables.

Source: OILTVAK (IS-Oil APPEND fields to TVAK (SD document types))

OILTVAK table fields

Field Data element Checktable Datatype Length Decimals
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
OIMSG_PRD Message type for product with contract restrictions OIDMSG_PRD CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIMSG_SHP Message type for contract restrictions ship-to party OIDMSG_SHP CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIMSG_QTY Message type for contract restrictions quantity OIDMSG_QTY CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIMSG_TRM Message type for contract restrictions payment terms OIDMSG_TRM CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIMSG_DAT Message type for contract restrictions validity period OIDMSG_DAT CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIMSG_UOM Message type for contract restrictions unit of measure OIDMSG_UOM CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIPRTFNC Partner function OID_PTRFNC TPAR CHAR 2 0
OIFCONTI IS-Oil MRN indicator for additional contract data OIF_CONTI CHAR 1 0
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

OILTVAK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
OILTVAK OICFKARTDI OILTVAK OICFKARTDI TVFK Billing: Document Types FKART
OILTVAK OICFKARTDI TVFK MANDT TVFK Billing: Document Types MANDT
OILTVAK OIPARVW1 OILTVAK OIPARVW1 TPAR Business Partner: Functions PARVW
OILTVAK OIPARVW1 TVAK MANDT TPAR Business Partner: Functions MANDT
OILTVAK OIPARVW2 OILTVAK OIPARVW2 TPAR Business Partner: Functions PARVW
OILTVAK OIPARVW2 TVAK MANDT TPAR Business Partner: Functions MANDT
OILTVAK OIPARVW3 TVAK MANDT TPAR Business Partner: Functions MANDT
OILTVAK OIPARVW3 OILTVAK OIPARVW3 TPAR Business Partner: Functions PARVW
OILTVAK OIPARVW4 OILTVAK OIPARVW4 TPAR Business Partner: Functions PARVW
OILTVAK OIPARVW4 TVAK MANDT TPAR Business Partner: Functions MANDT
OILTVAK OIPARVW5 TVAK MANDT TPAR Business Partner: Functions MANDT
OILTVAK OIPARVW5 OILTVAK OIPARVW5 TPAR Business Partner: Functions PARVW
OILTVAK OIPARVW6 TVAK MANDT TPAR Business Partner: Functions MANDT
OILTVAK OIPARVW6 OILTVAK OIPARVW6 TPAR Business Partner: Functions PARVW
OILTVAK OIPARVW7 TVAK MANDT TPAR Business Partner: Functions MANDT
OILTVAK OIPARVW7 OILTVAK OIPARVW7 TPAR Business Partner: Functions PARVW
OILTVAK OIPARVW8 TVAK MANDT TPAR Business Partner: Functions MANDT
OILTVAK OIPARVW8 OILTVAK OIPARVW8 TPAR Business Partner: Functions PARVW
OILTVAK OIPARVW9 TVAK MANDT TPAR Business Partner: Functions MANDT
OILTVAK OIPARVW9 OILTVAK OIPARVW9 TPAR Business Partner: Functions PARVW
OILTVAK OIPRTFNC TVAK MANDT TPAR Business Partner: Functions MANDT
OILTVAK OIPRTFNC OILTVAK OIPRTFNC TPAR Business Partner: Functions PARVW