I_CATotalsRecord

Contract Accounts Receivable and Payable Posting Totals | view: ICATOTREC | TRAN | Extraction: Not supported | Component: Contract Accounts Receivable and Payable
Tables used: DFKKSUMT001TKA02
Column Name Description
CompanyCode FK Company Code
CAReconciliationKey FK Reconciliation Key for General Ledger
DebitCreditCode Debit/Credit Indicator Show values
GLAccount FK General Ledger Account
BusinessArea FK Business Area
CAHashCodeOfAccountAssignments Hash Code Using Account Determination Fields
CATotalsRecordSequenceNumber Number of Summary Records for Reconciliation Key
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
CAAmountInLocalCurrency Amount In Local Currency With +/- Signs
CAAmountInSecondCurrency Amount in Second Parallel Currency with +/- Sign
CAAmountInThirdCurrency Amount in Third Parallel Currency with +/- Sign
CATaxBaseAmountInLocalCurrency Amount Subject to Tax in Local Currency (Tax Base Amount)
CANonDeductibleTxAmtInLoclCrcy Non-Deductible Tax Amount in Local Currency
CATaxPortionInLocalCurrency Tax Portion in FI-CA Local Currency
💲 Currency Key (TransactionCurrency):
CAAmountInTransactionCurrency Amount in Transaction Currency with +/- Sign
CATaxBaseAmount Amount Subject to Tax in Transaction Currency (Tax Base Amt)
CANonDeductibleTxAmtInDocCrcy Non-Deductible Tax Amount in Document Currency
CATaxPortionInTransCurrency Tax Amount as Statistical Information in Document Currency
💲 Update Currency for General Ledger Transaction Figures (CAGLPostingCurrency):
CAGLPostingAmount Amount for Updating in General Ledger
Column Name Description
Column Name Description
CAPostingDate Posting Date in the Document
CATaxDate Decisive Date for Calculating Taxes
DocumentDate Journal Entry Date
ValueDate Value date
CAGenLdgrTransfAltvPostingDate Alternative posting date for transfer to general ledger
TaxReportingDate Tax Reporting Date
Column Name Description
DebitCreditCode Debit/Credit Indicator Show values
CALineItemIsCreatedInGLDoc Line Item in Individual Document Show values
CATotalsRecordIsTaxItem Tax Item Show values
IsNegativePosting Negative Posting Show values
CAIsCashFlowItem Document Contains Assignments from Cash Flows Show values
CAContainsNonDeductibleInptTax Contains Non-Deductible Input Tax Show values
QuantitySignCode Quantity +/- Sign Show values
CAUpdateMethodForFundsMgmt Update Method for FM - FI-CA Integration Show values
CATotalsRecdIsDrctTrnsfdToGL Direct Transfer to G/L Accounting Show values
Column Name Description Domain name
CABPItemNumber Item Number in FI-CA Document OPUPK_KK
BusinessPlace Business Place J_1BBRANCH
Segment Segment for Segmental Reporting FB_SEGMENT
CostCenter Cost Center KOSTL
ProfitCenter Profit Center PRCTR
SalesOrder Sales Order Number VBELN
SalesOrderItem Item number in Sales Order NUM06
ProfitabilitySegment Profitability Segment Number (CO-PA) RKEOBJNR
ProfitabilitySegmentChanges Profitability Segment Changes (CO-PA) RKESUBNR
PlanningLevel Planning Level FDLEV
TaxCode Tax on Sales/Purchases Code MWSKZ
TransactionTypeDetermination Transaction Key CHAR3
CATaxRate Tax rate STPRZ_KK
TaxJurisdiction Tax Jurisdiction TXJCD
CAEnteredTaxJurisdictionCode Tax Jurisdiction Code (Entered value) TXJCD
CATaxJurisdictionLevelCounter Level Counter for Multi-Level Taxes in Tax Jurisdiction NUM01
ConditionType Condition Type KSCHL
PartnerCompany Company ID of Trading Partner RCOMP
CAAccountAssignmentCategory Account Assignment Category KONTT_KK
CAAccountAssignment Acct assnmnt string for industry-specific account assngments CHAR50
CADocumentTypeForGLTransfer Document Type for Transfer to General Ledger BLART
LedgerGroup Ledger Group FAGL_LDGRP
CACashFlowAccount Originating Account in Cash Flow Anlaysis SAKNR
CACashFlowCompanyCode Partner Company Code for Cash Flow Analysis BUKRS
OriginalFinancialMgmtArea Original FM Area for FM Account Assignment FIKRS
OriglYearForFinMgmtAcctAssgmt Original Year for FM Account Assignment GJAHR
CATotalsRecordCrrtnLevelValue Correction level for incorrect totals records NUM02
CANrOfDocsTrnsfdToGLRefVal Reference to Document Counter NUM07
Master Data Relations Join Conditions
Business Area
  • Business Area
  • Client
  • I_CATOTALSRECORD.BUSINESSAREA == TGSB.GSBER
  • I_CATOTALSRECORD.MANDT == TGSB.MANDT
Reconciliation Key for General Ledger
  • Reconciliation Key for General Ledger
  • Client
  • I_CATOTALSRECORD.CARECONCILIATIONKEY == DFKKSUMC.FIKEY
  • I_CATOTALSRECORD.MANDT == DFKKSUMC.MANDT
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_CATOTALSRECORD.MANDT == T004.MANDT
  • I_CATOTALSRECORD.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • I_CATOTALSRECORD.MANDT == T001.MANDT
  • I_CATOTALSRECORD.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Currency Key
  • Company Code Currency
  • Client
  • I_CATOTALSRECORD.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_CATOTALSRECORD.COMPANYCODECURRENCY == TCURC.WAERS
  • I_CATOTALSRECORD.MANDT == TCURC.MANDT
General Ledger Account
  • General Ledger Account
  • Client
  • Chart of Accounts
  • I_CATOTALSRECORD.GLACCOUNT == SKA1.SAKNR
  • I_CATOTALSRECORD.MANDT == SKA1.MANDT
  • I_CATOTALSRECORD.CHARTOFACCOUNTS == SKA1.KTOPL
House Bank Key
  • Client
  • House Bank Key
  • Company Code
  • I_CATOTALSRECORD.MANDT == T012.MANDT
  • I_CATOTALSRECORD.HOUSEBANK == T012.HBKID
  • I_CATOTALSRECORD.COMPANYCODE == T012.BUKRS
House Bank Account
  • Client
  • House Bank Key
  • Company Code
  • House Bank Account
  • I_CATOTALSRECORD.MANDT == T012K.MANDT
  • I_CATOTALSRECORD.HOUSEBANK == T012K.HBKID
  • I_CATOTALSRECORD.COMPANYCODE == T012K.BUKRS
  • I_CATOTALSRECORD.HOUSEBANKACCOUNT == T012K.HKTID
Currency Key
  • Currency Key
  • Company Code Currency
  • Client
  • I_CATOTALSRECORD.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_CATOTALSRECORD.COMPANYCODECURRENCY == TCURC.WAERS
  • I_CATOTALSRECORD.MANDT == TCURC.MANDT