TASK

TASK is an SAP database table in S/4HANA. It contains 53 fields.

Fields (53)

KeyField CDS FieldsUsed in Views
KEY EWMWarehouse EWMWarehouse 1
KEY obj_name object_name 1
KEY object object_type 1
KEY pgmid program_id 1
KEY ProjectElementUUID ProjectElementUUID 1
KEY ProjectUUID ProjectUUID 3
KEY SuplrActyTaskUUID SuplrActyTaskUUID 1
KEY Supplier Supplier 1
KEY TaskUUID ReferencedObjectUUID,TaskUUIDRaw 2
KEY trkorr task 2
KEY Warehouse Warehouse 1
KEY WarehouseTask WarehouseTask 2
KEY WarehouseTaskItem WarehouseTaskItem 2
ActivityArea ActivityArea 2
AuthorizationGroup AuthorizationGroup 1
CreationDateTime CreationDateTime 1
CriticalityCode CriticalityCode 1
DataController1 DataController1 1
DataController10 DataController10 1
DataController2 DataController2 1
DataController3 DataController3 1
DataController4 DataController4 1
DataController5 DataController5 1
DataController6 DataController6 1
DataController7 DataController7 1
DataController8 DataController8 1
DataController9 DataController9 1
DataControllerSet DataControllerSet 1
EndDate EndDate 1
ExternalId ExternalId 1
IsTaskReadyToStart IsTaskReadyToStart 1
Language Language 1
LastChangeDateTime LastChangeDateTime 1
LatestFinishDateTime LatestFinishDateTime 1
LatestStartDateTime LatestStartDateTime 1
LeadingSalesOrder LeadingSalesOrder 1
LeadingSalesOrderItem LeadingSalesOrderItem 1
Project Project 1
ProjectName ProjectName 1
ProjectNameMasterLanguage ProjectNameMasterLanguage 1
ProjectNameUserLanguage ProjectNameUserLanguage 1
RemainingWorkExtQuantityUnit RemainingWorkExtQuantityUnit 1
RemainingWorkQuantity RemainingWorkQuantity 1
ResultAnalysisInternalID ResultAnalysisInternalID 1
Severity Severity 1
SuplrActyTaskName SuplrActyTaskName 1
TaskName TaskName 1
TaskNameMasterLanguage TaskNameMasterLanguage 1
TaskNameUserLanguage TaskNameUserLanguage 1
TaskProcessingStatus TaskProcessingStatus 1
trfunction taskfunction 2
WarehouseProcessType WarehouseProcessType 2
WBSElementInternalID WBSElementInternalID 1

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 TASK (
    EWMWAREHOUSE,
    OBJ_NAME,
    OBJECT,
    PGMID,
    PROJECTELEMENTUUID,
    PROJECTUUID,
    SUPLRACTYTASKUUID,
    SUPPLIER,
    TASKUUID,
    TRKORR,
    WAREHOUSE,
    WAREHOUSETASK,
    WAREHOUSETASKITEM,
    ACTIVITYAREA,
    AUTHORIZATIONGROUP,
    CREATIONDATETIME,
    CRITICALITYCODE,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    ENDDATE,
    EXTERNALID,
    ISTASKREADYTOSTART,
    LANGUAGE,
    LASTCHANGEDATETIME,
    LATESTFINISHDATETIME,
    LATESTSTARTDATETIME,
    LEADINGSALESORDER,
    LEADINGSALESORDERITEM,
    PROJECT,
    PROJECTNAME,
    PROJECTNAMEMASTERLANGUAGE,
    PROJECTNAMEUSERLANGUAGE,
    REMAININGWORKEXTQUANTITYUNIT,
    REMAININGWORKQUANTITY,
    RESULTANALYSISINTERNALID,
    SEVERITY,
    SUPLRACTYTASKNAME,
    TASKNAME,
    TASKNAMEMASTERLANGUAGE,
    TASKNAMEUSERLANGUAGE,
    TASKPROCESSINGSTATUS,
    TRFUNCTION,
    WAREHOUSEPROCESSTYPE,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (EWMWAREHOUSE, OBJ_NAME, OBJECT, PGMID, PROJECTELEMENTUUID, PROJECTUUID, SUPLRACTYTASKUUID, SUPPLIER, TASKUUID, TRKORR, WAREHOUSE, WAREHOUSETASK, WAREHOUSETASKITEM)
);