SAP ABAP Table OIU_SB_CTRWC_T (Volumes for sale)
Hierarchy
☛
IS-OIL (Software Component) IS-OIL
⤷ IS-OIL-PRA (Application Component) Production and Revenue Accounting
⤷ OIU (Package) PRA Production and Revenue Accounting (Upstream Business)
⤷ IS-OIL-PRA (Application Component) Production and Revenue Accounting
⤷ OIU (Package) PRA Production and Revenue Accounting (Upstream Business)
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | OIU_SB_CTRWC_T | Table Relationship Diagram |
Short Description | Volumes for sale |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | DN_NO | OIU_DN_NO | OIU_DN_NO | CHAR | 20 | 0 | Delivery network number | OIU_PR_DN | |
3 | SA_DT | OIU_SA_DT | DATS | DATS | 8 | 0 | Sales date | ||
4 | WL_NO | OIU_WL_NO | OIU_WL_NO | CHAR | 15 | 0 | Well ID number | OIU_PR_WELL | |
5 | WC_NO | OIU_WC_NO | OIU_WC_NO | CHAR | 5 | 0 | Well Completion Number | OIU_PR_WC | |
6 | ORIG_MP_NO | OIU_ORIG_MP_NO | OIU_MP_NO | CHAR | 20 | 0 | Original measurement point number | OIU_PR_MP | |
7 | TRNSP_NO | OIU_TRNSP_NO | KUNNR | CHAR | 10 | 0 | Transporter number | KNA1 | |
8 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | OIU_CM_MAT_PRCD | |
9 | FREQ_CD | OIU_FREQ_CD | OIU_FREQ_CD | CHAR | 1 | 0 | Frequency | ||
10 | CT_NO | OIU_CT_NO | OIUCM_CONTRACT_NUMBER | CHAR | 10 | 0 | Contract Number | OIU_RV_CT | |
11 | VC_CD | OIU_VC_CD | OIU_VC_CD | CHAR | 1 | 0 | Volume class code | ||
12 | STD_VOL_U | OIU_STD_VOL_U | MEINS | UNIT | 3 | 0 | Standard volume unit | T006 | |
13 | STD_VOL | OIU_STD_VOL | MENGE | QUAN | 13 | 3 | Standard volume | ||
14 | STD_HEAT_VAL_U | OIU_STD_HEAT_VAL_U | MEINS | UNIT | 3 | 0 | Standardized Heating Value Unit | T006 | |
15 | STD_HEAT_VAL | OIU_STD_HEAT_VAL | MENGE | QUAN | 13 | 3 | Standardized Heating Value | ||
16 | STD_ENERGY_U | OIU_STD_ENERGY_U | MEINS | UNIT | 3 | 0 | Standard Energy UoM | T006 | |
17 | STD_ENERGY | OIU_STD_ENERGY | MENGE | QUAN | 13 | 3 | Standard Energy | ||
18 | QY_U | OIU_QY_U | MEINS | UNIT | 3 | 0 | Quantity Unit | T006 | |
19 | ENTL_QY | OIU_ENTL_QY | MENGE | QUAN | 13 | 3 | Entitled Quantity | ||
20 | ADJ_ENTL_QY | OIU_ADJ_ENTL_QY | MENGE | QUAN | 13 | 3 | Adjusted Entitlement (Volumetric or Energy) | ||
21 | PHASE_1_QY | OIU_PHASE_1_QY | OIU_VOLUME_SIGN | DEC | 13 | 3 | Phase One Allocation Energy Quantity | ||
22 | PHASE_2_QY | OIU_PHASE_2_QY | OIU_VOLUME_SIGN | DEC | 13 | 3 | Phase Two Allocation Energy Quantity | ||
23 | PHASE_3_QY | OIU_PHASE_3_QY | OIU_VOLUME_SIGN | DEC | 13 | 3 | Phase Three Allocation Energy Quantity | ||
24 | PHASE_4_QY | OIU_PHASE_4_QY | OIU_VOLUME_SIGN | DEC | 13 | 3 | Phase Four Allocation Energy Quantity | ||
25 | PHASE_5_QY | OIU_PHASE_5_QY | OIU_VOLUME_SIGN | DEC | 13 | 3 | Phase Five Allocation Energy Quantity | ||
26 | ME_DOCNR | OIU_ME_DOCNR | BELNR | CHAR | 10 | 0 | Meas. document number | ||
27 | ME_DOCYR | OIU_ME_DOCYR | GJAHR | NUMC | 4 | 0 | Meas. document year | ||
28 | .INCLUDE | 0 | 0 | Creator and date/time created | |||||
29 | OIU_CRUSER | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
30 | OIU_TIMESTAMP | TZNTSTMPS | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | OIU_SB_CTRWC_T | CT_NO | OIU_RV_CT | CT_NO | KEY | 1 | CN |
2 | OIU_SB_CTRWC_T | DN_NO | OIU_PR_DN | DN_NO | KEY | 1 | CN |
3 | OIU_SB_CTRWC_T | MATNR | OIU_CM_MAT_PRCD | MATNR | KEY | 1 | CN |
4 | OIU_SB_CTRWC_T | ORIG_MP_NO | OIU_PR_MP | MP_NO | KEY | 1 | CN |
5 | OIU_SB_CTRWC_T | QY_U | T006 | MSEHI | 1 | CN | |
6 | OIU_SB_CTRWC_T | STD_ENERGY_U | T006 | MSEHI | 1 | CN | |
7 | OIU_SB_CTRWC_T | STD_HEAT_VAL_U | T006 | MSEHI | 1 | CN | |
8 | OIU_SB_CTRWC_T | STD_VOL_U | T006 | MSEHI | KEY | 1 | CN |
9 | OIU_SB_CTRWC_T | TRNSP_NO | KNA1 | KUNNR | KEY | 1 | CN |
10 | OIU_SB_CTRWC_T | WC_NO | OIU_PR_WC | WC_NO | KEY | 1 | CN |
11 | OIU_SB_CTRWC_T | WL_NO | OIU_PR_WELL | WL_NO | KEY | 1 | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |