I_WORKPACKAGE

CDS View
20 Fields 25 CDS Views

Work Package

I_WORKPACKAGE is a CDS View in S/4HANA. Work Package. It contains 20 fields. 25 CDS views read from this table.

CDS Views using this table (25)

ViewTypeJoinVDMDescription
C_MM_WBSElmntEngmntProjVH view_entity inner CONSUMPTION WBS element on Engagement Project
C_PurOrdMaintainWBSValHelp view inner CONSUMPTION WBS Element Value Help
C_WorkPackage view from CONSUMPTION Work Package
C_WorkpackageDetails view from CONSUMPTION Work Package Details
I_CustomerProjectWorkPackage view from BASIC Customer Project Work Package
I_CustProjSlsOrdItemWorkPckg view inner COMPOSITE SO Item Wrk Pckgs for Customer Project
I_CustProjWrkPckgDetails view from BASIC Customer Project Workpackage Details
I_EngmntProjectSupplyData view inner BASIC Engagement Project Supply Data
I_EngmntProjFcstCube view left_outer COMPOSITE Forecast Info for Engmnt Project - Cube
I_EngmntProjFcstCube_2 view left_outer COMPOSITE Forecast Info for Engmnt Project - Cube
I_EngmntProjWrkPckg view from COMPOSITE Work Package
I_WorkPackageStdVH view from COMPOSITE Work Package
P_CATSDATAWITHCATEGORY view left_outer COMPOSITE CATS data with the project category
P_EngagementProjPlanActualCost view left_outer COMPOSITE Engagement Project Plan and Actual Cost
P_EngmentProjEmpWrkPckgDets view inner COMPOSITE Engagement Project Employee Work Package Details
P_EngmntProjAddlResources view left_outer COMPOSITE Additional Resources
P_Engmntprojplnactlexpense view inner COMPOSITE Engagement Project WP Plan Actual Expense
P_EngmntProjPlnDataByRsceType view inner COMPOSITE Engagement Project plan data by ressource types
P_EngmntProjWrkPckgDateSplit view from COMPOSITE Engagement Project Work Package Date Split
P_EngmtProjBillingItems view left_outer BASIC Engagement Project Billing Items
P_JP_SalesOrderWorkPackage view from CONSUMPTION Map of sales order and work package
P_Purordmaintaincustproj view from CONSUMPTION Customer Project Workpackage
P_PURORDWBSVALHELP view inner COMPOSITE Helper for WBS_VH
P_Workpackagepurchaseorder view from COMPOSITE Work Package Purchase Order
P_WrkPckgPlanActual view inner CONSUMPTION Work Package Plan Actual

Fields (20)

KeyField CDS FieldsUsed in Views
KEY WBSElementObject WBSElement,WBSElementObject,WorkPackageWBSObjectNumber 7
KEY WorkPackage CustomerProjectWorkPackage,WorkPackage 10
KEY WorkPackageUUID WorkPackageUUID 8
_EngagementProjectPlanData _EngagementProjectPlanData 2
_EngagementProjFinancialPlan _EngagementProjFinancialPlan 2
_SalesOrder _SalesOrder 1
_SalesOrderItem _SalesOrderItem 1
_WBSElement _WBSElement 1
CreatedByUser CreatedByUser 2
CreationDateTime CreationDateTime 3
EngagementProjFinPlanUUID EngagementProjFinPlanUUID 7
LastChangeDateTime LastChangeDateTime 4
LastChangedByUser LastChangedByUser 3
SalesOrder SalesOrder 8
SalesOrderItem SalesOrderItem 5
WBSDescription WBSDescription 5
WorkPackageEndDate CustProjWorkPackageEndDate,WorkPackageEndDate 12
WorkPackageName CustProjWorkPackageName,WorkPackageName 12
WorkPackageStartDate CustProjWorkPackageStartDate,WorkPackageStartDate 12
WorkPackageType WorkPackageType 4

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.

-- Work Package
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_WORKPACKAGE (
    WBSELEMENTOBJECT,
    WORKPACKAGE,
    WORKPACKAGEUUID,
    _ENGAGEMENTPROJECTPLANDATA,
    _ENGAGEMENTPROJFINANCIALPLAN,
    _SALESORDER,
    _SALESORDERITEM,
    _WBSELEMENT,
    CREATEDBYUSER,
    CREATIONDATETIME,
    ENGAGEMENTPROJFINPLANUUID,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    SALESORDER,
    SALESORDERITEM,
    WBSDESCRIPTION,
    WORKPACKAGEENDDATE,
    WORKPACKAGENAME,
    WORKPACKAGESTARTDATE,
    WORKPACKAGETYPE,
    PRIMARY KEY (WBSELEMENTOBJECT, WORKPACKAGE, WORKPACKAGEUUID)
);

Learn More