PlndIndepRqmtPlanIndSum

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 PlndIndepRqmtPlanIndSum.
-- 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: PIRSUM

CREATE VIEW PlndIndepRqmtPlanIndSum AS
SELECT
  pir.Product AS matnr,
  pir.Plant AS werks,
  pir.MRPArea AS berid,
  pir.PlndIndepRqmtType AS bedae,
  pir.PlndIndepRqmtVersion AS versb,
  coalesce(cast(pir.per_sdat as pph_per_sdat preserving type),'00010101') AS per_sdat,
  marc.perkz AS perkz_master,
  coalesce(pir.perkz_item,'') AS perkz_item,
  cast(pir.per_edat as pph_per_edat preserving type) AS per_edat,
  pir.DmndFcstIsDeleted AS DmndFcstIsDeleted,
  pir.DmndFcstInPastIsAccepted AS DmndFcstInPastIsAccepted,
  pir.plan_qty AS plan_qty,
  pir.withdr_qty AS withdr_qty,
  pir.open_qty AS open_qty,
  pir.UnitOfMeasure AS item_meins,
  pir.pdatu AS pdatu,
  marc.lvorm AS marc_lvorm,
  mara.lvorm AS mara_lvorm,
  mara.meins AS mara_meins,
  t141_marc.dpbed AS marc_dpbed,
  t141_mara.dpbed AS mara_dpbed,
  pir.lastchange AS lastchange,
  case when pir.LastChangeDate = fltp_to_dec( 0.0 as timestampl ) then fltp_to_dec( 99990101000000.0 as timestampl ) when pir.LastChangeDate is null then fltp_to_dec( 99990101000000.0 as timestampl ) else pir.LastChangeDate end as last_change_dats AS LastChangeDateendaslast_change_dats,
  pir.LastChangedByUser AS LastChangedByUser,
  marc.dispo AS dispo,
  pir.RequirementPlan AS RequirementPlan,
  pir.RequirementSegment AS RequirementSegment,
  pir.RequirementPlanIsExternal AS RequirementPlanIsExternal,
  pir.PlndIndepRqmtIsActive AS PlndIndepRqmtIsActive,
  pir.ProductName AS ProductName,
  _Plant.PlantName AS PlantName,
  _MRPArea.MRPAreaText AS MRPAreaText,
  _RqmtVersion.DmndFcstVersionText AS DmndFcstVersionText,
  _MRPController.MRPControllerName AS MRPControllerName,
  _RqmtType.PlndIndepRqmtTypeName AS RequirementTypeName
FROM P_PlndIndepRqmtAllAttrib AS pir
INNER JOIN marc ON /* join condition not captured in parsed metadata */
INNER JOIN mara ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Plant AS _Plant ON pir.Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_MRPArea AS _MRPArea ON pir.MRPArea = _MRPArea.MRPArea  -- association [1..1]
LEFT OUTER JOIN I_MRPController AS _MRPController ON marc.dispo = _MRPController.MRPController AND pir.Plant = _MRPController.Plant  -- association [1..1]
LEFT OUTER JOIN I_PlndIndepRqmtTypeText AS _RqmtType ON pir.PlndIndepRqmtType = _RqmtType.PlndIndepRqmtType AND _RqmtType.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_PlndIndepRqmtMRPVersionText AS _RqmtVersion ON pir.PlndIndepRqmtVersion = _RqmtVersion.Version AND _RqmtVersion.Language = $session.system_language  -- association [1..1]
;