A_CustomFieldODataUsage

DDL: A_CUSTOMFIELDODATAUSAGE SQL: ACFDODATAUSAGE Type: view
4 Fields 2 Data Sources

Custom Field OData Usage

A_CustomFieldODataUsage is a CDS View that provides data about "Custom Field OData Usage" in SAP S/4HANA. It reads from 2 data sources (P_CustomFieldLatestVersion, P_CUSTOMFIELDODATAUSAGE) and exposes 4 fields with key fields CustomFieldID, BusinessContext, ODataServiceKey.

Data Sources (2)

SourceAliasJoin Type
P_CustomFieldLatestVersion _LatestVersion inner
P_CUSTOMFIELDODATAUSAGE ODataUsage from

Annotations (5)

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

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CustomFieldID P_CUSTOMFIELDODATAUSAGE CustomFieldID External Name
KEY BusinessContext P_CUSTOMFIELDODATAUSAGE BusinessContext
KEY ODataServiceKey P_CUSTOMFIELDODATAUSAGE ODataServiceKey
IsSearchRelevant P_CUSTOMFIELDODATAUSAGE IsSearchRelevant

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_CustomFieldODataUsage.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ACFDODATAUSAGE

CREATE VIEW A_CustomFieldODataUsage AS
SELECT
  ODataUsage.CustomFieldID AS CustomFieldID,
  ODataUsage.BusinessContext AS BusinessContext,
  ODataUsage.ODataServiceKey AS ODataServiceKey,
  ODataUsage.IsSearchRelevant AS IsSearchRelevant
FROM P_CUSTOMFIELDODATAUSAGE AS ODataUsage
INNER JOIN P_CustomFieldLatestVersion AS _LatestVersion ON /* join condition not captured in parsed metadata */
;

Learn More