Fcdm_Read_Attributes

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 Fcdm_Read_Attributes.
-- 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: V_FCDM_ATTR

CREATE VIEW Fcdm_Read_Attributes AS
SELECT
  fcdm_head.fcdmversion AS fcdmversion,
  fcdm_head.matnr AS matnr,
  fcdm_head.werks AS werks,
  fcdm_head.berid AS berid,
  fcdm_item.per_sdat AS per_sdat,
  fcdm_head.plaab AS plaab,
  fcdm_head.planr AS planr,
  fcdm_head.bedae AS bedae,
  fcdm_vers.vervs AS vervs,
  fcdm_head.vervp AS vervp,
  fcdm_head.bdzei AS bdzei,
  fcdm_head.cons_mode AS cons_mode,
  fcdm_head.perkz AS perkz_head,
  fcdm_head.zuvkz AS zuvkz,
  fcdm_item.perkz AS perkz_item,
  fcdm_item.per_edat AS per_edat,
  fcdm_item.loevr AS loevr,
  fcdm_item.acc_past AS acc_past,
  fcdm_item.draft_qty AS draft_qty,
  fcdm_item.plan_qty AS plan_qty,
  fcdm_item.released AS released,
  fcdm_item.withdr_qty AS withdr_qty,
  fcdm_item.plan_qty - fcdm_item.withdr_qty AS open_qty,
  fcdm_item.cons_sdat AS cons_sdat,
  fcdm_item.cons_edat AS cons_edat,
  fcdm_item.pdatu AS pdatu
FROM fcdm_head
INNER JOIN fcdm_item ON /* join condition not captured in parsed metadata */
INNER JOIN fcdm_vers ON /* join condition not captured in parsed metadata */
;