P_ProductionVersion

DDL: P_PRODUCTIONVERSION SQL: PPRODNVERSION Type: view COMPOSITE
52 Fields 1 Data Sources

P_ProductionVersion is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ProductionVersion) and exposes 52 fields with key fields Material, Plant, ProductionVersion.

Data Sources (1)

SourceAliasJoin Type
I_ProductionVersion _ProdnVers from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPRODNVERSION view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (52)

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
DistributionKey I_ProductionVersion DistributionKey Distr. Number
ProductionVersionStatus I_ProductionVersion ProductionVersionStatus Check Status
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
MaterialMinLotSizeQuantity I_ProductionVersion MaterialMinLotSizeQuantity Min. Lot Size
MaterialMaxLotSizeQuantity I_ProductionVersion MaterialMaxLotSizeQuantity To Lot Size
ProductionVersionIsLocked I_ProductionVersion ProductionVersionIsLocked Prodn Version Lock
ProdnVersIsAllowedForRptvMfg I_ProductionVersion ProdnVersIsAllowedForRptvMfg REM Allowed
HasVersionCtrldBOMAndRouting I_ProductionVersion HasVersionCtrldBOMAndRouting BOM/RTG Vers. Exists
_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
_MatlCostApportionmentStruc I_ProductionVersion _MatlCostApportionmentStruc
_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
_ReceivingStorageLocation I_ProductionVersion _ReceivingStorageLocation

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_ProductionVersion.
-- 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: PPRODNVERSION

CREATE VIEW P_ProductionVersion AS
SELECT
  _ProdnVers.Material AS Material,
  _ProdnVers.Plant AS Plant,
  _ProdnVers.ProductionVersion AS ProductionVersion,
  _ProdnVers.ProductionVersionText AS ProductionVersionText,
  _ProdnVers.ChangeHistoryCount AS ChangeHistoryCount,
  _ProdnVers.ChangeNumber AS ChangeNumber,
  _ProdnVers.CreationDate AS CreationDate,
  _ProdnVers.CreatedByUser AS CreatedByUser,
  _ProdnVers.LastChangeDate AS LastChangeDate,
  _ProdnVers.LastChangedByUser AS LastChangedByUser,
  _ProdnVers.BillOfOperationsType AS BillOfOperationsType,
  _ProdnVers.BillOfOperationsGroup AS BillOfOperationsGroup,
  _ProdnVers.BillOfOperationsVariant AS BillOfOperationsVariant,
  _ProdnVers.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  _ProdnVers.BillOfMaterialVariant AS BillOfMaterialVariant,
  _ProdnVers.ProductionLine AS ProductionLine,
  _ProdnVers.ProductionSupplyArea AS ProductionSupplyArea,
  _ProdnVers.ProductionVersionGroup AS ProductionVersionGroup,
  _ProdnVers.MainProduct AS MainProduct,
  _ProdnVers.MaterialCostApportionmentStruc AS MaterialCostApportionmentStruc,
  _ProdnVers.IssuingStorageLocation AS IssuingStorageLocation,
  _ProdnVers.ReceivingStorageLocation AS ReceivingStorageLocation,
  _ProdnVers.OriginalBatchReferenceMaterial AS OriginalBatchReferenceMaterial,
  _ProdnVers.DistributionKey AS DistributionKey,
  _ProdnVers.ProductionVersionStatus AS ProductionVersionStatus,
  _ProdnVers.ProductionVersionLastCheckDate AS ProductionVersionLastCheckDate,
  _ProdnVers.RateBasedPlanningStatus AS RateBasedPlanningStatus,
  _ProdnVers.PreliminaryPlanningStatus AS PreliminaryPlanningStatus,
  _ProdnVers.BOMCheckStatus AS BOMCheckStatus,
  _ProdnVers.ValidityStartDate AS ValidityStartDate,
  _ProdnVers.ValidityEndDate AS ValidityEndDate,
  _ProdnVers.MaterialMinLotSizeQuantity AS MaterialMinLotSizeQuantity,
  _ProdnVers.MaterialMaxLotSizeQuantity AS MaterialMaxLotSizeQuantity,
  _ProdnVers.ProductionVersionIsLocked AS ProductionVersionIsLocked,
  _ProdnVers.ProdnVersIsAllowedForRptvMfg AS ProdnVersIsAllowedForRptvMfg,
  _ProdnVers.HasVersionCtrldBOMAndRouting AS HasVersionCtrldBOMAndRouting,
  _ProdnVers._BillOfOperations AS _BillOfOperations,
  _ProdnVers._BillOfOperationsGroup AS _BillOfOperationsGroup,
  _ProdnVers._BillOfOperationsType AS _BillOfOperationsType,
  _ProdnVers._ChangeMaster AS _ChangeMaster,
  _ProdnVers._IssuingStorageLocation AS _IssuingStorageLocation,
  _ProdnVers._MainProduct AS _MainProduct,
  _ProdnVers._Material AS _Material,
  _ProdnVers._MatlCostApportionmentStruc AS _MatlCostApportionmentStruc,
  _ProdnVers._OriglBatchReferenceMaterial AS _OriglBatchReferenceMaterial,
  _ProdnVers._Plant AS _Plant,
  _ProdnVers._Product AS _Product,
  _ProdnVers._ProductionLine AS _ProductionLine,
  _ProdnVers._ProductionSupplyArea AS _ProductionSupplyArea,
  _ProdnVers._ProductionVersionGroup AS _ProductionVersionGroup,
  _ProdnVers._ProductPlant AS _ProductPlant,
  _ProdnVers._ReceivingStorageLocation AS _ReceivingStorageLocation
FROM I_ProductionVersion AS _ProdnVers
;

Learn More