P_ProposedStockBuffer

DDL: P_PROPOSEDSTOCKBUFFER SQL: PPROPSTKBUF Type: view CONSUMPTION Package: ODATA_PP_DD_STLM
45 Fields 1 Data Sources

Proposed Stock Buffer

P_ProposedStockBuffer is a Consumption CDS View that provides data about "Proposed Stock Buffer" in SAP S/4HANA. It reads from 1 data source (I_StockLevelProposal) and exposes 45 fields with key fields Material, Plant, MRPArea, ProposalStartDate, ProposalVersion. Part of development package ODATA_PP_DD_STLM.

Data Sources (1)

SourceAliasJoin Type
I_StockLevelProposal StockProposalHdr from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PPROPSTKBUF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY Material I_StockLevelProposal Material Vehicle Model
KEY Plant I_StockLevelProposal Plant Valuation Area
KEY MRPArea I_StockLevelProposal MRPArea MRP Area
KEY ProposalStartDate I_StockLevelProposal ProposalStartDate
KEY ProposalVersion I_StockLevelProposal ProposalVersion
ProposedLeadTime I_StockLevelProposal DecoupledLeadTime
ProposedIndividualLeadTime I_StockLevelProposal IndividualLeadTime
IsMinOrderQtyConsidered I_StockLevelProposal IsMinOrderQtyConsidered
LastChangeDateTime I_StockLevelProposal LastChangeDateTime Timestamp
LeadTimeFactor I_StockLevelProposal LeadTimeFactor
MinOrderQtyUnit I_StockLevelProposal MinOrderQtyUnit
MinimumOrderQuantity I_StockLevelProposal MinimumOrderQuantity Minimum Order Quantity
ProposalEndDate I_StockLevelProposal ProposalEndDate
StockLevelProposalID I_StockLevelProposal StockLevelProposalID
StockLevelProposalStatus I_StockLevelProposal StockLevelProposalStatus
ProposedVariabilityFactor I_StockLevelProposal VariabilityFactor
BillOfMaterialUUID I_StockLevelProposal BillOfMaterialUUID Character Field of Length 12
SourceOfSupply I_StockLevelProposal SourceOfSupply Supply source
clientNULLasProposalStatusChangeDate
ProposedRedZone I_StockLevelProposal ProposedRedZone
ProposedYellowZone I_StockLevelProposal ProposedYellowZone
ProposedGreenZone I_StockLevelProposal ProposedGreenZone
ProposedAverageDailyUsage I_StockLevelProposal AverageDailyUsage
BOMUsageCode I_StockLevelProposal BOMUsageCode
BOMUsageValue
ConsumptionCode I_StockLevelProposal ConsumptionCode
ConsumptionValue I_StockLevelProposal ConsumptionValue
Currency I_StockLevelProposal Currency Valuation Crcy
VariabilityCode I_StockLevelProposal VariabilityCode
VariabilityQuantity I_StockLevelProposal VariabilityQuantity
VariabilityUnit I_StockLevelProposal VariabilityUnit
ReplenishmentLeadTimeCode I_StockLevelProposal ReplenishmentLeadTimeCode
ReplenishmentLeadTimeValue I_StockLevelProposal ReplenishmentLeadTimeValue
ProcurementType I_StockLevelProposal ProcurementType Procurement
CurRedZoneAdjustmentFctr I_StockLevelProposal CurRedZoneAdjustmentFctr
CurYellowZoneAdjustmentFctr I_StockLevelProposal CurYellowZoneAdjustmentFctr
CurGreenZoneAdjustmentFctr I_StockLevelProposal CurGreenZoneAdjustmentFctr
PrevRedZoneAdjustmentFctr I_StockLevelProposal PrevRedZoneAdjustmentFctr
PrevYellowZoneAdjustmentFctr I_StockLevelProposal PrevYellowZoneAdjustmentFctr
PrevGreenZoneAdjustmentFctr I_StockLevelProposal PrevGreenZoneAdjustmentFctr
AvgDailyUsageUnit
AvgDailyUsageCalcdForDate
_ProcmtText I_StockLevelProposal _ProcmtText
_VarText I_StockLevelProposal _VarText
_ReplnmtText I_StockLevelProposal _ReplnmtText

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_ProposedStockBuffer.
-- 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: PPROPSTKBUF

CREATE VIEW P_ProposedStockBuffer AS
SELECT
  StockProposalHdr.Material AS Material,
  StockProposalHdr.Plant AS Plant,
  StockProposalHdr.MRPArea AS MRPArea,
  StockProposalHdr.ProposalStartDate AS ProposalStartDate,
  StockProposalHdr.ProposalVersion AS ProposalVersion,
  StockProposalHdr.DecoupledLeadTime AS ProposedLeadTime,
  StockProposalHdr.IndividualLeadTime AS ProposedIndividualLeadTime,
  StockProposalHdr.IsMinOrderQtyConsidered AS IsMinOrderQtyConsidered,
  StockProposalHdr.LastChangeDateTime AS LastChangeDateTime,
  StockProposalHdr.LeadTimeFactor AS LeadTimeFactor,
  StockProposalHdr.MinOrderQtyUnit AS MinOrderQtyUnit,
  StockProposalHdr.MinimumOrderQuantity AS MinimumOrderQuantity,
  StockProposalHdr.ProposalEndDate AS ProposalEndDate,
  StockProposalHdr.StockLevelProposalID AS StockLevelProposalID,
  StockProposalHdr.StockLevelProposalStatus AS StockLevelProposalStatus,
  StockProposalHdr.VariabilityFactor AS ProposedVariabilityFactor,
  StockProposalHdr.BillOfMaterialUUID AS BillOfMaterialUUID,
  StockProposalHdr.SourceOfSupply AS SourceOfSupply,
  tstmp_to_dats( StockProposalHdr.ProposalStatusChangeDate, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as ProposalStatusChangeDate AS clientNULLasProposalStatusChangeDate,
  StockProposalHdr.ProposedRedZone AS ProposedRedZone,
  StockProposalHdr.ProposedYellowZone AS ProposedYellowZone,
  StockProposalHdr.ProposedGreenZone AS ProposedGreenZone,
  StockProposalHdr.AverageDailyUsage AS ProposedAverageDailyUsage,
  StockProposalHdr.BOMUsageCode AS BOMUsageCode,
  cast(StockProposalHdr.BOMUsageValue as abap.int4) AS BOMUsageValue,
  StockProposalHdr.ConsumptionCode AS ConsumptionCode,
  StockProposalHdr.ConsumptionValue AS ConsumptionValue,
  StockProposalHdr.Currency AS Currency,
  StockProposalHdr.VariabilityCode AS VariabilityCode,
  StockProposalHdr.VariabilityQuantity AS VariabilityQuantity,
  StockProposalHdr.VariabilityUnit AS VariabilityUnit,
  StockProposalHdr.ReplenishmentLeadTimeCode AS ReplenishmentLeadTimeCode,
  StockProposalHdr.ReplenishmentLeadTimeValue AS ReplenishmentLeadTimeValue,
  StockProposalHdr.ProcurementType AS ProcurementType,
  StockProposalHdr.CurRedZoneAdjustmentFctr AS CurRedZoneAdjustmentFctr,
  StockProposalHdr.CurYellowZoneAdjustmentFctr AS CurYellowZoneAdjustmentFctr,
  StockProposalHdr.CurGreenZoneAdjustmentFctr AS CurGreenZoneAdjustmentFctr,
  StockProposalHdr.PrevRedZoneAdjustmentFctr AS PrevRedZoneAdjustmentFctr,
  StockProposalHdr.PrevYellowZoneAdjustmentFctr AS PrevYellowZoneAdjustmentFctr,
  StockProposalHdr.PrevGreenZoneAdjustmentFctr AS PrevGreenZoneAdjustmentFctr,
  '' AS AvgDailyUsageUnit,
  '' AS AvgDailyUsageCalcdForDate,
  StockProposalHdr._ProcmtText AS _ProcmtText,
  StockProposalHdr._VarText AS _VarText,
  StockProposalHdr._ReplnmtText AS _ReplnmtText
FROM I_StockLevelProposal AS StockProposalHdr
;

Learn More