I_SEMTAGGLACCOUNT

CDS View

G/L Account with Semantic Tag

I_SEMTAGGLACCOUNT is a CDS View in S/4HANA. G/L Account with Semantic Tag. It contains 8 fields. 35 CDS views read from this table.

Used by 35 CDS view(s) 8 fields

CDS Views using this table (35)

ViewTypeJoinVDMDescription
F_GLAccountBySemanticTag view_entity from DERIVATION_FUNCTION G/L Accounts By Semantic Tag
FIS_COGS view inner Cost of Goods Sold
I_SemTagFinStmntLeafItem view from COMPOSITE Financial Statement Leaf Items for Semantic Tag
I_SemTagFinStmntLeafItem view union_all COMPOSITE Financial Statement Leaf Items for Semantic Tag
I_StatementOfChanges view right_outer COMPOSITE Statement of Changes line items
P_AcctgPrncpGLAcctSemTagValdty view from COMPOSITE Get GLaccount according to semantic tag
P_ActualPlanBalFlowSemtag view inner COMPOSITE P_ActualPlanBalFlowSemtag
P_ActualPlanGLAcctBalance view_entity inner COMPOSITE Actual Plan G/L Account Balances
P_EBRRProjMntrSemanticTagCalc view_entity inner COMPOSITE EBRR Monitor: Project (2) - helper CDS for Semantic Tags
P_EBRRPrvdrContrSemTagCalc view_entity inner COMPOSITE Provider Contract Semantic tag calculation
P_EBRRSDMonSemTagCalc view_entity inner COMPOSITE EBRR: Service Document Semantic tag calculation
P_EBRRSvdMonSemtagCalc view_entity inner COMPOSITE EBRR: Service Document Semantic tag calculation
P_EntProjLineItemSemTagGLAcct view_entity inner COMPOSITE EntProj Line Item with Semantic Tag
P_EvtBsdRevnRecgnProjMntrAmt view_entity inner COMPOSITE EBRR Monitor: Project amount sums
P_EvtBsdRevnRecgnProjMntrAmtST view_entity inner COMPOSITE P_EvtBsdRevnRecgnProjMntrAmt using Slalittypes
P_GLAccountLineItemSemTagGLACC view inner COMPOSITE G/L Acc Line Item with Semantic Tag
P_GLAcctFlowSemTagDateFunc view_entity inner COMPOSITE P_GLAcctFlowSemTagDateFunc
P_GLAcctFlowSemTagDateFunc2 view_entity inner COMPOSITE P_GLAcctFlowSemTagDateFunc2
P_GLAcctItemBrkDwnData view_entity inner COMPOSITE G/L Account Line Items with Breakdown
P_GLAcctItemCostBrkDwnDisCrcy view_entity inner COMPOSITE Private View of G/L Account Line Item with Currency Cube
P_GLAcctItemCurrencyRole view_entity inner COMPOSITE Private View of G/L Account Line Item with Currency Cube
P_GLAcctLineItemSemTagGLAcct view inner COMPOSITE G/L Account Line Item with Semantic Tag
P_GLAcctLineItemSemTagRevProj view_entity inner COMPOSITE GL Account Line Item with Semantic Tag
P_GLIncgOrdPrdtvAnalysisUnion view inner COMPOSITE Incoming Sales Orders Union
P_GrossMarginUnion_2 view inner COMPOSITE Gross Margin Union
P_PE_GLAccountLineItemSemTag view_entity inner CONSUMPTION Peru - G/L Account Line Item with Semantic Tag
P_PlanLineItemSemTagGLAcc view inner COMPOSITE Plan Line Item with Semantic Tag for G/L Acc
P_PlnLineItemSemTagGLAcct view inner COMPOSITE Plan Line Item With Semantic Tag G/L Acc
P_ProjectFinancialSummary view inner COMPOSITE Project Financial Summary
P_SRVCDOCREVNRECGNCHSTBASE view_entity left_outer CONSUMPTION Revenue Recognition Monitor Base View
P_SrvcDocRevnRecgnSTBase view_entity inner CONSUMPTION P_SrvcDocRevnRecgnJEBaseHome
P_Trrmonbase view_entity inner COMPOSITE Revenue Recognition Monitor Base View
P_Trrmonchart view_entity inner COMPOSITE Revn Recn Monitor Chart Base View
P_Trrsobase view_entity inner COMPOSITE Base View TRR for Sales Order
P_Trrsochartbase view_entity inner COMPOSITE Base View TRR for SalOrd.Chart

Fields (8)

KeyField CDS FieldsUsed in Views
KEY ChartOfAccounts ChartOfAccounts 1
KEY GLAccountHierarchy GLAccountHierarchy 12
KEY SemanticTag SemanticTag 14
KEY ValidityEndDate ValidityEndDate 5
KEY ValidityStartDate ValidityStartDate 5
_Hierarchy _Hierarchy 2
_SemanticTag _SemanticTag 2
HierarchyNode HierarchyNode 3 
@EndUserText.label: 'G/L Account with Semantic Tag'
@AbapCatalog.sqlViewName: 'IFISEMTAGGLACCT'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@Analytics: { dataCategory: #CUBE,
              dataExtraction.enabled: true
            }
//@ObjectModel.representativeKey: 'SemanticTag'

@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.modelingPattern: #ANALYTICAL_CUBE
@ObjectModel.supportedCapabilities: [ #ANALYTICAL_PROVIDER,
                                      #SQL_DATA_SOURCE,
                                      #CDS_MODELING_DATA_SOURCE,
                                      #CDS_MODELING_ASSOCIATION_TARGET,
                                      #EXTRACTION_DATA_SOURCE]
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions:true
@ObjectModel.sapObjectNodeType.name:'SemanticTagGeneralLedger'

define view I_SemTagGLAccount
  as select distinct from P_SemTagGLAccount

  association [0..*] to I_GLAccountHierarchyNode as _GLAccountHierarchyNode on  $projection.GLAccountHierarchy = _GLAccountHierarchyNode.GLAccountHierarchy
                                                                            and $projection.HierarchyNode      = _GLAccountHierarchyNode.HierarchyNode

{
  @ObjectModel.foreignKey.association: '_Hierarchy'
  GLAccountHierarchy,
  cast ( '' as hrynode )                                                                          as HierarchyNode,
  @ObjectModel.foreignKey.association: '_SemanticTag'
  SemanticTag,
  @Semantics.businessDate.to: true
  ValidityEndDate,
  @Semantics.businessDate.from: true
  ValidityStartDate,
  @ObjectModel.foreignKey.association: '_ChartOfAccounts'
  ChartOfAccounts,
  @ObjectModel.foreignKey.association: '_GLAccountInChartOfAccounts'
  GLAccount,
  FunctionalAreaIsUsed,
  cast( case when SemanticTag = 'NTINC_ALAC' then '' else FunctionalAreaIsUsed end as xfber_011 ) as IsFunctionalAreaPermitted,
  _Hierarchy,
  //OBSOLETING, DO NOT USE THIS ASSOCIATION!!!

  _GLAccountHierarchyNode,
  _SemanticTag,
  _ChartOfAccounts,
  _GLAccountInChartOfAccounts

}

Learn More