FISVD_ACTION_DS

DDL: FISVD_ACTION_DS SQL: FITAXACTIONDS Type: view

Action Description

FISVD_ACTION_DS is a CDS View that provides data about "Action Description" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 2 fields with key field action.

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FITAXACTIONDS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #P view
EndUserText.label Action Description view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY action domvalue_l
language ddlanguage
@AbapCatalog.sqlViewName: 'FITAXACTIONDS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: {
  serviceQuality: #P
}
@EndUserText.label: 'Action Description'
/*This CDS view is for the Change Document:Change Type */
define view FISVD_ACTION_DS
  as select from dd07t
{
      @ObjectModel.text.element: ['action_txt']
  key domvalue_l as action,
      @Semantics.language: true
      ddlanguage as language,
      @Semantics.text: true
      case
        when domvalue_l = 'E' then 'Delete'
        when domvalue_l = 'J' then 'Insert'
      else
        ddtext
      end        as Description
}
where
      domname    = 'CDCHNGIND'
  and ddlanguage = $session.system_language
  and as4local   = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/