/APE/C_APIIDTP_C

DDL: /APE/C_APIIDTP_C Type: view_entity CONSUMPTION

Application Programming Interface ID

/APE/C_APIIDTP_C is a Consumption CDS View that provides data about "Application Programming Interface ID" in SAP S/4HANA. It reads from 1 data source (/APE/I_APIIDTP_C) and exposes 11 fields with key field APIIDKey.

Data Sources (1)

SourceAliasJoin Type
/APE/I_APIIDTP_C /APE/I_APIIDTP_C projection

Annotations (8)

NameValueLevelField
EndUserText.label Application Programming Interface ID view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
Search.searchable true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #CONSUMPTION view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY APIIDKey config_key Char
APIID api_id GUID
descriptionasAPIIDTextlocalized
MarketRole market_role
descriptionasMarketRoleTextlocalized
ConfigurationLayer config_layer
TextasConfigurationLayerTextlocalized
DeploymentTarget deploy_target
TextasDeploymentTargetTextlocalized
ChangedAt changed_at Timestamp
_WhereUsed _WhereUsed

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_APIIDTP_C.
-- 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_APIIDTP_C AS
SELECT
  config_key AS APIIDKey,
  api_id AS APIID,
  _APIIDText.description as APIIDText : localized AS descriptionasAPIIDTextlocalized,
  market_role AS MarketRole,
  _MarketRoleText.description as MarketRoleText : localized AS descriptionasMarketRoleTextlocalized,
  config_layer AS ConfigurationLayer,
  _ConfigurationLayerText.Text as ConfigurationLayerText : localized AS TextasConfigurationLayerTextlocalized,
  deploy_target AS DeploymentTarget,
  _DeploymentTargetText.Text as DeploymentTargetText : localized AS TextasDeploymentTargetTextlocalized,
  changed_at AS ChangedAt
FROM /APE/I_APIIDTP_C
;