I_BUSINESSUSERBASIC

CDS View
21 Fields 45 CDS Views

Business User Basic

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

CDS Views using this table (45)

ViewTypeJoinVDMDescription
/DCO/I_BusinessUserVH view_entity from COMPOSITE Business User
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_EHSBizUsrWthPrsnlWrkAgrmtVH view from CONSUMPTION EHS Business User with Personal Work Agr
C_EHSBusinessUserValueHelp view from CONSUMPTION EHS Business User
C_EHSInspectionInspectorVH view_entity from CONSUMPTION EHS Inspection Inspector
C_IHBBusinessUserVH view_entity from CONSUMPTION Business User
C_PPM_TeamMemberSearchHelp view from CONSUMPTION Search help for team member
C_ProdCmplncReqRequesterCntct view_entity from CONSUMPTION Requester Contact Card
C_ProjBillgReqWrkflwRcpntVH view_entity 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_SrvcDocWrkflwRecipientVH view_entity from CONSUMPTION Approval Workflow Recipient
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_CentralInvoiceUserEmailAddr view from COMPOSITE Email address per user
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_MaintJobAndWorkItemForUser view_entity 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_TimeSheetHoursByUser view_entity from COMPOSITE Timesheet hours by user
I_TimeSheetMissingHoursByUser view_entity from COMPOSITE Timesheet missing hours by user
I_VerifyDwnPaytReqUserWrkflwVH view_entity from COMPOSITE Business User
I_WorkAssignmentByManager view_entity from COMPOSITE Work assignments under a manager
I_WorkforceAvailabilityByUser view_entity from COMPOSITE Workforce availability for user
P_CUSTPROJSLSORDITMBYUSER view_entity inner COMPOSITE Customer Projects for sales order items by user
P_EHSBusinesUserWithPersWrkAgr view from COMPOSITE Determin party IDs for my user
P_EHSMBusinessUser view from CONSUMPTION EHS releated Business User data
P_EMPWORKINGHOURS_1 view inner COMPOSITE Employee working hours
P_EngmntProjWithStdRoles view left_outer COMPOSITE Engagement Project Roles With Standard Roles
P_EngmntProjWithUserInvlmnt view inner COMPOSITE Engagement Project with User Involvement
P_FS4_BPU_USR21 view_entity inner BASIC SDM view for USR21 Technical description
P_MyPrelimBillingDocumentItem view_entity inner COMPOSITE My Preliminary Billing Document Item
P_RespyMgmtBPWithUser view from COMPOSITE Business Partner with a User
P_RespyMgmtOrgUnitBPRelshp view inner BASIC basic View to get Org Unit and BP Relationship
R_EntProjBusinessUser view_entity from BASIC Business Users in Enterprise Projects
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 10
KEY BusinessPartnerUUID BusinessPartnerUUID 3
KEY UserID CreatedByUser,LastChangedByUser,UserID 14
AuthorizationGroup AuthorizationGroup 7
BusinessPartnerIsBlocked BusinessPartnerIsBlocked 1
DataController1 DataController1 7
DataController10 DataController10 7
DataController2 DataController2 7
DataController3 DataController3 7
DataController4 DataController4 7
DataController5 DataController5 7
DataController6 DataController6 7
DataController7 DataController7 7
DataController8 DataController8 7
DataController9 DataController9 7
DataControllerSet DataControllerSet 7
FirstName FirstName 8
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 6
IsMarkedForArchiving IsMarkedForArchiving 1
LastName FamilyName,LastName 8
PersonFullName FullName,person_full_name,PersonFullName 5

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