C_ProdnSupplyAreaProdnVersion

DDL: C_PRODNSUPPLYAREAPRODNVERSION Type: view_entity CONSUMPTION
9 Fields 1 Data Sources 1 Associations

Production Version of PSA Where Used

C_ProdnSupplyAreaProdnVersion is a Consumption CDS View that provides data about "Production Version of PSA Where Used" in SAP S/4HANA. It reads from 1 data source (I_ProductionVersion) and exposes 9 fields with key fields ProductionVersion, Plant, Material. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProductionVersion I_ProductionVersion from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ProductText _ProductText $projection.Material = _ProductText.Product and _ProductText.Language = $session.system_language

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Production Version of PSA Where Used view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ProductionVersion ProductionVersion Version ID
KEY Plant Plant Valuation Area
KEY Material Material Material
ProductionSupplyArea ProductionSupplyArea Supply Area
TargetProductionSupplyArea TargetProductionSupplyArea
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate Validity End Date
ProductionVersionText ProductionVersionText Vertikalization Text
ProductName _ProductText ProductName Description

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_ProdnSupplyAreaProdnVersion.
-- 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_ProdnSupplyAreaProdnVersion AS
SELECT
  ProductionVersion,
  Plant,
  Material,
  ProductionSupplyArea,
  TargetProductionSupplyArea,
  ValidityStartDate,
  ValidityEndDate,
  ProductionVersionText,
  _ProductText.ProductName AS ProductName
FROM I_ProductionVersion
LEFT OUTER JOIN I_ProductText AS _ProductText ON Material = _ProductText.Product AND _ProductText.Language = $session.system_language  -- association [0..1]
;

Learn More