P_ChmlCmplncInfoMigration

@AbapCatalog.sqlViewName: 'PCCMPLCNINFOMIG'
@AbapCatalog.compiler.compareFilter: true

@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #NOT_ALLOWED

@ObjectModel:
{
  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #M,
    serviceQuality: #B
  }
}  

@VDM.viewType: #COMPOSITE
@VDM.private: true

-- View for the silent data migration for physical-chemical properties of ChmlCmplncInfo objects
-- It selects all ChmlCmplncInfo objects that do not have the necessary physical-chemical root objects

-------------------------------------------------------------
-- IMPORTANT: View may not be changed after initial delivery! 
-------------------------------------------------------------

define view P_ChmlCmplncInfoMigration

  as select from I_ChmlCmplncInfo

    left outer to one join I_PhysicalChemicalProperty as PhysicalChemicalProperty on I_ChmlCmplncInfo.ChmlCmplncInfoUUID = PhysicalChemicalProperty.ChmlCmplncInfoUUID
{
  I_ChmlCmplncInfo.mandt,
  I_ChmlCmplncInfo.ChmlCmplncInfoUUID,
  I_ChmlCmplncInfo.ChmlCmplncInternalName,
  '00'     as StatusField
}
where
       PhysicalChemicalProperty.PhysChmlPrptyUUID      is null

  // ChmlCmplncInfo must be an unpackaged product

  and  I_ChmlCmplncInfo.ChmlCmplncInfoType           =    'BU'
  and(
       I_ChmlCmplncInfo.MaterialIsProduced    =    'X'
    or I_ChmlCmplncInfo.MaterialIsSold        =    'X'
    or I_ChmlCmplncInfo.MaterialIsTransported =    'X'
  )