P_ChmlCmplncInfoMigration

DDL: P_CHMLCMPLNCINFOMIGRATION SQL: PCCMPLCNINFOMIG Type: view COMPOSITE Package: EHFND_BO_CCI

Silent Data Migration for ChmlCmplncInfo

P_ChmlCmplncInfoMigration is a Composite CDS View that provides data about "Silent Data Migration for ChmlCmplncInfo" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncInfo) and exposes 4 fields. Part of development package EHFND_BO_CCI.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncInfo I_ChmlCmplncInfo from

Annotations (9)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName PCCMPLCNINFOMIG view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (4)

KeyFieldSource TableSource FieldDescription
mandt I_ChmlCmplncInfo mandt
ChmlCmplncInfoUUID I_ChmlCmplncInfo ChmlCmplncInfoUUID
ChmlCmplncInternalName I_ChmlCmplncInfo ChmlCmplncInternalName
StatusField 
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'PCCMPLCNINFOMIG'

@AccessControl.authorizationCheck: #NOT_ALLOWED

@ClientHandling.algorithm: #SESSION_VARIABLE

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

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

-- 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')
  and (   I_ChmlCmplncInfo.ChmlCmplncProdCatztnPhrsUUID = hextobin('BA14816F0C34426CA20628AA85C5A2C2') -- Mixture
       or I_ChmlCmplncInfo.ChmlCmplncProdCatztnPhrsUUID = hextobin('F0EEDDE8B2464E568D8A10B11C33014A') -- Substance
     )

Learn More