I_MISSIONESSENTIALTASK

CDS View
19 Fields 6 CDS Views

View for Mission Essential Task

I_MISSIONESSENTIALTASK is a CDS View in S/4HANA. View for Mission Essential Task. It contains 19 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_MissionEssentialTaskNameVH view from CONSUMPTION Value Help for MET Name
C_MissionEssentialTaskVH view from CONSUMPTION Value Help for MET ID and Name
I_MissionEssentialTaskDimn view from COMPOSITE View for MET Dimension
I_MissionEssentialTaskName view from BASIC Text for Hierarchy Nodes and leaf nodes for MET
I_MissionEssentialTaskTP view from TRANSACTIONAL View for Mission Essential Task
I_MissionEssentialTaskVH view from COMPOSITE MET ID and Name with all statuses

Fields (19)

KeyField CDS FieldsUsed in Views
KEY MissionEssentialTaskID MissionEssentialTaskID,MissionEssentialTaskSearchID 6
KEY MissionEssentialTaskUUID MissionEssentialTaskUUID 6
KEY MsnEsnlTskName MsnEsnlTskName 6
DfsCapbltStmntSqncNmbr DfsCapbltStmntSqncNmbr 2
MsnEsnlTskCreatedByUser MsnEsnlTskCreatedByUser 1
MsnEsnlTskCreationDteTme MsnEsnlTskCreationDteTme 1
MsnEsnlTskDescription MsnEsnlTskDescription 5
MsnEsnlTskIsRootTask MsnEsnlTskIsRootTask 2
MsnEsnlTskLastChgdByUser MsnEsnlTskLastChgdByUser 1
MsnEsnlTskLastChgdDteTme MsnEsnlTskLastChgdDteTme 1
MsnEsnlTskParentUUID MsnEsnlTskParentUUID 1
MsnEsnlTskRootUUID MsnEsnlTskRootUUID 2
MsnEsnlTskShortName MsnEsnlTskShortName 5
MsnEsnlTskStatusCode MsnEsnlTskStatusCode 3
MsnEsnlTskStatusObjectID MsnEsnlTskStatusObjectID 2
MsnEsnlTskTrngPlnText MsnEsnlTskTrngPlnText 1
MsnEsnlTskType MsnEsnlTskType 2
MsnEsnlTskValidityEndDte MsnEsnlTskValidityEndDte 5
MsnEsnlTskValidityStartDte MsnEsnlTskValidityStartDte 5

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.

-- View for Mission Essential Task
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MISSIONESSENTIALTASK (
    MISSIONESSENTIALTASKID,
    MISSIONESSENTIALTASKUUID,
    MSNESNLTSKNAME,
    DFSCAPBLTSTMNTSQNCNMBR,
    MSNESNLTSKCREATEDBYUSER,
    MSNESNLTSKCREATIONDTETME,
    MSNESNLTSKDESCRIPTION,
    MSNESNLTSKISROOTTASK,
    MSNESNLTSKLASTCHGDBYUSER,
    MSNESNLTSKLASTCHGDDTETME,
    MSNESNLTSKPARENTUUID,
    MSNESNLTSKROOTUUID,
    MSNESNLTSKSHORTNAME,
    MSNESNLTSKSTATUSCODE,
    MSNESNLTSKSTATUSOBJECTID,
    MSNESNLTSKTRNGPLNTEXT,
    MSNESNLTSKTYPE,
    MSNESNLTSKVALIDITYENDDTE,
    MSNESNLTSKVALIDITYSTARTDTE,
    PRIMARY KEY (MISSIONESSENTIALTASKID, MISSIONESSENTIALTASKUUID, MSNESNLTSKNAME)
);

Learn More