OIUCA_V_WC_U_TCTR

DDL: OIUCA_V_WC_U_TCTR Type: view_entity

Projection View of Contractual Allocation Well Sale Volume

OIUCA_V_WC_U_TCTR is a CDS View that provides data about "Projection View of Contractual Allocation Well Sale Volume" in SAP S/4HANA. It reads from 2 data sources (oiu_sb_ctrwc, oiu_sb_ctrwc_t) and exposes 53 fields.

Data Sources (2)

SourceAliasJoin Type
oiu_sb_ctrwc oiu_sb_ctrwc from
oiu_sb_ctrwc_t oiu_sb_ctrwc_t union_all

Annotations (6)

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

KeyFieldSource TableSource FieldDescription
taf_flg
dn_no dn_no Delivery network ID
sa_dt sa_dt Sales Date
wl_no wl_no Well
wc_no wc_no Well Completion
orig_mp_no orig_mp_no Originating MP
trnsp_no trnsp_no Transporter nbr
matnr matnr Vehicle Model
freq_cd freq_cd Frequency
ct_no ct_no Contract
vc_cd vc_cd Volume Class
std_vol_u std_vol_u Unit
std_vol std_vol Volume
std_heat_val std_heat_val Standardized HV
std_energy_u std_energy_u Std.energy UoM
std_energy std_energy Std. Energy
qy_u qy_u UoM
entl_qy entl_qy Entitled Qy
adj_entl_qy adj_entl_qy Tot. Adj. Entl.
phase_1_qy phase_1_qy Phase 1 Imb.
phase_2_qy phase_2_qy Phase 2 Imb.
phase_3_qy phase_3_qy Phase 3 Imb.
phase_4_qy phase_4_qy Phase 4 quant.
phase_5_qy phase_5_qy Phase 5 quant.
me_docnr me_docnr DocNr
me_docyr me_docyr Doc. year
oiu_cruser Created By
dn_no dn_no Delivery network ID
sa_dt sa_dt Sales Date
wl_no wl_no Well
wc_no wc_no Well Completion
orig_mp_no orig_mp_no Originating MP
trnsp_no trnsp_no Transporter nbr
matnr matnr Vehicle Model
freq_cd freq_cd Frequency
ct_no ct_no Contract
vc_cd vc_cd Volume Class
std_vol_u std_vol_u Unit
std_vol std_vol Volume
std_heat_val std_heat_val Standardized HV
std_energy_u std_energy_u Std.energy UoM
std_energy std_energy Std. Energy
qy_u qy_u UoM
entl_qy entl_qy Entitled Qy
adj_entl_qy adj_entl_qy Tot. Adj. Entl.
phase_1_qy phase_1_qy Phase 1 Imb.
phase_2_qy phase_2_qy Phase 2 Imb.
phase_3_qy phase_3_qy Phase 3 Imb.
phase_4_qy phase_4_qy Phase 4 quant.
phase_5_qy phase_5_qy Phase 5 quant.
me_docnr me_docnr DocNr
me_docyr me_docyr Doc. year
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_TCTR.
-- 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_TCTR AS
SELECT
  cast( 'F' as abap.char(1) ) AS taf_flg,
  dn_no,
  sa_dt,
  wl_no,
  wc_no,
  orig_mp_no,
  trnsp_no,
  matnr,
  freq_cd,
  ct_no,
  vc_cd,
  std_vol_u,
  std_vol,
  std_heat_val,
  std_energy_u,
  std_energy,
  qy_u,
  entl_qy,
  adj_entl_qy,
  phase_1_qy,
  phase_2_qy,
  phase_3_qy,
  phase_4_qy,
  phase_5_qy,
  me_docnr,
  me_docyr,
  cast (oiu_cruser as fclm_bam_created_by ) AS oiu_cruser
FROM oiu_sb_ctrwc
-- UNION ALL with additional select branch(es): oiu_sb_ctrwc_t
;