P_SchedProdnAltvProdnVers

DDL: P_SCHEDPRODNALTVPRODNVERS SQL: PSHPDALTPV Type: view BASIC

P_SchedProdnAltvProdnVers is a Basic CDS View 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.

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 (6)

NameValueLevelField
AbapCatalog.sqlViewName PSHPDALTPV view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE 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 
@AbapCatalog.sqlViewName: 'PSHPDALTPV'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@VDM.private: true
define view 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!= ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLOFOPERATIONSOPBASIC",
"I_BOOSQNCOPERATIONASSGMTCHGST",
"I_ORGANIZATIONADDRESS",
"I_PLANT",
"I_PRODUCTIONVERSION",
"I_WORKCENTER"
],
"ASSOCIATED":
[
"I_PLANT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More