P_PROJSEMTAGACCTWITHPROJSTOCK

CDS View

GL Accounts for Semantic Tag

P_PROJSEMTAGACCTWITHPROJSTOCK is a CDS View in S/4HANA. GL Accounts for Semantic Tag. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_ProjActualCostLineItems view inner COMPOSITE Project Cost Line Items with Actual Costs
P_ProjCmtmtCostLineItms view inner COMPOSITE Project Cost Line Items with Commitment Costs 
//@AbapCatalog.sqlViewName: 'PPRJSEMTAGACPRST'

//@AbapCatalog.compiler.compareFilter:true

@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #MIXED
//@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.private:true

//This view was created based on P_PROJECTSEMTAGACC view. 

//The only difference is that current view was enhanced to include Project Stocks


define view entity P_ProjSemTagAcctWithProjStock
  as select from I_ControllingArea         as _ContArea
    inner join   R_ProjectSemTagGLAccount  as _SemTagGL on _ContArea.CtrlgStdFinStatementVersion = _SemTagGL.GLAccountHierarchy
  // inner join   P_SEMTAGVERMAP           as _ChildTag on _SemTagGL.SemanticTag = _ChildTag.SemanticTag

    inner join   P_SemTagActCostAndProjStk as _ChildTag on _SemTagGL.SemanticTag = _ChildTag.SemanticTag

{
  _ContArea.ControllingArea,
  @ObjectModel.foreignKey.association: '_Hierarchy'
  _SemTagGL.GLAccountHierarchy,
  _ChildTag.SemanticTag,
  _ChildTag.ParentSemanticTag,
  @Semantics.businessDate.to: true
  _SemTagGL.ValidityEndDate,
  @Semantics.businessDate.from: true
  _SemTagGL.ValidityStartDate,
  _SemTagGL.HierarchyNodeClass,
  _SemTagGL.HierarchyNodeVal,
  _SemTagGL._Hierarchy

}

where
        _ContArea.CtrlgStdFinStatementVersion is not initial
  and(
        _SemTagGL.ValidityStartDate                     <= $session.system_date
    and _SemTagGL.ValidityEndDate                       >= $session.system_date
  )

Learn More