I_BUSINESSUSER

CDS View
22 Fields 20 CDS Views

Business User

I_BUSINESSUSER is a CDS View in S/4HANA. Business User. It contains 22 fields. 20 CDS views read from this table.

CDS Views using this table (20)

ViewTypeJoinVDMDescription
C_ChgMgmtPersonInvolvedVH view from CONSUMPTION Change Mgmt Person Involved Value Help
C_EmployeeAddress view from CONSUMPTION Employee User ID, Name and Org. Info
C_MPStatusItemDetails view left_outer CONSUMPTION Master Project Scope Area Details
C_PurReqnEmplByCoOfAuthorVH view inner CONSUMPTION Value Help of Employees by Company of Author
C_SplrActyTskCreaByValueHelp view inner CONSUMPTION "Created-By" User of Activity Task
C_SrcgProjPurchaserRespPersnVH view_entity from CONSUMPTION Purchaser Resp Person for Srcg Project
C_SuplrEvalQnaireLastChgdByVH view inner CONSUMPTION Last Changed by Value Help
C_SuplrEvalQnaireTransChgdByVH view inner CONSUMPTION Last Changed by Value Help
C_SuplrEvalRespAppraiserVH view inner CONSUMPTION Appraiser Value Help
C_SuplrEvalTemplateChangedByVH view inner CONSUMPTION Evaluation Template Last Changed By
C_SuplrEvalTmplLastChangedByVH view inner CONSUMPTION Supplier Eval. Templ. Last Changed By
C_SuplrListPurrRespPersonVH view_entity from CONSUMPTION Supplier List Purchase Responsible
C_TransPurCatLastChangedByVH view inner CONSUMPTION Last Changed by Value Help
I_EHSTaskProcessorValueHelp view from COMPOSITE EHS Task Owner User Value Help
I_SalesPlanChangeLog view left_outer COMPOSITE Sales Plan Change Log
I_SrvcEmployeeDetsByLoginUser view from COMPOSITE Displays logged on User Employee Details
I_SuplrActyTaskEmailTmplAPI01 view left_outer COMPOSITE Email Template for Task Notification
I_SuplrGEvalEmailTmplAPI02 view left_outer COMPOSITE Email Template for Eval Notification
P_SalesPlanMyTeams view left_outer COMPOSITE
S_RPLPRWORKFLOWRECIPIENTVH view inner Centrally Managed Pur Reqn User

Fields (22)

KeyField CDS FieldsUsed in Views
KEY BPIdentificationNumber Employee 1
KEY BusinessPartner BusinessPartner 9
KEY UserID CreatedByUser,UserID 12
AcademicTitle AcademicTitleName 1
AuthorizationGroup AuthorizationGroup,BPPersonAuthorizationGroup 9
CorrespondenceLanguage CorrespondenceLanguage 1
DataController1 DataController1 8
DataController10 DataController10 8
DataController2 DataController2 8
DataController3 DataController3 8
DataController4 DataController4 8
DataController5 DataController5 8
DataController6 DataController6 8
DataController7 DataController7 8
DataController8 DataController8 8
DataController9 DataController9 8
DataControllerSet DataControllerSet 8
FirstName FirstName 9
FormOfAddress FormOfAddress 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 9
LastName FamilyName,LastName 9
PersonFullName EmployeeFullName,FullName,PersonFullName 8

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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BUSINESSUSER (
    BPIDENTIFICATIONNUMBER,
    BUSINESSPARTNER,
    USERID,
    ACADEMICTITLE,
    AUTHORIZATIONGROUP,
    CORRESPONDENCELANGUAGE,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    FIRSTNAME,
    FORMOFADDRESS,
    ISBUSINESSPURPOSECOMPLETED,
    LASTNAME,
    PERSONFULLNAME,
    PRIMARY KEY (BPIDENTIFICATIONNUMBER, BUSINESSPARTNER, USERID)
);

Learn More