R_ProductionVersionTP

DDL: R_PRODUCTIONVERSIONTP Type: view_entity TRANSACTIONAL
85 Fields 1 Data Sources 8 Associations

Production Version Header

R_ProductionVersionTP is a Transactional CDS View that provides data about "Production Version Header" in SAP S/4HANA. It reads from 1 data source (I_ProductionVersion) and exposes 85 fields with key fields Material, Plant, ProductionVersion. It has 8 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProductionVersion I_ProductionVersion from

Associations (8)

CardinalityTargetAliasCondition
[0..1] I_ProdnVersLock _ProdnVersLockVH $projection.ProductionVersionLock = _ProdnVersLockVH.ProductionVersionIsLocked
[0..1] I_ProdnVersLockText _ProdnVersLockText $projection.ProductionVersionLock = _ProdnVersLockText.ProductionVersionIsLocked and _ProdnVersLockText.Language = $session.system_language
[1..1] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material and _MaterialText.Language = $session.system_language
[0..1] I_ProdnVersChkStsTxt _RoutingStatusText $projection.ProductionVersionStatus = _RoutingStatusText.ProductionVersionStatus and _RoutingStatusText.Language = $session.system_language
[0..1] I_BillOfOperationsTypeText _BillOfOperationsTypeText $projection.BillOfOperationsType = _BillOfOperationsTypeText.BillOfOperationsType and _BillOfOperationsTypeText.Language = $session.system_language
[0..1] I_RecmddProdnVersMatlBOM _MaterialBOM $projection.Material = _MaterialBOM.Material and $projection.Plant = _MaterialBOM.Plant and $projection.BillOfMaterialVariant = _MaterialBOM.BillOfMaterialVariant and $projection.BillOfMaterialVariantUsage = _MaterialBOM.BillOfMaterialVariantUsage and $projection.ValidityStartDate >= _MaterialBOM.HeaderValidityStartDate and $projection.ValidityStartDate <= _MaterialBOM.HeaderValidityEndDate
[0..*] I_ProdnVersConstcyLogCount _ConstcyLogCount $projection.Material = _ConstcyLogCount.Material and $projection.Plant = _ConstcyLogCount.Plant and $projection.ProductionVersion = _ConstcyLogCount.ProductionVersion -- to Consistency Log
[0..*] R_ProdnVersConstcyLogTP _ConstcyLog

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Production Version Header view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name ProductionVersion view

Fields (85)

KeyFieldSource TableSource FieldDescription
KEY Material I_ProductionVersion Material Vehicle Model
KEY Plant I_ProductionVersion Plant Valuation Area
KEY ProductionVersion I_ProductionVersion ProductionVersion Version ID
ProductionVersionText I_ProductionVersion ProductionVersionText Vertikalization Text
ChangeHistoryCount I_ProductionVersion ChangeHistoryCount
ChangeNumber I_ProductionVersion ChangeNumber Change Number
CreationDate I_ProductionVersion CreationDate Time Stamp
CreatedByUser I_ProductionVersion CreatedByUser User Name
LastChangeDate I_ProductionVersion LastChangeDate Time Stamp
LastChangedByUser I_ProductionVersion LastChangedByUser User Name
BillOfOperationsType I_ProductionVersion BillOfOperationsType Task List Type
BillOfOperationsGroup I_ProductionVersion BillOfOperationsGroup Group
BillOfOperationsVariant I_ProductionVersion BillOfOperationsVariant Group Counter
BillOfMaterialVariantUsage I_ProductionVersion BillOfMaterialVariantUsage Usage
BillOfMaterialVariant I_ProductionVersion BillOfMaterialVariant AlternativeBOM
ProductionLine I_ProductionVersion ProductionLine Production Line
ProductionSupplyArea I_ProductionVersion ProductionSupplyArea Supply Area
ProductionVersionGroup I_ProductionVersion ProductionVersionGroup
MainProduct I_ProductionVersion MainProduct
MaterialCostApportionmentStruc I_ProductionVersion MaterialCostApportionmentStruc Apportionment
IssuingStorageLocation I_ProductionVersion IssuingStorageLocation Iss. Stor. Loc.
ReceivingStorageLocation I_ProductionVersion ReceivingStorageLocation RecStorLoc
OriginalBatchReferenceMaterial I_ProductionVersion OriginalBatchReferenceMaterial
QuantityDistributionKey I_ProductionVersion QuantityDistributionKey Distribution
ProductionVersionStatus
ProductionVersionLastCheckDate I_ProductionVersion ProductionVersionLastCheckDate
RateBasedPlanningStatus I_ProductionVersion RateBasedPlanningStatus
PreliminaryPlanningStatus I_ProductionVersion PreliminaryPlanningStatus
BOMCheckStatus I_ProductionVersion BOMCheckStatus
ValidityStartDate I_ProductionVersion ValidityStartDate Validity Start Date
ValidityEndDate I_ProductionVersion ValidityEndDate ValidTo
ProductionVersionLock
ProdnVersIsAllowedForRptvMfg I_ProductionVersion ProdnVersIsAllowedForRptvMfg REM Allowed
HasVersionCtrldBOMAndRouting I_ProductionVersion HasVersionCtrldBOMAndRouting BOM/RTG Vers. Exists
PlanningAndExecutionBOMIsDiff I_ProductionVersion PlanningAndExecutionBOMIsDiff Plng Exec Mstr Diff
ExecBillOfMaterialVariantUsage I_ProductionVersion ExecBillOfMaterialVariantUsage SF BOM Usage
ExecBillOfMaterialVariant I_ProductionVersion ExecBillOfMaterialVariant SF BOM Alt.
ExecBillOfOperationsType I_ProductionVersion ExecBillOfOperationsType Task list Type
ExecBillOfOperationsGroup I_ProductionVersion ExecBillOfOperationsGroup Tasklist Group
ExecBillOfOperationsVariant I_ProductionVersion ExecBillOfOperationsVariant Group Counter
EWMWarehouse I_ProductionVersion Warehouse Warehouse No.
DestinationStorageBin I_ProductionVersion DestinationStorageBin Storage Bin
ProcurementType I_ProductionVersion ProcurementType Procurement
MaterialProcurementProfile I_ProductionVersion MaterialProcurementProfile Special Procur.
UsgeProbltyWthVersCtrlInPct I_ProductionVersion UsgeProbltyWthVersCtrlInPct Usg Probability
MaterialBaseUnit I_ProductionVersion MaterialBaseUnit Valuation Unit
MaterialMinLotSizeQuantity I_ProductionVersion MaterialMinLotSizeQuantity Min. Lot Size
MaterialMaxLotSizeQuantity I_ProductionVersion MaterialMaxLotSizeQuantity To Lot Size
CostingLotSize I_ProductionVersion CostingLotSize Cstg Lot Size
TargetProductionSupplyArea I_ProductionVersion TargetProductionSupplyArea
MRPController _MatlPlnt MRPController MRP Controller
MaterialName _MaterialText MaterialName Material Description
PlantName
MRPResponsible
RoutingCheckStatusText _RoutingStatusText ProductionVersionStatusText
ProductionVersionLockText _ProdnVersLockText ProductionVersionLockText
BillOfOperationsTypeName _BillOfOperationsTypeText BillOfOperationsTypeName
_ProdnVersLockVH _ProdnVersLockVH
_BillOfOperations I_ProductionVersion _BillOfOperations
_BillOfOperationsGroup I_ProductionVersion _BillOfOperationsGroup
_BillOfOperationsType I_ProductionVersion _BillOfOperationsType
_ChangeMaster I_ProductionVersion _ChangeMaster
_IssuingStorageLocation I_ProductionVersion _IssuingStorageLocation
_MainProduct I_ProductionVersion _MainProduct
_Material I_ProductionVersion _Material
_MaterialBaseUnit I_ProductionVersion _MaterialBaseUnit
_MatlCostApportionmentStruc I_ProductionVersion _MatlCostApportionmentStruc
_MatlProcurementProfile I_ProductionVersion _MatlProcurementProfile
_OriglBatchReferenceMaterial I_ProductionVersion _OriglBatchReferenceMaterial
_Plant I_ProductionVersion _Plant
_Product I_ProductionVersion _Product
_ProductionLine I_ProductionVersion _ProductionLine
_ProductionSupplyArea I_ProductionVersion _ProductionSupplyArea
_ProductionVersionGroup I_ProductionVersion _ProductionVersionGroup
_ProductPlant I_ProductionVersion _ProductPlant
_QuantityDistributionKey I_ProductionVersion _QuantityDistributionKey
_ReceivingStorageLocation I_ProductionVersion _ReceivingStorageLocation
_TargetProductionSupplyArea I_ProductionVersion _TargetProductionSupplyArea
_RoutingStatusText _RoutingStatusText
_MaterialText _MaterialText
_BillOfOperationsTypeText _BillOfOperationsTypeText
_ProdnVersLockText _ProdnVersLockText
_MaterialBOM _MaterialBOM
_ConstcyLog _ConstcyLog
_ConstcyLogCount _ConstcyLogCount

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 R_ProductionVersionTP.
-- 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 R_ProductionVersionTP AS
SELECT
  I_ProductionVersion.Material AS Material,
  I_ProductionVersion.Plant AS Plant,
  I_ProductionVersion.ProductionVersion AS ProductionVersion,
  I_ProductionVersion.ProductionVersionText AS ProductionVersionText,
  I_ProductionVersion.ChangeHistoryCount AS ChangeHistoryCount,
  I_ProductionVersion.ChangeNumber AS ChangeNumber,
  I_ProductionVersion.CreationDate AS CreationDate,
  I_ProductionVersion.CreatedByUser AS CreatedByUser,
  I_ProductionVersion.LastChangeDate AS LastChangeDate,
  I_ProductionVersion.LastChangedByUser AS LastChangedByUser,
  I_ProductionVersion.BillOfOperationsType AS BillOfOperationsType,
  I_ProductionVersion.BillOfOperationsGroup AS BillOfOperationsGroup,
  I_ProductionVersion.BillOfOperationsVariant AS BillOfOperationsVariant,
  I_ProductionVersion.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  I_ProductionVersion.BillOfMaterialVariant AS BillOfMaterialVariant,
  I_ProductionVersion.ProductionLine AS ProductionLine,
  I_ProductionVersion.ProductionSupplyArea AS ProductionSupplyArea,
  I_ProductionVersion.ProductionVersionGroup AS ProductionVersionGroup,
  I_ProductionVersion.MainProduct AS MainProduct,
  I_ProductionVersion.MaterialCostApportionmentStruc AS MaterialCostApportionmentStruc,
  I_ProductionVersion.IssuingStorageLocation AS IssuingStorageLocation,
  I_ProductionVersion.ReceivingStorageLocation AS ReceivingStorageLocation,
  I_ProductionVersion.OriginalBatchReferenceMaterial AS OriginalBatchReferenceMaterial,
  I_ProductionVersion.QuantityDistributionKey AS QuantityDistributionKey,
  cast(I_ProductionVersion.ProductionVersionStatus as mpe_pv_rtg_chksts preserving type ) AS ProductionVersionStatus,
  I_ProductionVersion.ProductionVersionLastCheckDate AS ProductionVersionLastCheckDate,
  I_ProductionVersion.RateBasedPlanningStatus AS RateBasedPlanningStatus,
  I_ProductionVersion.PreliminaryPlanningStatus AS PreliminaryPlanningStatus,
  I_ProductionVersion.BOMCheckStatus AS BOMCheckStatus,
  I_ProductionVersion.ValidityStartDate AS ValidityStartDate,
  I_ProductionVersion.ValidityEndDate AS ValidityEndDate,
  cast(I_ProductionVersion.ProductionVersionIsLocked as mpe_pv_lock_status preserving type ) AS ProductionVersionLock,
  I_ProductionVersion.ProdnVersIsAllowedForRptvMfg AS ProdnVersIsAllowedForRptvMfg,
  I_ProductionVersion.HasVersionCtrldBOMAndRouting AS HasVersionCtrldBOMAndRouting,
  I_ProductionVersion.PlanningAndExecutionBOMIsDiff AS PlanningAndExecutionBOMIsDiff,
  I_ProductionVersion.ExecBillOfMaterialVariantUsage AS ExecBillOfMaterialVariantUsage,
  I_ProductionVersion.ExecBillOfMaterialVariant AS ExecBillOfMaterialVariant,
  I_ProductionVersion.ExecBillOfOperationsType AS ExecBillOfOperationsType,
  I_ProductionVersion.ExecBillOfOperationsGroup AS ExecBillOfOperationsGroup,
  I_ProductionVersion.ExecBillOfOperationsVariant AS ExecBillOfOperationsVariant,
  I_ProductionVersion.Warehouse AS EWMWarehouse,
  I_ProductionVersion.DestinationStorageBin AS DestinationStorageBin,
  I_ProductionVersion.ProcurementType AS ProcurementType,
  I_ProductionVersion.MaterialProcurementProfile AS MaterialProcurementProfile,
  I_ProductionVersion.UsgeProbltyWthVersCtrlInPct AS UsgeProbltyWthVersCtrlInPct,
  I_ProductionVersion.MaterialBaseUnit AS MaterialBaseUnit,
  I_ProductionVersion.MaterialMinLotSizeQuantity AS MaterialMinLotSizeQuantity,
  I_ProductionVersion.MaterialMaxLotSizeQuantity AS MaterialMaxLotSizeQuantity,
  I_ProductionVersion.CostingLotSize AS CostingLotSize,
  I_ProductionVersion.TargetProductionSupplyArea AS TargetProductionSupplyArea,
  _MatlPlnt.MRPController AS MRPController,
  _MaterialText.MaterialName AS MaterialName,
  I_ProductionVersion._Plant.PlantName AS PlantName,
  I_ProductionVersion._ProductPlant.MRPResponsible AS MRPResponsible,
  _RoutingStatusText.ProductionVersionStatusText AS RoutingCheckStatusText,
  _ProdnVersLockText.ProductionVersionLockText AS ProductionVersionLockText,
  _BillOfOperationsTypeText.BillOfOperationsTypeName AS BillOfOperationsTypeName,
  I_ProductionVersion._BillOfOperations AS _BillOfOperations,
  I_ProductionVersion._BillOfOperationsGroup AS _BillOfOperationsGroup,
  I_ProductionVersion._BillOfOperationsType AS _BillOfOperationsType,
  I_ProductionVersion._ChangeMaster AS _ChangeMaster,
  I_ProductionVersion._IssuingStorageLocation AS _IssuingStorageLocation,
  I_ProductionVersion._MainProduct AS _MainProduct,
  I_ProductionVersion._Material AS _Material,
  I_ProductionVersion._MaterialBaseUnit AS _MaterialBaseUnit,
  I_ProductionVersion._MatlCostApportionmentStruc AS _MatlCostApportionmentStruc,
  I_ProductionVersion._MatlProcurementProfile AS _MatlProcurementProfile,
  I_ProductionVersion._OriglBatchReferenceMaterial AS _OriglBatchReferenceMaterial,
  I_ProductionVersion._Plant AS _Plant,
  I_ProductionVersion._Product AS _Product,
  I_ProductionVersion._ProductionLine AS _ProductionLine,
  I_ProductionVersion._ProductionSupplyArea AS _ProductionSupplyArea,
  I_ProductionVersion._ProductionVersionGroup AS _ProductionVersionGroup,
  I_ProductionVersion._ProductPlant AS _ProductPlant,
  I_ProductionVersion._QuantityDistributionKey AS _QuantityDistributionKey,
  I_ProductionVersion._ReceivingStorageLocation AS _ReceivingStorageLocation,
  I_ProductionVersion._TargetProductionSupplyArea AS _TargetProductionSupplyArea
FROM I_ProductionVersion
LEFT OUTER JOIN I_ProdnVersLock AS _ProdnVersLockVH ON ProductionVersionLock = _ProdnVersLockVH.ProductionVersionIsLocked  -- association [0..1]
LEFT OUTER JOIN I_ProdnVersLockText AS _ProdnVersLockText ON ProductionVersionLock = _ProdnVersLockText.ProductionVersionIsLocked AND _ProdnVersLockText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_ProdnVersChkStsTxt AS _RoutingStatusText ON ProductionVersionStatus = _RoutingStatusText.ProductionVersionStatus AND _RoutingStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsTypeText AS _BillOfOperationsTypeText ON BillOfOperationsType = _BillOfOperationsTypeText.BillOfOperationsType AND _BillOfOperationsTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_RecmddProdnVersMatlBOM AS _MaterialBOM ON Material = _MaterialBOM.Material AND Plant = _MaterialBOM.Plant AND BillOfMaterialVariant = _MaterialBOM.BillOfMaterialVariant AND BillOfMaterialVariantUsage = _MaterialBOM.BillOfMaterialVariantUsage AND ValidityStartDate >= _MaterialBOM.HeaderValidityStartDate AND ValidityStartDate <= _MaterialBOM.HeaderValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_ProdnVersConstcyLogCount AS _ConstcyLogCount ON Material = _ConstcyLogCount.Material AND Plant = _ConstcyLogCount.Plant AND ProductionVersion = _ConstcyLogCount.ProductionVersion  -- association [0..*]
LEFT OUTER JOIN R_ProdnVersConstcyLogTP AS _ConstcyLog ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More