P_SchedProdnAltvProdnVers

DDL: P_SCHEDPRODNALTVPRODNVERS Type: view_entity BASIC Package: PPH_VDM_CAP_EVAL

Alternative Production Version

P_SchedProdnAltvProdnVers is a Basic CDS View that provides data about "Alternative Production Version" in SAP S/4HANA. It reads from 4 data sources (I_BOOSqncOperationAssgmtChgSt, I_BillOfOperationsOpBasic, I_WorkCenter, I_ProductionVersion) and exposes 8 fields with key fields Material, Plant, ProductionVersion. It has 1 association to related views. Part of development package PPH_VDM_CAP_EVAL.

4 data source(s) 8 fields

Data Sources (4)

SourceAliasJoin Type
I_BOOSqncOperationAssgmtChgSt _plas inner
I_BillOfOperationsOpBasic _plpo inner
I_WorkCenter _workcenter inner
I_ProductionVersion I_ProductionVersion from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Plant _plant _plant.Plant = I_ProductionVersion.Plant

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
VDM.private true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Material I_ProductionVersion Material
KEY Plant I_ProductionVersion Plant
KEY ProductionVersion I_ProductionVersion ProductionVersion
WorkCenter I_WorkCenter WorkCenter
WorkCenterTypeCode I_WorkCenter WorkCenterTypeCode
WorkCenterInternalID I_WorkCenter WorkCenterInternalID
CapacityInternalID I_WorkCenter CapacityInternalID
AddressTimeZone 
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@VDM.private: true
define view entity P_SchedProdnAltvProdnVers
  as select from I_ProductionVersion
  
  inner join I_WorkCenter                  as _workcenter  on _workcenter.WorkCenter              = I_ProductionVersion.ProductionLine
  inner join I_BOOSqncOperationAssgmtChgSt as _plas        on _plas.BillOfOperationsType          = I_ProductionVersion.BillOfOperationsType
                                                          and _plas.BillOfOperationsGroup         = I_ProductionVersion.BillOfOperationsGroup
                                                          and _plas.BillOfOperationsVariant       = I_ProductionVersion.BillOfOperationsVariant 
  inner join I_BillOfOperationsOpBasic     as _plpo        on _plpo.BillOfOperationsType          = _plas.BillOfOperationsType
                                                          and _plpo.BillOfOperationsGroup         = _plas.BillOfOperationsGroup
                                                          and _plpo.BOOOperationInternalID        = _plas.BOOOperationInternalID
                                                          and _plpo.BOOOpInternalVersionCounter   = _plas.BOOSqncOpAssgmtIntVersionCntr  
                                                          and _plpo.WorkCenterInternalID          = _workcenter.WorkCenterInternalID
//  inner join I_Plant as _plant                            on  _plant.Plant                        = I_ProductionVersion.Plant

  association [1..1] to I_Plant            as _plant       on _plant.Plant = I_ProductionVersion.Plant
//  P_SchedProdnPlantTimeZone     as _timezone   on  _timezone.werks                     = I_ProductionVersion.Plant

{  

  key I_ProductionVersion.Material,
  key I_ProductionVersion.Plant,
  key I_ProductionVersion.ProductionVersion ,
      _workcenter.WorkCenter,
      _workcenter.WorkCenterTypeCode,
      _workcenter.WorkCenterInternalID,
      _workcenter.CapacityInternalID,
      _plant._OrganizationAddress.AddressTimeZone
//      _timezone.PlantTimeZone 

      
}
where I_ProductionVersion.ProductionLine!= ''

Learn More