C_StockLevelMgmtTP

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 C_StockLevelMgmtTP.
-- 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: CSTKLVLMGMTTP

CREATE VIEW C_StockLevelMgmtTP AS
SELECT
  StockProposal.MRPArea AS MRPArea,
  StockProposal.Plant AS Plant,
  StockProposal.Material AS Material,
  StockProposal.ProposalStartDate AS ProposalStartDate,
  StockProposal.ProposalVersion AS ProposalVersion,
  _SDMAreaOfResponsibility.UserID AS UserID,
  StockProposal._BufMatPlant._Material._Text[1:Language=$session.system_language].ProductName AS MaterialName,
  StockProposal._BufMatPlant._Plant.PlantName AS PlantName,
  _SDMAreaOfResponsibility.MRPAreaText AS MRPAreaText,
  StockProposal.MaterialBaseUnit AS BaseUnit,
  StockProposal.StockLevelProposalID AS StockLevelProposalID,
  StockProposal.StockLevelProposalStatus AS StockLevelProposalStatus,
  StockProposal._StatusText.ProposalStatusDescription AS ProposalStatusDescription,
  _CalFields.CurrentRedZone AS CurrentRedZone,
  StockProposal.OriglProposedRedZone AS OriglProposedRedZone,
  StockProposal.PrevRedZoneAdjustmentFctr AS PrevRedZoneAdjustmentFctr,
  _CalFields.RedZoneDifference AS RedZoneDifference,
  StockProposal.ProposedRedZone AS ProposedRedZone,
  StockProposal.CurRedZoneAdjustmentFctr AS CurRedZoneAdjustmentFctr,
  _CalFields.CurrentYellowZone AS CurrentYellowZone,
  StockProposal.OriglProposedYellowZone AS OriglProposedYellowZone,
  StockProposal.PrevYellowZoneAdjustmentFctr AS PrevYellowZoneAdjustmentFctr,
  _CalFields.YellowZoneDifference AS YellowZoneDifference,
  StockProposal.ProposedYellowZone AS ProposedYellowZone,
  StockProposal.CurYellowZoneAdjustmentFctr AS CurYellowZoneAdjustmentFctr,
  _CalFields.CurrentGreenZone AS CurrentGreenZone,
  StockProposal.OriglProposedGreenZone AS OriglProposedGreenZone,
  StockProposal.PrevGreenZoneAdjustmentFctr AS PrevGreenZoneAdjustmentFctr,
  _CalFields.GreenZoneDifference AS GreenZoneDifference,
  StockProposal.ProposedGreenZone AS ProposedGreenZone,
  StockProposal.CurGreenZoneAdjustmentFctr AS CurGreenZoneAdjustmentFctr,
  _CalFields.MaxStockDifference AS MaxStockDifference,
  _CalFields.MaxStockDeviationRate AS MaxStockDeviationRate,
  _CalFields.UnitOfMeasure AS UnitOfMeasure,
  _CalFields.CurrentAverageDailyUsage AS CurrentAverageDailyUsage,
  _CalFields.ProposedAverageDailyUsage AS ProposedAverageDailyUsage,
  _CalFields.AvgDailyUsageDifference AS AvgDailyUsageDifference,
  _CalFields.AvgDailyUsageDeviationRate AS AvgDailyUsageDeviationRate,
  _CalFields.CurrentVariabilityFactor AS CurrentVariabilityFactor,
  _CalFields.ProposedVariabilityFactor AS ProposedVariabilityFactor,
  _CalFields.VariabilityFactorDeviationRate AS VariabilityFactorDeviationRate,
  _CalFields.VariabilityFactorDifference AS VariabilityFactorDifference,
  _CalFields.CurrentLeadTime AS CurrentLeadTime,
  _CalFields.ProposedLeadTime AS ProposedLeadTime,
  _CalFields.LeadTimeDifference AS LeadTimeDifference,
  _CalFields.LeadTimeDeviationRate AS LeadTimeDeviationRate,
  _CalFields.CurrentLeadTimeFactor AS CurrentLeadTimeFactor,
  _CalFields.ProposedLeadTimeFactor AS ProposedLeadTimeFactor,
  _CalFields.LeadTimeFactorDifference AS LeadTimeFactorDifference,
  _CalFields.LeadTimeFactorDeviationRate AS LeadTimeFactorDeviationRate,
  _CalFields.DifferenceInDays AS DifferenceInDays,
  StockProposal._BufMatPlant._Material.ProductGroup AS MaterialGroup,
  StockProposal.MRPController AS MRPController,
  StockProposal.PurchasingGroup AS PurchasingGroup,
  StockProposal.MRPGroup AS MRPGroup,
  _CalFields.MatlPrpslAdjmtFctrIsApplied AS MatlPrpslAdjmtFctrIsApplied,
  _CalFields.NormalizedCurrentGreenZone AS NormalizedCurrentGreenZone,
  _CalFields.NormalizedCurrentYellowZone AS NormalizedCurrentYellowZone,
  _CalFields.NormalizedCurrentRedZone AS NormalizedCurrentRedZone,
  _CalFields.NormalizedProposedGreenZone AS NormalizedProposedGreenZone,
  _CalFields.NormalizedProposedYellowZone AS NormalizedProposedYellowZone,
  _CalFields.NormalizedProposedRedZone AS NormalizedProposedRedZone,
  StockProposal._MatMRPArea._MRPArea.MRPAreaCategory AS MRPAreaCategory,
  _CalFields.HorizonDaysInPast AS HorizonDaysInPast,
  _CalFields.AvgDailyUsageHorizonEndDate AS AvgDailyUsageHorizonEndDate,
  _CalFields.AvgDailyUsageHorizonStartDate AS AvgDailyUsageHorizonStartDate,
  _CalFields.ProposedMaterialBufferProfile AS ProposedMaterialBufferProfile,
  _CalFields.ProposedMatlBufferProfileText AS ProposedMatlBufferProfileText,
  StockProposal.BOMUsageCode AS BOMUsageCode,
  StockProposal._BOMUsgText.BOMUsageDescription AS BOMUsageDescription,
  StockProposal.ConsumptionCode AS ConsumptionCode,
  StockProposal._ConsumptionText.ConsumptionDescription AS ConsumptionDescription,
  StockProposal.VariabilityCode AS VariabilityCode,
  _CalFields.VariabilityQuantity AS VariabilityQuantity,
  _CalFields.VariabilityDescription AS VariabilityDescription,
  StockProposal.ReplenishmentLeadTimeCode AS ReplenishmentLeadTimeCode,
  _CalFields.ReplenishmentLeadTimeValue AS ReplenishmentLeadTimeValue,
  _CalFields.ReplenishmentLeadTimeDesc AS ReplenishmentLeadTimeDesc,
  StockProposal.ProcurementType AS ProcurementType,
  _CalFields.ProcurementTypeDescription AS ProcurementTypeDescription,
  _CalFields.CurrentMatlVariabilityCode AS CurrentMatlVariabilityCode,
  StockProposal.VariabilityCode AS ProposedMatlVariabilityCode,
  _CalFields.ProposedMatlVariabilityQty AS ProposedMatlVariabilityQty,
  _CalFields.ProposedMatlVariabilityUnit AS ProposedMatlVariabilityUnit,
  _CalFields.CurrentMatlLeadTimeCode AS CurrentMatlLeadTimeCode,
  StockProposal.ReplenishmentLeadTimeCode AS ProposedMatlLeadTimeCode,
  _CalFields.ProposedMatlLeadTime AS ProposedMatlLeadTime,
  StockProposal.BOMExplosionDate AS BOMExplosionDate,
  _CalFields.BufLvlProposalHorizonStartDate AS BufLvlProposalHorizonStartDate,
  StockProposal._BufMatPlant AS _BufMatPlant
FROM I_StockLevelProposalTP AS StockProposal
INNER JOIN also AS filter ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_MRPAreaByAreaOfRespy AS _SDMAreaOfResponsibility ON MRPArea = _SDMAreaOfResponsibility.MRPArea AND MRPController = _SDMAreaOfResponsibility.MRPController AND _SDMAreaOfResponsibility.UserID = $session.user  -- association [1..1]
LEFT OUTER JOIN P_StockLevelMngNumFields AS _CalFields ON Material = _CalFields.Material AND Plant = _CalFields.Plant AND MRPArea = _CalFields.MRPArea  -- association [1..1]
LEFT OUTER JOIN C_MaterialDailyDemand AS _MaterialDailyDemand ON Material = _MaterialDailyDemand.Material AND Plant = _MaterialDailyDemand.Plant AND MRPArea = _MaterialDailyDemand.MRPArea  -- association [1..*]
LEFT OUTER JOIN C_ProposedBufferMatlBOM AS _ProposedBOM ON Material = _ProposedBOM.Material AND Plant = _ProposedBOM.Plant AND MRPArea = _ProposedBOM.MRPArea  -- association [1..*]
LEFT OUTER JOIN C_ProdBufPrflAndClassfctn AS _BufferClassifications ON Material = _BufferClassifications.Material AND Plant = _BufferClassifications.Plant AND MRPArea = _BufferClassifications.MRPArea  -- association [1..*]
LEFT OUTER JOIN C_MatlConsumptionIndValHelp AS _MatlConsumptionIndValHelp ON ConsumptionCode = _MatlConsumptionIndValHelp.ConsumptionCode  -- association [1..1]
LEFT OUTER JOIN C_MatlLeadTimeIndValHelp AS _MatlLeadTimeIndValHelp ON ReplenishmentLeadTimeCode = _MatlLeadTimeIndValHelp.ReplenishmentLeadTimeCode  -- association [1..1]
LEFT OUTER JOIN C_MatlVariabilityIndValHelp AS _MatlVariabilityIndValHelp ON VariabilityCode = _MatlVariabilityIndValHelp.VariabilityCode  -- association [1..1]
LEFT OUTER JOIN C_MatlBOMUsageIndValHelp AS _MatlBOMUsageIndValHelp ON BOMUsageCode = _MatlBOMUsageIndValHelp.BOMUsageCode  -- association [1..1]
LEFT OUTER JOIN C_StockLevelProposalStatus AS _StockProposalStatus ON StockLevelProposalStatus = _StockProposalStatus.StockLevelProposalStatus  -- association [1..1]
LEFT OUTER JOIN C_MaterialProcurementTypeVH AS _MaterialProcurementTypeVH ON ProcurementType = _MaterialProcurementTypeVH.ProcurementType  -- association [1..1]
LEFT OUTER JOIN C_MatlPrpslAdjmtFctrIsAppld AS _AdjustmentFactor ON matlprpsladjmtfctrisapplied = _AdjustmentFactor.MatlPrpslAdjmtFctrIsApplied  -- association [1..1]
;