OIU_SB_RNEMP_T
Temporary Residue and NGL entitlements at a MP level
OIU_SB_RNEMP_T is an SAP database table in S/4HANA. Temporary Residue and NGL entitlements at a MP level. It contains 27 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| OIUCA_V_MP_U_TRNE | view_entity | union_all | Projection View of Contractual Allocation MP Entitle Volume |
Fields (27)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | dn_no | OIU_DN_NO | Delivery network ID | |||
| KEY | mp_no | OIU_MP_NO | Measurement Pt | |||
| KEY | matnr | MATNR | Material | |||
| KEY | vt_cd | OIU_VT_CD | Volume Type | |||
| KEY | sa_dt | OIU_SA_DT | Sales Date | |||
| KEY | own_no | OIU_OWN_NO | Owner | |||
| KEY | own_int_type_cd | OIU_PART_INT_TYPE | Interest Type | |||
| KEY | own_isq_no | OIU_OWN_ISQ_NO | Own. ISQ | |||
| KEY | lse_plt_cd | OIU_LSE_PLT_CD | Lease plt cd | |||
| KEY | sales_src_cd | OIUCA_SALES_SRC_CD | Sales Source | |||
| entl_vol_u | OIU_ENTL_VOL_U | Unit | ||||
| entl_vol | OIU_ENTL_VOL | Entl. Vol. | ||||
| heat_val_u | OIU_HEAT_VAL_U | HV Unit | ||||
| heat_val | OIU_HEAT_VAL | Heat.val.factor | ||||
| energy_u | OIU_ENERGY_U | Energy Unit | ||||
| entl_energy | OIU_ENTL_ENERGY | Energy | ||||
| gri_pc | OIU_GRI_PC | GRI | ||||
| lse_vol | OIU_LSE_VL_QY | Lse Vol | ||||
| ct_no | OIU_CT_NO | Contract | ||||
| lse_pc | OIUCA_RET_LSE_PC | % Ret. to Lease | ||||
| oiu_cruser | ERNAM | Created By | ||||
| oiu_timestamp | TZNTSTMPS | Time Stamp | ||||
| mk_rep_no | OIU_MK_REP_NO | Marketing Rep | ||||
| mk_rep_isq_no | OIU_MK_REP_ISQ_NO | Mkt. Rep. ISQ | ||||
| adj_gri_pc | OIU_ADJ_GRI_PC | Adjusted GRI | ||||
| kw_own_cd | BOOLEAN | Boolean Variable (X = True, - = False, Space = Unknown) |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Temporary Residue and NGL entitlements at a MP level
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_SB_RNEMP_T (
MANDT, -- Client [MANDT]
DN_NO, -- Delivery network ID [OIU_DN_NO]
MP_NO, -- Measurement Pt [OIU_MP_NO]
MATNR, -- Material [MATNR]
VT_CD, -- Volume Type [OIU_VT_CD]
SA_DT, -- Sales Date [OIU_SA_DT]
OWN_NO, -- Owner [OIU_OWN_NO]
OWN_INT_TYPE_CD, -- Interest Type [OIU_PART_INT_TYPE]
OWN_ISQ_NO, -- Own. ISQ [OIU_OWN_ISQ_NO]
LSE_PLT_CD, -- Lease plt cd [OIU_LSE_PLT_CD]
SALES_SRC_CD, -- Sales Source [OIUCA_SALES_SRC_CD]
ENTL_VOL_U, -- Unit [OIU_ENTL_VOL_U]
ENTL_VOL, -- Entl. Vol. [OIU_ENTL_VOL]
HEAT_VAL_U, -- HV Unit [OIU_HEAT_VAL_U]
HEAT_VAL, -- Heat.val.factor [OIU_HEAT_VAL]
ENERGY_U, -- Energy Unit [OIU_ENERGY_U]
ENTL_ENERGY, -- Energy [OIU_ENTL_ENERGY]
GRI_PC, -- GRI [OIU_GRI_PC]
LSE_VOL, -- Lse Vol [OIU_LSE_VL_QY]
CT_NO, -- Contract [OIU_CT_NO]
LSE_PC, -- % Ret. to Lease [OIUCA_RET_LSE_PC]
OIU_CRUSER, -- Created By [ERNAM]
OIU_TIMESTAMP, -- Time Stamp [TZNTSTMPS]
MK_REP_NO, -- Marketing Rep [OIU_MK_REP_NO]
MK_REP_ISQ_NO, -- Mkt. Rep. ISQ [OIU_MK_REP_ISQ_NO]
ADJ_GRI_PC, -- Adjusted GRI [OIU_ADJ_GRI_PC]
KW_OWN_CD, -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
PRIMARY KEY (MANDT, DN_NO, MP_NO, MATNR, VT_CD, SA_DT, OWN_NO, OWN_INT_TYPE_CD, OWN_ISQ_NO, LSE_PLT_CD, SALES_SRC_CD)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA