I_ProdBufLvlPrpsl

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_ProdBufLvlPrpsl.
-- 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: IPRODBUFLVLPRPSL

CREATE VIEW I_ProdBufLvlPrpsl AS
SELECT
  Material,
  Plant,
  MRPArea,
  ProposalStartDate,
  ProposalVersion,
  ProposalEndDate,
  StockLevelProposalID,
  ConsumptionCode,
  ConsumptionMode,
  cast(cast( ConsumptionValue as abap.curr(17,2) ) as pph_dd_abc_con_value ) AS ConsumptionValue,
  Currency,
  VariabilityCode,
  VariabilityMode,
  VariabilityQuantity,
  VariabilityUnit,
  ReplenishmentLeadTimeCode,
  ReplenishmentLeadTimeMode,
  ProcurementType,
  ReplenishmentLeadTimeValue,
  BOMUsageCode,
  BOMUsageMode,
  BOMUsageValue,
  HorizonDaysInPast,
  HorizonDaysInFuture,
  IndividualLeadTime,
  LeadTimeCalculationMethod,
  DecoupledLeadTime,
  SourceOfSupply,
  SOSType,
  LeadTimeFactor,
  VariabilityFactor,
  StockLevelProposalStatus,
  ProposalRunIsSuspended,
  ProposalRunSuspendedFromDate,
  ProposalRunSuspendedToDate,
  ProposalMode,
  ProposalStatusChangeDate,
  IsMinOrderQtyConsidered,
  MinimumOrderQuantity,
  MinOrderQtyUnit,
  RedZoneAdjustmentFactor,
  YellowZoneAdjustmentFactor,
  GreenZoneAdjustmentFactor,
  DemandAdjustmentFactor,
  OrderCycle,
  BillOfMaterialUUID,
  BOMExplosionDate,
  CreatedByUser,
  LastChangedByUser,
  CreationDateTime,
  MaterialGroup,
  PurchasingGroup,
  CurRedZoneAdjustmentFctr,
  CurYellowZoneAdjustmentFctr,
  CurGreenZoneAdjustmentFctr,
  _ProposalRecords.AverageDailyUsage AS AverageDailyUsage,
  _ProposalRecords.AvgDailyUsageUnit AS AvgDailyUsageUnit,
  _BufMatPlant._Material.BaseUnit AS MaterialBaseUnit,
  MRPGroup,
  MRPController,
  UnitOfMeasureNumberOfDecimals,
  AverageDailyUsageMode,
  ProductAuthorizationGroup,
  ProductTypeAuthorizationGroup,
  ProductGroupAuthorizationGroup,
  IsBulkMaterial,
  IsPhantomItem,
  MRPMaterialStatus
FROM I_ProdBufLvlPrpslZones AS _ProposalRecords
;