OIUCA_V_WC_U_TENT

DDL: OIUCA_V_WC_U_TENT Type: view_entity

Projection View of Contractual Allocation Well Entitle Volume

OIUCA_V_WC_U_TENT is a CDS View that provides data about "Projection View of Contractual Allocation Well Entitle Volume" in SAP S/4HANA. It reads from 2 data sources (oiu_sb_entwc, oiu_sb_entwc_t) and exposes 45 fields.

Data Sources (2)

SourceAliasJoin Type
oiu_sb_entwc oiu_sb_entwc from
oiu_sb_entwc_t oiu_sb_entwc_t union_all

Annotations (6)

NameValueLevelField
EndUserText.label Projection View of Contractual Allocation Well 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 (45)

KeyFieldSource TableSource FieldDescription
taf_flg
dn_no dn_no Delivery network ID
matnr matnr Vehicle Model
wl_no wl_no Well
wc_no wc_no Well Completion
bukrs bukrs Value
vname vname Volatility Name
doi_no doi_no Venture/DOI
sa_dt sa_dt Sales Date
freq_cd freq_cd Frequency
vt_cd vt_cd Volume Type
own_no own_no Owner Number
own_isq_no own_isq_no Own. ISQ
mk_rep_no mk_rep_no Marketing Rep
vol_u vol_u Unit
entl_vol entl_vol Entl. Vol.
adj_entl_vol adj_entl_vol Adj.Entl.Vol.
energy_u energy_u UoM
entl_energy entl_energy Energy
gri_pc gri_pc GRI
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
matnr matnr Vehicle Model
wl_no wl_no Well
wc_no wc_no Well Completion
bukrs bukrs Value
vname vname Volatility Name
doi_no doi_no Venture/DOI
sa_dt sa_dt Sales Date
freq_cd freq_cd Frequency
vt_cd vt_cd Volume Type
own_no own_no Owner Number
own_isq_no own_isq_no Own. ISQ
mk_rep_no mk_rep_no Marketing Rep
vol_u vol_u Unit
entl_vol entl_vol Entl. Vol.
adj_entl_vol adj_entl_vol Adj.Entl.Vol.
energy_u energy_u UoM
entl_energy entl_energy Energy
gri_pc gri_pc GRI
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_WC_U_TENT.
-- 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_WC_U_TENT AS
SELECT
  cast( 'F' as abap.char(1) ) AS taf_flg,
  dn_no,
  matnr,
  wl_no,
  wc_no,
  bukrs,
  vname,
  doi_no,
  sa_dt,
  freq_cd,
  vt_cd,
  own_no,
  own_isq_no,
  mk_rep_no,
  vol_u,
  entl_vol,
  adj_entl_vol,
  energy_u,
  entl_energy,
  gri_pc,
  adj_gri_pc,
  kw_own_cd,
  cast (oiu_cruser as fclm_bam_created_by ) AS oiu_cruser
FROM oiu_sb_entwc
-- UNION ALL with additional select branch(es): oiu_sb_entwc_t
;