N_SBLE_IMPLEMENTATION

DDL: N_SBLE_IMPLEMENTATION Type: view_entity Package: S_BLE_MODEL

BLE: Implementations

N_SBLE_IMPLEMENTATION is a CDS View that provides data about "BLE: Implementations" in SAP S/4HANA. It reads from 1 data source (N_SBLE_IMPLEMENTATION_ALL) and exposes 6 fields. It has 5 associations to related views. Part of development package S_BLE_MODEL.

Data Sources (1)

SourceAliasJoin Type
N_SBLE_IMPLEMENTATION_ALL Implementation from

Associations (5)

CardinalityTargetAliasCondition
[0..1] N_SCLG_USER _CreatedBy _CreatedBy.name = Implementation.created_by
[0..1] N_SCLG_USER _LastChangedBy _LastChangedBy.name = Implementation.last_changed_by
[0..1] N_SBLE_REWORK_DEMAND _ReworkDemand _ReworkDemand.implementation_id = Implementation.implementation_id
[0..1] N_SBLE_CFDA_VISIBILITY _CFDAVisibility _CFDAVisibility.badi_name = Implementation.extension_point_id
[0..1] N_SBLE_CLG_BADI_W_CACHE _BadiCache _BadiCache.ID = Implementation.extension_point_id

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label BLE: Implementations view

Fields (6)

KeyFieldSource TableSource FieldDescription
status N_SBLE_IMPLEMENTATION_ALL status Workflow Status
transported N_SBLE_IMPLEMENTATION_ALL transported Truth Value
type
description N_SBLE_IMPLEMENTATION_ALL description Well Code Des.
created_by _CreatedBy description Well Code Des.
created_on N_SBLE_IMPLEMENTATION_ALL created_on Variant created on

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_SBLE_IMPLEMENTATION.
-- 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_SBLE_IMPLEMENTATION AS
SELECT
  Implementation.status AS status,
  Implementation.transported AS transported,
  'BLEB' AS type,
  Implementation.description AS description,
  _CreatedBy.description AS created_by,
  Implementation.created_on AS created_on
FROM N_SBLE_IMPLEMENTATION_ALL AS Implementation
LEFT OUTER JOIN N_SCLG_USER AS _CreatedBy ON _CreatedBy.name = Implementation.created_by  -- association [0..1]
LEFT OUTER JOIN N_SCLG_USER AS _LastChangedBy ON _LastChangedBy.name = Implementation.last_changed_by  -- association [0..1]
LEFT OUTER JOIN N_SBLE_REWORK_DEMAND AS _ReworkDemand ON _ReworkDemand.implementation_id = Implementation.implementation_id  -- association [0..1]
LEFT OUTER JOIN N_SBLE_CFDA_VISIBILITY AS _CFDAVisibility ON _CFDAVisibility.badi_name = Implementation.extension_point_id  -- association [0..1]
LEFT OUTER JOIN N_SBLE_CLG_BADI_W_CACHE AS _BadiCache ON _BadiCache.ID = Implementation.extension_point_id  -- association [0..1]
;