I_BUSINESSUSERVH

CDS View

Business User - Value Help

I_BUSINESSUSERVH is a CDS View in S/4HANA. Business User - Value Help. It contains 23 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
/SSB/CORE_USERS view from Fetches list of all users in the system
apj_v_job_user view from Apllication Jobs User
ATOV_BUSINESS_USER view from ATO: Business User
ATOV_BUSINESS_USER_BASE view from ATO: Basic View for Business User
ATOV_BUSINESS_USER_BASE view union ATO: Basic View for Business User
C_BankAccountReviewerVH view_entity from CONSUMPTION Bank Account Reviewer
C_RespyMgmtNonBlkdBPWithUserVH view from CONSUMPTION Select Business Partner
FCLM_BAM_BUSINESSUSER view_entity from Cash Business User
I_RespyMPotntlTeamOwnerStdVH view inner COMPOSITE Potential Team Owner value help
SHSM_FIN_USERID view from Value-Help for Business Users

Fields (23)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner 5
KEY UserID UserID 4
AuthorizationGroup AuthorizationGroup 4
BPIdentificationNumber BPIdentificationNumber 2
Building Building,WorkplaceBuilding 2
DataController1 DataController1 4
DataController10 DataController10 4
DataController2 DataController2 4
DataController3 DataController3 4
DataController4 DataController4 4
DataController5 DataController5 4
DataController6 DataController6 4
DataController7 DataController7 4
DataController8 DataController8 4
DataController9 DataController9 4
DataControllerSet DataControllerSet 4
DefaultEmailAddress DefaultEmailAddress 4
Department Department 2
FirstName FirstName 5
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 4
LastName LastName 5
PersonFullName FullName,PersonFullName 5
RoomNumber RoomNumber 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Business User - Value Help
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BUSINESSUSERVH (
    BUSINESSPARTNER,
    USERID,
    AUTHORIZATIONGROUP,
    BPIDENTIFICATIONNUMBER,
    BUILDING,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    DEFAULTEMAILADDRESS,
    DEPARTMENT,
    FIRSTNAME,
    ISBUSINESSPURPOSECOMPLETED,
    LASTNAME,
    PERSONFULLNAME,
    ROOMNUMBER,
    PRIMARY KEY (BUSINESSPARTNER, USERID)
);