I_ENGMNTPROJASSGMTTOSESSIONUSR

CDS View

Engagement Project Assignment To User

I_ENGMNTPROJASSGMTTOSESSIONUSR is a CDS View in S/4HANA. Engagement Project Assignment To User. It contains 34 fields. 19 CDS views read from this table.

CDS Views using this table (19)

ViewTypeJoinVDMDescription
P_ActualsForEngmntProject view from COMPOSITE
P_EngmntProjBillgAndRblsAnlys view from COMPOSITE
P_EngmntProjDemands view from CONSUMPTION Engagement Project Demands
P_EngmntProjectWithActual view from COMPOSITE
P_EngmntProjGLAcctLneItmSemTag view from COMPOSITE
P_EngmntProjPlanDataWithDraft view from COMPOSITE
P_EngmntProjPlannedData view from COMPOSITE
P_EngmntProjPlnActlAsSoldRevn view union_all COMPOSITE
P_EngmntProjPlngData view from COMPOSITE
P_EngmntProjReviewData view union_all COMPOSITE
P_EngmntProjSlsOrdItmDet view from COMPOSITE
P_EngmntProjStaffingAnalysis view from COMPOSITE
P_EngmntProjUnbilledRevData view from COMPOSITE
P_EngmntProjWrkPckgUnitKPI view from COMPOSITE
P_EngmtProjActlPlnSlsOrd view union_all COMPOSITE
P_EngmtProjActuals view from COMPOSITE
P_EngmtProjDmndByPerdKPI view from COMPOSITE
P_EngmtProjSalesPlanData view from COMPOSITE
P_WorkPackageUnitKPI view from COMPOSITE

Fields (34)

KeyField CDS FieldsUsed in Views
KEY EngagementProject EngagementProject 7
KEY EngagementProjectServiceOrg CustomerProjectServiceOrg,EngagementProjectServiceOrg 10
KEY EngagementProjFinPlanUUID EngagementProjFinPlanUUID 6
ControllingArea ControllingArea,EngmntProjectControllingArea 5
Currency Currency,ProjectCurrency 9
CurrentYearPeriod CurrentYearPeriod 2
Customer Customer 9
EngagementProjectCategory EngagementProjectCategory 10
EngagementProjectCostCenter EngagementProjectCostCenter 8
EngagementProjectReviewStatus EngagementProjectReviewStatus 4
EngagementProjectStage EngagementProjectStage 9
EngagementProjectType EngagementProjectType 9
EngagementProjectUUID EngagementProjectUUID 3
EngmntProjectHeaderCompanyCode EngmntProjectHeaderCompanyCode 8
EngmntProjReviewYearPeriod EngmntProjReviewYearPeriod 4
IsMyProject IsMyProject 17
LastChangeDateTime LastChangeDateTime 5
ProfitCenter ProfitCenter 9
ProjAccountantUserID ProjectAccountant 2
ProjControllerUserID ProjectController 2
ProjectAccountantExternalID ProjectAccountantExternalID 2
ProjectAccountantName ProjectAccountantName 2
ProjectControllerExternalID ProjectControllerExternalID 2
ProjectControllerName ProjectControllerName 2
ProjectEndDate ProjectEndDate 1
ProjectManagerExternalID ProjectManagerExternalID 5
ProjectManagerName ProjectManagerName 8
ProjectPartnerExternalID ProjectPartnerExternalID 2
ProjectPartnerName ProjectPartnerName 2
ProjectProfileCode ProjectProfileCode 8
ProjectStartDate ProjectStartDate 1
ProjectVisibility ProjectVisibility 10
ProjManagerUserID ProjectManager 4
ProjPartnerUserID Projectpartner 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.

-- Engagement Project Assignment To User
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ENGMNTPROJASSGMTTOSESSIONUSR (
    ENGAGEMENTPROJECT,
    ENGAGEMENTPROJECTSERVICEORG,
    ENGAGEMENTPROJFINPLANUUID,
    CONTROLLINGAREA,
    CURRENCY,
    CURRENTYEARPERIOD,
    CUSTOMER,
    ENGAGEMENTPROJECTCATEGORY,
    ENGAGEMENTPROJECTCOSTCENTER,
    ENGAGEMENTPROJECTREVIEWSTATUS,
    ENGAGEMENTPROJECTSTAGE,
    ENGAGEMENTPROJECTTYPE,
    ENGAGEMENTPROJECTUUID,
    ENGMNTPROJECTHEADERCOMPANYCODE,
    ENGMNTPROJREVIEWYEARPERIOD,
    ISMYPROJECT,
    LASTCHANGEDATETIME,
    PROFITCENTER,
    PROJACCOUNTANTUSERID,
    PROJCONTROLLERUSERID,
    PROJECTACCOUNTANTEXTERNALID,
    PROJECTACCOUNTANTNAME,
    PROJECTCONTROLLEREXTERNALID,
    PROJECTCONTROLLERNAME,
    PROJECTENDDATE,
    PROJECTMANAGEREXTERNALID,
    PROJECTMANAGERNAME,
    PROJECTPARTNEREXTERNALID,
    PROJECTPARTNERNAME,
    PROJECTPROFILECODE,
    PROJECTSTARTDATE,
    PROJECTVISIBILITY,
    PROJMANAGERUSERID,
    PROJPARTNERUSERID,
    PRIMARY KEY (ENGAGEMENTPROJECT, ENGAGEMENTPROJECTSERVICEORG, ENGAGEMENTPROJFINPLANUUID)
);