I_USER

CDS View
6 Fields 128 CDS Views

User

I_USER is a CDS View in S/4HANA. User. It contains 6 fields. 128 CDS views read from this table.

CDS Views using this table (128)

ViewTypeJoinVDMDescription
/IWBEP/CDS_I_User_Email view_entity from Email address of a user
/LTB/I_MC_ACTIVITY_DETAIL_LIST view left_outer The activity details of MC
/ltb/i_mc_pe_ana_user view_entity from User Information
/ltb/i_mc_pe_ana_user view_entity union User Information
/LTB/I_MC_PROJ_USER view left_outer Project User
APS_IAM_DPP view left_outer Display Publishing Processes
APS_OM_PrintClientUser view from Print Client User
C_ACMUserNameValueHelp view_entity from CONSUMPTION User Names
C_BillgDocDueListCreatedByVH view from CONSUMPTION Billing Document Due List Created By Value Help
C_BillgProcDocWrkFlwRcpntVH view inner CONSUMPTION Billg Proc. Doc. WF Recipient Value Help
C_BillingDocumentUserVH view from CONSUMPTION Billing Document User Value Help
C_BusEvtLogUserCntctCardVH view from CONSUMPTION Business Event Log User
C_CAInvcgClrfctnIsAdmin view from CONSUMPTION Administratorrechte Klärungsfall Fakt.
C_ChgRecdWorkflowRecipientVH view inner CONSUMPTION People Picker for Change Record task processor
C_CmplncDisclUserVH view_entity from CONSUMPTION Create or Change User
C_CustomerReturnUserVH view from CONSUMPTION Customer Return User
C_DrctActivityAllocationUserVH view_entity from CONSUMPTION Created By
C_EHSSystemUserValueHelp view_entity from CONSUMPTION System user in EHS
C_EngagementProjectUserVH view from CONSUMPTION Engagement Project user value help
C_JITOutbCallCreatedByUserVH view inner CONSUMPTION Value Help for JIT Call Created by User
C_ManageJournalEntryUserVH view_entity from CONSUMPTION Manage Journal Entry User
C_MfgBusinessPartnerVH view inner CONSUMPTION Mfg Business Partner Value Help
C_MfgOperatorDetail view inner CONSUMPTION Production Operator details
C_MngJrnlEntryHistoryUserVH view_entity from CONSUMPTION Manage Journal Entry History User
C_PurchaseOrderWorkflowEmail view left_outer CONSUMPTION Purchase Order Details for Workflow Deadline Email
C_RepostCostAcctgCrtedByUserVH view_entity from CONSUMPTION Created By
C_ResvnDocumentCreatedByVH view_entity from CONSUMPTION Reservation User Filter
C_ReturnsRefDocUserValueHelp view from CONSUMPTION Returns Order Reference Document User
C_SalesDocumentUserVH view from CONSUMPTION Sales Document User
C_SalesOrderRequestUserVH view from CONSUMPTION Sales Order Request User Value Help
C_SalesPlanUserVH view from CONSUMPTION Sales Plan User Value Help
C_SituationDefinitionUserName view from CONSUMPTION Consumption view to fetch the User name
C_SlsDocWrkFlwRecipientVH view inner CONSUMPTION Sales Document Work Flow Recipient VH
C_SlsPriceWorkflowRecipientVH view inner CONSUMPTION Sales Price Workflow Recipient
C_SupplierActivityOVP view left_outer CONSUMPTION Supplier Activity Overview Page
C_UnivAllocCycVersCreatedByVH view_entity from CONSUMPTION Created By
C_ValueChainUserVH view_entity from CONSUMPTION Value Chain User Help
CBC_STA_SRC_CR view left_outer
CUAN_ME_ME_QR_AUTH_USER_SEARCH view_entity inner CUAN_ME_ME_QR_AUTH_USER_SEARCH
CUAN_ME_QR_REUSE_USED_IN view_entity left_outer Messages That Use Reusable Blocks
CUAN_ME_QR_TOOLBOX_BLOCKS view_entity left_outer Toolbox Blocks in Message Design View
CUAN_TG_WITH_NAMES_SEARCH view_entity left_outer AT_SEARCH_TARGET_GROUP_WITH_NAMES
DHAMB_AUTH_GROUP_user view_entity from All users with auth. group assignment
F2_Mmim_User_Vh view from Help-View for Users
FSCM_UsernameVH view from Suche nach Benutzernamen
GEN_RESULT_SET_W_O_MEM_COUNT view_entity left_outer Query Result Sets by Elements
GSEG_CDS_BUILDING_BLOCK_COLD view_entity left_outer Search Cold Building Blocks
GSEG_CDS_SEG_MODEL_COLD view_entity left_outer Search Cold Segmentation Models
hrpy_pcc_activity view_entity left_outer Payroll Activities
HRPY_PCC_recurrence view left_outer Recurrence Data
HRPY_PCC_step view_entity left_outer Step Recurrence
I_AccrObjResponsiblePerson view_entity inner COMPOSITE Responsible User
I_ACMApplicationOverview view left_outer TRANSACTIONAL Interface Layer for ACM Application Overview
I_ACMUserName view from BASIC Name of the user along with the user id
I_APJ_USERS view from All users (OnPrem and Business Users)
I_ARBankStatementTP view left_outer TRANSACTIONAL Bank Statement BO active and draft
I_BusEvtLogUserContactCard view_entity from COMPOSITE Business Event Log User Contact Card
I_CACorrespncHistoryUserVH view_entity from BASIC Display Correspondence User
I_CAScrtyDepRequestProcess view_entity left_outer COMPOSITE Document Process of a Specific Request
I_CreatedByUserOfSIT view inner TRANSACTIONAL Value Help for Created by User
I_CustomCDSViewUser view from Custom CDS View User
I_DocumentInfoRecordUserVH view left_outer COMPOSITE Document Info Record User
I_DraftAdministrativeUserVH view_entity inner Draft User
I_EntProjectTeamMemberUser view_entity inner COMPOSITE EntProject Team Members and their users
I_ExternalTaxUserIDVH view_entity from BASIC External Tax User Id
I_FinSGLRunIDUserNameVH view_entity from BASIC Search Help for Run ID users
I_IBCUserVH view_entity from CONSUMPTION
I_InternalOrderUserVH view_entity from COMPOSITE Internal order user
I_IPUTSScpDurationUsrVH view_entity from BASIC IPUTS Scope Duration User
I_JITOutbMntrLstChgByUsr view_entity from COMPOSITE Last Changed by user
I_LglTransWrkflwEmlDeadLine view left_outer COMPOSITE Email Template for Workflow Deadline
I_MaterialSampleDetails view left_outer COMPOSITE CDS View for Material Sample Details
I_MatlDocUserVH view from BASIC Invtry Management postings on user
I_MfgStdTxtVersCreatedByVH view from BASIC Standard Text Version Created By Value Help
I_NominationScheduleUserText view from BASIC Trip created by user value help
I_PPM_IsMyProject view inner COMPOSITE All projects a user is respsonible for
I_PPM_TeamMemberIsInRole view inner COMPOSITE returns X, when the user is in the given ProjectRoleCateg.
I_PPM_User view from BASIC User information in table HRP1001
I_PPS_UserVH view_entity from COMPOSITE User Master Help
I_PPSEntitySimulationDate view_entity from COMPOSITE Entity simulation date set for user
I_PrepaymentAgrmtUserNameText view inner BASIC Prepayment Agreement User Name Text
I_PrepaymentAgrmtUserNameVH view inner BASIC Prepayment Agrmt User Name VH
I_ProcmtEmployeeUserDetails view from COMPOSITE CDS view for Procurement Employee Details
I_ProcurementBusinessUser view inner BASIC Businessuser in procurement
I_ProdCmplncCntntUser view from COMPOSITE User Names for Admin Data
I_ProjectMgrOrgDet view left_outer COMPOSITE Retrieve project details for the session user
I_PurCtrUserDetails view inner BASIC User details for contract
I_RequestOwners view_entity inner Request Owners
I_SCBO2_CreatedByUser view_entity from Created By User
I_SCBO2_LastChangedByUser view_entity from Last Changed By User
I_SLCQnaireParty view left_outer BASIC Party Referenced in Questionnaire
I_SrvcEntrShtRespUsrValueHelp view inner COMPOSITE SES Responsible User Value Help
I_SrvcMgmtCreatedByUserVH view from COMPOSITE Created by User of Srvc Mgmt Value Help
I_SuplrInvcCreatedByValHelp view from BASIC Supplier Invoice List Created By Value Help
I_SupplierEvalTemplateParty view left_outer BASIC Party Referenced by Evaluation Template
I_TaskOwners view_entity inner Task Owners
I_TDAUserNameDetail view_entity from BASIC User Detail
I_TrdgContrUserVH view_entity from BASIC Created By
I_UserCurrency_F2200 view from COMPOSITE User currency
I_Userdetails view from COMPOSITE Basic CDS for User Details
I_WorkflowUser view from COMPOSITE Workflow User
P_InvoiceWorkFlowRecipient view inner COMPOSITE People Picker for Invoice Approver
P_MaterialShortageProfileUser view from CONSUMPTION
P_MfgOpActyTeamUserAssgmt view inner COMPOSITE
P_PartyIDForMySystemUser view from COMPOSITE
P_PartyIDForMyUser view from COMPOSITE
P_PurOrdItemChgScoreHistory view left_outer CONSUMPTION Pur Ord Item Changed Score History
P_QltyBPWithUser view inner BASIC
P_RetailStoreAssignableUser view inner BASIC
P_RSHAppUserSettingsInclDflt view from COMPOSITE
p_sclt_user view from CLT: User info
P_StorePickingReqAuthzdUser view inner COMPOSITE
P_Usersetgetparamforctrlgarea view from BASIC
P_UserSettingsForCompanyCode view from BASIC
P_UserSettingsForDeprArea view from BASIC
R_ConditionDocumentUserVH view_entity from COMPOSITE Condition Document User
R_DCBTrader view_entity from COMPOSITE Deal Capture Backend Trader
R_PPDSOptmzrLgExplUserVH view_entity from BASIC User Value Help
R_Sitn2InstceUserName view from BASIC User Name for Situation Instance
R_Sitn2UserName view from TRANSACTIONAL Consumption view to fetch the User name
S_EPM_WF_USER view inner BASIC EPM Demo: User/Employee
s_sclt_trace_user view union Trace user
SATC_CI_CF_USER view_entity from User
SATC_CI_EXEMPTION_USER_TEXT view_entity from User Text
sycm_aps_i_user view from User information
V_Mmim_Ddl_Om_Or_Email view left_outer Output Management E-Mail
V_Mmim_Ddl_Om_Or_GR4PO_EMAIL view left_outer Output Management E-Mail GR4PO
View_o2c_Fica_Mywl_Bpart view left_outer My Worklist Business Partner Totals

Fields (6)

KeyField CDS FieldsUsed in Views
KEY UserID ContactCardID,HCMProcessInitiatorUserID,NominationSchedUserID,PPSEntityUserID,TransportRequestOwner,TransportRequestTaskOwner,user_id,UserID,UserName 41
AddressID AddressID 1
AddressPersonID Person,PersonNumber 2
BusinessPartnerUUID BusinessPartnerUUID 2
IsTechnicalUser IsTechnicalUser 2
UserDescription ApplDocumentChangedByName,ApplDocumentCreatedByName,Description,Fullname,LastChangedByUserFullName,PartyName,PersName,ResponsiblePersonFullName,UserDescription,username 28

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.

-- User
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_USER (
    USERID,
    ADDRESSID,
    ADDRESSPERSONID,
    BUSINESSPARTNERUUID,
    ISTECHNICALUSER,
    USERDESCRIPTION,
    PRIMARY KEY (USERID)
);

Learn More