I_StockLevelProposalTP

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_StockLevelProposalTP.
-- 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: IDDSTKLVLPRPSLTP

CREATE VIEW I_StockLevelProposalTP AS
SELECT
  StockProposal.Material AS Material,
  StockProposal.Plant AS Plant,
  StockProposal.MRPArea AS MRPArea,
  StockProposal.ProposalStartDate AS ProposalStartDate,
  StockProposal.ProposalVersion AS ProposalVersion,
  StockProposal.ProposalEndDate AS ProposalEndDate,
  StockProposal.StockLevelProposalID AS StockLevelProposalID,
  StockProposal.MaterialGroup AS MaterialGroup,
  StockProposal.PurchasingGroup AS PurchasingGroup,
  StockProposal.ConsumptionCode AS ConsumptionCode,
  StockProposal.ConsumptionValue AS ConsumptionValue,
  StockProposal.Currency AS Currency,
  StockProposal.VariabilityCode AS VariabilityCode,
  StockProposal.VariabilityQuantity AS VariabilityQuantity,
  StockProposal.VariabilityUnit AS VariabilityUnit,
  StockProposal.ReplenishmentLeadTimeCode AS ReplenishmentLeadTimeCode,
  StockProposal.ProcurementType AS ProcurementType,
  StockProposal.ReplenishmentLeadTimeValue AS ReplenishmentLeadTimeValue,
  StockProposal.BOMUsageCode AS BOMUsageCode,
  StockProposal.BOMUsageValue AS BOMUsageValue,
  StockProposal.IndividualLeadTime AS IndividualLeadTime,
  StockProposal.DecoupledLeadTime AS DecoupledLeadTime,
  StockProposal.SourceOfSupply AS SourceOfSupply,
  StockProposal.SOSType AS SOSType,
  StockProposal.LeadTimeFactor AS LeadTimeFactor,
  StockProposal.VariabilityFactor AS VariabilityFactor,
  StockProposal.StockLevelProposalStatus AS StockLevelProposalStatus,
  StockProposal.ProposalStatusChangeDate AS ProposalStatusChangeDate,
  StockProposal.IsMinOrderQtyConsidered AS IsMinOrderQtyConsidered,
  StockProposal.MinimumOrderQuantity AS MinimumOrderQuantity,
  StockProposal.MinOrderQtyUnit AS MinOrderQtyUnit,
  StockProposal.PrevRedZoneAdjustmentFctr AS PrevRedZoneAdjustmentFctr,
  StockProposal.PrevYellowZoneAdjustmentFctr AS PrevYellowZoneAdjustmentFctr,
  StockProposal.PrevGreenZoneAdjustmentFctr AS PrevGreenZoneAdjustmentFctr,
  StockProposal.CurRedZoneAdjustmentFctr AS CurRedZoneAdjustmentFctr,
  StockProposal.CurYellowZoneAdjustmentFctr AS CurYellowZoneAdjustmentFctr,
  StockProposal.CurGreenZoneAdjustmentFctr AS CurGreenZoneAdjustmentFctr,
  StockProposal.BillOfMaterialUUID AS BillOfMaterialUUID,
  StockProposal.BOMExplosionDate AS BOMExplosionDate,
  StockProposal.CreatedByUser AS CreatedByUser,
  StockProposal.LastChangedByUser AS LastChangedByUser,
  StockProposal.CreationDateTime AS CreationDateTime,
  StockProposal.LastChangeDateTime AS LastChangeDateTime,
  ProposedRedZone,
  ProposedYellowZone,
  ProposedGreenZone,
  OriglProposedRedZone,
  OriglProposedYellowZone,
  OriglProposedGreenZone,
  StockProposal.AverageDailyUsage AS AverageDailyUsage,
  AvgDailyUsageUnit,
  StockProposal.MaterialBaseUnit AS MaterialBaseUnit,
  StockProposal.MRPGroup AS MRPGroup,
  StockProposal.MRPController AS MRPController
FROM I_StockLevelProposal AS StockProposal
;