I_DraftAdminUserBackup_CC

DDL: I_DRAFTADMINUSERBACKUP_CC Type: view_entity
5 Fields 2 Data Sources

Draft Admin User Backup Data

I_DraftAdminUserBackup_CC is a CDS View that provides data about "Draft Admin User Backup Data" in SAP S/4HANA. It reads from 2 data sources (sdraft_user_h_cc, sdraft_user_b_cc) and exposes 5 fields with key fields DraftUUID, DraftEntityType, UserID.

Data Sources (2)

SourceAliasJoin Type
sdraft_user_h_cc Header inner
sdraft_user_b_cc User from

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Draft Admin User Backup Data view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY DraftUUID sdraft_user_h_cc draft_key UUID
KEY DraftEntityType sdraft_user_h_cc draft_entity Entity Name
KEY UserID sdraft_user_b_cc user_name User Name
ActiveKey sdraft_user_h_cc active_key Active Key
UserAccessRole sdraft_user_b_cc user_role Draft User Role

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 I_DraftAdminUserBackup_CC.
-- 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 I_DraftAdminUserBackup_CC AS
SELECT
  Header.draft_key AS DraftUUID,
  Header.draft_entity AS DraftEntityType,
  User.user_name AS UserID,
  Header.active_key AS ActiveKey,
  User.user_role AS UserAccessRole
FROM sdraft_user_b_cc AS User
INNER JOIN sdraft_user_h_cc AS Header ON /* join condition not captured in parsed metadata */
;

Learn More