OIUCA_V_MP_U_TACT

DDL: OIUCA_V_MP_U_TACT Type: view_entity

Projection View of Contractual Allocation MP Actual Volume

OIUCA_V_MP_U_TACT is a CDS View that provides data about "Projection View of Contractual Allocation MP Actual Volume" in SAP S/4HANA. It reads from 2 data sources (oiu_sb_actmp, oiu_sb_actmp_t) and exposes 39 fields.

Data Sources (2)

SourceAliasJoin Type
oiu_sb_actmp oiu_sb_actmp from
oiu_sb_actmp_t oiu_sb_actmp_t union_all

Annotations (6)

NameValueLevelField
EndUserText.label Projection View of Contractual Allocation MP Actual Volume view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (39)

KeyFieldSource TableSource FieldDescription
taf_flg
dn_no dn_no Delivery network ID
mp_no mp_no Measurement Pt
matnr matnr Vehicle Model
ct_no ct_no Contract
sa_dt sa_dt Sales Date
own_no own_no Owner Number
own_isq_no own_isq_no Own. ISQ
orig_mp_no orig_mp_no Originating MP
trnsp_no trnsp_no Transporter nbr
freq_cd freq_cd Frequency
actl_vol_u actl_vol_u Unit
actl_vol actl_vol Actual Volume
heat_val_u heat_val_u HV Unit
heat_val heat_val Heat.val.factor
actl_energy actl_energy Energy
wg_ovrd_pc wg_ovrd_pc WG override %
entl_ct_vol entl_ct_vol Ent. Ct. Volume
entl_ct_ener entl_ct_ener Ent Energy
oiu_cruser Created By
dn_no dn_no Delivery network ID
mp_no mp_no Measurement Pt
matnr matnr Vehicle Model
ct_no ct_no Contract
sa_dt sa_dt Sales Date
own_no own_no Owner Number
own_isq_no own_isq_no Own. ISQ
orig_mp_no orig_mp_no Originating MP
trnsp_no trnsp_no Transporter nbr
freq_cd freq_cd Frequency
actl_vol_u actl_vol_u Unit
actl_vol actl_vol Actual Volume
heat_val_u heat_val_u HV Unit
heat_val heat_val Heat.val.factor
actl_energy actl_energy Energy
wg_ovrd_pc wg_ovrd_pc WG override %
entl_ct_vol entl_ct_vol Ent. Ct. Volume
entl_ct_ener entl_ct_ener Ent Energy
oiu_cruser Created By

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view OIUCA_V_MP_U_TACT.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW OIUCA_V_MP_U_TACT AS
SELECT
  cast( 'F' as abap.char(1) ) AS taf_flg,
  dn_no,
  mp_no,
  matnr,
  ct_no,
  sa_dt,
  own_no,
  own_isq_no,
  orig_mp_no,
  trnsp_no,
  freq_cd,
  actl_vol_u,
  actl_vol,
  heat_val_u,
  heat_val,
  actl_energy,
  wg_ovrd_pc,
  entl_ct_vol,
  entl_ct_ener,
  cast (oiu_cruser as fclm_bam_created_by ) AS oiu_cruser
FROM oiu_sb_actmp
-- UNION ALL with additional select branch(es): oiu_sb_actmp_t
;