P_GLAccountSemTagInCompanyCode

Get GLaccount in one company code according to semantic tag | view: PGLACCTBUKRS | Extraction: Not supported | Component: Closing Operations / Period-End
Column Name Description
GLAccount FK G/L Account Number
CompanyCode FK Company Code
AccountingPrinciple FK Accounting Principle
SemanticTag FK Semantic Tag of a Hierarchy Node
ChartOfAccounts Chart of Accounts
Column Name Description
Column Name Description
Column Name Description
ValidityStartDate Valid-From Date
ValidityEndDate FK Valid To Date
Column Name Description
ReconciliationAccountType Account is Reconciliation Account Show values
AccountIsOpenItemManaged Indicator: Open Item Management? Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Accounting Principle
  • Client
  • Accounting Principle
  • P_GLACCOUNTSEMTAGINCOMPANYCODE.MANDT == TACC_PRINCIPLE.MANDT
  • P_GLACCOUNTSEMTAGINCOMPANYCODE.ACCOUNTINGPRINCIPLE == TACC_PRINCIPLE.ACC_PRINCIPLE
Company Code
  • Client
  • Company Code
  • P_GLACCOUNTSEMTAGINCOMPANYCODE.MANDT == T001.MANDT
  • P_GLACCOUNTSEMTAGINCOMPANYCODE.COMPANYCODE == T001.BUKRS
G/L Account Number
  • ?
  • G/L Account Number
  • Client
  • P_GLACCOUNTSEMTAGINCOMPANYCODE.[column in domain "KTOPL"] == SKA1.KTOPL
  • P_GLACCOUNTSEMTAGINCOMPANYCODE.GLACCOUNT == SKA1.SAKNR
  • P_GLACCOUNTSEMTAGINCOMPANYCODE.MANDT == SKA1.MANDT
Semantic Tag of a Hierarchy Node
  • Client
  • Semantic Tag of a Hierarchy Node
  • P_GLACCOUNTSEMTAGINCOMPANYCODE.MANDT == FINSC_SEM_TAG.MANDT
  • P_GLACCOUNTSEMTAGINCOMPANYCODE.SEMANTICTAG == FINSC_SEM_TAG.FINS_SEM_TAG