I_KanbanCalculationProfile

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_KanbanCalculationProfile.
-- 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: IKNBCALCPRFL

CREATE VIEW I_KanbanCalculationProfile AS
SELECT
  werks AS Plant,
  kcprf AS KanbanContainerCalcProfile,
  kcart AS KanbanContainerCalculationType,
  kcsaf AS KanbanCtnCalcSafetyFactor,
  kccon AS KanbanCtnCalculationConstant,
  kcgla AS KanbanCalcRqmtsSmoothingType,
  verti AS QuantityDistributionKey,
  schgrup AS SupplySourceShiftGrouping,
  sprog AS SupplySourceShiftSequence,
  fabkl AS SupplySourceFactoryCalendar,
  kwbzd AS ReplnmtLeadTimeInWorkdays,
  cast(tpkbp.kwbzm as vdm_kwbzm preserving type) AS ReplnmtLeadTimeInHoursAndMins,
  schgrupv AS ConsumerShiftGrouping,
  sprogv AS ConsumerShiftSequence,
  fabklv AS ConsumerFactoryCalendar,
  cast(tpkbp.pintvd as vdm_pintvd preserving type) AS PullIntervalInWorkdays,
  cast(tpkbp.pintvm as vdm_pintvm preserving type) AS PullIntervalInHoursAndMinutes,
  kdmbuf AS KnbnCtnCalcRqmtBufferInPercent,
  kspbuf AS KnbnCtnCalcSupplySrceBufInPct,
  kdmvol AS RqmtFluctuationsAreConsdrd,
  mrppp AS MRPPlanningCalendar,
  abftb AS NonWorkingDaysAreConsdrd
FROM tpkbp
LEFT OUTER JOIN I_KanbanCalcProfileText AS _Text ON KanbanContainerCalcProfile = _Text.KanbanContainerCalcProfile AND Plant = _Text.Plant  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
;