I_BUSINESSUSERVH
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /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)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA