I_KanbanCalcChangeProposal

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 I_KanbanCalcChangeProposal.
-- 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: IKNBCALCCHGPR

CREATE VIEW I_KanbanCalcChangeProposal AS
SELECT
  pknum AS KanbanControlCycle,
  kcedt AS KnbnCalcChgPrpslCreationDate,
  nexdt AS KnbnControlCycleNextChangeDate,
  nexaz AS KnbnCalcNextNumberOfContainers,
  nexmg AS KnbnCalcNextContainerQty,
  nextri AS KnbnCalcNextTriggerPointVal,
  kcvdt AS KnbnCalcEvalPeriodStartDate,
  kcbdt AS KnbnCalcEvalPeriodEndDate,
  pcmaa AS MaxNmbrOfKnbnCtnsInEvalPerd,
  pcmam AS MaxKnbnCtnQtyInEvalPerd,
  pcmia AS MinNmbrOfKnbnCtnsInEvalPerd,
  pcmim AS MinKnbnCtnQtyInEvalPerd,
  pcmaa_rft AS RefillTmeNmbrOfKnbnCtns,
  pcmam_rft AS RefillTmeKnbnCtnQty,
  pcmaa_wt AS WaitTmeNmbrOfKnbnCtns,
  pcmam_wt AS WaitTmeKnbnCtnQty,
  pcmaa_itt AS TranspTmeNmbrOfKnbnCtns,
  pcmam_itt AS TranspTmeKnbnCtnQty,
  pcmaa_pit AS PullIntvlNmbrOfKnbnCtns,
  pcmam_pit AS PullIntvlKnbnCtnQty,
  pcmaa_calbuf AS CalBufNmbrOfKnbnCtns,
  pcmam_calbuf AS CalBufKnbnCtnQty,
  pcmaa_volat AS RqmtFluctuationNmbrOfKnbnCtn,
  pcmam_volat AS RqmtFluctuationKnbnCtnQty,
  pcmaa_dmbuf AS RqmtBufNmbrOfKnbnCtns,
  pcmam_dmbuf AS RqmtBufKnbnCtnQty,
  pcmaa_supbuf AS SupBufNmbrOfKnbnCtns,
  pcmam_supbuf AS SupBufKnbnCtnQty,
  pcmaa_nopara AS ReplnmtLeadTmeNmbrOfKnbnCtns,
  pcmam_nopara AS ReplnmtLeadTmeKnbnCtnQty,
  pcmaa_sfc AS SftyFctrNmbrOfKnbnCtns,
  pcmam_sfc AS SftyFctrKnbnCtnQty,
  pcmaa_capabuf AS CapBufNmbrOfCtns,
  pcmam_capabuf AS CapBufKnbnCtnQty,
  capa_wrkct AS PlanningWorkCenter,
  triggr AS KanbanCtrlCycReplnmtTriggerGrp,
  capa_utl_t AS KanbanCalcTotalCapUtilznPct,
  capa_utl_p AS KanbanCalcProdnCapUtilznPct,
  capa_utl_s AS KanbanCalcSetupCapUtilznPct,
  kigdays AS NrOfDaysWthoutRqmtsToBeIgnrd,
  plscn AS MRPPlanningScenario,
  _KanbanControlCycle.BaseUnit AS BaseUnit,
  _KanbanControlCycle.Plant AS Plant,
  _KanbanControlCycle.Supplier AS Supplier
FROM pkpr
LEFT OUTER JOIN I_KanbanControlCycle AS _KanbanControlCycle ON KanbanControlCycle = _KanbanControlCycle.KanbanControlCycle  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompanyByPlant AS _SupplierCompanyByPlant ON supplier = _SupplierCompanyByPlant.Supplier AND plant = _SupplierCompanyByPlant.Plant  -- association [0..1]
;