P_Bpfpdynitem

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 P_Bpfpdynitem.
-- 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: PBPFPDIFLOW

CREATE VIEW P_Bpfpdynitem AS
SELECT
  DIIndividualFlow.dlinr AS dlinr,
  DIIndividualFlow.vbeln AS vbeln,
  DIIndividualFlow.vbpos AS vbpos,
  DynamicItem.cpd_dliid AS cpd_dliid,
  DIIndividualFlow.fkdat AS fkdat,
  DIIndividualFlow.dopen AS dopen,
  DIIndividualFlow.fkdat_active AS fkdat_active,
  DIIndividualFlow.to_date AS to_date,
  case when DIIndividualFlow.dopen = 'X' then 'X' end as dopen_x AS dopenXthenXendasdopen_x,
  case when DIIndividualFlow.dopen = 'D' then 'X' end as dopen_d AS dopenDthenXendasdopen_d,
  case when DIIndividualFlow.dopen = ' ' then 'X' end as dopen_space AS dopenthenXendasdopen_space,
  case when DIIndividualFlow.fkdat_active = 'X' then 'X' end as fkdat_active_x AS fkdat_activeXthenXendasfkdat_active_x
FROM ad01dlief AS DIIndividualFlow
INNER JOIN ad01dli AS DynamicItem ON /* join condition not captured in parsed metadata */
;