P_ChmlCmplncReqIntNmMigration1

DDL: P_CHMLCMPLNCREQINTNMMIGRATION1 Type: view_entity COMPOSITE Package: EHFND_BO_CRQ

View for scilent data migration for CRQ internal number

P_ChmlCmplncReqIntNmMigration1 is a Composite CDS View that provides data about "View for scilent data migration for CRQ internal number" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncReq) and exposes 3 fields with key field ChmlCmplncRequestUUID. Part of development package EHFND_BO_CRQ.

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncReq I_ChmlCmplncReq from

Annotations (6)

NameValueLevelField
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 (3)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncRequestUUID ChmlCmplncRequestUUID
ProductComplianceRequest ProductComplianceRequest
CreationUTCDateTime CreationUTCDateTime
@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 entity P_ChmlCmplncReqIntNmMigration1

  as select from I_ChmlCmplncReq

{
  key ChmlCmplncRequestUUID,

      ProductComplianceRequest,
      CreationUTCDateTime,    
      
      case
        when ProductComplianceRequest = ''
          then '00' -- not yet executed
        else '01' -- Migration not needed/ already done
      end as StatusField

}