ATOV_BUSINESS_USER_BASE

DDL: ATOV_BUSINESS_USER_BASE SQL: ATOV_BUS_USERB Type: view
13 Fields 6 Data Sources

ATO: Basic View for Business User

ATOV_BUSINESS_USER_BASE is a CDS View that provides data about "ATO: Basic View for Business User" in SAP S/4HANA. It reads from 6 data sources and exposes 13 fields with key fields dev_prefix, UserID, UserID.

Data Sources (6)

SourceAliasJoin Type
I_BusinessUserVH business_user_base from
I_BusinessUserVH own_user_base union
ato_prefix_set prefix_setting inner
ato_prefix_set prefix_setting inner
usrefus useralias inner
usrefus useralias inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATOV_BUS_USERB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label ATO: Basic View for Business User view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY dev_prefix ato_prefix_set dev_prefix Namespace
KEY UserID I_BusinessUserVH UserID User Name
BusinessPartner I_BusinessUserVH BusinessPartner Issuing Authority
LastName I_BusinessUserVH LastName Last Name
FirstName I_BusinessUserVH FirstName First Name
PersonFullName I_BusinessUserVH PersonFullName Full Name
dev_prefix Namespace
KEY UserID I_BusinessUserVH UserID User Name
BusinessPartner I_BusinessUserVH BusinessPartner Issuing Authority
LastName I_BusinessUserVH LastName Last Name
FirstName I_BusinessUserVH FirstName First Name
PersonFullName I_BusinessUserVH PersonFullName Full Name
useralias usrefus useralias Alias

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 ATOV_BUSINESS_USER_BASE.
-- 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: ATOV_BUS_USERB

CREATE VIEW ATOV_BUSINESS_USER_BASE AS
SELECT
  prefix_setting.dev_prefix AS dev_prefix,
  business_user_base.UserID AS UserID,
  business_user_base.BusinessPartner AS BusinessPartner,
  business_user_base.LastName AS LastName,
  business_user_base.FirstName AS FirstName,
  business_user_base.PersonFullName AS PersonFullName,
  useralias.useralias AS useralias
FROM I_BusinessUserVH AS business_user_base
INNER JOIN usrefus AS useralias ON /* join condition not captured in parsed metadata */
INNER JOIN ato_prefix_set AS prefix_setting ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_BusinessUserVH
;

Learn More