P_CNSLDTNDOMAIN

CDS View

Consolidation General Domain

P_CNSLDTNDOMAIN is a CDS View in S/4HANA. Consolidation General Domain. 25 CDS views read from this table.

CDS Views using this table (25)

ViewTypeJoinVDMDescription
A_CnsldtnInvmtActyType view from BASIC Investment Activity Type
A_CnsldtnOfInvestmentsActivity view from BASIC Consolidation of Investments Activity
I_CnsldtnAdhocSetBrkdwnType view from BASIC Consolidation Ad Hoc Set Breakdown Type
I_CnsldtnApportionment view from BASIC Consolidation Apportionment
I_CnsldtnBreakdownType view from BASIC Consolidation Breakdown Type
I_CnsldtnCrcyCnvrsnDiffType view from BASIC Currency Conversion Difference Type
I_CnsldtnDocTypeBusinessAppl view from BASIC Cnsldtn Doc Type Business Appl
I_CnsldtnFinStmntItemType view_entity from BASIC Financial Statement Item Type
I_CnsldtnFSItemTypeSignLogic view_entity from BASIC Consolidation FS Item Type Sign Logic
I_CnsldtnInvmtActy view from BASIC Investment Activity
I_CnsldtnJrnlEntrSource view from BASIC Consolidation Journal Entry Source
I_CnsldtnJrnlEntryItemOrigin view_entity from BASIC Consolidation Journal Entry Item Origin
I_CnsldtnLfcycOperationType view_entity from BASIC Lifecycle Operation Type
I_CnsldtnMDSource view from BASIC Master Data Source
I_CnsldtnPostingLevel view from BASIC Consolidation Posting Level
I_CnsldtnPostingLevel_2 view_entity from BASIC Consolidation Posting Level
I_CnsldtnQuestionType view_entity from BASIC Consolidation Question Type
I_CnsldtnReportingLevel view from BASIC Consolidation Reporting Level
I_CnsldtnSignLogicType view_entity from BASIC Consolidation Sign Logic Type
I_CnsldtnSystemMessageType view_entity from BASIC Consolidation System Message Type
I_CnsldtnTaskCategory view from BASIC Consolidation Task Category
I_CnsldtnTaskLogItemType view_entity from BASIC Consolidation Task Log Item Type
I_CnsldtnVersionRunMode view from BASIC Consolidation Version Run Mode
I_CnsldtnVersionType view from BASIC Consolidation Version Type
P_CnsldtnCurrencySource view from BASIC Consolidation Currency Source
@AbapCatalog:{
  sqlViewName: 'PCSDOMAIN',
  compiler.compareFilter: true
  }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {
    usageType: {
        dataClass: #META,
        serviceQuality: #A,
        sizeCategory: #S
    },
    resultSet.sizeCategory: #XS
}
@VDM:{
  viewType: #BASIC,
  private: true
  }

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

  as select from dd07l as _Domain

{
  key      _Domain.domvalue_l as DomainValue

}
where
      _Domain.domname  = $parameters.P_DomainName
  and _Domain.as4local = 'A';