C_DfsScenAlternativeTaskTP

DDL: C_DFSSCENALTERNATIVETASKTP Type: view_entity CONSUMPTION
14 Fields 1 Data Sources 1 Associations 1 OData Services 1 Fiori Apps

Projection View For Scenario Alternative Task

C_DfsScenAlternativeTaskTP is a Consumption CDS View that provides data about "Projection View For Scenario Alternative Task" in SAP S/4HANA. It reads from 1 data source (R_DfsScenAlternativeTaskTP) and exposes 14 fields with key field DfsScenarioAltvTaskUUID. It has 1 association to related views. It is exposed through 1 OData service (UI_DFS_SCENARIO). It is used in 1 Fiori application: Manage Planning Scenarios.

Data Sources (1)

SourceAliasJoin Type
R_DfsScenAlternativeTaskTP R_DfsScenAlternativeTaskTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_DfsScenAltvTskToCapbltList _DfsScenAltvTskToCapbltList $projection.DfsScenarioAltvTaskUUID = _DfsScenAltvTskToCapbltList.DfsScenarioAltvTaskUUID

Annotations (7)

NameValueLevelField
EndUserText.label Projection View For Scenario Alternative Task view
Metadata.allowExtensions true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
UI_DFS_SCENARIO UI_DFS_SCENARIO V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F4697 Manage Planning Scenarios Transactional A scenario consists of one or more possible alternatives. Alternatives can be alternative response options to a threat or natural disaster. Each alternative includes a set of objects related to a capability code, and they are combined with active force elements at alternative task level. A scenario is used in capability-based planning and development processes. It collects different objects related to the capability and actual active force elements (or reference force elements) and allows the user to compare the scenario alternative requirement defined by the capabilities assigned to it with active force elements that could possibly fulfil the requirements. A planner can view the crucial personnel, material and training requirements (job, FMPO, METL) linked to each required capability code in a scenario alternative task. This allows the planner to evaluate whether the identified unit is now ready and prepared to perform the operation at hand. This scenario master data set is also used as the basis for any tailored and complex readiness and preparedness evaluations, reporting or simulations. Two types of scenarios are available: 1. Preparedness monitoring scenario 2. Capability development scenario The Preparedness monitoring scenario is a scenario that is monitored periodically. The aim is to identify shortcomings in capabilities and provide input for different downstream processes, such as material replenishments or any human resources management activities. The capability development scenario relates to the introduction of new or upgraded capabilities in defense.

Manage Planning Scenarios

Business Role: Organizational Planner - Capabilities

A scenario consists of one or more possible alternatives. Alternatives can be alternative response options to a threat or natural disaster. Each alternative includes a set of objects related to a capability code, and they are combined with active force elements at alternative task level.

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY DfsScenarioAltvTaskUUID DfsScenarioAltvTaskUUID Task UUID
DfsScenarioAltvUUID DfsScenarioAltvUUID Alternative UUID
DfsScenarioUUID DfsScenarioUUID Scenario UUID
DfsScenarioAltvTaskID DfsScenarioAltvTaskID Task ID
DfsScenarioAltvTaskName DfsScenarioAltvTaskName Task Name
DfsScenAltvTaskCreationDteTme DfsScenAltvTaskCreationDteTme Created On
DfsScenAltvTaskCreatedByUser DfsScenAltvTaskCreatedByUser Created By
DfsScenAltvTaskLastChgdDteTme DfsScenAltvTaskLastChgdDteTme Changed On
DfsScenAltvTaskLastChgdByUser DfsScenAltvTaskLastChgdByUser Changed By
DfsScenarioLastChgdDteTme DfsScenarioLastChgdDteTme Changed On
_ScenarioTPredirectedtoC_DfsScenarioTP
_CreatedByUserContactCard _CreatedByUserContactCard
_LastChangedByUserContactCard _LastChangedByUserContactCard
_DfsScenAltvTskToCapbltList _DfsScenAltvTskToCapbltList

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_DfsScenAlternativeTaskTP.
-- 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.

CREATE VIEW C_DfsScenAlternativeTaskTP AS
SELECT
  DfsScenarioAltvTaskUUID,
  DfsScenarioAltvUUID,
  DfsScenarioUUID,
  DfsScenarioAltvTaskID,
  DfsScenarioAltvTaskName,
  DfsScenAltvTaskCreationDteTme,
  DfsScenAltvTaskCreatedByUser,
  DfsScenAltvTaskLastChgdDteTme,
  DfsScenAltvTaskLastChgdByUser,
  DfsScenarioLastChgdDteTme
FROM R_DfsScenAlternativeTaskTP
LEFT OUTER JOIN C_DfsScenAltvTskToCapbltList AS _DfsScenAltvTskToCapbltList ON DfsScenarioAltvTaskUUID = _DfsScenAltvTskToCapbltList.DfsScenarioAltvTaskUUID  -- association [0..*]
;

Learn More