I_DraftAdministrativeUserVH

DDL: I_DRAFTADMINISTRATIVEUSERVH Type: view_entity Package: SBOI_RAP_SERVICES_DSP_ADMIN
3 Fields 1 Data Sources 113 OData Services

Draft User

I_DraftAdministrativeUserVH is a CDS View that provides data about "Draft User" in SAP S/4HANA. It reads from 1 data source (I_User) and exposes 3 fields with key field UserID. It is exposed through 113 OData services (ASQL_F0702A, ASQL_F0717, ASQL_F0731B, ...). Part of development package SBOI_RAP_SERVICES_DSP_ADMIN.

Data Sources (1)

SourceAliasJoin Type
I_User _UserDescription inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Draft User view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view

OData Services (113)

ServiceBindingVersionContractRelease
ASQL_F0702A ASQL_F0702A C2 NOT_RELEASED
ASQL_F0717 ASQL_F0717 C2 NOT_RELEASED
ASQL_F0731B ASQL_F0731B C2 NOT_RELEASED
ASQL_F0859 ASQL_F0859 C2 NOT_RELEASED
ASQL_F1688 ASQL_F1688 C2 NOT_RELEASED
ASQL_F2158 ASQL_F2158 C2 NOT_RELEASED
ASQL_F2526 ASQL_F2526 C2 NOT_RELEASED
ASQL_F2602 ASQL_F2602 C2 NOT_RELEASED
ASQL_F2698 ASQL_F2698 C2 NOT_RELEASED
ASQL_F3091 ASQL_F3091 C2 NOT_RELEASED
ASQL_F3215 ASQL_F3215 C2 NOT_RELEASED
ASQL_F3233 ASQL_F3233 C2 NOT_RELEASED
ASQL_F3266A ASQL_F3266A C2 NOT_RELEASED
ASQL_F3338A ASQL_F3338A C2 NOT_RELEASED
ASQL_F3616 ASQL_F3616 C2 NOT_RELEASED
ASQL_F3799 ASQL_F3799 C2 NOT_RELEASED
ASQL_F3812 ASQL_F3812 C2 NOT_RELEASED
ASQL_F3822 ASQL_F3822 C2 NOT_RELEASED
ASQL_F3829 ASQL_F3829 C2 NOT_RELEASED
ASQL_F3881 ASQL_F3881 C2 NOT_RELEASED
ASQL_F3883 ASQL_F3883 C2 NOT_RELEASED
ASQL_F3883A ASQL_F3883A C2 NOT_RELEASED
ASQL_F4051 ASQL_F4051 C2 NOT_RELEASED
ASQL_F4072 ASQL_F4072 C2 NOT_RELEASED
ASQL_F4271 ASQL_F4271 C2 NOT_RELEASED
ASQL_F4346 ASQL_F4346 C2 NOT_RELEASED
ASQL_F4408 ASQL_F4408 C2 NOT_RELEASED
ASQL_F4443 ASQL_F4443 C2 NOT_RELEASED
ASQL_F4449 ASQL_F4449 C2 NOT_RELEASED
ASQL_F4513 ASQL_F4513 C2 NOT_RELEASED
ASQL_F4521 ASQL_F4521 C2 NOT_RELEASED
ASQL_F4523 ASQL_F4523 C2 NOT_RELEASED
ASQL_F4567 ASQL_F4567 C2 NOT_RELEASED
ASQL_F4568 ASQL_F4568 C2 NOT_RELEASED
ASQL_F4569 ASQL_F4569 C2 NOT_RELEASED
ASQL_F4657 ASQL_F4657 C2 NOT_RELEASED
ASQL_F4692 ASQL_F4692 C2 NOT_RELEASED
ASQL_F4707 ASQL_F4707 C2 NOT_RELEASED
ASQL_F4708 ASQL_F4708 C2 NOT_RELEASED
ASQL_F4709 ASQL_F4709 C2 NOT_RELEASED
ASQL_F4710 ASQL_F4710 C2 NOT_RELEASED
ASQL_F4736 ASQL_F4736 C2 NOT_RELEASED
ASQL_F4820 ASQL_F4820 C2 NOT_RELEASED
ASQL_F4857 ASQL_F4857 C2 NOT_RELEASED
ASQL_F4907 ASQL_F4907 C2 NOT_RELEASED
ASQL_F5079 ASQL_F5079 C2 NOT_RELEASED
ASQL_F5227 ASQL_F5227 C2 NOT_RELEASED
ASQL_F5261 ASQL_F5261 C2 NOT_RELEASED
ASQL_F5302 ASQL_F5302 C2 NOT_RELEASED
ASQL_F5303 ASQL_F5303 C2 NOT_RELEASED
ASQL_F5354 ASQL_F5354 C2 NOT_RELEASED
ASQL_F5372 ASQL_F5372 C2 NOT_RELEASED
ASQL_F5375 ASQL_F5375 C2 NOT_RELEASED
ASQL_F5380 ASQL_F5380 C2 NOT_RELEASED
ASQL_F5410 ASQL_F5410 C2 NOT_RELEASED
ASQL_F5430 ASQL_F5430 C2 NOT_RELEASED
ASQL_F5448 ASQL_F5448 C2 NOT_RELEASED
ASQL_F5467 ASQL_F5467 C2 NOT_RELEASED
ASQL_F5470 ASQL_F5470 C2 NOT_RELEASED
ASQL_F5512 ASQL_F5512 C2 NOT_RELEASED
ASQL_F5549 ASQL_F5549 C2 NOT_RELEASED
ASQL_F5601 ASQL_F5601 C2 NOT_RELEASED
ASQL_F5742 ASQL_F5742 C2 NOT_RELEASED
ASQL_F5753 ASQL_F5753 C2 NOT_RELEASED
ASQL_F5755 ASQL_F5755 C2 NOT_RELEASED
ASQL_F5785 ASQL_F5785 C2 NOT_RELEASED
ASQL_F5798 ASQL_F5798 C2 NOT_RELEASED
ASQL_F5859 ASQL_F5859 C2 NOT_RELEASED
ASQL_F5861 ASQL_F5861 C2 NOT_RELEASED
ASQL_F5940 ASQL_F5940 C2 NOT_RELEASED
ASQL_F5941 ASQL_F5941 C2 NOT_RELEASED
ASQL_F5942 ASQL_F5942 C2 NOT_RELEASED
ASQL_F5955 ASQL_F5955 C2 NOT_RELEASED
ASQL_F5999 ASQL_F5999 C2 NOT_RELEASED
ASQL_F6038 ASQL_F6038 C2 NOT_RELEASED
ASQL_F6039 ASQL_F6039 C2 NOT_RELEASED
ASQL_F6040 ASQL_F6040 C2 NOT_RELEASED
ASQL_F6073 ASQL_F6073 C2 NOT_RELEASED
ASQL_F6120 ASQL_F6120 C2 NOT_RELEASED
ASQL_F6122 ASQL_F6122 C2 NOT_RELEASED
ASQL_F6204 ASQL_F6204 C2 NOT_RELEASED
ASQL_F6205 ASQL_F6205 C2 NOT_RELEASED
ASQL_F6335 ASQL_F6335 C2 NOT_RELEASED
ASQL_F6342 ASQL_F6342 C2 NOT_RELEASED
ASQL_F6374 ASQL_F6374 C2 NOT_RELEASED
ASQL_F6400 ASQL_F6400 C2 NOT_RELEASED
ASQL_F6488 ASQL_F6488 C2 NOT_RELEASED
ASQL_F6489 ASQL_F6489 C2 NOT_RELEASED
ASQL_F6575 ASQL_F6575 C2 NOT_RELEASED
ASQL_F6616 ASQL_F6616 C2 NOT_RELEASED
ASQL_F6621 ASQL_F6621 C2 NOT_RELEASED
ASQL_F6652 ASQL_F6652 C2 NOT_RELEASED
ASQL_F6749 ASQL_F6749 C2 NOT_RELEASED
ASQL_F6750 ASQL_F6750 C2 NOT_RELEASED
ASQL_F6751 ASQL_F6751 C2 NOT_RELEASED
ASQL_F6848 ASQL_F6848 C2 NOT_RELEASED
ASQL_F6852 ASQL_F6852 C2 NOT_RELEASED
ASQL_F7081 ASQL_F7081 C2 NOT_RELEASED
ASQL_F7107 ASQL_F7107 C2 NOT_RELEASED
ASQL_F7204A ASQL_F7204A C2 NOT_RELEASED
ASQL_F7334 ASQL_F7334 C2 NOT_RELEASED
ASQL_F7337 ASQL_F7337 C2 NOT_RELEASED
ASQL_F7370 ASQL_F7370 C2 NOT_RELEASED
ASQL_F7411 ASQL_F7411 C2 NOT_RELEASED
ASQL_F7414 ASQL_F7414 C2 NOT_RELEASED
ASQL_F7448 ASQL_F7448 C2 NOT_RELEASED
ASQL_F7510 ASQL_F7510 C2 NOT_RELEASED
ASQL_F7775 ASQL_F7775 C2 NOT_RELEASED
ASQL_F7900 ASQL_F7900 C2 NOT_RELEASED
ASQL_F8417 ASQL_F8417 C2 NOT_RELEASED
UI_MANAGEREVENUECONTRACTS_V4 UI_MANAGEREVENUECONTRACTS_V4 V4 C1 NOT_RELEASED
UI_MANUALSPREADING UI_MANUALSPREADING V4 C1 NOT_RELEASED
UI_PRICEALLOCATION UI_PRICEALLOCATION V4 C1 NOT_RELEASED

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY UserID UserAttr bname User name
UserGroup UserAttr attr_id User Attribute
UserDescription I_User UserDescription Full Name

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_DraftAdministrativeUserVH.
-- 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_DraftAdministrativeUserVH AS
SELECT
  UserAttr.bname AS UserID,
  UserAttr.attr_id AS UserGroup,
  _UserDescription.UserDescription AS UserDescription
INNER JOIN I_User AS _UserDescription ON /* join condition not captured in parsed metadata */
;

Learn More