A_CustomFieldBusinessContext

DDL: A_CUSTOMFIELDBUSINESSCONTEXT SQL: ACFDBUSINESSCTXT Type: view

Custom Field Business Context

A_CustomFieldBusinessContext is a CDS View that provides data about "Custom Field Business Context" in SAP S/4HANA. It reads from 2 data sources (P_CustomFieldLatestVersion, cfd_w_rep_bus) and exposes 2 fields with key fields CustomFieldID, BusinessContext.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
P_CustomFieldLatestVersion _LatestVersion inner
cfd_w_rep_bus BusinessContext from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ACFDBUSINESSCTXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Custom Field Business Context view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY CustomFieldID P_CustomFieldLatestVersion external_name
KEY BusinessContext cfd_w_rep_bus business_context 
@AbapCatalog.sqlViewName: 'ACFDBUSINESSCTXT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED // TODO: Authorization check?

@EndUserText.label: 'Custom Field Business Context'
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API

define view A_CustomFieldBusinessContext 
  as select from cfd_w_rep_bus          as BusinessContext 
  inner join P_CustomFieldLatestVersion as _LatestVersion  on  _LatestVersion.name = BusinessContext.name                                                                                                                   
 {
  key _LatestVersion.external_name     as CustomFieldID,
  key BusinessContext.business_context as BusinessContext
 } 
 where BusinessContext.version = _LatestVersion.Version
   and _LatestVersion.origin   = #CFD_FIELD_ORIGIN.' '   // consider only Custom Fields (not ABAP Managed Fields)

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

Learn More