OIU_SB_ACTMP
Actual Owner Level Contractual Allocations results at MP
OIU_SB_ACTMP is an SAP database table in S/4HANA. Actual Owner Level Contractual Allocations results at MP. It contains 19 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ContrAllocVolPrimProdMP | view | from | BASIC | CA Volume Primary Product For MP |
| OIUCA_V_MP_U_TACT | view_entity | from | Projection View of Contractual Allocation MP Actual Volume |
Fields (19)
| 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 % |
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 (
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]
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