A_CustomFieldCDSUsage

DDL: A_CUSTOMFIELDCDSUSAGE SQL: ACFDCDSUSAGE Type: view

Custom Field CDS Usage

A_CustomFieldCDSUsage is a CDS View that provides data about "Custom Field CDS Usage" in SAP S/4HANA. It reads from 1 data source (P_CustomFieldLatestVersion) and exposes 4 fields with key fields CustomFieldID, BusinessContext, CDSView. It has 2 associations to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
P_CustomFieldLatestVersion _LatestVersion inner

Associations (2)

CardinalityTargetAliasCondition
[0..*] P_UnionBusinessContext _UnionContext _UnionContext.Suffix = CDSUsage.union_suffix
[0..*] P_DirectUnionBusinessContext _DirectUnionContext _DirectUnionContext.Suffix = CDSUsage.union_suffix

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ACFDCDSUSAGE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Custom Field CDS Usage view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CustomFieldID P_CustomFieldLatestVersion external_name
KEY BusinessContext
KEY CDSView CDSUsage cds_view_name
IsSearchRelevant CDSUsage include_in_basic_search 
@AbapCatalog.sqlViewName: 'ACFDCDSUSAGE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED // TODO: Authorization check?

@EndUserText.label: 'Custom Field CDS Usage'
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API

define view A_CustomFieldCDSUsage
  as select distinct from cfd_w_rep_cds              as CDSUsage
  inner join P_CustomFieldLatestVersion              as _LatestVersion      on  _LatestVersion.name       = CDSUsage.name  
  association [0..*] to P_UnionBusinessContext       as _UnionContext       on _UnionContext.Suffix       = CDSUsage.union_suffix
  association [0..*] to P_DirectUnionBusinessContext as _DirectUnionContext on _DirectUnionContext.Suffix = CDSUsage.union_suffix 
 {
  key _LatestVersion.external_name                                                                                            as CustomFieldID,
  key coalesce( _DirectUnionContext.business_context, coalesce( _UnionContext.business_context, CDSUsage.business_context ) ) as BusinessContext,
  key CDSUsage.cds_view_name                                                                                                  as CDSView,
      CDSUsage.include_in_basic_search                                                                                        as IsSearchRelevant
 } 
 where CDSUsage.version      = _LatestVersion.Version
   and _LatestVersion.origin = #CFD_FIELD_ORIGIN.' '   // consider only Custom Fields (not ABAP Managed Fields)

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_CUSTOMFIELDLATESTVERSION",
"P_DIRECTUNIONBUSINESSCONTEXT",
"P_UNIONBUSINESSCONTEXT",
"CFD_W_REP_CDS"
],
"ASSOCIATED":
[
"P_DIRECTUNIONBUSINESSCONTEXT",
"P_UNIONBUSINESSCONTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More