N_SCBE_CLG_BDEF_W_CACHE

DDL: N_SCBE_CLG_BDEF_W_CACHE Type: view_entity
9 Fields 1 Data Sources

CBE CLG: BDEF

N_SCBE_CLG_BDEF_W_CACHE is a CDS View that provides data about "CBE CLG: BDEF" in SAP S/4HANA. It reads from 1 data source (cfd_w_bdef) and exposes 9 fields with key field ID.

Data Sources (1)

SourceAliasJoin Type
cfd_w_bdef bdef from

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CBE CLG: BDEF view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ID cfd_w_bdef id WorklistID
Type
Availability cfd_w_bdef availability Pkg. Release Status
ReleaseStatus cfd_w_bdef release_status Status
Description bdefCache description Well Code Des.
Documentation bdefCache documentation Documentation
SAPObjectNodeType bdefCache sap_object_node_type SONT Name
UpperDescription bdefCache upper_description
UpperDocumentation bdefCache upper_documentation

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 N_SCBE_CLG_BDEF_W_CACHE.
-- 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 N_SCBE_CLG_BDEF_W_CACHE AS
SELECT
  bdef.id AS ID,
  'SCBE' AS Type,
  bdef.availability AS Availability,
  bdef.release_status AS ReleaseStatus,
  bdefCache.description AS Description,
  bdefCache.documentation AS Documentation,
  bdefCache.sap_object_node_type AS SAPObjectNodeType,
  bdefCache.upper_description AS UpperDescription,
  bdefCache.upper_documentation AS UpperDocumentation
FROM cfd_w_bdef AS bdef
;

Learn More