SCIBEHV_E_USER

DDL: SCIBEHV_E_USER SQL: SCIBEHV_V_USER Type: view
7 Fields 1 Data Sources 2 Associations

Test object for CL_CI_TEST_BEHV_1IMPL unit tests

SCIBEHV_E_USER is a CDS View that provides data about "Test object for CL_CI_TEST_BEHV_1IMPL unit tests" in SAP S/4HANA. It reads from 1 data source (scibehv_t_user) and exposes 7 fields with key field name. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
scibehv_t_user scibehv_t_user from

Associations (2)

CardinalityTargetAliasCondition
[0..1] SCIBEHV_E_DBDEV _UsrDev $projection.pers_dev = _UsrDev.devClass
[0..1] SCIBEHV_E_DBTAB _UsrTab $projection.pers_tab = _UsrTab.tabname

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SCIBEHV_V_USER view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Test object for CL_CI_TEST_BEHV_1IMPL unit tests view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY name name Zone name
name_first name_first First Name
name_last name_last Last Name
pers_dev pers_dev Package
pers_tab pers_tab Table Name
_UsrDev _UsrDev
_UsrTab _UsrTab

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 SCIBEHV_E_USER.
-- 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.
-- SQL view name: SCIBEHV_V_USER

CREATE VIEW SCIBEHV_E_USER AS
SELECT
  name,
  name_first,
  name_last,
  pers_dev,
  pers_tab
FROM scibehv_t_user
LEFT OUTER JOIN SCIBEHV_E_DBDEV AS _UsrDev ON pers_dev = _UsrDev.devClass  -- association [0..1]
LEFT OUTER JOIN SCIBEHV_E_DBTAB AS _UsrTab ON pers_tab = _UsrTab.tabname  -- association [0..1]
;

Learn More