SAP Table OIU_RV_CT

Generated Table for View

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

OIU_RV_CT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
CT_NO Contract Number OIU_CT_NO CHAR 10 0
CT_TYPE_CD Contract Type OIU_CT_TYPE_CD OIU_CM_CTTYP CHAR 2 0
BUKRS Company code to be billed BUKRS_VF T001 CHAR 4 0
CTPTY_CT_NO Customer purchase order number BSTNK CHAR 20 0
CUST_VEND_CD Customer/Vendor Indicator OIU_CUST_VEND_CD CHAR 1 0
C Customer
V Vendor
P Partner
CTPTY_NO Sold-to party KUNAG KNA1 CHAR 10 0
START_DT Valid-from date (outline agreements, product proposals) GUEBG DATS 8 0
END_DT Valid-to date (outline agreements, product proposals) GUEEN DATS 8 0
APPR_FL Approval indicator OIU_APPL_FL CHAR 1 0
X Active
NULL Inactive
APPR_DATA Approval Date OIU_APPR_DT DATS 8 0
EXEC_DATA Contract Execution Date OIU_EXEC_DT DATS 8 0
STD_CD_FL Standard Contract Flag OIU_STD_CT_FL CHAR 1 0
X Active
NULL Inactive
OLD_CT_NO Old / Previous Contract Number OIU_PREV_CT_NO CHAR 10 0
GPLT_COMPANY Gas Plant Company OIU_GPLT_BUKRS T001 CHAR 4 0
GPLT_VNAME Gas Plant Venture OIU_GPLT_VNAME OIU_DO_JV CHAR 6 0
GPLT_DOI_NOI Gasplant DOI No OIU_GPLT_DOI_NO CHAR 5 0
MK_REP_NO Marketing Representative No OIU_MK_REP_NO CHAR 10 0
MK_REP_ISQ_NO Marketing Representative Interest Sequence No OIU_MK_REP_ISQ_NO CHAR 2 0
DEST_SALE_CD Plant Destination Of Product Sale Codes OIU_DEST_SALE_CD CHAR 1 0
B Bypass
P Processing
S Straddle
N None
INV_NO Contract Invoice Number OIU_INV_NO CHAR 6 0
LIFE_LSE_FL Life Lease Flag OIU_LIFE_LSE_FL CHAR 1 0
X Active
NULL Inactive
INV_FL Invoice Flag OIU_INV_FL CHAR 1 0
X Active
NULL Inactive
OBLIG_DT Obligation Date OIU_OBLIG_DT DATS 8 0
DESK_CD Desk Codes OIU_DESK_CD CHAR 3 0
EIA_GINA_CD Energy Information Agency Report Code OIU_EIA_GINA_CD CHAR 2 0
CT_STATUS_CD Contract Status Code OIU_CT_STATUS_CD CHAR 2 0
AC Active
AS Assigned
CO Correction
MO Modified
RE Renewal
RO Rollover
SU Successor
TE Terminated
SPOT_TERM_CD Spot/Term OIU_SPOT_TERM_CD CHAR 1 0
S Spot
T Term
OIU_CRUSER Name of Person who Created the Object ERNAM CHAR 12 0
OIU_TIMESTAMP Date on Which Record Was Created ERDAT DATS 8 0
OIU_STNDEDQ_CD Varying/Equ Daily Qu OIU_STNDEDQ_CD CHAR 1 0
E Equal Daily Quantity
V Varying Daily Quantity
OIU_IOTR_FL Price includes Tax Reimbursement. OIU_IOTR_FL CHAR 1 0
X Active
NULL Inactive
OIU_EXRES_SPLT Excess Residue Return (Before/After) Lease Plant Split Code OIU_EXRES_SPLT_CD CHAR 1 0
B Before
A After
N None

OIU_RV_CT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
OIU_RV_CT BUKRS OIU_RV_CT MANDT T001 Company Codes MANDT
OIU_RV_CT BUKRS OIU_RV_CT BUKRS T001 Company Codes BUKRS
OIU_RV_CT CTPTY_NO OIU_RV_CT MANDT KNA1 General Data in Customer Master MANDT
OIU_RV_CT CTPTY_NO OIU_RV_CT CTPTY_NO KNA1 General Data in Customer Master KUNNR
OIU_RV_CT CT_TYPE_CD OIU_RV_CT CT_TYPE_CD OIU_CM_CTTYP Contract Type (TBLCS007) CT_TYPE_CD
OIU_RV_CT GPLT_COMPANY OIU_RV_CT GPLT_COMPANY T001 Company Codes BUKRS
OIU_RV_CT GPLT_COMPANY SYST MANDT T001 Company Codes MANDT
OIU_RV_CT GPLT_VNAME OIU_RV_CT GPLT_COMPANY OIU_DO_JV PRA venture extension BUKRS
OIU_RV_CT GPLT_VNAME OIU_RV_CT GPLT_VNAME OIU_DO_JV PRA venture extension VNAME
OIU_RV_CT GPLT_VNAME SYST MANDT OIU_DO_JV PRA venture extension MANDT
OIU_RV_CT MANDT OIU_RV_CT MANDT T000 Clients MANDT