C_PMRPSimulationSupplyVH

DDL: C_PMRPSIMULATIONSUPPLYVH SQL: CPMRPSUPLYVH Type: view CONSUMPTION
3 Fields 1 Associations 1 OData Services

pMRP Simulation Component Supply Filter Values

C_PMRPSimulationSupplyVH is a Consumption CDS View that provides data about "pMRP Simulation Component Supply Filter Values" in SAP S/4HANA. It has 1 association to related views. It is exposed through 1 OData service (PMRP_SIMU_COMPONENT_SERVICEDEF).

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PMRPSupplyGroupCategoryText _PMRPSupplyGroupCategoryText $projection.PMRPSupplyGroupCategory = _PMRPSupplyGroupCategoryText.PMRPSupplyGroupCategory and _PMRPSupplyGroupCategoryText.Language = $session.system_language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CPMRPSUPLYVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE 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 Supply Filter Values view

OData Services (1)

ServiceBindingVersionContractRelease
PMRP_SIMU_COMPONENT_SERVICEDEF PMRP_SIM_COMPONENT_SERVICE V2 C1 NOT_RELEASED

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY PMRPReferencePlan PMRPReferencePlan
KEY PMRPSupplyGroupCategory PMRPSupplyGroupCategory Supply Group Cat
KEY PMRPSourceOfSupplyCategory PMRPSourceOfSupplyCategory

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_PMRPSimulationSupplyVH.
-- 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: CPMRPSUPLYVH

CREATE VIEW C_PMRPSimulationSupplyVH AS
SELECT
  PMRPReferencePlan,
  PMRPSupplyGroupCategory,
  PMRPSourceOfSupplyCategory
LEFT OUTER JOIN I_PMRPSupplyGroupCategoryText AS _PMRPSupplyGroupCategoryText ON PMRPSupplyGroupCategory = _PMRPSupplyGroupCategoryText.PMRPSupplyGroupCategory AND _PMRPSupplyGroupCategoryText.Language = $session.system_language  -- association [1..1]
;

Learn More