I_ENGMNTPROJASSGMTTOSESSIONUSR
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA