P_ProductionVersion

DDL: P_PRODUCTIONVERSION SQL: PPRODNVERSION Type: view COMPOSITE

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.

1 data source(s) 52 fields

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
KEY Plant I_ProductionVersion Plant
KEY ProductionVersion I_ProductionVersion ProductionVersion
ProductionVersionText I_ProductionVersion ProductionVersionText
ChangeHistoryCount I_ProductionVersion ChangeHistoryCount
ChangeNumber I_ProductionVersion ChangeNumber
CreationDate I_ProductionVersion CreationDate
CreatedByUser I_ProductionVersion CreatedByUser
LastChangeDate I_ProductionVersion LastChangeDate
LastChangedByUser I_ProductionVersion LastChangedByUser
BillOfOperationsType I_ProductionVersion BillOfOperationsType
BillOfOperationsGroup I_ProductionVersion BillOfOperationsGroup
BillOfOperationsVariant I_ProductionVersion BillOfOperationsVariant
BillOfMaterialVariantUsage I_ProductionVersion BillOfMaterialVariantUsage
BillOfMaterialVariant I_ProductionVersion BillOfMaterialVariant
ProductionLine I_ProductionVersion ProductionLine
ProductionSupplyArea I_ProductionVersion ProductionSupplyArea
ProductionVersionGroup I_ProductionVersion ProductionVersionGroup
MainProduct I_ProductionVersion MainProduct
MaterialCostApportionmentStruc I_ProductionVersion MaterialCostApportionmentStruc
IssuingStorageLocation I_ProductionVersion IssuingStorageLocation
ReceivingStorageLocation I_ProductionVersion ReceivingStorageLocation
OriginalBatchReferenceMaterial I_ProductionVersion OriginalBatchReferenceMaterial
DistributionKey I_ProductionVersion DistributionKey
ProductionVersionStatus I_ProductionVersion ProductionVersionStatus
ProductionVersionLastCheckDate I_ProductionVersion ProductionVersionLastCheckDate
RateBasedPlanningStatus I_ProductionVersion RateBasedPlanningStatus
PreliminaryPlanningStatus I_ProductionVersion PreliminaryPlanningStatus
BOMCheckStatus I_ProductionVersion BOMCheckStatus
ValidityStartDate I_ProductionVersion ValidityStartDate
ValidityEndDate I_ProductionVersion ValidityEndDate
MaterialMinLotSizeQuantity I_ProductionVersion MaterialMinLotSizeQuantity
MaterialMaxLotSizeQuantity I_ProductionVersion MaterialMaxLotSizeQuantity
ProductionVersionIsLocked I_ProductionVersion ProductionVersionIsLocked
ProdnVersIsAllowedForRptvMfg I_ProductionVersion ProdnVersIsAllowedForRptvMfg
HasVersionCtrldBOMAndRouting I_ProductionVersion HasVersionCtrldBOMAndRouting
_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 
@AbapCatalog.sqlViewName: 'PPRODNVERSION'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_ProductionVersion
  as select from I_ProductionVersion as _ProdnVers
{
  key  _ProdnVers.Material,
  key  _ProdnVers.Plant,
  key  _ProdnVers.ProductionVersion,
       _ProdnVers.ProductionVersionText,
       _ProdnVers.ChangeHistoryCount,
       _ProdnVers.ChangeNumber,
       _ProdnVers.CreationDate,
       _ProdnVers.CreatedByUser,
       _ProdnVers.LastChangeDate,
       _ProdnVers.LastChangedByUser,
       _ProdnVers.BillOfOperationsType,
       _ProdnVers.BillOfOperationsGroup,
       _ProdnVers.BillOfOperationsVariant,
       _ProdnVers.BillOfMaterialVariantUsage,
       _ProdnVers.BillOfMaterialVariant,
       _ProdnVers.ProductionLine,
       _ProdnVers.ProductionSupplyArea,
       _ProdnVers.ProductionVersionGroup,
       _ProdnVers.MainProduct,
       _ProdnVers.MaterialCostApportionmentStruc,
       _ProdnVers.IssuingStorageLocation,
       _ProdnVers.ReceivingStorageLocation,
       _ProdnVers.OriginalBatchReferenceMaterial,
       _ProdnVers.DistributionKey,
       _ProdnVers.ProductionVersionStatus,
       _ProdnVers.ProductionVersionLastCheckDate,
       _ProdnVers.RateBasedPlanningStatus,
       _ProdnVers.PreliminaryPlanningStatus,
       _ProdnVers.BOMCheckStatus,
       _ProdnVers.ValidityStartDate,
       _ProdnVers.ValidityEndDate,
       _ProdnVers.MaterialMinLotSizeQuantity,
       _ProdnVers.MaterialMaxLotSizeQuantity,
       _ProdnVers.ProductionVersionIsLocked,
       _ProdnVers.ProdnVersIsAllowedForRptvMfg,
       _ProdnVers.HasVersionCtrldBOMAndRouting,
       _ProdnVers._BillOfOperations,
       _ProdnVers._BillOfOperationsGroup,
       _ProdnVers._BillOfOperationsType,
       _ProdnVers._ChangeMaster,
       _ProdnVers._IssuingStorageLocation,
       _ProdnVers._MainProduct,
       _ProdnVers._Material,
       _ProdnVers._MatlCostApportionmentStruc,
       _ProdnVers._OriglBatchReferenceMaterial,
       _ProdnVers._Plant,
       _ProdnVers._Product,
       _ProdnVers._ProductionLine,
       _ProdnVers._ProductionSupplyArea,
       _ProdnVers._ProductionVersionGroup,
       _ProdnVers._ProductPlant,
       _ProdnVers._ReceivingStorageLocation,
// Mapping Repetetive manufacturing to Discrete Industry       

       cast( case
       when _ProdnVers._BillOfOperationsType.BillOfOperationsApplication = 'R'
       then cast ('P' as plnaw)
       else
       cast (_ProdnVers._BillOfOperationsType.BillOfOperationsApplication as plnaw)
       end as plnaw preserving type ) as BillOfOperationsApplication
}

Learn More