C_PMRPSimulationProductVH

DDL: C_PMRPSIMULATIONPRODUCTVH Type: view_entity CONSUMPTION Package: PMRP_UI_SERVICES
23 Fields 5 Associations 2 OData Services

PMRP Simulation Component Filter Values

C_PMRPSimulationProductVH is a Consumption CDS View that provides data about "PMRP Simulation Component Filter Values" in SAP S/4HANA. It has 5 associations to related views. It is exposed through 2 OData services (ASQL_F4450, PMRP_SIMU_COMPONENT_SERVICEDEF). Part of development package PMRP_UI_SERVICES.

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_PMRPSourceOfSupply _SourceOfSupply $projection.PMRPReferencePlan = _SourceOfSupply.PMRPReferencePlan and $projection.PMRPSourceOfSupplyInternalID = _SourceOfSupply.PMRPSourceOfSupplyInternalID
[1..1] I_PlndIndepRqmtMRPCtrlrText _PMRPText $projection.Plant = _PMRPText.Plant and $projection.MRPController = _PMRPText.MRPController
[1..1] I_PMRPProcurementType _PMRPProcurementType $projection.Product = _PMRPProcurementType.Product and $projection.Plant = _PMRPProcurementType.Plant
[1..1] C_PMRPSupplyGroupName _SupplyGroup $projection.PMRPReferencePlan = _SupplyGroup.PMRPReferencePlan and $projection.PMRPSupplyGroupCategory = _SupplyGroup.PMRPSupplyGroupCategory and $projection.PMRPSupplyGroup = _SupplyGroup.PMRPSupplyGroup
[1..1] I_PlantStdVH _PlantVH $projection.Plant = _PlantVH.Plant

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
EndUserText.label PMRP Simulation Component Filter Values view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F4450 ASQL_F4450 C2 NOT_RELEASED
PMRP_SIMU_COMPONENT_SERVICEDEF PMRP_SIM_COMPONENT_SERVICE V2 C1 NOT_TO_BE_RELEASED_STABLE

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY PMRPSimulation PMRPSimulation Simulation ID
KEY Product Product Product Sold
KEY Plant Plant Valuation Area
KEY MRPArea MRPArea MRP Area
KEY PMRPSourceOfSupplyInternalID PMRPSourceOfSupplyInternalID Source of Supply ID
KEY PMRPReferencePlan PMRPReferencePlan
KEY MRPController MRPController MRP Controller
PMRPSupplyGroupCategory PMRPSupplyGroupCategory Supply Group Cat
PMRPSupplyGroup PMRPSupplyGroup Supply Group
PMRPSupplyGroupName _SupplyGroup PMRPSupplyGroupName
MRPControllerName _PMRPText MRPControllerName Controller name
MRPProcedureCthenXelseendasMRPProcedure
PlantName _PlantVH PlantName Plant Name
PMRPSourceOfSupplyName _SourceOfSupply PMRPSourceOfSupplyName
ProductionLine _SourceOfSupply ProductionLine Production Line
ReceivingPlant _SourceOfSupply ReceivingPlant Receiving Plant
SupplyingPlant _SourceOfSupply SupplyingPlant Supplying Plant
PMRPSourceOfSupplyCategory _SourceOfSupply PMRPSourceOfSupplyCategory
Supplier _SourceOfSupply Supplier Supplier
ProcurementType _PMRPProcurementType ProcurementType Procurement
ProcurementTypeDescription _PMRPProcurementType ProcurementTypeDescription
_SourceOfSupply _SourceOfSupply
_PMRPSimulation _PMRPSimulation

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_PMRPSimulationProductVH.
-- 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 C_PMRPSimulationProductVH AS
SELECT
  PMRPSimulation,
  Product,
  Plant,
  MRPArea,
  PMRPSourceOfSupplyInternalID,
  PMRPReferencePlan,
  MRPController,
  PMRPSupplyGroupCategory,
  PMRPSupplyGroup,
  _SupplyGroup.PMRPSupplyGroupName AS PMRPSupplyGroupName,
  _PMRPText.MRPControllerName AS MRPControllerName,
  case when _Product.MRPProcedure = 'C' then 'X' else ' ' end as MRPProcedure AS MRPProcedureCthenXelseendasMRPProcedure,
  _PlantVH.PlantName AS PlantName,
  _SourceOfSupply.PMRPSourceOfSupplyName AS PMRPSourceOfSupplyName,
  _SourceOfSupply.ProductionLine AS ProductionLine,
  _SourceOfSupply.ReceivingPlant AS ReceivingPlant,
  _SourceOfSupply.SupplyingPlant AS SupplyingPlant,
  _SourceOfSupply.PMRPSourceOfSupplyCategory AS PMRPSourceOfSupplyCategory,
  _SourceOfSupply.Supplier AS Supplier,
  _PMRPProcurementType.ProcurementType AS ProcurementType,
  _PMRPProcurementType.ProcurementTypeDescription AS ProcurementTypeDescription
LEFT OUTER JOIN I_PMRPSourceOfSupply AS _SourceOfSupply ON PMRPReferencePlan = _SourceOfSupply.PMRPReferencePlan AND PMRPSourceOfSupplyInternalID = _SourceOfSupply.PMRPSourceOfSupplyInternalID  -- association [1..1]
LEFT OUTER JOIN I_PlndIndepRqmtMRPCtrlrText AS _PMRPText ON Plant = _PMRPText.Plant AND MRPController = _PMRPText.MRPController  -- association [1..1]
LEFT OUTER JOIN I_PMRPProcurementType AS _PMRPProcurementType ON Product = _PMRPProcurementType.Product AND Plant = _PMRPProcurementType.Plant  -- association [1..1]
LEFT OUTER JOIN C_PMRPSupplyGroupName AS _SupplyGroup ON PMRPReferencePlan = _SupplyGroup.PMRPReferencePlan AND PMRPSupplyGroupCategory = _SupplyGroup.PMRPSupplyGroupCategory AND PMRPSupplyGroup = _SupplyGroup.PMRPSupplyGroup  -- association [1..1]
LEFT OUTER JOIN I_PlantStdVH AS _PlantVH ON Plant = _PlantVH.Plant  -- association [1..1]
;

Learn More