R_PROJECTSEMTAGGLACCOUNT

CDS View

GL Accounts for Semantic Tag

R_PROJECTSEMTAGGLACCOUNT is a CDS View in S/4HANA. GL Accounts for Semantic Tag. It contains 8 fields. 9 CDS views read from this table.

Used by 9 CDS view(s) 8 fields

CDS Views using this table (9)

ViewTypeJoinVDMDescription
P_GetAllChildSemanticTag view from COMPOSITE Fetches all the child semantic tag for Act Cost & Budget
P_GetBudgetRlvtSemanticTagAll view_entity inner COMPOSITE Get All Semantic Tags for the Project
P_GetBudgetSemanticTag view from COMPOSITE Fetches Budget Semantic Tag
P_ProjActlPlnJrnlEntrItm view inner COMPOSITE Project Actual Plan Journal Entry Items
P_ProjCostAcctgLineItms view inner COMPOSITE Projects with Accounting Cost Line Items
P_PROJECTSEMTAGACC view inner COMPOSITE GL Accounts for Semantic Tag
P_ProjectStockAcctSemanticTag view inner COMPOSITE Project stock account semantic tag
P_ProjSemTagAcctWithProjStock view_entity inner COMPOSITE GL Accounts for Semantic Tag
P_WPMO_PROJCOSTLINEITEMS view inner COMPOSITE PPM Project Cost Line Items

Fields (8)

KeyField CDS FieldsUsed in Views
KEY GLAccountHierarchy FinancialStatementVariant,GLAccountHierarchy 6
KEY SemanticTag SemanticTag 7
_Hierarchy _Hierarchy 1
HierarchyNode HierarchyNode,NodeValue 2
HierarchyNodeClass HierarchyNodeClass 3
HierarchyNodeVal HierarchyNodeVal 3
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 3 
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@EndUserText.label: 'GL Accounts for Semantic Tag'
@AbapCatalog.sqlViewName: 'RPROJSEMTAGGLACT'
@AbapCatalog.compiler.compareFilter:true 
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE

define view R_ProjectSemTagGLAccount
  as select from P_SemTagGLAccount

{
  @ObjectModel.foreignKey.association: '_Hierarchy'
  GLAccountHierarchy,
  //      @ObjectModel.foreignKey.association: '_GLAccountHierarchyNode'

  @ObjectModel.foreignKey.association: '_SemanticTag'
  SemanticTag,
  HierarchyNode,  /*CE2308:Global Hierarchy*/
  @Semantics.businessDate.to: true
  ValidityEndDate,
  @Semantics.businessDate.from: true
  ValidityStartDate,
   cast( ChartOfAccounts as nodecls) as HierarchyNodeClass,
//  ChartOfAccounts as HierarchyNodeClass ,

  GLAccount as HierarchyNodeVal,
  _Hierarchy,
  _SemanticTag

}

Learn More