I_BUSINESSUSERBASIC

CDS View
21 Fields 51 CDS Views

Business User Basic

I_BUSINESSUSERBASIC is a CDS View in S/4HANA. Business User Basic. It contains 21 fields. 51 CDS views read from this table.

CDS Views using this table (51)

ViewTypeJoinVDMDescription
C_ADM_BUSINESS_USER view from CONSUMPTION Workflow Administration User
C_BusinessUserEvent view_entity from Business User Event Root View
C_ChmlCmplncReqRequesterCntct view from CONSUMPTION Chemical Compliance Request Requester Contact Card
C_CollabnApplFrtOrdRespPersn view from CONSUMPTION Freight Order Responsible Person
C_CollabnApplTenderingManager view from CONSUMPTION Tendering Manager
C_EHSBizUsrWthPrsnlWrkAgrmtVH view from CONSUMPTION EHS Business User with Personal Work Agr
C_EHSBusinessUserValueHelp view from CONSUMPTION EHS Business User
C_IHBBusinessUserVH view_entity from CONSUMPTION Business User
C_PPM_TeamMemberSearchHelp view from CONSUMPTION Search help for team member
C_PPS_ContactBusinessUserVH view_entity from CONSUMPTION PPS Contact Person
C_ProdCmplncReqRequesterCntct view_entity from CONSUMPTION Requester Contact Card
C_ProjBillgReqWrkflwRcpntVH view from CONSUMPTION People picker for manage workflow
C_ProjectManagerVH view from CONSUMPTION Project Manager Value Help
C_PurCatCreaByValueHelp view inner CONSUMPTION "Created-By" User of Purchasing Category
C_PurCatLastChByValueHelp view inner CONSUMPTION Last "Changed-By" User of Purch. Cat.
C_PurCatPurchRespValueHelp view inner CONSUMPTION Purchaser Responsible for Purch. Cat.
C_PurgQnairePurrRespPersonVH view_entity from CONSUMPTION Purg Qnaire Purchaser Responsible Person
C_SrvcDocWrkflwRecipientVH view from CONSUMPTION Approval Workflow Recipient
C_SubstVolRetrackingUserVH view from CONSUMPTION Substance Volume Retracking Users
C_SubstVolRetrckChgdByUserVH view from CONSUMPTION Select Retracking Changed By User
C_SubstVolRetrckCmpltdByUserVH view from CONSUMPTION Select Retracking Completed By User
C_SubstVolRetrckDecidedByUsrVH view from CONSUMPTION Select Retracking Decided By User
I_ADM_LOGHIST view left_outer swwloghist
I_ADM_WORKFLOW view left_outer COMPOSITE Workflow work items
I_BusinessUserVH view_entity from COMPOSITE Business User - Value Help
I_ChangeManagementBusinessUser view_entity from COMPOSITE Change Mgmt Business Users
I_EHSLocationBusinessUser view from COMPOSITE EHS Business User for Location
I_EHSMyInvestigationSource view_entity inner COMPOSITE My investigations by location source
I_EHSMyInvstgnActySource view_entity inner COMPOSITE Total number invstgn activities source
I_EHSTskInstcePersnContactCard view inner COMPOSITE EHS Task Instance Person Contact Card
I_InvgCsMEmployee view inner COMPOSITE ICM Employee
I_MaintJobAndWorkItemForUser view inner COMPOSITE Current Users Maintenance Jobs and Work Items
I_OrdFlfllmntRespyAssgdUserVH view from COMPOSITE Order Fulfillment Responsibility Assigned User Value Help
I_PPM_ContactData view from COMPOSITE Contact information for project participants
I_PPS_PurContrItemUnrlzdAmt view_entity inner COMPOSITE PPS Unrealized amount for Contract item
I_SrcgProjPotentialContact view_entity union COMPOSITE Potential Contact for Sourcing Project
I_VerifyDwnPaytReqUserWrkflwVH view_entity from COMPOSITE Business User
P_CollabnApplCarrierUser view inner CONSUMPTION
P_CUSTPROJSLSORDITMBYUSER view inner COMPOSITE
P_EHSBusinesUserWithPersWrkAgr view from COMPOSITE
P_EHSMBusinessUser view from CONSUMPTION
P_EMPWORKINGHOURS_1 view inner COMPOSITE
P_EngmntProjWithStdRoles view left_outer COMPOSITE
P_EngmntProjWithUserInvlmnt view inner COMPOSITE
P_FS4_BPU_USR21 view_entity inner BASIC SDM view for USR21 Technical description
P_MyPrelimBillingDocumentItem view_entity inner COMPOSITE
P_RespyMgmtBPWithUser view from COMPOSITE
P_RespyMgmtOrgUnitBPRelshp view inner BASIC
R_SrcgProjPotntlTemplateResp view_entity from COMPOSITE Responsible for Soucing Project Template
SACMRT_ASPECT_USER_EXT view_entity left_outer ACM RT: Aspect User Extensions
WFD_PremU view left_outer Workforce Domain - Sel view for PREMU

Fields (21)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner,person_id 15
KEY BusinessPartnerUUID BusinessPartnerUUID 7
KEY UserID BusinessUser,CreatedByUser,LastChangedByUser,UserID 14
AuthorizationGroup AuthorizationGroup 11
BusinessPartnerIsBlocked BusinessPartnerIsBlocked 1
DataController1 DataController1 9
DataController10 DataController10 9
DataController2 DataController2 9
DataController3 DataController3 9
DataController4 DataController4 9
DataController5 DataController5 9
DataController6 DataController6 9
DataController7 DataController7 9
DataController8 DataController8 9
DataController9 DataController9 9
DataControllerSet DataControllerSet 10
FirstName FirstName 9
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 10
IsMarkedForArchiving IsMarkedForArchiving 1
LastName FamilyName,LastName 9
PersonFullName BusinessPartnerName,FullName,person_full_name,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 Basic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BUSINESSUSERBASIC (
    BUSINESSPARTNER,
    BUSINESSPARTNERUUID,
    USERID,
    AUTHORIZATIONGROUP,
    BUSINESSPARTNERISBLOCKED,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    FIRSTNAME,
    ISBUSINESSPURPOSECOMPLETED,
    ISMARKEDFORARCHIVING,
    LASTNAME,
    PERSONFULLNAME,
    PRIMARY KEY (BUSINESSPARTNER, BUSINESSPARTNERUUID, USERID)
);

Learn More