C_ProdBufLvlDmndAdjmtFctr

DDL: C_PRODBUFLVLDMNDADJMTFCTR SQL: CPRODBUFLVLZNFCT Type: view CONSUMPTION Package: ODATA_PP_DD_STLM
13 Fields 2 Data Sources 1 OData Services

MBL Demand Adjustment Factors

C_ProdBufLvlDmndAdjmtFctr is a Consumption CDS View that provides data about "MBL Demand Adjustment Factors" in SAP S/4HANA. It reads from 2 data sources (I_ProdBufLvlPrpsl, I_ProdBufLvlPrpslDemandFctr) and exposes 13 fields with key fields Material, Plant, MRPArea, ProposalStartDate, ProposalVersion. It is exposed through 1 OData service (ASQL_F3653). Part of development package ODATA_PP_DD_STLM.

Data Sources (2)

SourceAliasJoin Type
I_ProdBufLvlPrpsl _ProposalHeader inner
I_ProdBufLvlPrpslDemandFctr DemandAdjustments from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CPRODBUFLVLZNFCT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label MBL Demand Adjustment Factors view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F3653 ASQL_F3653 C2 NOT_RELEASED

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Material I_ProdBufLvlPrpslDemandFctr Material Vehicle Model
KEY Plant I_ProdBufLvlPrpslDemandFctr Plant Valuation Area
KEY MRPArea I_ProdBufLvlPrpslDemandFctr MRPArea MRP Area
KEY ProposalStartDate I_ProdBufLvlPrpslDemandFctr ProposalStartDate
KEY ProposalVersion I_ProdBufLvlPrpslDemandFctr ProposalVersion
KEY ProposalDmndAdjmtFctrStartDate I_ProdBufLvlPrpslDemandFctr ProposalDmndAdjmtFctrStartDate
ProposalDmndAdjmtFctrEndDate I_ProdBufLvlPrpslDemandFctr ProposalDmndAdjmtFctrEndDate
DemandAdjustmentFactor I_ProdBufLvlPrpslDemandFctr DemandAdjustmentFactor
AverageDailyUsage
AdjustedAverageDailyUsage
ProductAuthorizationGroup I_ProdBufLvlPrpslDemandFctr ProductAuthorizationGroup
ProductTypeAuthorizationGroup I_ProdBufLvlPrpslDemandFctr ProductTypeAuthorizationGroup
ProductGroupAuthorizationGroup I_ProdBufLvlPrpslDemandFctr ProductGroupAuthorizationGroup

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_ProdBufLvlDmndAdjmtFctr.
-- 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: CPRODBUFLVLZNFCT

CREATE VIEW C_ProdBufLvlDmndAdjmtFctr AS
SELECT
  DemandAdjustments.Material AS Material,
  DemandAdjustments.Plant AS Plant,
  DemandAdjustments.MRPArea AS MRPArea,
  DemandAdjustments.ProposalStartDate AS ProposalStartDate,
  DemandAdjustments.ProposalVersion AS ProposalVersion,
  DemandAdjustments.ProposalDmndAdjmtFctrStartDate AS ProposalDmndAdjmtFctrStartDate,
  DemandAdjustments.ProposalDmndAdjmtFctrEndDate AS ProposalDmndAdjmtFctrEndDate,
  DemandAdjustments.DemandAdjustmentFactor AS DemandAdjustmentFactor,
  cast (1 as pph_average_daily_usage) AS AverageDailyUsage,
  cast (1 as pph_average_daily_usage) AS AdjustedAverageDailyUsage,
  DemandAdjustments.ProductAuthorizationGroup AS ProductAuthorizationGroup,
  DemandAdjustments.ProductTypeAuthorizationGroup AS ProductTypeAuthorizationGroup,
  DemandAdjustments.ProductGroupAuthorizationGroup AS ProductGroupAuthorizationGroup
FROM I_ProdBufLvlPrpslDemandFctr AS DemandAdjustments
INNER JOIN I_ProdBufLvlPrpsl AS _ProposalHeader ON /* join condition not captured in parsed metadata */
;

Learn More