P_ChmlCmplncProdCatztnMigrtn

DDL: P_CHMLCMPLNCPRODCATZTNMIGRTN SQL: PCCMPLCNPCMIG Type: view COMPOSITE Package: EHFND_BO_CCI

Silent Data Migration for Product Categorization in CCI

P_ChmlCmplncProdCatztnMigrtn is a Composite CDS View that provides data about "Silent Data Migration for Product Categorization in CCI" 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.sqlViewName PCCMPLCNPCMIG view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_ALLOWED view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (4)

KeyFieldSource TableSource FieldDescription
ChmlCmplncInfoUUID I_ChmlCmplncInfo ChmlCmplncInfoUUID
ChmlCmplncInfoType I_ChmlCmplncInfo ChmlCmplncInfoType
ChmlCmplncProdCatztnPhrsUUID I_ChmlCmplncInfo ChmlCmplncProdCatztnPhrsUUID
00asStatusField 
@AbapCatalog.sqlViewName: 'PCCMPLCNPCMIG'
@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

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

define view P_ChmlCmplncProdCatztnMigrtn

  as select from I_ChmlCmplncInfo
{
  I_ChmlCmplncInfo.ChmlCmplncInfoUUID,
  I_ChmlCmplncInfo.ChmlCmplncInfoType,
  I_ChmlCmplncInfo.ChmlCmplncProdCatztnPhrsUUID,
  '00'as StatusField
}
where
  I_ChmlCmplncInfo.ChmlCmplncInfoType           =    'BU'
  and(
    I_ChmlCmplncInfo.ChmlCmplncProdCatztnPhrsUUID is null
    or I_ChmlCmplncInfo.ChmlCmplncProdCatztnPhrsUUID = hextobin('00000000000000000000000000000000')
    
  )

Learn More