OIUCA_V_MP_U_TRNE

DDL: OIUCA_V_MP_U_TRNE Type: view_entity

Projection View of Contractual Allocation MP Entitle Volume

OIUCA_V_MP_U_TRNE is a CDS View that provides data about "Projection View of Contractual Allocation MP Entitle Volume" in SAP S/4HANA. It reads from 2 data sources (oiu_sb_rnemp, oiu_sb_rnemp_t) and exposes 43 fields.

Data Sources (2)

SourceAliasJoin Type
oiu_sb_rnemp oiu_sb_rnemp from
oiu_sb_rnemp_t oiu_sb_rnemp_t union_all

Annotations (6)

NameValueLevelField
EndUserText.label Projection View of Contractual Allocation MP Entitle 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 (43)

KeyFieldSource TableSource FieldDescription
taf_flg
dn_no dn_no Delivery network ID
mp_no mp_no Measurement Pt
matnr matnr Vehicle Model
vt_cd vt_cd Volume Type
sa_dt sa_dt Sales Date
own_no own_no Owner Number
own_isq_no own_isq_no Own. ISQ
entl_vol_u entl_vol_u Unit
entl_vol entl_vol Entl. Vol.
heat_val_u heat_val_u HV Unit
heat_val heat_val Heat.val.factor
energy_u energy_u UoM
entl_energy entl_energy Energy
gri_pc gri_pc GRI
lse_vol lse_vol Lse Vol
ct_no ct_no Contract
lse_pc lse_pc % Ret. to Lease
mk_rep_no mk_rep_no Marketing Rep
adj_gri_pc adj_gri_pc Adjusted GRI
kw_own_cd kw_own_cd Owner Code KW
oiu_cruser Created By
dn_no dn_no Delivery network ID
mp_no mp_no Measurement Pt
matnr matnr Vehicle Model
vt_cd vt_cd Volume Type
sa_dt sa_dt Sales Date
own_no own_no Owner Number
own_isq_no own_isq_no Own. ISQ
entl_vol_u entl_vol_u Unit
entl_vol entl_vol Entl. Vol.
heat_val_u heat_val_u HV Unit
heat_val heat_val Heat.val.factor
energy_u energy_u UoM
entl_energy entl_energy Energy
gri_pc gri_pc GRI
lse_vol lse_vol Lse Vol
ct_no ct_no Contract
lse_pc lse_pc % Ret. to Lease
mk_rep_no mk_rep_no Marketing Rep
adj_gri_pc adj_gri_pc Adjusted GRI
kw_own_cd kw_own_cd Owner Code KW
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_TRNE.
-- 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_TRNE AS
SELECT
  cast( 'F' as abap.char(1) ) AS taf_flg,
  dn_no,
  mp_no,
  matnr,
  vt_cd,
  sa_dt,
  own_no,
  own_isq_no,
  entl_vol_u,
  entl_vol,
  heat_val_u,
  heat_val,
  energy_u,
  entl_energy,
  gri_pc,
  lse_vol,
  ct_no,
  lse_pc,
  mk_rep_no,
  adj_gri_pc,
  kw_own_cd,
  cast (oiu_cruser as fclm_bam_created_by ) AS oiu_cruser
FROM oiu_sb_rnemp
-- UNION ALL with additional select branch(es): oiu_sb_rnemp_t
;