OIU_SB_ACTMP_T
Actual Owner Level Contractual Allocations results at MP
OIU_SB_ACTMP_T is an SAP database table in S/4HANA. Actual Owner Level Contractual Allocations results at MP. 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_TACT | view_entity | union_all | Projection View of Contractual Allocation MP Actual 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 | ct_no | OIU_CT_NO | Contract | |||
| 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 | orig_mp_no | OIU_ORIG_MP_NO | Originating MP | |||
| KEY | trnsp_no | OIU_TRNSP_NO | Transporter | |||
| KEY | freq_cd | OIU_FREQ_CD | Frequency | |||
| actl_vol_u | OIU_ACTL_VOL_U | Unit | ||||
| actl_vol | OIU_ACTL_VOL | Actual Volume | ||||
| heat_val_u | OIU_HEAT_VAL_U | HV Unit | ||||
| heat_val | OIU_HEAT_VAL | Heat.val.factor | ||||
| actl_energy_u | OIU_ACTL_ENERGY_U | Energy Unit | ||||
| actl_energy | OIU_ACTL_ENERGY | Energy | ||||
| wg_ovrd_pc | OIU_WG_OVRD_PC | WG override % | ||||
| entl_ct_vol | OIU_ENTL_CT_VOL | Ent. Ct. Volume | ||||
| adj_entl_ct_vol | OIU_ADJ_ENTL_CT_VOL | Adj.Ent.Ct.Vol. | ||||
| entl_ct_vol_u | OIU_VOL_U | Unit | ||||
| entl_ct_ener | OIU_ENTL_CT_ENER | Ent Energy | ||||
| adj_entl_ct_ener | OIU_ADJ_ENTL_CT_ENER | Adj.Ent.Ct.En. | ||||
| entl_ct_ener_u | OIU_ENERGY_U | Energy Unit | ||||
| oiu_cruser | ERNAM | Created By | ||||
| oiu_timestamp | TZNTSTMPS | Time Stamp |
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.
-- Actual Owner Level Contractual Allocations results at MP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_SB_ACTMP_T (
MANDT, -- Client [MANDT]
DN_NO, -- Delivery network ID [OIU_DN_NO]
MP_NO, -- Measurement Pt [OIU_MP_NO]
MATNR, -- Material [MATNR]
CT_NO, -- Contract [OIU_CT_NO]
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]
ORIG_MP_NO, -- Originating MP [OIU_ORIG_MP_NO]
TRNSP_NO, -- Transporter [OIU_TRNSP_NO]
FREQ_CD, -- Frequency [OIU_FREQ_CD]
ACTL_VOL_U, -- Unit [OIU_ACTL_VOL_U]
ACTL_VOL, -- Actual Volume [OIU_ACTL_VOL]
HEAT_VAL_U, -- HV Unit [OIU_HEAT_VAL_U]
HEAT_VAL, -- Heat.val.factor [OIU_HEAT_VAL]
ACTL_ENERGY_U, -- Energy Unit [OIU_ACTL_ENERGY_U]
ACTL_ENERGY, -- Energy [OIU_ACTL_ENERGY]
WG_OVRD_PC, -- WG override % [OIU_WG_OVRD_PC]
ENTL_CT_VOL, -- Ent. Ct. Volume [OIU_ENTL_CT_VOL]
ADJ_ENTL_CT_VOL, -- Adj.Ent.Ct.Vol. [OIU_ADJ_ENTL_CT_VOL]
ENTL_CT_VOL_U, -- Unit [OIU_VOL_U]
ENTL_CT_ENER, -- Ent Energy [OIU_ENTL_CT_ENER]
ADJ_ENTL_CT_ENER, -- Adj.Ent.Ct.En. [OIU_ADJ_ENTL_CT_ENER]
ENTL_CT_ENER_U, -- Energy Unit [OIU_ENERGY_U]
OIU_CRUSER, -- Created By [ERNAM]
OIU_TIMESTAMP, -- Time Stamp [TZNTSTMPS]
PRIMARY KEY (MANDT, DN_NO, MP_NO, MATNR, CT_NO, SA_DT, OWN_NO, OWN_INT_TYPE_CD, OWN_ISQ_NO, ORIG_MP_NO, TRNSP_NO, FREQ_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