WORKPACKAGECUBE
WORKPACKAGECUBE is an SAP database table in S/4HANA. It contains 36 fields.
Fields (36)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| ActualPlanDeviationExpnCost | ActualPlanDeviationExpnCost | 1 | |
| Currency | Currency | 2 | |
| EngagementProjectCategory | EngagementProjectCategory | 1 | |
| EngagementProjectForecastMonth | EngagementProjectForecastMonth | 1 | |
| EngagementProjectForecastYear | EngagementProjectForecastYear | 1 | |
| EngagementProjectName | EngagementProjectName | 2 | |
| EngagementProjectResource | EngagementProjectResource | 2 | |
| EngagementProjectResourceType | EngagementProjectResourceType | 2 | |
| EngagementProjectReviewStatus | EngagementProjectReviewStatus | 1 | |
| EngagementProjectStage | EngagementProjectStage | 1 | |
| EngmntProjectDeliveryOrg | EngagementProjectServiceOrg,EngmntProjectDeliveryOrg | 2 | |
| EngmtProjFinPlanVersion | EngmtProjFinPlanVersion | 1 | |
| FiscalPeriod | FiscalPeriod | 1 | |
| FiscalYear | FiscalYear | 1 | |
| FiscalYearPeriod | FiscalYearPeriod | 1 | |
| IsDeleted | IsDeleted | 1 | |
| IsUnitBased | IsUnitBased | 1 | |
| LastChangeDateTime | LastChangeDateTime | 1 | |
| ProjectLastChangedDateTime | ProjectLastChangedDateTime | 1 | |
| RevenueAsSoldAmount | RevenueAsSoldAmount | 1 | |
| SalesOrder | SalesOrder | 2 | |
| SalesOrderItem | SalesOrderItem | 2 | |
| SalesOrderItemText | SalesOrderItemText | 2 | |
| TotalNetAmount | NetAmount | 1 | |
| UnitOfMeasure | UnitOfMeasure | 2 | |
| WBSElementExternalID | WBSElementExternalID | 1 | |
| WBSElementIsBillingElement | WBSElementIsBillingElement | 1 | |
| WorkItem | WorkItem | 2 | |
| WorkPackage | WorkPackage | 2 | |
| WorkPackageEndDate | WorkPackageEndDate | 2 | |
| WorkPackageName | WorkPackageName | 2 | |
| WorkPackageStartDate | WorkPackageStartDate | 2 | |
| WorkPackageType | WorkPackageType | 2 | |
| WorkPackageUnit | WorkPackageUnit | 1 | |
| WorkPackageUnitText | WorkPackageUnitText | 1 | |
| WorkPackageUnitUoM | WorkPackageUnitUoM | 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.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WORKPACKAGECUBE (
ACTUALPLANDEVIATIONEXPNCOST,
CURRENCY,
ENGAGEMENTPROJECTCATEGORY,
ENGAGEMENTPROJECTFORECASTMONTH,
ENGAGEMENTPROJECTFORECASTYEAR,
ENGAGEMENTPROJECTNAME,
ENGAGEMENTPROJECTRESOURCE,
ENGAGEMENTPROJECTRESOURCETYPE,
ENGAGEMENTPROJECTREVIEWSTATUS,
ENGAGEMENTPROJECTSTAGE,
ENGMNTPROJECTDELIVERYORG,
ENGMTPROJFINPLANVERSION,
FISCALPERIOD,
FISCALYEAR,
FISCALYEARPERIOD,
ISDELETED,
ISUNITBASED,
LASTCHANGEDATETIME,
PROJECTLASTCHANGEDDATETIME,
REVENUEASSOLDAMOUNT,
SALESORDER,
SALESORDERITEM,
SALESORDERITEMTEXT,
TOTALNETAMOUNT,
UNITOFMEASURE,
WBSELEMENTEXTERNALID,
WBSELEMENTISBILLINGELEMENT,
WORKITEM,
WORKPACKAGE,
WORKPACKAGEENDDATE,
WORKPACKAGENAME,
WORKPACKAGESTARTDATE,
WORKPACKAGETYPE,
WORKPACKAGEUNIT,
WORKPACKAGEUNITTEXT,
WORKPACKAGEUNITUOM
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- 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