SAP ABAP Table OIU_SB_ENTMP (MP level owner entitlements)
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_ENTMP | Table Relationship Diagram |
Short Description | MP level owner entitlements |
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 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | OIU_CM_MAT_PRCD | |
4 | MP_NO | OIU_MP_NO | OIU_MP_NO | CHAR | 20 | 0 | Measurement point number | OIU_PR_MP | |
5 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
6 | VNAME | JV_NAME | JV_NAME | CHAR | 6 | 0 | Joint venture | OIU_DO_JV | |
7 | DOI_NO | OIU_DOI_NO | OIU_DOI_NO | CHAR | 5 | 0 | Division of interest (DOI) | OIU_DO_DI | |
8 | SA_DT | OIU_SA_DT | DATS | DATS | 8 | 0 | Sales date | ||
9 | FREQ_CD | OIU_FREQ_CD | OIU_FREQ_CD | CHAR | 1 | 0 | Frequency | ||
10 | VT_CD | OIU_VT_CD | OIU_VL_TYPE_CD | CHAR | 2 | 0 | Volume type code | OIU_PR_VLTYP | |
11 | OWN_NO | OIU_OWN_NO | LIFNR | CHAR | 10 | 0 | PRA owner | LFA1 | |
12 | OWN_INT_TYPE_CD | OIU_PART_INT_TYPE | OIU_PART_INT_TYPE | CHAR | 2 | 0 | Participant Interest Type | OIU_CM_PINTTY | |
13 | OWN_ISQ_NO | OIU_OWN_ISQ_NO | OIU_OWN_ISQ_NO | CHAR | 2 | 0 | Owner Interest Sequence Number | ||
14 | MK_REP_NO | OIU_MK_REP_NO | KUNNR | CHAR | 10 | 0 | Marketing Representative No | KNA1 | |
15 | MK_REP_ISQ_NO | OIU_MK_REP_ISQ_NO | OIU_MK_REP_ISQ_NO | CHAR | 2 | 0 | Marketing Representative Interest Sequence No | ||
16 | VOL_U | OIU_VOL_U | MEINS | UNIT | 3 | 0 | Volume Unit | T006 | |
17 | ENTL_VOL | OIU_ENTL_VOL | MENGE | QUAN | 13 | 3 | Entitled Volume | ||
18 | ADJ_ENTL_VOL | OIU_ADJ_ENTL_VOL | MENGE | QUAN | 13 | 3 | Adjusted Entitlement Volume | ||
19 | ENERGY_U | OIU_ENERGY_U | MEINS | UNIT | 3 | 0 | Energy quantity unit | T006 | |
20 | ENTL_ENERGY | OIU_ENTL_ENERGY | MENGE | QUAN | 13 | 3 | Entitlement Energy | ||
21 | ADJ_ENTL_ENERGY | OIU_ADJ_ENTL_ENERGY | MENGE | QUAN | 13 | 3 | Adjusted Entitlement Energy | ||
22 | GRI_PC | OIU_GRI_PC | OIU_PERCENT98 | DEC | 9 | 8 | Gross Revenue Interest Decimal | ||
23 | ADJ_GRI_PC | OIU_ADJ_GRI_PC | OIU_PERCENT98 | DEC | 9 | 8 | Adjusted GRI Percentage | ||
24 | .INCLUDE | 0 | 0 | Creator and date/time created | |||||
25 | OIU_CRUSER | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
26 | 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_ENTMP | BUKRS | T001 | BUKRS | KEY | 1 | CN |
2 | OIU_SB_ENTMP | DN_NO | OIU_PR_DN | DN_NO | KEY | 1 | CN |
3 | OIU_SB_ENTMP | DOI_NO | OIU_DO_DI | DOI_NO | KEY | 1 | CN |
4 | OIU_SB_ENTMP | ENERGY_U | T006 | MSEHI | 1 | CN | |
5 | OIU_SB_ENTMP | MATNR | OIU_CM_MAT_PRCD | MATNR | KEY | 1 | CN |
6 | OIU_SB_ENTMP | MK_REP_NO | KNA1 | KUNNR | 1 | CN | |
7 | OIU_SB_ENTMP | MP_NO | OIU_PR_MP | MP_NO | KEY | 1 | CN |
8 | OIU_SB_ENTMP | OWN_INT_TYPE_CD | OIU_CM_PINTTY | OWN_INT_TYPE_CD | KEY | 1 | CN |
9 | OIU_SB_ENTMP | OWN_NO | LFA1 | LIFNR | KEY | 1 | CN |
10 | OIU_SB_ENTMP | VNAME | OIU_DO_JV | VNAME | KEY | 1 | CN |
11 | OIU_SB_ENTMP | VOL_U | T006 | MSEHI | 1 | CN | |
12 | OIU_SB_ENTMP | VT_CD | OIU_PR_VLTYP | VL_TYPE_CD | KEY |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 46C |