P_CNSLDTNDOMAINTEXT

CDS View

P_CNSLDTNDOMAINTEXT is a CDS View in S/4HANA. 19 CDS views read from this table.

Used by 19 CDS view(s)

CDS Views using this table (19)

ViewTypeJoinVDMDescription
A_CnsldtnInvmtActyTypeT view from BASIC Investment Activity Type - Text
A_CnsldtnOfInvestmentsActyT view from BASIC Investment Activity Type Text
I_CnsldtnAdhocSetBrkdwnTypeT view from BASIC Cnsldtn Ad Hoc Set Breakdown Type - Text
I_CnsldtnApportionmentT view from BASIC Consolidation Apportionment - Text
I_CnsldtnApportionmentText_2 view from BASIC Consolidation Apportionment - Text
I_CnsldtnBreakdownTypeT view from BASIC Consolidation Breakdown Type - Text
I_CnsldtnCrcyCnvrsnDiffTypeT view from BASIC Currency Cnvrsns Difference Type - Text
I_CnsldtnCrcyCnvrsnDiffTypeT_2 view from BASIC Currency Cnvrsns Difference Type - Text
I_CnsldtnDocTypeBusinessApplT view from BASIC Cnsldtn Doc Type Business Appl - Text
I_CnsldtnFinStmntItemTypeT view from BASIC Financial Statement Item Type - Text
I_CnsldtnInvmtActyT view from BASIC Investment Activity - Text
I_CnsldtnMDSourceT view from BASIC Master Data Source - Text
I_CnsldtnPostingLevelText_2 view from BASIC Consolidation Posting Level - Text
I_CnsldtnReportingLevelT view from BASIC Consolidation Reporting Level - Text
I_CnsldtnReportingLevelText_2 view from BASIC Consolidation Reporting Level - Text
I_CnsldtnTaskCategoryText view from BASIC Consolidation Task Category - Text
I_CnsldtnVersionRunModeText view from BASIC Consolidation Version Run Mode - Text
I_CnsldtnVersionTypeText view from BASIC Consolidation Version Type - Text
P_CnsldtnCurrencySourceText view from BASIC 
@AbapCatalog:{
  sqlViewName: 'PCSDOMAINTEXT',
  compiler.compareFilter: true,
  preserveKey: true
  }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {
    usageType: {
        dataClass: #META,
        serviceQuality: #A,
        sizeCategory: #S
    }
//  dataCategory: #TEXT not allowed in original views, ATC-2

  }
@VDM:{
  viewType: #BASIC,
  private: true
  }

/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ]  } */
define view P_CnsldtnDomainText
  with parameters
    P_DomainName : domname

  as select from dd07t as _DomainT

  association [1..1] to I_Language as _Language on $projection.Language = _Language.Language
  
{
  key cast(_DomainT.ddlanguage as spras preserving type )                 as Language,

  key _DomainT.domvalue_l                                                 as DomainValue,

      cast(_DomainT.ddtext as fincs_description_text_60 preserving type ) as DomainValueText,


      _Language
}
where
      _DomainT.domname  = $parameters.P_DomainName
  and _DomainT.as4local = 'A';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T"
],
"ASSOCIATED":
[
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More