C_PMRPTopLevelDemandColumn

DDL: C_PMRPTOPLEVELDEMANDCOLUMN SQL: CPMRPTLDC Type: view CONSUMPTION
18 Fields 1 Data Sources 1 Associations 1 OData Services

Top Level Demand Columns

C_PMRPTopLevelDemandColumn is a Consumption CDS View that provides data about "Top Level Demand Columns" in SAP S/4HANA. It reads from 1 data source (I_PMRPSimlnTopLevelDemandTP) and exposes 18 fields with key fields PMRPSimulation, TopLevelProduct, TopLevelPlant, TopLevelMRPArea, BucketInternalID. It has 1 association to related views. It is exposed through 1 OData service (PMRP_SIMU_SERVICEDEF).

Data Sources (1)

SourceAliasJoin Type
I_PMRPSimlnTopLevelDemandTP I_PMRPSimlnTopLevelDemandTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PMRPSimlnTopLevelDemandKPI _DemandKPI $projection.PMRPSimulation = _DemandKPI.PMRPSimulation and $projection.TopLevelDemandInternalID = _DemandKPI.TopLevelDemandInternalID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPMRPTLDC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
EndUserText.label Top Level Demand Columns view

OData Services (1)

ServiceBindingVersionContractRelease
PMRP_SIMU_SERVICEDEF PMRP_SIMUL_SERVICE V2 C1 NOT_RELEASED

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY PMRPSimulation PMRPSimulation Simulation ID
KEY TopLevelProduct TopLevelProduct
KEY TopLevelPlant TopLevelPlant
KEY TopLevelMRPArea TopLevelMRPArea
KEY BucketInternalID BucketInternalID Bucket ID
TopLevelDemandInternalID TopLevelDemandInternalID Top-Level Demand ID
PMRPBucketName Bucket ID
PMRPBucketCategory _Bucket PMRPBucketCategory
PMRPReferencePlan PMRPReferencePlan
UnitOfMeasure UnitOfMeasure Unit Protected Qty
SimulatedRequiredQuantity SimulatedRequiredQuantity
ReferenceRequiredQuantity ReferenceRequiredQuantity
DeltaQuantity
PMRPDeltaQuantity _DemandKPI PMRPTopLvlDmndDeltaQuantity
AcceptedRequestedRatioInPct AcceptedRequestedRatioInPct
PMRPBucketYear _Bucket PMRPBucketYear
PMRPBucketPeriod _Bucket PMRPBucketPeriod
PMRPBucketCategoryText

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_PMRPTopLevelDemandColumn.
-- 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: CPMRPTLDC

CREATE VIEW C_PMRPTopLevelDemandColumn AS
SELECT
  PMRPSimulation,
  TopLevelProduct,
  TopLevelPlant,
  TopLevelMRPArea,
  BucketInternalID,
  TopLevelDemandInternalID,
  cast (BucketInternalID as sstring) AS PMRPBucketName,
  _Bucket.PMRPBucketCategory AS PMRPBucketCategory,
  PMRPReferencePlan,
  UnitOfMeasure,
  SimulatedRequiredQuantity,
  ReferenceRequiredQuantity,
  cast (( ReferenceRequiredQuantity - SimulatedRequiredQuantity ) as pmrp_req_quantity ) AS DeltaQuantity,
  _DemandKPI.PMRPTopLvlDmndDeltaQuantity AS PMRPDeltaQuantity,
  AcceptedRequestedRatioInPct,
  _Bucket.PMRPBucketYear AS PMRPBucketYear,
  _Bucket.PMRPBucketPeriod AS PMRPBucketPeriod,
  _Bucket._PMRPBucketCategory._Text[Language = $session.system_language].PMRPBucketCategoryText AS PMRPBucketCategoryText
FROM I_PMRPSimlnTopLevelDemandTP
LEFT OUTER JOIN I_PMRPSimlnTopLevelDemandKPI AS _DemandKPI ON PMRPSimulation = _DemandKPI.PMRPSimulation AND TopLevelDemandInternalID = _DemandKPI.TopLevelDemandInternalID  -- association [1..1]
;

Learn More