P_ProjSemTagAcctWithProjStock

DDL: P_PROJSEMTAGACCTWITHPROJSTOCK SQL: PPRJSEMTAGACPRST Type: view_entity COMPOSITE Package: ODATA_PS_COS_PROJCOSTLINEITEM

GL Accounts for Semantic Tag

P_ProjSemTagAcctWithProjStock is a Composite CDS View that provides data about "GL Accounts for Semantic Tag" in SAP S/4HANA. It reads from 3 data sources (P_SemTagActCostAndProjStk, I_ControllingArea, R_ProjectSemTagGLAccount) and exposes 9 fields. Part of development package ODATA_PS_COS_PROJCOSTLINEITEM.

3 data source(s) 9 fields

Data Sources (3)

SourceAliasJoin Type
P_SemTagActCostAndProjStk _ChildTag inner
I_ControllingArea _ContArea from
R_ProjectSemTagGLAccount _SemTagGL inner

Annotations (6)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view

Fields (9)

KeyFieldSource TableSource FieldDescription
ControllingArea I_ControllingArea ControllingArea
GLAccountHierarchy R_ProjectSemTagGLAccount GLAccountHierarchy
SemanticTag P_SemTagActCostAndProjStk SemanticTag
ParentSemanticTag P_SemTagActCostAndProjStk ParentSemanticTag
ValidityEndDate R_ProjectSemTagGLAccount ValidityEndDate
ValidityStartDate R_ProjectSemTagGLAccount ValidityStartDate
HierarchyNodeClass R_ProjectSemTagGLAccount HierarchyNodeClass
HierarchyNodeVal R_ProjectSemTagGLAccount HierarchyNodeVal
_Hierarchy R_ProjectSemTagGLAccount _Hierarchy 
//@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