C_LinkedProductionVersionAll

DDL: C_LINKEDPRODUCTIONVERSIONALL Type: view_entity CONSUMPTION
33 Fields 2 Data Sources 2 Associations 1 OData Services 1 Fiori Apps

All Linked Production Version

C_LinkedProductionVersionAll is a Consumption CDS View that provides data about "All Linked Production Version" in SAP S/4HANA. It reads from 2 data sources (R_ProductionVersionTP, R_RecmddProductionVersionTP) and exposes 33 fields with key fields Material, Plant, RecommendedProductionVersion, ProductionVersion, Plant. It has 2 associations to related views. It is exposed through 1 OData service (UI_PRODUCTIONVERSION). It is used in 1 Fiori application: Process Production Versions.

Data Sources (2)

SourceAliasJoin Type
R_ProductionVersionTP R_ProductionVersionTP from
R_RecmddProductionVersionTP R_RecmddProductionVersionTP union

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_LinkedProdnVersBOM _BillOfMaterial $projection.Material = _BillOfMaterial.Material and $projection.Plant = _BillOfMaterial.Plant and $projection.BillOfMaterialVariant = _BillOfMaterial.BillOfMaterialVariant and _BillOfMaterial.ValidityStartDate <= $session.system_date and _BillOfMaterial.ValidityEndDate >= $session.system_date
[1..1] C_LinkedProdnVersBOO _RoutingStatusText $projection.Material = _RoutingStatusText.Material and $projection.Plant = _RoutingStatusText.Plant and $projection.BillOfOperationsType = _RoutingStatusText.BillOfOperationsType and $projection.BillOfOperationsGroup = _RoutingStatusText.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _RoutingStatusText.BillOfOperationsVariant and _RoutingStatusText.ValidityStartDate <= $session.system_date and _RoutingStatusText.ValidityEndDate >= $session.system_date

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label All Linked Production Version view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_PRODUCTIONVERSION UI_PRODUCTIONVERSION V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F6400 Process Production Versions Transactional With this app, you can view the following details: Existing production versions Proposals for creating a new production version if a new BOM / Task List is created or if a production version does not exist for a BOM/Task list combination Production versions if there are any inconsistencies related to missing information

Process Production Versions

Business Role: Others

With this app, you can achieve the following: View and edit existing production versions Create new production versions Mass lock and unlock of Production versions Mass consistency check of existing production versions View all proposals that are generated when a new production version if a new BOM / Task List is created or if a production version does not exist for a BOM/Task list combination. Accept or Reject Proposals in a individual manner or through mass action. Delete selected production versions

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY RecommendedProductionVersion
KEY ProductionVersion ProductionVersion Version ID
LinkedProductionVersionAll
BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
BillOfOperationsGroup BillOfOperationsGroup Group
BillOfOperationsVariant BillOfOperationsVariant Group Counter
BillOfOperationsType BillOfOperationsType Task List Type
BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
MaterialName MaterialName Material Description
PlantName PlantName Plant Name
ProductionVersionText ProductionVersionText
ProducerEventType
ProducerBusinessObjectType
BOMHeaderText _BillOfMaterial BOMHeaderText BOM Description
system_datekeyMaterialasMaterial
KEY Plant Plant Valuation Area
KEY RecommendedProductionVersion RecommendedProductionVersion
KEY ProductionVersion Version ID
LinkedProductionVersionAll RecommendedProductionVersion
BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
BillOfOperationsGroup BillOfOperationsGroup Group
BillOfOperationsVariant BillOfOperationsVariant Group Counter
BillOfOperationsType BillOfOperationsType Task List Type
BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
MaterialName _MaterialText MaterialName Material Description
PlantName _Plant PlantName Plant Name
ProductionVersionText ProductionVersionText
ProducerEventType ProducerEventType
ProducerBusinessObjectType ProducerBusinessObjectType
BOMHeaderText _BillOfMaterial BOMHeaderText BOM Description
BillOfOperationsDesc _RoutingStatusText BillOfOperationsDesc

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_LinkedProductionVersionAll.
-- 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_LinkedProductionVersionAll AS
SELECT
  Material,
  Plant,
  cast ( ' ' as abap.char(8) ) AS RecommendedProductionVersion,
  ProductionVersion,
  cast ( ProductionVersion as abap.char(8) ) AS LinkedProductionVersionAll,
  BillOfMaterialVariant,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BillOfOperationsType,
  BillOfMaterialVariantUsage,
  MaterialName,
  PlantName,
  ProductionVersionText,
  cast ( ' ' as abap.char(1) ) AS ProducerEventType,
  cast ( ' ' as abap.char(1) ) AS ProducerBusinessObjectType,
  _BillOfMaterial.BOMHeaderText AS BOMHeaderText,
  _RoutingStatusText.BillOfOperationsDesc as BillOfOperationsDesc AS system_datekeyMaterialasMaterial,
  _RoutingStatusText.BillOfOperationsDesc AS BillOfOperationsDesc
FROM R_ProductionVersionTP
LEFT OUTER JOIN C_LinkedProdnVersBOM AS _BillOfMaterial ON Material = _BillOfMaterial.Material AND Plant = _BillOfMaterial.Plant AND BillOfMaterialVariant = _BillOfMaterial.BillOfMaterialVariant AND _BillOfMaterial.ValidityStartDate <= $session.system_date AND _BillOfMaterial.ValidityEndDate >= $session.system_date  -- association [1..1]
LEFT OUTER JOIN C_LinkedProdnVersBOO AS _RoutingStatusText ON Material = _RoutingStatusText.Material AND Plant = _RoutingStatusText.Plant AND BillOfOperationsType = _RoutingStatusText.BillOfOperationsType AND BillOfOperationsGroup = _RoutingStatusText.BillOfOperationsGroup AND BillOfOperationsVariant = _RoutingStatusText.BillOfOperationsVariant AND _RoutingStatusText.ValidityStartDate <= $session.system_date AND _RoutingStatusText.ValidityEndDate >= $session.system_date  -- association [1..1]
-- UNION with additional select branch(es): R_RecmddProductionVersionTP
;

Learn More