Atpc_Cds_Union

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 Atpc_Cds_Union.
-- 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.
-- SQL view name: ATPC_UNION

CREATE VIEW Atpc_Cds_Union AS
SELECT
  mandt,
  delnr,
  delps,
  delet,
  atpcat,
  matnr,
  werks,
  berid,
  lgort,
  charg,
  bwtar,
  sgt_rcat,
  sobkz,
  sskey,
  sskey_ext,
  group_number,
  Group_Type,
  fixmg,
  uepvw,
  uepos,
  mtvfp,
  abgru,
  lfsta,
  xchar,
  lprio,
  kztlf,
  antlf,
  cast('0' as webaz) AS webaz,
  resmd,
  req_class,
  pstyv,
  cast('' as ebstyp preserving type) AS bstyp,
  cast('' as esart) AS bsart,
  open_reqqty,
  vtweg,
  spart,
  auart,
  vsbed,
  vstel,
  route,
  aulwe,
  cast(0 as eplif) AS plifz,
  tddat,
  tduhr,
  wadat,
  wauhr,
  lddat,
  lduhr,
  cast('00000000' as eldat) AS eldat,
  cast('000000' as eluhr) AS eluhr,
  gewei,
  kwmeng,
  uvvlk,
  fsh_candate,
  CreationDate,
  LastChangeDate,
  Substn_Numerator,
  Substn_Denominator,
  cuobj,
  cuobj_ch,
  rfsta,
  bwart,
  shkzg,
  awahr,
  vbtyp,
  stman,
  umvkz,
  lsmeng,
  volum,
  voleh,
  ntgew,
  tm_ctrl_key
FROM Atpc_Cds_Vbep
-- UNION with additional select branch(es): Atpc_Cds_Sto
;