I_Aps_Com_Comm_Api_Key

DDL: I_APS_COM_COMM_API_KEY SQL: APS_COM_API_KEY Type: view Package: SR_APS_COM_CSCN
13 Fields 3 Data Sources

Settings for API Keys

I_Aps_Com_Comm_Api_Key is a CDS View that provides data about "Settings for API Keys" in SAP S/4HANA. It reads from 3 data sources (I_Aps_Com_Data_Element_Text, I_APS_COM_STRUCTURE_TEXT, APS_COM_CSCN_API_ROOT_PROPERTY) and exposes 13 fields with key fields CommunicationScenarioID, InterfaceKeyID. Part of development package SR_APS_COM_CSCN.

Data Sources (3)

SourceAliasJoin Type
I_Aps_Com_Data_Element_Text _DataElementText left_outer
I_APS_COM_STRUCTURE_TEXT _StructureText left_outer
APS_COM_CSCN_API_ROOT_PROPERTY APS_COM_CSCN_API_ROOT_PROPERTY from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName APS_COM_API_KEY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Settings for API Keys view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CommunicationScenarioID communicationscenarioid
KEY InterfaceKeyID interfacekeyid
InterfaceKeyName interfacekeyname
InterfaceKeyDataElement interfacekeydataelement Data Element
InterfaceKeyStructure interfacekeystructure
InterfaceKeyValue interfacekeyvalue
ShortDescriptionendasInterfaceKeyLabel
DataElementLength I_Aps_Com_Data_Element_Text DataElementLength
IsCaseSensitive I_Aps_Com_Data_Element_Text IsCaseSensitive Link
IsSecure issecure
IsHidden ishidden
IsMultiple ismultiple
SupportsSearchHelp supportssearchhelp

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 I_Aps_Com_Comm_Api_Key.
-- 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: APS_COM_API_KEY

CREATE VIEW I_Aps_Com_Comm_Api_Key AS
SELECT
  CommunicationScenarioID,
  InterfaceKeyID,
  InterfaceKeyName,
  InterfaceKeyDataElement,
  InterfaceKeyStructure,
  InterfaceKeyValue,
  case when interfacekeystructure != '' then _StructureText.Description when _DataElementText.LongDescription != '' then _DataElementText.LongDescription when _DataElementText.MediumDescription != '' then _DataElementText.MediumDescription else _DataElementText.ShortDescription end as InterfaceKeyLabel AS ShortDescriptionendasInterfaceKeyLabel,
  _DataElementText.DataElementLength AS DataElementLength,
  _DataElementText.IsCaseSensitive AS IsCaseSensitive,
  IsSecure,
  IsHidden,
  IsMultiple,
  SupportsSearchHelp
FROM APS_COM_CSCN_API_ROOT_PROPERTY
LEFT OUTER JOIN I_Aps_Com_Data_Element_Text AS _DataElementText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_APS_COM_STRUCTURE_TEXT AS _StructureText ON /* join condition not captured in parsed metadata */
;

Learn More