C_CmplRqRsltDraftAdminvData

DDL: C_CMPLRQRSLTDRAFTADMINVDATA SQL: CCRRDRAFTADMDATA Type: view CONSUMPTION

Draft admin data for Compliance Assessments

C_CmplRqRsltDraftAdminvData is a Consumption CDS View that provides data about "Draft admin data for Compliance Assessments" in SAP S/4HANA. It reads from 1 data source (I_CmplRqRslt) and exposes 7 fields with key field CmplRqRsltUUID.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_CmplRqRslt I_CmplRqRslt from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CCRRDRAFTADMDATA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Draft admin data for Compliance Assessments view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CmplRqRsltUUID CmplRqRsltUUID
CmplRqVersUUID CmplRqVersUUID
LastChangeDateTime
LastChangedByUser
InProcessByUser
LastChangedByUserDescription
InProcessByUserDescription 
@AbapCatalog.sqlViewName: 'CCRRDRAFTADMDATA'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true

@AccessControl: {
  authorizationCheck: #MANDATORY,
  personalData.blocking: #NOT_REQUIRED
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Draft admin data for Compliance Assessments'

@VDM.viewType: #CONSUMPTION

@ObjectModel:
{
  usageType:
  {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #XL,
    serviceQuality: #C
  }
}

@UI.presentationVariant.requestAtLeast : [
  'DraftUUID',
  'LastChangeDateTime',
  'LastChangedByUser',
  'InProcessByUser',
  'LastChangedByUserDescription',
  'InProcessByUserDescription'
]


define view C_CmplRqRsltDraftAdminvData
  as select from I_CmplRqRslt
{
  key CmplRqRsltUUID,
      CmplRqVersUUID,

      ---- Fields for draft indicator ----

      @ObjectModel: {
        virtualElement: true,
        virtualElementCalculatedBy: 'ABAP:CL_EHFND_CRR_DRAFT_IND_EXIT'
      }
      -- This is the only way to get a UUID field to be calculated in a virtual data element
      HEXTOBIN( '00000000000000000000000000000000' )                                           as DraftUUID,

      @ObjectModel: {
        virtualElement: true,
        virtualElementCalculatedBy: 'ABAP:CL_EHFND_CRR_DRAFT_IND_EXIT'
      }
      cast ( 0 as sdraft_last_changed_at )                       as LastChangeDateTime,

      @ObjectModel: {
        virtualElement: true,
        virtualElementCalculatedBy: 'ABAP:CL_EHFND_CRR_DRAFT_IND_EXIT'
      }
      cast ( '' as sdraft_last_changed_by )                      as LastChangedByUser,

      @ObjectModel: {
        virtualElement: true,
        virtualElementCalculatedBy: 'ABAP:CL_EHFND_CRR_DRAFT_IND_EXIT'
      }
      cast ( '' as sdraft_in_process_by )                        as InProcessByUser,

      @ObjectModel: {
        virtualElement: true,
        virtualElementCalculatedBy: 'ABAP:CL_EHFND_CRR_DRAFT_IND_EXIT'
      }
      cast ( '' as sdraft_last_changed_by_desc )                 as LastChangedByUserDescription,

      @ObjectModel: {
        virtualElement: true,
        virtualElementCalculatedBy: 'ABAP:CL_EHFND_CRR_DRAFT_IND_EXIT'
      }
      cast ( '' as sdraft_in_process_by_desc )                   as InProcessByUserDescription,

      ---- needed for authority check ----
      ComplianceRequirement

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CMPLRQRSLT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More