SAP ABAP Table ROIU_SB_CTR_MPWC (Maintenance Structure: OIU_SB_CTRMP, CTRWC, CTROB)
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 | INTTAB | Structure |
Structure | ROIU_SB_CTR_MPWC | Table Relationship Diagram |
Short Description | Maintenance Structure: OIU_SB_CTRMP, CTRWC, CTROB |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
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 | UOMGR | OIU_CA_UOMGR | OIU_ME_UOMGR | CHAR | 3 | 0 | Gas Allocation Basis UOM | * | |
2 | UOMGR_DE | OIU_ME_UOMGR_TX | TEXT40 | CHAR | 40 | 0 | Description of the unit of measure group | ||
3 | OB_VOL_U | OIU_OB_VOL_U | MEINS | UNIT | 3 | 0 | Observed Volume Unit | * | |
4 | OB_VOL | OIU_OB_VOL | MENGE | QUAN | 13 | 3 | Observed Volume | ||
5 | OB_TEMP_U | OIU_TEMP_U | MEINS | UNIT | 3 | 0 | Unit of Temperature | T006 | |
6 | OB_TEMP | OIU_TEMP | MENGE | QUAN | 13 | 3 | Temperature | ||
7 | OB_PS_BASE_U | OIU_OB_PS_BASE_U | MEINS | UNIT | 3 | 0 | Observed Pressure Base Unit | T006 | |
8 | OB_PS_BASE | OIU_OB_PS_BASE | MENGE | QUAN | 13 | 3 | Observed Pressure Based Volume | ||
9 | OB_HEAT_VAL_U | OIU_OB_HEAT_VAL_U | MEINS | UNIT | 3 | 0 | Observed Heating Value Unit | T006 | |
10 | OB_HEAT_VAL | OIU_OB_HEAT_VAL | MENGE | QUAN | 13 | 3 | Observed Heating Value | ||
11 | OB_HEAT_VAL_TYP | OIB_HVCLS | OIB_HVCLS | CHAR | 2 | 0 | Heating value class (calorific value class) | ||
12 | OB_ENERGY_U | OIU_OB_ENERGY_U | MEINS | UNIT | 3 | 0 | Oberserved Energy Unit | * | |
13 | OB_ENERGY | OIU_OB_ENERGY | MENGE | QUAN | 13 | 3 | Observed Energy | ||
14 | .INCLUDE | 0 | 0 | Volumes for sale | |||||
15 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
16 | DN_NO | OIU_DN_NO | OIU_DN_NO | CHAR | 20 | 0 | Delivery network number | OIU_PR_DN | |
17 | SA_DT | OIU_SA_DT | DATS | DATS | 8 | 0 | Sales date | ||
18 | WL_NO | OIU_WL_NO | OIU_WL_NO | CHAR | 15 | 0 | Well ID number | OIU_PR_WELL | |
19 | WC_NO | OIU_WC_NO | OIU_WC_NO | CHAR | 5 | 0 | Well Completion Number | OIU_PR_WC | |
20 | ORIG_MP_NO | OIU_ORIG_MP_NO | OIU_MP_NO | CHAR | 20 | 0 | Original measurement point number | OIU_PR_MP | |
21 | TRNSP_NO | OIU_TRNSP_NO | KUNNR | CHAR | 10 | 0 | Transporter number | KNA1 | |
22 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | OIU_CM_MAT_PRCD | |
23 | FREQ_CD | OIU_FREQ_CD | OIU_FREQ_CD | CHAR | 1 | 0 | Frequency | ||
24 | CT_NO | OIU_CT_NO | OIUCM_CONTRACT_NUMBER | CHAR | 10 | 0 | Contract Number | OIU_RV_CT | |
25 | VC_CD | OIU_VC_CD | OIU_VC_CD | CHAR | 1 | 0 | Volume class code | ||
26 | STD_VOL_U | OIU_STD_VOL_U | MEINS | UNIT | 3 | 0 | Standard volume unit | T006 | |
27 | STD_VOL | OIU_STD_VOL | MENGE | QUAN | 13 | 3 | Standard volume | ||
28 | STD_HEAT_VAL_U | OIU_STD_HEAT_VAL_U | MEINS | UNIT | 3 | 0 | Standardized Heating Value Unit | T006 | |
29 | STD_HEAT_VAL | OIU_STD_HEAT_VAL | MENGE | QUAN | 13 | 3 | Standardized Heating Value | ||
30 | STD_ENERGY_U | OIU_STD_ENERGY_U | MEINS | UNIT | 3 | 0 | Standard Energy UoM | T006 | |
31 | STD_ENERGY | OIU_STD_ENERGY | MENGE | QUAN | 13 | 3 | Standard Energy | ||
32 | QY_U | OIU_QY_U | MEINS | UNIT | 3 | 0 | Quantity Unit | T006 | |
33 | ENTL_QY | OIU_ENTL_QY | MENGE | QUAN | 13 | 3 | Entitled Quantity | ||
34 | ADJ_ENTL_QY | OIU_ADJ_ENTL_QY | MENGE | QUAN | 13 | 3 | Adjusted Entitlement (Volumetric or Energy) | ||
35 | PHASE_1_QY | OIU_PHASE_1_QY | OIU_VOLUME_SIGN | DEC | 13 | 3 | Phase One Allocation Energy Quantity | ||
36 | PHASE_2_QY | OIU_PHASE_2_QY | OIU_VOLUME_SIGN | DEC | 13 | 3 | Phase Two Allocation Energy Quantity | ||
37 | PHASE_3_QY | OIU_PHASE_3_QY | OIU_VOLUME_SIGN | DEC | 13 | 3 | Phase Three Allocation Energy Quantity | ||
38 | PHASE_4_QY | OIU_PHASE_4_QY | OIU_VOLUME_SIGN | DEC | 13 | 3 | Phase Four Allocation Energy Quantity | ||
39 | PHASE_5_QY | OIU_PHASE_5_QY | OIU_VOLUME_SIGN | DEC | 13 | 3 | Phase Five Allocation Energy Quantity | ||
40 | ME_DOCNR | OIU_ME_DOCNR | BELNR | CHAR | 10 | 0 | Meas. document number | ||
41 | ME_DOCYR | OIU_ME_DOCYR | GJAHR | NUMC | 4 | 0 | Meas. document year | ||
42 | .INCLUDE | 0 | 0 | Creator and date/time created | |||||
43 | OIU_CRUSER | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
44 | OIU_TIMESTAMP | TZNTSTMPS | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
45 | MP_NO | OIU_MP_NO | OIU_MP_NO | CHAR | 20 | 0 | Measurement point number | * | |
46 | MP_DE | OIU_MP_DE | OIU_TEXT35 | CHAR | 35 | 0 | Measurement point description | ||
47 | DN_DE | OIU_DN_DE | OIU_TEXT35 | CHAR | 35 | 0 | Delivery network description | ||
48 | WC_NM | OIU_WC_NM | OIU_TEXT35 | CHAR | 35 | 0 | Well completion name | ||
49 | ORIG_MP_DE | OIU_MP_DE | OIU_TEXT35 | CHAR | 35 | 0 | Measurement point description | ||
50 | CT_TYPE_CD | OIU_CT_TYPE_CD | OIU_CT_TYPE_CD | CHAR | 2 | 0 | Contract Type | * | |
51 | CT_TYPE_DE | OIU_CT_TYPE_DE | OIU_TEXT50 | CHAR | 50 | 0 | Contract Type Description | ||
52 | MK_REP_NO | OIU_MK_REP_NO | KUNNR | CHAR | 10 | 0 | Marketing Representative No | * | |
53 | MK_REP_ISQ_NO | OIU_MK_REP_ISQ_NO | OIU_MK_REP_ISQ_NO | CHAR | 2 | 0 | Marketing Representative Interest Sequence No | ||
54 | MK_REP_NM | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
55 | DEST_SALE_CD | OIU_DEST_SALE_CD | OIU_DEST_SALE_CD | CHAR | 1 | 0 | Plant Destination Of Product Sale Codes | ||
56 | DEST_SALE_TX | OIU_DEST_SALE_TX | CHAR10 | CHAR | 10 | 0 | Destination Sale Description | ||
57 | TRNSP_NM | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
58 | MAKTX | MAKTX | TEXT40 | CHAR | 40 | 0 | Material description | ||
59 | FREQ_CD_TX | OIU_FREQ_CD_TX | CHAR16 | CHAR | 16 | 0 | Frequency Code Text | ||
60 | SA_MONTH | OIU_SALES_MONTH | OIU_SALE_DT | ACCP | 6 | 0 | Sales Month (YYYYMM) | ||
61 | REF_SA_MONTH | OIU_SALES_MONTH_REF | OIU_SALE_DT | ACCP | 6 | 0 | Reference Sales Month (YYYYMM) | ||
62 | REF_SA_DT | OIU_PROD_DT_REF | DATUM | DATS | 8 | 0 | Reference Production Date | ||
63 | REF_DN_NO | OIU_DN_NO_REF | OIU_DN_NO | CHAR | 20 | 0 | Reference delivery network number | * | |
64 | REF_DN_DE | OIU_DN_DE | OIU_TEXT35 | CHAR | 35 | 0 | Delivery network description | ||
65 | REF_WL_NO | OIU_WL_NO_REF | OIU_WL_NO | CHAR | 15 | 0 | Reference well ID number | * | |
66 | REF_WC_NO | OIU_WC_NO_REF | OIU_WC_NO | CHAR | 5 | 0 | Reference well completion number | * | |
67 | REF_WC_NM | OIU_WC_NM | OIU_TEXT35 | CHAR | 35 | 0 | Well completion name | ||
68 | REF_MP_NO | OIU_MP_NO_REF | OIU_MP_NO | CHAR | 20 | 0 | Reference measurement point number | * | |
69 | REF_MP_DE | OIU_MP_DE | OIU_TEXT35 | CHAR | 35 | 0 | Measurement point description | ||
70 | REF_ORIG_MP_NO | OIU_ORIG_MP_NO_REF | OIU_MP_NO | CHAR | 20 | 0 | Referenced Originating Measurement Point | * | |
71 | REF_ORIG_MP_DE | OIU_MP_DE | OIU_TEXT35 | CHAR | 35 | 0 | Measurement point description | ||
72 | REF_FREQ_CD | OIU_FREQ_CD_REF | OIU_FREQ_CD | CHAR | 1 | 0 | Reference Frequency code | ||
73 | REF_FREQ_CD_TX | OIU_FREQ_CD_TX | CHAR16 | CHAR | 16 | 0 | Frequency Code Text | ||
74 | REF_MATNR | REF_MATNR | MATNR | CHAR | 18 | 0 | Reference material | * | |
75 | REF_MAKTX | MAKTX | TEXT40 | CHAR | 40 | 0 | Material description | ||
76 | REF_TRNSP_NO | OIU_TRNSP_NO_REF | KUNNR | CHAR | 10 | 0 | Reference Transporter number | * | |
77 | REF_TRNSP_NM | NAME1 | TEXT30 | CHAR | 30 | 0 | Name | ||
78 | BASE_DENSITY | OIU_OB_DENSITY | MENGE | QUAN | 13 | 3 | Observed Denisty | ||
79 | BASE_DENSITY_U | OIB_BDNEH | MEINS | UNIT | 3 | 0 | Unit for densities at standard/base conditions | T006 | |
80 | DENTYP | OIB_DNTYP | OIB_DNTYP | CHAR | 1 | 0 | Density Type | ||
81 | XXDBACTION | OIU_DBACTION | CHAR1 | CHAR | 1 | 0 | Database Action Flag | ||
82 | MSEHI | MSEHI | MEINS | UNIT | 3 | 0 | Unit of Measurement | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ROIU_SB_CTR_MPWC | BASE_DENSITY_U | T006 | MSEHI | 1 | CN | |
2 | ROIU_SB_CTR_MPWC | CT_NO | OIU_RV_CT | CT_NO | KEY | 1 | CN |
3 | ROIU_SB_CTR_MPWC | DN_NO | OIU_PR_DN | DN_NO | KEY | 1 | CN |
4 | ROIU_SB_CTR_MPWC | MATNR | OIU_CM_MAT_PRCD | MATNR | KEY | 1 | CN |
5 | ROIU_SB_CTR_MPWC | OB_HEAT_VAL_U | T006 | MSEHI | 1 | CN | |
6 | ROIU_SB_CTR_MPWC | OB_PS_BASE_U | T006 | MSEHI | 1 | CN | |
7 | ROIU_SB_CTR_MPWC | OB_TEMP_U | T006 | MSEHI | 1 | CN | |
8 | ROIU_SB_CTR_MPWC | ORIG_MP_NO | OIU_PR_MP | MP_NO | KEY | 1 | CN |
9 | ROIU_SB_CTR_MPWC | QY_U | T006 | MSEHI | 1 | CN | |
10 | ROIU_SB_CTR_MPWC | STD_ENERGY_U | T006 | MSEHI | 1 | CN | |
11 | ROIU_SB_CTR_MPWC | STD_HEAT_VAL_U | T006 | MSEHI | 1 | CN | |
12 | ROIU_SB_CTR_MPWC | STD_VOL_U | T006 | MSEHI | 1 | CN | |
13 | ROIU_SB_CTR_MPWC | TRNSP_NO | KNA1 | KUNNR | KEY | 1 | CN |
14 | ROIU_SB_CTR_MPWC | WC_NO | OIU_PR_WC | WC_NO | KEY | 1 | CN |
15 | ROIU_SB_CTR_MPWC | WL_NO | OIU_PR_WELL | WL_NO | KEY | 1 | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 46C |