C_ImpctMgmtScenarioManageTP

DDL: C_IMPCTMGMTSCENARIOMANAGETP Type: view_entity CONSUMPTION

Impact Management Scenario Manage

C_ImpctMgmtScenarioManageTP is a Consumption CDS View that provides data about "Impact Management Scenario Manage" in SAP S/4HANA. It reads from 1 data source (R_ImpctMgmtScenarioTP) and exposes 13 fields with key field ImpctMgmtScenarioUUID.

Data Sources (1)

SourceAliasJoin Type
R_ImpctMgmtScenarioTP R_ImpctMgmtScenarioTP projection

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Impact Management Scenario Manage view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ImpctMgmtScenarioUUID R_ImpctMgmtScenarioTP ImpctMgmtScenarioUUID Scenario ID
Language R_ImpctMgmtScenarioTP Language Report Text Language
ImpctMgmtScenarioName R_ImpctMgmtScenarioTP ImpctMgmtScenarioName Scenario Name
ImpctMgmtScenarioText R_ImpctMgmtScenarioTP ImpctMgmtScenarioText Scenario Descr
ImpctMgmtScenIsDflt R_ImpctMgmtScenarioTP ImpctMgmtScenIsDflt
ImpctMgmtCreatedByName R_ImpctMgmtScenarioTP ImpctMgmtCreatedByName Created By
CreatedByUserFullName _CreatedByUserContactCard UserDescription Full Name
ImpctMgmtCreatedDteTme R_ImpctMgmtScenarioTP ImpctMgmtCreatedDteTme Created On
dats8
ImpctMgmtChangedByName R_ImpctMgmtScenarioTP ImpctMgmtChangedByName User Name
LastChangedByUserFullName _LastChangedByUserContactCard UserDescription Full Name
ImpctMgmtChangedDteTme R_ImpctMgmtScenarioTP ImpctMgmtChangedDteTme Time Stamp
dats8

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_ImpctMgmtScenarioManageTP.
-- 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_ImpctMgmtScenarioManageTP AS
SELECT
  R_ImpctMgmtScenarioTP.ImpctMgmtScenarioUUID AS ImpctMgmtScenarioUUID,
  R_ImpctMgmtScenarioTP.Language AS Language,
  R_ImpctMgmtScenarioTP.ImpctMgmtScenarioName AS ImpctMgmtScenarioName,
  R_ImpctMgmtScenarioTP.ImpctMgmtScenarioText AS ImpctMgmtScenarioText,
  R_ImpctMgmtScenarioTP.ImpctMgmtScenIsDflt AS ImpctMgmtScenIsDflt,
  R_ImpctMgmtScenarioTP.ImpctMgmtCreatedByName AS ImpctMgmtCreatedByName,
  _CreatedByUserContactCard.UserDescription AS CreatedByUserFullName,
  R_ImpctMgmtScenarioTP.ImpctMgmtCreatedDteTme AS ImpctMgmtCreatedDteTme,
  virtual CreationDate : abap.dats(8) AS dats8,
  R_ImpctMgmtScenarioTP.ImpctMgmtChangedByName AS ImpctMgmtChangedByName,
  _LastChangedByUserContactCard.UserDescription AS LastChangedByUserFullName,
  R_ImpctMgmtScenarioTP.ImpctMgmtChangedDteTme AS ImpctMgmtChangedDteTme
FROM R_ImpctMgmtScenarioTP
;