A_ProductBufferSizing

DDL: A_PRODUCTBUFFERSIZING Type: view_entity COMPOSITE Package: ODATA_PP_DD_BUFFERSIZING_API
60 Fields 1 Data Sources 5 Associations 1 OData Services

Buffer Proposal Details

A_ProductBufferSizing is a Composite CDS View that provides data about "Buffer Proposal Details" in SAP S/4HANA. It reads from 1 data source (I_ProdBufLvlPrpslData) and exposes 60 fields with key fields Material, Plant, MRPArea, ProposalStartDate, ProposalVersion. It has 5 associations to related views. It is exposed through 1 OData service (API_BUFFERSIZING_SRV). Part of development package ODATA_PP_DD_BUFFERSIZING_API.

Data Sources (1)

SourceAliasJoin Type
I_ProdBufLvlPrpslData I_ProdBufLvlPrpslData from

Associations (5)

CardinalityTargetAliasCondition
[0..*] A_ProductStockBuffer _ActualStock
[0..*] A_StockLevelPrpslBOM _PrpslBOM
[0..*] A_ProdStkBufPrpslDmnd _ProductBufferProposalDemand
[0..*] A_ProdStkBufPrpslDmndFctr _ProductBufPrpslDmndFctr
[0..*] A_ProdStkBufPrpslZnAdjmt _ProductBufferProposalZones

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Buffer Proposal Details view

OData Services (1)

ServiceBindingVersionContractRelease
API_BUFFERSIZING_SRV API_BUFFERSIZING_SRV V2 C2 C1

Fields (60)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY MRPArea MRPArea MRP Area
KEY ProposalStartDate ProposalStartDate Proposal Valid From
KEY ProposalVersion ProposalVersion Proposal Version
ProposalEndDate ProposalEndDate Proposal Valid To
StockLevelProposalID StockLevelProposalID Proposal ID
ProcurementType ProcurementType Procurement
ConsumptionCode ConsumptionCode Value Indicator
ConsumptionMode ConsumptionMode Value Mode
ConsumptionValue
Currency Currency Valuation Crcy
VariabilityCode VariabilityCode Variability Indicator
VariabilityMode VariabilityMode Variability Mode
VariabilityQuantity VariabilityQuantity Value from XYZ Analysis
VariabilityUnit VariabilityUnit Base Unit
ReplenishmentLeadTimeCode ReplenishmentLeadTimeCode DLT Indicator
ReplenishmentLeadTimeMode ReplenishmentLeadTimeMode DLT Mode
ReplenishmentLeadTimeValue ReplenishmentLeadTimeValue Value from EFG Analysis
BillOfMaterialUUID BillOfMaterialUUID Character Field of Length 12
BOMUsageCode BOMUsageCode BOM Usage Indicator
BOMUsageMode BOMUsageMode BOM Usage Mode
BOMUsageValue BOMUsageValue Value from PQR Analysis
HorizonDaysInPast HorizonDaysInPast Horizon for past
HorizonDaysInFuture HorizonDaysInFuture Horizon for future
IndividualLeadTime IndividualLeadTime Individual Lead Time
LeadTimeCalculationMethod LeadTimeCalculationMethod
DecoupledLeadTime DecoupledLeadTime Decoupled Lead Time
SourceOfSupply SourceOfSupply Supply source
SOSType SOSType SRVC Source Type
LeadTimeFactor LeadTimeFactor DLT Factor
VariabilityFactor VariabilityFactor Variabilty Factor
StockLevelProposalStatus StockLevelProposalStatus
ProposalRunIsSuspended ProposalRunIsSuspended Susp Proposal Ind.
ProposalRunSuspendedFromDate ProposalRunSuspendedFromDate Prpsl Run Susp Start
ProposalRunSuspendedToDate ProposalRunSuspendedToDate Prpsl Run Susp End
ProposalMode ProposalMode Proposal Mode
ProposalStatusChangeDate ProposalStatusChangeDate Time Stamp
IsMinOrderQtyConsidered IsMinOrderQtyConsidered Is MOQ Considered
MinimumOrderQuantity MinimumOrderQuantity Minimum Order Quantity
MinOrderQtyUnit MinOrderQtyUnit Base Unit
CurRedZoneAdjustmentFctr CurRedZoneAdjustmentFctr Adj. Factor Red Zone
CurYellowZoneAdjustmentFctr CurYellowZoneAdjustmentFctr Adj. Factor Yel Zone
CurGreenZoneAdjustmentFctr CurGreenZoneAdjustmentFctr Adj. Fctr. Gree Zone
OrderCycle OrderCycle Order Cycle
BOMExplosionDate BOMExplosionDate Explosion Date
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangeDateTime LastChangeDateTime Timestamp
ProductAuthorizationGroup ProductAuthorizationGroup AuthorizGroup
ProductTypeAuthorizationGroup ProductTypeAuthorizationGroup
ProductGroupAuthorizationGroup ProductGroupAuthorizationGroup
UnitOfMeasureNumberOfDecimals UnitOfMeasureNumberOfDecimals
AverageDailyUsageMode AverageDailyUsageMode Average Daily Usage Mode
_ProductBufferProposalDemand _ProductBufferProposalDemand
_ProductBufPrpslDmndFctr _ProductBufPrpslDmndFctr
_ProductBufferProposalZones _ProductBufferProposalZones
_ActualStock _ActualStock
_PrpslBOM _PrpslBOM

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 A_ProductBufferSizing.
-- 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.

CREATE VIEW A_ProductBufferSizing AS
SELECT
  Material,
  Plant,
  MRPArea,
  ProposalStartDate,
  ProposalVersion,
  ProposalEndDate,
  StockLevelProposalID,
  ProcurementType,
  ConsumptionCode,
  ConsumptionMode,
  cast(ConsumptionValue as abap.dec( 17, 4 )) AS ConsumptionValue,
  Currency,
  VariabilityCode,
  VariabilityMode,
  VariabilityQuantity,
  VariabilityUnit,
  ReplenishmentLeadTimeCode,
  ReplenishmentLeadTimeMode,
  ReplenishmentLeadTimeValue,
  BillOfMaterialUUID,
  BOMUsageCode,
  BOMUsageMode,
  BOMUsageValue,
  HorizonDaysInPast,
  HorizonDaysInFuture,
  IndividualLeadTime,
  LeadTimeCalculationMethod,
  DecoupledLeadTime,
  SourceOfSupply,
  SOSType,
  LeadTimeFactor,
  VariabilityFactor,
  StockLevelProposalStatus,
  ProposalRunIsSuspended,
  ProposalRunSuspendedFromDate,
  ProposalRunSuspendedToDate,
  ProposalMode,
  ProposalStatusChangeDate,
  IsMinOrderQtyConsidered,
  MinimumOrderQuantity,
  MinOrderQtyUnit,
  CurRedZoneAdjustmentFctr,
  CurYellowZoneAdjustmentFctr,
  CurGreenZoneAdjustmentFctr,
  OrderCycle,
  BOMExplosionDate,
  CreatedByUser,
  LastChangedByUser,
  CreationDateTime,
  LastChangeDateTime,
  ProductAuthorizationGroup,
  ProductTypeAuthorizationGroup,
  ProductGroupAuthorizationGroup,
  UnitOfMeasureNumberOfDecimals,
  AverageDailyUsageMode
FROM I_ProdBufLvlPrpslData
LEFT OUTER JOIN A_ProductStockBuffer AS _ActualStock ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_StockLevelPrpslBOM AS _PrpslBOM ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ProdStkBufPrpslDmnd AS _ProductBufferProposalDemand ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ProdStkBufPrpslDmndFctr AS _ProductBufPrpslDmndFctr ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ProdStkBufPrpslZnAdjmt AS _ProductBufferProposalZones ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More