WORKPACKAGECUBE

WORKPACKAGECUBE is an SAP database table in S/4HANA. It contains 36 fields.

Fields (36)

KeyField CDS FieldsUsed 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
);