C_MissionEssentialTaskQry

DDL: C_MISSIONESSENTIALTASKQRY SQL: CMETQRY Type: view CONSUMPTION

View for Mission Essential Task Query

C_MissionEssentialTaskQry is a Consumption CDS View that provides data about "View for Mission Essential Task Query" in SAP S/4HANA. It reads from 1 data source (I_MissionEssentialTaskDimn) and exposes 16 fields with key field MissionEssentialTaskUUID. It is used in 1 Fiori application: Display Mission Essential Task Hierarchy.

Data Sources (1)

SourceAliasJoin Type
I_MissionEssentialTaskDimn Self from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CMETQRY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label View for Mission Essential Task Query view
Analytics.query true view
OData.publish true view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
UI.headerInfo.typeName Mission Essential Task view
UI.headerInfo.typeNamePlural METL Items view

Fiori Apps (1)

App IDApp NameTypeDescription
F4132 Display Mission Essential Task Hierarchy Transactional, Reuse Component

Display Mission Essential Task Hierarchy

Business Role: Organizational Planner - Capabilities

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY MissionEssentialTaskUUID MissionEssentialTaskUUID MET UUID
MissionEssentialTaskID I_MissionEssentialTaskDimn MissionEssentialTaskID MET ID
MissionEssentialTaskSearchID MissionEssentialTaskID MET ID
MsnEsnlTskName I_MissionEssentialTaskDimn MsnEsnlTskName MET Name
MsnEsnlTskSearchName MsnEsnlTskName MET Name
MsnEsnlTskDescription I_MissionEssentialTaskDimn MsnEsnlTskDescription MET Description
MsnEsnlTskSearchDescription MsnEsnlTskDescription MET Description
MsnEsnlTskValidityStartDte I_MissionEssentialTaskDimn MsnEsnlTskValidityStartDte Valid From
MsnEsnlTskValidityEndDte I_MissionEssentialTaskDimn MsnEsnlTskValidityEndDte Valid To
MsnEsnlTskShortName I_MissionEssentialTaskDimn MsnEsnlTskShortName MET Code
MsnEsnlTskSearchShortName MsnEsnlTskShortName MET Code
MsnEsnlTskType I_MissionEssentialTaskDimn MsnEsnlTskType MET Type
Status I_MissionEssentialTaskDimn Status MET Status
MsnEsnlTskSearchType MsnEsnlTskType MET Type
MsnEsnlTskSearchRootName MsnEsnlTskSearchRootName MET Tree
DfsCapbltStmntSqncNmbr I_MissionEssentialTaskDimn DfsCapbltStmntSqncNmbr Sequence Number

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_MissionEssentialTaskQry.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CMETQRY

CREATE VIEW C_MissionEssentialTaskQry AS
SELECT
  MissionEssentialTaskUUID,
  Self.MissionEssentialTaskID AS MissionEssentialTaskID,
  MissionEssentialTaskID AS MissionEssentialTaskSearchID,
  Self.MsnEsnlTskName AS MsnEsnlTskName,
  MsnEsnlTskName AS MsnEsnlTskSearchName,
  Self.MsnEsnlTskDescription AS MsnEsnlTskDescription,
  MsnEsnlTskDescription AS MsnEsnlTskSearchDescription,
  Self.MsnEsnlTskValidityStartDte AS MsnEsnlTskValidityStartDte,
  Self.MsnEsnlTskValidityEndDte AS MsnEsnlTskValidityEndDte,
  Self.MsnEsnlTskShortName AS MsnEsnlTskShortName,
  MsnEsnlTskShortName AS MsnEsnlTskSearchShortName,
  Self.MsnEsnlTskType AS MsnEsnlTskType,
  Self.Status AS Status,
  MsnEsnlTskType AS MsnEsnlTskSearchType,
  MsnEsnlTskSearchRootName,
  Self.DfsCapbltStmntSqncNmbr AS DfsCapbltStmntSqncNmbr
FROM I_MissionEssentialTaskDimn AS Self
;