P_MX_FinStmntWthTrialBalance

Financial Statement with Trial Balances | view: PMXFINSTMTTRLBAL | Extraction: Not supported | Component: Financials Mexico
Column Name Description
HierarchyNodeUniqueID Hierarchy node
FinancialStatementVariant FK G/L Account Hierarchy
ChartOfAccounts Chart of Accounts
ValidityEndDate Validity End Date
CompanyCode Company Code
Ledger FK Ledger in General Ledger Accounting
AccountingDocument Journal Entry
FiscalYear Fiscal Year
LedgerGLLineItem Ledger Journal Entry Item
GLAccount General Ledger Account
StatryRptCategory FK Report Category ID
StatryRptgEntity FK Reporting Entity
StatryRptRunID Report Run ID
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
StartingBalanceAmtInCoCodeCrcy Starting Balance in Company Code Currency
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
EndingBalanceAmtInCoCodeCrcy Ending Balance in Company Code Currency
💲 Reporting Currency (ReportingCurrency):
StartingBalanceAmtInRptgCrcy Starting Balance Amount in Reporting Currency
DebitAmountInReportingCurrency Debit Amount in Reporting Currency
CreditAmountInReportingCrcy Credit Amount in Reporting Currency
EndingBalanceAmtInRptgCrcy Ending Balance Amount in Reporting Currency
Column Name Description
Column Name Description
ValidityEndDate Validity End Date
ValidityStartDate Validity Start Date
PostingDate Posting Date
Column Name Description
FinancialStatementNodeType Hierarchy node type Show values
Column Name Description Domain name
AccountingDocumentItem Journal Entry Posting View Item BUZEI
FinancialStatementItem null
FiscalPeriod Fiscal Period POPER
VATRegistration VAT Registration Number STCEG
GLAccountType null
GLAccountInfo G/L Account Long Text TEXT50
MX_SATGLAccountGrouping null
Master Data Relations Join Conditions
Company Code Currency
  • Company Code Currency
  • Client
  • P_MX_FINSTMNTWTHTRIALBALANCE.COMPANYCODECURRENCY == TCURC.WAERS
  • P_MX_FINSTMNTWTHTRIALBALANCE.MANDT == TCURC.MANDT
G/L Account Group
  • ?
  • G/L Account Group
  • Client
  • P_MX_FINSTMNTWTHTRIALBALANCE.[column in domain "KTOPL"] == T077S.KTOPL
  • P_MX_FINSTMNTWTHTRIALBALANCE.GLACCOUNTGROUP == T077S.KTOKS
  • P_MX_FINSTMNTWTHTRIALBALANCE.MANDT == T077S.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Reporting Entity
  • Client
  • Reporting Entity
  • P_MX_FINSTMNTWTHTRIALBALANCE.MANDT == SRF_RPG_ENT.MANDT
  • P_MX_FINSTMNTWTHTRIALBALANCE.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY