P_VersEngBOMAcrossAllProdnPlnt

/*

This Private view is a cartesian product of an EBOM with all plants present in the system.The Catesian product is done
because the EBOM shouls have the possiblity of handover to any manufacturing plant Hence the Plant after join has been
renamed as Production Plant

*/

@AbapCatalog.sqlViewName: 'PVERSEBOMALLPLNT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality:#X, sizeCategory: #XXL, dataClass: #MASTER}
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_VersEngBOMAcrossAllProdnPlnt
  as select from P_VersEngBillOfMaterial as VersEngBOM
    cross join   I_Plant                 as ProductionPlant
{
  key  VersEngBOM.BillOfMaterialCategory,
  key  VersEngBOM.BillOfMaterial,
  key  VersEngBOM.BillOfMaterialVariant,
  key  VersEngBOM.Material,
  key  VersEngBOM.Plant,
  key  VersEngBOM.BillOfMaterialVersion,
  key  cast(ProductionPlant.Plant as mpe_mec_prodn_plnt preserving type)                                                 as ProductionPlant,
       VersEngBOM.BOMAlternativeText,
       VersEngBOM.BOMGroup,
       VersEngBOM.BOMHeaderBaseUnit,
       VersEngBOM.BOMHeaderInternalChangeCount,
       VersEngBOM.BOMHeaderQuantityInBaseUnit,
       VersEngBOM.BOMHeaderText,
       VersEngBOM.BOMIsToBeDeleted,
       VersEngBOM.EBOMType,
       VersEngBOM.BOMPrioritizedVersion,
       VersEngBOM.BOMTechnicalType,
       VersEngBOM.BOMUsagePriority,
       VersEngBOM.BOMVersionStatus,
       VersEngBOM.BillOfMaterialAuthsnGrp,
       VersEngBOM.BillOfMaterialHeaderUUID,
       VersEngBOM.BillOfMaterialStatus,
       VersEngBOM.BillOfMaterialUUID,
       VersEngBOM.BillOfMaterialVariantUsage,
       VersEngBOM.ChgToEngineeringChgDocument,
       VersEngBOM.CreatedByUser,
       VersEngBOM.DocumentIsCreatedByCAD,
       VersEngBOM.EngineeringChangeDocument,
       VersEngBOM.HeaderValidityEndDate,
       VersEngBOM.HeaderValidityStartDate,
       VersEngBOM.IsALE,
       VersEngBOM.IsConfiguredMaterial,
       VersEngBOM.IsLatestBOMVersion,
       VersEngBOM.IsMarkedForDeletion,
       VersEngBOM.IsMultipleBOMAlt,
       VersEngBOM.LaboratoryOrDesignOffice,

       // Last Change Date should be calclulated based on header and item both

//              case when VersEngBOM.BOMItemLastChangeDate > VersEngBOM.LastChangeDate

//                   then

//                        VersEngBOM.BOMItemLastChangeDate

//                   else

//                        VersEngBOM.LastChangeDate

//              end                                                               as LastChangeDate,

       case when VersEngBOM.LastChangeDate is null 
       then VersEngBOM.RecordCreationDate 
       else VersEngBOM.LastChangeDate end as LastChangeDate,

       // Unitization Flag

       VersEngBOM.IsMaterialUnitized,

       VersEngBOM.RecordCreationDate,
       VersEngBOM.LastChangedByUser,
       VersEngBOM.MatFromLotSizeQuantity,
       VersEngBOM.IsVersionBillOfMaterial,
       VersEngBOM.MaterialToLotSizeQuantity,

       VersEngBOM._BillOfMaterialItem,
       VersEngBOM._BillOfMaterialVariantUsage,
       VersEngBOM._UnitOfMeasure
}