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 |
Possible values
|
||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||
INV_NO | Contract Invoice Number | OIU_INV_NO | CHAR | 6 | 0 | |||||||||||||||||||
LIFE_LSE_FL | Life Lease Flag | OIU_LIFE_LSE_FL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
INV_FL | Invoice Flag | OIU_INV_FL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||
SPOT_TERM_CD | Spot/Term | OIU_SPOT_TERM_CD | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||
OIU_IOTR_FL | Price includes Tax Reimbursement. | OIU_IOTR_FL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
OIU_EXRES_SPLT | Excess Residue Return (Before/After) Lease Plant Split Code | OIU_EXRES_SPLT_CD | CHAR | 1 | 0 |
Possible values
|
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 |