P_ProductionVersionTP

DDL: P_PRODUCTIONVERSIONTP Type: view_entity COMPOSITE
82 Fields 1 Data Sources

Production version details

P_ProductionVersionTP is a Composite CDS View that provides data about "Production version details" in SAP S/4HANA. It reads from 1 data source (R_ProductionVersionTP) and exposes 82 fields with key fields Material, Plant, ProductionVersion.

Data Sources (1)

SourceAliasJoin Type
R_ProductionVersionTP R_ProductionVersionTP from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Production version details view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (82)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY ProductionVersion ProductionVersion Version ID
ProductionVersionText ProductionVersionText
ChangeHistoryCount ChangeHistoryCount
ChangeNumber ChangeNumber Change Number
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangedByUser LastChangedByUser User Name
BillOfOperationsType BillOfOperationsType Task List Type
BillOfOperationsGroup BillOfOperationsGroup Group
BillOfOperationsVariant BillOfOperationsVariant Group Counter
BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
ProductionLine ProductionLine Production Line
ProductionSupplyArea ProductionSupplyArea Supply Area
ProductionVersionGroup ProductionVersionGroup
MainProduct MainProduct
MaterialCostApportionmentStruc MaterialCostApportionmentStruc
IssuingStorageLocation IssuingStorageLocation Iss. Stor. Loc.
ReceivingStorageLocation ReceivingStorageLocation RecStorLoc
OriginalBatchReferenceMaterial OriginalBatchReferenceMaterial
QuantityDistributionKey QuantityDistributionKey Distribution
ProductionVersionStatus ProductionVersionStatus
ProductionVersionLastCheckDate ProductionVersionLastCheckDate
RateBasedPlanningStatus RateBasedPlanningStatus
PreliminaryPlanningStatus PreliminaryPlanningStatus
BOMCheckStatus BOMCheckStatus
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
ProductionVersionLock ProductionVersionLock
ProdnVersIsAllowedForRptvMfg ProdnVersIsAllowedForRptvMfg
HasVersionCtrldBOMAndRouting HasVersionCtrldBOMAndRouting
PlanningAndExecutionBOMIsDiff PlanningAndExecutionBOMIsDiff
ExecBillOfMaterialVariantUsage ExecBillOfMaterialVariantUsage
ExecBillOfMaterialVariant ExecBillOfMaterialVariant
ExecBillOfOperationsType ExecBillOfOperationsType
ExecBillOfOperationsGroup ExecBillOfOperationsGroup
ExecBillOfOperationsVariant ExecBillOfOperationsVariant
EWMWarehouse EWMWarehouse Warehouse No.
DestinationStorageBin DestinationStorageBin
ProcurementType ProcurementType Procurement
MaterialProcurementProfile MaterialProcurementProfile Special Procur.
UsgeProbltyWthVersCtrlInPct UsgeProbltyWthVersCtrlInPct
MaterialBaseUnit MaterialBaseUnit Valuation Unit
MaterialMinLotSizeQuantity MaterialMinLotSizeQuantity
MaterialMaxLotSizeQuantity MaterialMaxLotSizeQuantity
CostingLotSize CostingLotSize
TargetProductionSupplyArea TargetProductionSupplyArea
MRPController MRPController MRP Controller
MaterialName MaterialName Material Description
PlantName PlantName Plant Name
MRPResponsible MRPResponsible MRP Controller
RoutingCheckStatusText RoutingCheckStatusText
ProductionVersionLockText ProductionVersionLockText
BillOfOperationsTypeName BillOfOperationsTypeName
_BillOfOperations _BillOfOperations
_BillOfOperationsGroup _BillOfOperationsGroup
_BillOfOperationsType _BillOfOperationsType
_BillOfOperationsTypeText _BillOfOperationsTypeText
_ChangeMaster _ChangeMaster
_IssuingStorageLocation _IssuingStorageLocation
_MainProduct _MainProduct
_Material _Material
_MaterialBaseUnit _MaterialBaseUnit
_MaterialText _MaterialText
_MatlCostApportionmentStruc _MatlCostApportionmentStruc
_MatlProcurementProfile _MatlProcurementProfile
_OriglBatchReferenceMaterial _OriglBatchReferenceMaterial
_Plant _Plant
_ProdnVersLockText _ProdnVersLockText
_ProdnVersLockVH _ProdnVersLockVH
_Product _Product
_ProductionLine _ProductionLine
_ProductionSupplyArea _ProductionSupplyArea
_ProductionVersionGroup _ProductionVersionGroup
_ProductPlant _ProductPlant
_QuantityDistributionKey _QuantityDistributionKey
_ReceivingStorageLocation _ReceivingStorageLocation
_RoutingStatusText _RoutingStatusText
_TargetProductionSupplyArea _TargetProductionSupplyArea

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 P_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 P_ProductionVersionTP AS
SELECT
  Material,
  Plant,
  ProductionVersion,
  ProductionVersionText,
  ChangeHistoryCount,
  ChangeNumber,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BillOfMaterialVariantUsage,
  BillOfMaterialVariant,
  ProductionLine,
  ProductionSupplyArea,
  ProductionVersionGroup,
  MainProduct,
  MaterialCostApportionmentStruc,
  IssuingStorageLocation,
  ReceivingStorageLocation,
  OriginalBatchReferenceMaterial,
  QuantityDistributionKey,
  ProductionVersionStatus,
  ProductionVersionLastCheckDate,
  RateBasedPlanningStatus,
  PreliminaryPlanningStatus,
  BOMCheckStatus,
  ValidityStartDate,
  ValidityEndDate,
  ProductionVersionLock,
  ProdnVersIsAllowedForRptvMfg,
  HasVersionCtrldBOMAndRouting,
  PlanningAndExecutionBOMIsDiff,
  ExecBillOfMaterialVariantUsage,
  ExecBillOfMaterialVariant,
  ExecBillOfOperationsType,
  ExecBillOfOperationsGroup,
  ExecBillOfOperationsVariant,
  EWMWarehouse,
  DestinationStorageBin,
  ProcurementType,
  MaterialProcurementProfile,
  UsgeProbltyWthVersCtrlInPct,
  MaterialBaseUnit,
  MaterialMinLotSizeQuantity,
  MaterialMaxLotSizeQuantity,
  CostingLotSize,
  TargetProductionSupplyArea,
  MRPController,
  MaterialName,
  PlantName,
  MRPResponsible,
  RoutingCheckStatusText,
  ProductionVersionLockText,
  BillOfOperationsTypeName
FROM R_ProductionVersionTP
;

Learn More