C_CmplncPrpsNameWithFallback

DDL: C_CMPLNCPRPSNAMEWITHFALLBACK SQL: CCPNAMEFALLBACK Type: view CONSUMPTION

Compliance Purpose Name with Fallback

C_CmplncPrpsNameWithFallback is a Consumption CDS View that provides data about "Compliance Purpose Name with Fallback" in SAP S/4HANA. It reads from 1 data source (I_CmplncPrps) and exposes 3 fields with key field CmplncPrpsUUID. It has 2 associations to related views.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_CmplncPrps CmplncPrps from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CmplncPrpsText _CmplncPrpsTextILL _CmplncPrpsTextILL.CmplncPrpsUUID = $projection.CmplncPrpsUUID and _CmplncPrpsTextILL.Language = $session.system_language
[0..1] I_CmplncPrpsText _CmplncPrpsEnglishText _CmplncPrpsEnglishText.CmplncPrpsUUID = $projection.CmplncPrpsUUID and _CmplncPrpsEnglishText.Language = 'E'

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CCPNAMEFALLBACK view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Compliance Purpose Name with Fallback view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY CmplncPrpsUUID I_CmplncPrps CmplncPrpsUUID
CmplncPrpsName _CmplncPrpsTextILL CmplncPrpsName
CmplncPrpsEnglishName _CmplncPrpsEnglishText CmplncPrpsName 
@AbapCatalog.sqlViewName: 'CCPNAMEFALLBACK'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Compliance Purpose Name with Fallback'

@VDM.viewType: #CONSUMPTION

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel:
{
  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #S,
    serviceQuality: #C
  }
}

define view C_CmplncPrpsNameWithFallback
  as select from    I_CmplncPrps     as CmplncPrps
  association [0..1] to I_CmplncPrpsText as _CmplncPrpsTextILL     on  _CmplncPrpsTextILL.CmplncPrpsUUID     = $projection.CmplncPrpsUUID
                                                                   and _CmplncPrpsTextILL.Language           = $session.system_language
  association [0..1] to I_CmplncPrpsText as _CmplncPrpsEnglishText on  _CmplncPrpsEnglishText.CmplncPrpsUUID = $projection.CmplncPrpsUUID
                                                                   and _CmplncPrpsEnglishText.Language       = 'E'
{
  key CmplncPrps.CmplncPrpsUUID,

      cast( case
        when _CmplncPrpsTextILL.CmplncPrpsName is not null
          then _CmplncPrpsTextILL.CmplncPrpsName

        when _CmplncPrpsTextILL.CmplncPrpsName is null
         and _CmplncPrpsEnglishText.CmplncPrpsName is not null
          then _CmplncPrpsEnglishText.CmplncPrpsName

        else CmplncPrps.CmplncPrps

      end as ehfnd_cmplnc_prps_name preserving type ) as CmplncPrps,

      _CmplncPrpsTextILL.CmplncPrpsName           as CmplncPrpsName,
      _CmplncPrpsEnglishText.CmplncPrpsName       as CmplncPrpsEnglishName
}

Learn More