C_BalanceAuditTrail

Line Items for Balance Audit Trail | view: CFINS_BAT_ITEMS | Extraction: Not supported | Component: Information System
Tables used: BSEGT001TKA02KNA1LFA1FINSC_FISC_DATE
Column Name Description
CompanyCode Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
LedgerGLLineItem Posting Row
Column Name Description
💲 Local Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Local Currency
Column Name Description
Column Name Description
ClearingDate Clearing Date
PostingDate Posting Date in the Document
ClearingCreationDate Clearing Entry Date
DocumentDate Document Date in Document
Column Name Description
AccountingDocumentCategory Document Category Show values
IsCleared Clearing Indicator Show values
DebitCreditCode Debit Credit Indicator Show values
FinancialAccountType Account type Show values
IsOpenItemManaged Indicator: Open Item Management? Show values
Column Name Description Domain name
ClearingAccountingDocument Document Number of the Clearing Document BELNR
FiscalPeriod Fiscal Period MONAT
Customer Customer Number KUNNR
Supplier Account Number of Supplier LIFNR
ProfitCenter Profit Center PRCTR
AssignmentReference Assignment Reference ZUONR
DocumentItemText Document Item Text TEXT50
ClearingFiscalPeriod Clearing Fiscal Period POPER
ClearingFiscalYear Clearing Fiscal Year GJAHR
CompanyCodeName Name of Company Code or Company TEXT25
CustomerName Customer Name TEXT80
SupplierName Supplier Name TEXT80
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_BALANCEAUDITTRAIL.BASEUNIT == T006.MSEHI
  • C_BALANCEAUDITTRAIL.MANDT == T006.MANDT
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_BALANCEAUDITTRAIL.MANDT == T004.MANDT
  • C_BALANCEAUDITTRAIL.CHARTOFACCOUNTS == T004.KTOPL
Document Type
  • Document Type
  • Client
  • C_BALANCEAUDITTRAIL.DOCUMENTTYPE == T003.BLART
  • C_BALANCEAUDITTRAIL.MANDT == T003.MANDT
General Ledger Account
  • Company Code
  • General Ledger Account
  • Client
  • C_BALANCEAUDITTRAIL.COMPANYCODE == SKB1.BUKRS
  • C_BALANCEAUDITTRAIL.GLACCOUNT == SKB1.SAKNR
  • C_BALANCEAUDITTRAIL.MANDT == SKB1.MANDT
Tax on sales/purchases code
  • ?
  • Client
  • Tax on sales/purchases code
  • C_BALANCEAUDITTRAIL.[column in domain "KALSM_D"] == T007A.KALSM
  • C_BALANCEAUDITTRAIL.MANDT == T007A.MANDT
  • C_BALANCEAUDITTRAIL.TAXCODE == T007A.MWSKZ