SHSM_FIN_USERID

DDL: SHSM_FIN_USERID SQL: SHSMFINUSERID Type: view
15 Fields 1 Data Sources

Value-Help for Business Users

SHSM_FIN_USERID is a CDS View that provides data about "Value-Help for Business Users" in SAP S/4HANA. It reads from 1 data source (I_BusinessUserVH) and exposes 15 fields with key field USNAM.

Data Sources (1)

SourceAliasJoin Type
I_BusinessUserVH I_BusinessUserVH from

Annotations (12)

NameValueLevelField
EndUserText.label Value-Help for Business Users view
AbapCatalog.sqlViewName SHSMFINUSERID view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY USNAM UserID User Name
Fullname PersonFullName Full Name
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
AuthorizationGroup AuthorizationGroup AuthorizGroup
DataControllerSet I_BusinessUserVH DataControllerSet Data Ctrlr. Set
DataController1 I_BusinessUserVH DataController1 Data Controller
DataController2 I_BusinessUserVH DataController2 Data Controller
DataController3 I_BusinessUserVH DataController3 Data Controller
DataController4 I_BusinessUserVH DataController4 Data Controller
DataController5 I_BusinessUserVH DataController5 Data Controller
DataController6 I_BusinessUserVH DataController6 Data Controller
DataController7 I_BusinessUserVH DataController7 Data Controller
DataController8 I_BusinessUserVH DataController8 Data Controller
DataController9 I_BusinessUserVH DataController9 Data Controller
DataController10 I_BusinessUserVH DataController10 Data Controller

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 SHSM_FIN_USERID.
-- 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: SHSMFINUSERID

CREATE VIEW SHSM_FIN_USERID AS
SELECT
  UserID AS USNAM,
  PersonFullName AS Fullname,
  IsBusinessPurposeCompleted,
  AuthorizationGroup,
  I_BusinessUserVH.DataControllerSet AS DataControllerSet,
  I_BusinessUserVH.DataController1 AS DataController1,
  I_BusinessUserVH.DataController2 AS DataController2,
  I_BusinessUserVH.DataController3 AS DataController3,
  I_BusinessUserVH.DataController4 AS DataController4,
  I_BusinessUserVH.DataController5 AS DataController5,
  I_BusinessUserVH.DataController6 AS DataController6,
  I_BusinessUserVH.DataController7 AS DataController7,
  I_BusinessUserVH.DataController8 AS DataController8,
  I_BusinessUserVH.DataController9 AS DataController9,
  I_BusinessUserVH.DataController10 AS DataController10
FROM I_BusinessUserVH
;

Learn More