/APE/C_APIDefinition_UI

DDL: /APE/C_APIDEFINITION_UI Type: view CONSUMPTION
30 Fields 1 Data Sources 6 Associations

Application Programming Interface Define

/APE/C_APIDefinition_UI is a Consumption CDS View that provides data about "Application Programming Interface Define" in SAP S/4HANA. It reads from 1 data source (/APE/I_APIDefinition_TP) and exposes 30 fields with key field APIDefKey. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
/APE/I_APIDefinition_TP /APE/I_APIDefinition_TP from

Associations (6)

CardinalityTargetAliasCondition
[0..1] /APE/C_ProcessCluster_VH _ProcessClusterVH _ProcessClusterVH.ProcessClusterKey = $projection.ProcessClusterKey
[0..1] /APE/C_APIID_VH _APIIDVH _APIIDVH.APIIDKey = $projection.ApiIdKey
[0..1] /APE/C_Version_VH _VersionVH _VersionVH.VersionKey = $projection.VersionKey
[0..1] /APE/C_MarketRole_VH _MarketRole _MarketRole.MarketRole = $projection.MarketRole
[0..1] /APE/C_ConfigLayer_VH _ConfigurationLayer _ConfigurationLayer.Value = $projection.ConfigurationLayer
[0..1] /APE/C_DeploymentTarget_VH _DeploymentTarget _DeploymentTarget.Value = $projection.DeploymentTarget

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName /APE/C_APIDEFUI view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Application Programming Interface Define view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.draftEnabled true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY APIDefKey config_key Char
ApiIdKey api_id_uuid
APIID api_id GUID
APIIDLI api_id GUID
APIDIDSubTitle _APIIDVH APIID
APIIDDescription _APIIDVH APIIDDescription
HeadTitle _APIIDVH APIIDDescription
HeadDescription api_id GUID
APIIDDescriptionISL _APIIDVH APIIDDescriptionISL
ProcessClusterKey proc_cluster_uuid
ProcessCluster proc_cluster
FCReadOnly 3
ProcessClusterLi _ProcessClusterVH ProcessCluster
ProcessClusterDescription _ProcessClusterVH ProcessClusterDescription
VersionKey version_uuid
Version version XML Vers.
VersionDescription _VersionVH VersionDescription
DescriptionInLoginLanguage _VersionVH DescriptionInLoginLanguage
VersionLi _VersionVH Version XML Vers.
ServiceDestination service_dest
DeploymentTarget deploy_target
DeploymentTargetDescription _DeploymentTarget Description Well Code Des.
ConfigurationLayer config_layer
ConfigurationLayerDescription _ConfigurationLayer Description Well Code Des.
MarketRole market_role
MarketRoleDescription _MarketRole MarketRoleDescription
_ProcessClusterVH _ProcessClusterVH
_APIIDVH _APIIDVH
_VersionVH _VersionVH
proc_cluster proc_cluster

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 /APE/C_APIDefinition_UI.
-- 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.

CREATE VIEW /APE/C_APIDefinition_UI AS
SELECT
  config_key AS APIDefKey,
  api_id_uuid AS ApiIdKey,
  api_id AS APIID,
  api_id AS APIIDLI,
  _APIIDVH.APIID AS APIDIDSubTitle,
  _APIIDVH.APIIDDescription AS APIIDDescription,
  _APIIDVH.APIIDDescription AS HeadTitle,
  api_id AS HeadDescription,
  _APIIDVH.APIIDDescriptionISL AS APIIDDescriptionISL,
  proc_cluster_uuid AS ProcessClusterKey,
  proc_cluster AS ProcessCluster,
  3 AS FCReadOnly,
  _ProcessClusterVH.ProcessCluster AS ProcessClusterLi,
  _ProcessClusterVH.ProcessClusterDescription AS ProcessClusterDescription,
  version_uuid AS VersionKey,
  Version,
  _VersionVH.VersionDescription AS VersionDescription,
  _VersionVH.DescriptionInLoginLanguage AS DescriptionInLoginLanguage,
  _VersionVH.Version AS VersionLi,
  service_dest AS ServiceDestination,
  deploy_target AS DeploymentTarget,
  _DeploymentTarget.Description AS DeploymentTargetDescription,
  config_layer AS ConfigurationLayer,
  _ConfigurationLayer.Description AS ConfigurationLayerDescription,
  market_role AS MarketRole,
  _MarketRole.MarketRoleDescription AS MarketRoleDescription,
  proc_cluster
FROM /APE/I_APIDefinition_TP
LEFT OUTER JOIN /APE/C_ProcessCluster_VH AS _ProcessClusterVH ON _ProcessClusterVH.ProcessClusterKey = ProcessClusterKey  -- association [0..1]
LEFT OUTER JOIN /APE/C_APIID_VH AS _APIIDVH ON _APIIDVH.APIIDKey = ApiIdKey  -- association [0..1]
LEFT OUTER JOIN /APE/C_Version_VH AS _VersionVH ON _VersionVH.VersionKey = VersionKey  -- association [0..1]
LEFT OUTER JOIN /APE/C_MarketRole_VH AS _MarketRole ON _MarketRole.MarketRole = MarketRole  -- association [0..1]
LEFT OUTER JOIN /APE/C_ConfigLayer_VH AS _ConfigurationLayer ON _ConfigurationLayer.Value = ConfigurationLayer  -- association [0..1]
LEFT OUTER JOIN /APE/C_DeploymentTarget_VH AS _DeploymentTarget ON _DeploymentTarget.Value = DeploymentTarget  -- association [0..1]
;

Learn More