P_StockLevelMngNumFields

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_StockLevelMngNumFields.
-- 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: PSTCKLVLMNGNUM

CREATE VIEW P_StockLevelMngNumFields AS
SELECT
  MRPArea,
  Material,
  Plant,
  _CalFields.ProposalStartDate AS ProposalStartDate,
  _CalFields.ProposalVersion AS ProposalVersion,
  dats_add_days(_CalFields.ProposalStartDate, -1*1, 'NULL') AS AvgDailyUsageHorizonEndDate,
  dats_add_days(_CalFields.ProposalStartDate,-1*(_CalFields.HorizonDaysInPast + 1), 'NULL') AS AvgDailyUsageHorizonStartDate,
  DATS_ADD_DAYS( cast(_CalFields.ProposalStartDate as dats) ,(-1 * cast(_CalFields.TotalNoOfDays as abap.int4)),'NULL') AS BufLvlProposalHorizonStartDate,
  cast(cast(division(AvgDailyUsageDifference, 1, 3) as abap.quan(13,3)) as pph_avgdailyusagedifference preserving type ) AS AvgDailyUsageDifference,
  cast(cast(division(LeadTimeDifference, 1, 2) as abap.dec(7,2)) as pph_leadtimedifference preserving type ) AS LeadTimeDifference,
  division(VariabilityFactorDifference, 1, 2) AS VariabilityFactorDifference,
  division(LeadTimeFactorDifference,1,2) AS LeadTimeFactorDifference,
  cast(fltp_to_dec(AvgDailyUsageDeviationRate as abap.dec( 12, 2 )) as pph_avgdailyusagedeviationrate preserving type ) AS AvgDailyUsageDeviationRate,
  fltp_to_dec(VariabilityFactorDeviationRate as abap.dec( 12, 2 )) AS VariabilityFactorDeviationRate,
  fltp_to_dec(LeadTimeDeviationRate as abap.dec( 12, 2 )) AS LeadTimeDeviationRate,
  cast(fltp_to_dec(LeadTimeFactorDeviationRate as abap.dec( 12, 2 )) as pph_leadtimedeviationrate preserving type ) AS LeadTimeFactorDeviationRate,
  CurrentRedZone,
  CurrentYellowZone,
  CurrentGreenZone,
  ProposedRedZone,
  ProposedYellowZone,
  ProposedGreenZone,
  RedZoneDifference,
  YellowZoneDifference,
  GreenZoneDifference,
  cast(cast(_CalFields.MaxStockDifference as abap.quan(13,3)) as pph_maxstockdifference preserving type) AS MaxStockDifference,
  _CalFields.CurrentLeadTime AS CurrentLeadTime,
  _CalFields.BufferLevelStartDate AS BufferLevelStartDate,
  _CalFields.CurrentAvgDailyUsage AS CurrentAverageDailyUsage,
  _CalFields.CurrentLeadTimeFactor AS CurrentLeadTimeFactor,
  _CalFields.CurrentVariabilityFactor AS CurrentVariabilityFactor,
  _CalFields.ProposalEndDate AS ProposalEndDate,
  _CalFields.ProposedAverageDailyUsage AS ProposedAverageDailyUsage,
  _CalFields.ProposedLeadTime AS ProposedLeadTime,
  _CalFields.ProposedLeadTimeFactor AS ProposedLeadTimeFactor,
  _CalFields.ProposedVariabilityFactor AS ProposedVariabilityFactor,
  _CalFields.StockLevelProposalID AS StockLevelProposalID,
  _CalFields.StockLevelProposalStatus AS StockLevelProposalStatus,
  _CalFields.AvgDailyUsageUnit AS AvgDailyUsageUnit,
  _CalFields.ProposedMaterialBufferProfile AS ProposedMaterialBufferProfile,
  _CalFields.ProposedMatlBufferProfileText AS ProposedMatlBufferProfileText,
  _CalFields.ProcurementTypeDescription AS ProcurementTypeDescription,
  _CalFields.VariabilityDescription AS VariabilityDescription,
  _CalFields.ReplenishmentLeadTimeDesc AS ReplenishmentLeadTimeDesc,
  _CalFields.DifferenceInDaysDesc AS DifferenceInDaysDesc,
  cast ('%' as meins) AS UnitOfMeasure,
  cast('TAG' as msehi ) AS ActualUnitOfMeasure,
  dats_days_between(_CalFields.ProposalStartDate, cast($session.system_date as sydatum) ) + cast(_CalFields.HorizonDaysInPast as abap.int4) AS HorizonDaysInPast,
  _CalFields.MatlPrpslAdjmtFctrIsApplied AS MatlPrpslAdjmtFctrIsApplied,
  _CalFields.VariabilityQuantity AS VariabilityQuantity,
  _CalFields.VariabilityUnit AS VariabilityUnit,
  _CalFields.ReplenishmentLeadTimeValue AS ReplenishmentLeadTimeValue,
  _CalFields.ProposedMatlVariabilityCode AS ProposedMatlVariabilityCode,
  _CalFields.ProposedMatlVariabilityQty AS ProposedMatlVariabilityQty,
  _CalFields.ProposedMatlVariabilityUnit AS ProposedMatlVariabilityUnit,
  _CalFields.ProposedMatlLeadTimeCode AS ProposedMatlLeadTimeCode,
  _CalFields.ProposedMatlLeadTime AS ProposedMatlLeadTime,
  _CalFields.CurrentMatlLeadTimeCode AS CurrentMatlLeadTimeCode,
  _CalFields.CurrentMatlVariabilityCode AS CurrentMatlVariabilityCode
FROM P_StockLevelMngCalcFields AS _CalFields
LEFT OUTER JOIN I_DifferenceInDaysText AS _DifferenceInDaysText ON _DifferenceInDaysText.DifferenceInDays = _CalFields.DifferenceInDaysDesc AND _DifferenceInDaysText.Language = $session.system_language  -- association [1..1]
;