MDRC_GTI_StatusText

DDL: MDRC_GTI_STATUSTEXT Type: view

Status Text for Incomplete GTI Documents

MDRC_GTI_StatusText is a CDS View that provides data about "Status Text for Incomplete GTI Documents" in SAP S/4HANA. It reads from 2 data sources (dd07t, I_CN_GoldenTaxDocumentStatusT) and exposes 8 fields with key fields CN_GoldenTaxDocumentStatus, Language. It has 2 associations to related views.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
dd07t dd07t from
I_CN_GoldenTaxDocumentStatusT I_CN_GoldenTaxDocumentStatusT union

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CN_GoldenTaxDocumentStatus _GoldenTaxDocumentStatus $projection.CN_GoldenTaxDocumentStatus = _GoldenTaxDocumentStatus.CN_GoldenTaxDocumentStatus
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Status Text for Incomplete GTI Documents view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName MDRCGTDOCSTST view
AbapCatalog.compiler.compareFilter true view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey CN_GoldenTaxDocumentStatus view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
AbapCatalog.preserveKey true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CN_GoldenTaxDocumentStatus
KEY Language ddlanguage
CN_GoldenTaxDocumentStatusDesc ddtext
_GoldenTaxDocumentStatus _GoldenTaxDocumentStatus
Language Language
CN_GoldenTaxDocumentStatusDesc CN_GoldenTaxDocumentStatusDesc
_GoldenTaxDocumentStatus _GoldenTaxDocumentStatus
_Language _Language 
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Status Text for Incomplete GTI Documents'
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED
}
@AbapCatalog: {
  sqlViewName: 'MDRCGTDOCSTST',
  compiler.compareFilter: true
}
@ObjectModel: {
  dataCategory: #TEXT,
  representativeKey: 'CN_GoldenTaxDocumentStatus',
  usageType: {
     dataClass:      #META,
     serviceQuality: #A,
     sizeCategory:   #S
   }
}
@AbapCatalog.preserveKey:true
define view MDRC_GTI_StatusText
  as select from dd07t

  association [0..1] to I_CN_GoldenTaxDocumentStatus as _GoldenTaxDocumentStatus on $projection.CN_GoldenTaxDocumentStatus = _GoldenTaxDocumentStatus.CN_GoldenTaxDocumentStatus
  association [0..1] to I_Language                   as _Language                on $projection.Language = _Language.Language
{
      @ObjectModel.foreignKey.association: '_GoldenTaxDocumentStatus'
  key substring(domvalue_l, 1, 1) as CN_GoldenTaxDocumentStatus,

      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key ddlanguage                  as Language,

      @Semantics.text: true
      ddtext                      as CN_GoldenTaxDocumentStatusDesc,

      //Associations

      _GoldenTaxDocumentStatus,
      _Language
}
where
  (
    dd07t.domname  = 'MDRC_GTI_STATUS'
  )
  and(
    dd07t.as4local = 'A'
  )
  union select from I_CN_GoldenTaxDocumentStatusT
{
  CN_GoldenTaxDocumentStatus,
  Language,
  CN_GoldenTaxDocumentStatusDesc,
  //Associations

  _GoldenTaxDocumentStatus,
  _Language
}
where 
  (   CN_GoldenTaxDocumentStatus = '2'
  or  CN_GoldenTaxDocumentStatus = '3'
  or  CN_GoldenTaxDocumentStatus = '4')
  and Language                   = $projection.language
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CN_GOLDENTAXDOCUMENTSTATUST",
"DD07T"
],
"ASSOCIATED":
[
"I_CN_GOLDENTAXDOCUMENTSTATUS",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More