P_CFD_REGISTRY_ABS_ENTITY_SO

DDL: P_CFD_REGISTRY_ABS_ENTITY_SO Type: view_entity

Custom Fields: Available Abstract Entity Usage

P_CFD_REGISTRY_ABS_ENTITY_SO is a CDS View that provides data about "Custom Fields: Available Abstract Entity Usage" in SAP S/4HANA. It reads from 2 data sources (cfd_w_abs_ctxt, cfd_w_abs_sv_op) and exposes 10 fields with key fields AbstractEntityName, BusinessContext, ServiceName, ServiceVersion, EntityAlias.

Data Sources (2)

SourceAliasJoin Type
cfd_w_abs_ctxt Context inner
cfd_w_abs_sv_op Operation inner

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_ALLOWED view
VDM.private true view
EndUserText.label Custom Fields: Available Abstract Entity Usage view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY AbstractEntityName Entity abstract_entity_name Abstract Entity Name
KEY BusinessContext cfd_w_abs_ctxt business_context Business Context
KEY ServiceName cfd_w_abs_sv_op service_name Service Name
KEY ServiceVersion cfd_w_abs_sv_op service_version Version
KEY EntityAlias cfd_w_abs_sv_op entity_alias Entity Alias
KEY Operation cfd_w_abs_sv_op operation Transaction
ParameterKind cfd_w_abs_sv_op parameter_kind
IsInvisible Entity usage_invisible Is Invisible
Availability Entity availability Pkg. Release Status
ReleaseStatus cfd_w_abs_ctxt release_status Status

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 P_CFD_REGISTRY_ABS_ENTITY_SO.
-- 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 P_CFD_REGISTRY_ABS_ENTITY_SO AS
SELECT
  Entity.abstract_entity_name AS AbstractEntityName,
  Context.business_context AS BusinessContext,
  Operation.service_name AS ServiceName,
  Operation.service_version AS ServiceVersion,
  Operation.entity_alias AS EntityAlias,
  Operation.operation AS Operation,
  Operation.parameter_kind AS ParameterKind,
  Entity.usage_invisible AS IsInvisible,
  Entity.availability AS Availability,
  Context.release_status AS ReleaseStatus
INNER JOIN cfd_w_abs_ctxt AS Context ON /* join condition not captured in parsed metadata */
INNER JOIN cfd_w_abs_sv_op AS Operation ON /* join condition not captured in parsed metadata */
;