SAP ABAP Table OIUP_SB_ENTWC (WC level owner entitlements (PDM Shadow))
Hierarchy
☛
IS-OIL (Software Component) IS-OIL
⤷ IS-OIL-PRA (Application Component) Production and Revenue Accounting
⤷ OIU_P (Package) Partitioned Data Management
⤷ IS-OIL-PRA (Application Component) Production and Revenue Accounting
⤷ OIU_P (Package) Partitioned Data Management
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | OIUP_SB_ENTWC | Table Relationship Diagram |
Short Description | WC level owner entitlements (PDM Shadow) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | L | Table for storing temporary data, delivered empty |
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 | PDM_GUID | GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID in 'CHAR' Format in Uppercase | ||
3 | DN_NO | OIU_DN_NO | OIU_DN_NO | CHAR | 20 | 0 | Delivery network number | OIU_PR_DN | |
4 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | OIU_CM_MAT_PRCD | |
5 | WL_NO | OIU_WL_NO | OIU_WL_NO | CHAR | 15 | 0 | Well ID number | OIU_PR_WELL | |
6 | WC_NO | OIU_WC_NO | OIU_WC_NO | CHAR | 5 | 0 | Well Completion Number | OIU_PR_WC | |
7 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
8 | VNAME | JV_NAME | JV_NAME | CHAR | 6 | 0 | Joint venture | OIU_DO_JV | |
9 | DOI_NO | OIU_DOI_NO | OIU_DOI_NO | CHAR | 5 | 0 | Division of interest (DOI) | OIU_DO_DI | |
10 | SA_DT | OIU_SA_DT | DATS | DATS | 8 | 0 | Sales date | ||
11 | FREQ_CD | OIU_FREQ_CD | OIU_FREQ_CD | CHAR | 1 | 0 | Frequency | ||
12 | VT_CD | OIU_VT_CD | OIU_VL_TYPE_CD | CHAR | 2 | 0 | Volume type code | OIU_PR_VLTYP | |
13 | OWN_NO | OIU_OWN_NO | LIFNR | CHAR | 10 | 0 | PRA owner | LFA1 | |
14 | OWN_INT_TYPE_CD | OIU_PART_INT_TYPE | OIU_PART_INT_TYPE | CHAR | 2 | 0 | Participant Interest Type | OIU_CM_PINTTY | |
15 | OWN_ISQ_NO | OIU_OWN_ISQ_NO | OIU_OWN_ISQ_NO | CHAR | 2 | 0 | Owner Interest Sequence Number | ||
16 | MK_REP_NO | OIU_MK_REP_NO | KUNNR | CHAR | 10 | 0 | Marketing Representative No | KNA1 | |
17 | MK_REP_ISQ_NO | OIU_MK_REP_ISQ_NO | OIU_MK_REP_ISQ_NO | CHAR | 2 | 0 | Marketing Representative Interest Sequence No | ||
18 | VOL_U | OIU_VOL_U | MEINS | UNIT | 3 | 0 | Volume Unit | T006 | |
19 | ENTL_VOL | OIU_ENTL_VOL | MENGE | QUAN | 13 | 3 | Entitled Volume | ||
20 | ADJ_ENTL_VOL | OIU_ADJ_ENTL_VOL | MENGE | QUAN | 13 | 3 | Adjusted Entitlement Volume | ||
21 | ENERGY_U | OIU_ENERGY_U | MEINS | UNIT | 3 | 0 | Energy quantity unit | T006 | |
22 | ENTL_ENERGY | OIU_ENTL_ENERGY | MENGE | QUAN | 13 | 3 | Entitlement Energy | ||
23 | ADJ_ENTL_ENERGY | OIU_ADJ_ENTL_ENERGY | MENGE | QUAN | 13 | 3 | Adjusted Entitlement Energy | ||
24 | GRI_PC | OIU_GRI_PC | OIU_PERCENT98 | DEC | 9 | 8 | Gross Revenue Interest Decimal | ||
25 | ADJ_GRI_PC | OIU_ADJ_GRI_PC | OIU_PERCENT98 | DEC | 9 | 8 | Adjusted GRI Percentage | ||
26 | .INCLUDE | 0 | 0 | Creator and date/time created | |||||
27 | OIU_CRUSER | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
28 | 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 | OIUP_SB_ENTWC | BUKRS | T001 | BUKRS | KEY | 1 | CN |
2 | OIUP_SB_ENTWC | DN_NO | OIU_PR_DN | DN_NO | KEY | 1 | CN |
3 | OIUP_SB_ENTWC | DOI_NO | OIU_DO_DI | DOI_NO | KEY | 1 | CN |
4 | OIUP_SB_ENTWC | ENERGY_U | T006 | MSEHI | 1 | CN | |
5 | OIUP_SB_ENTWC | MATNR | OIU_CM_MAT_PRCD | MATNR | KEY | 1 | CN |
6 | OIUP_SB_ENTWC | MK_REP_NO | KNA1 | KUNNR | 1 | CN | |
7 | OIUP_SB_ENTWC | OWN_INT_TYPE_CD | OIU_CM_PINTTY | OWN_INT_TYPE_CD | KEY | 1 | CN |
8 | OIUP_SB_ENTWC | OWN_NO | LFA1 | LIFNR | KEY | 1 | CN |
9 | OIUP_SB_ENTWC | VNAME | OIU_DO_JV | VNAME | KEY | 1 | CN |
10 | OIUP_SB_ENTWC | VOL_U | T006 | MSEHI | 1 | CN | |
11 | OIUP_SB_ENTWC | VT_CD | OIU_PR_VLTYP | VL_TYPE_CD | KEY | ||
12 | OIUP_SB_ENTWC | WC_NO | OIU_PR_WC | WC_NO | KEY | 1 | CN |
13 | OIUP_SB_ENTWC | WL_NO | OIU_PR_WELL | WL_NO | KEY | 1 | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 600 |