I_CADocumentGLItem

G/L Document Item | view: ICADOCGLITEM | TRAN | Extraction: Not supported | Component: Contract Accounts Receivable and Payable
Tables used: DFKKOPKDFKKKOTFK001TFK001TT001TKA02T005
Column Name Description
CADocumentNumber Number of a FI-CA Document
CAGLItemNumber Item Number in FI-CA Document
Column Name Description
💲 Currency Key (Currency):
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
💲 Transaction Currency (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
Column Name Description
Column Name Description
ValueDate Value date
CATaxDate Decisive Date for Calculating Taxes
Column Name Description
ExchRateIsIndirectQuotation Exchange Rate Is Indirect Quotation Show values
CAInternalPostingReasonCode Reason for Automatic Creation of Posting Show values
CANegativePostingControlCode Control Field for Negative Posting Show values
CATransactionKeyAccountDetn Transaction key for account determination Show values
CAIsSeparateLineItemInGL Create Line Item in General Ledger Show values
CAContainsNonDeductibleInptTax Contains Non-Deductible Input Tax Show values
CATaxIsCalculatedExternally Tax on Sales/Purchases Was Calculated by Document Show values
CAAltvExchangeRateForTaxItem Alternative Exchange Rate for Tax Items Show values
CATaxItemHasAltvExchangeRate Alternative Exchange Rate for Tax Items Show values
CAAltvExchangeRateSetCode Alternative Exchange Rate for Tax Items Show values
CAIsCashFlowItem Document Contains Assignments from Cash Flows Show values
QuantitySignCode Quantity +/- Sign Show values
CashManagementLinkType Link Type Show values
CAItmIsCreatedByPostgInterface Item Created by Posting Interface Show values
CAStatusOfEuroConversion Status of Euro Conversion Show values
CAProfitAnalysisUpdtIsDirect CO-PA update done directly Show values
CACtrlFieldForAcctAssgmtDistr Control Field for Account Assignment Distributions Show values
CAUpdateMethodForFundsMgmt Update Method for FM - FI-CA Integration Show values
Column Name Description Domain name
CompanyCode Company Code BUKRS
BusinessArea Business Area GSBER
BusinessPlace Business Place J_1BBRANCH
Segment Segment for Segmental Reporting FB_SEGMENT
ProfitCenter Profit Center PRCTR
PartnerCompany Company ID of Trading Partner RCOMP
GLAccount G/L Account SAKNR
CAExchangeRate Absolute Exchange Rate FIS_UKURS
CAAccountAssignmentCategory Account Assignment Category KONTT_KK
CAAccountAssignment Acct assnmnt string for industry-specific account assngments CHAR50
CostCenter Cost Center KOSTL
SalesOrder Sales Order Number VBELN
SalesOrderItem Item number in Sales Order NUM06
CAReconciliationKey Reconciliation Key for General Ledger FIKEY_KK
LedgerGroup Ledger Group FAGL_LDGRP
ProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
ProfitabilitySegment_2 Profitability Segment RKEOBJNR_CHAR
ProfitabilitySegmentChanges Profitability Segment Changes (CO-PA) RKESUBNR
PlanningLevel Planning Level FDLEV
CARepetitionGroup Repetition group WHGRP_KK
ConditionType Condition Type KSCHL
TaxCode Tax on Sales/Purchases Code MWSKZ
CASupplementaryTaxCode Supplementary Tax MWSKZ
CAWithholdingTaxSupplement Withholding Tax Supplement QSSEW_KK
CAOtherTaxCode Tax Code for Other Taxes STRKZ_KK
CAGroupingCodeForTaxItems Grouping Key for Tax Items CHAR6
TaxJurisdiction Tax Jurisdiction TXJCD
CAEnteredTaxJurisdictionCode Tax Jurisdiction Code (Entered value) TXJCD
CATaxJurisdictionLevelCounter Level Counter for Multi-Level Taxes in Tax Jurisdiction NUM01
CATaxExceptionID Key for tax exception CHAR16
CATaxRate Tax rate STPRZ_KK
GrossIncomeTaxActivityCode Activity Code for Gross Income Tax J_1AGICD2
EmploymentTaxDistributionType Distribution Type for Employment Tax J_1ADTYP
CACashFlowAccount Originating Account in Cash Flow Anlaysis SAKNR
CACashFlowCompanyCode Partner Company Code for Cash Flow Analysis BUKRS
BankStatementShortID Short Key of Account Statement KUKEY_EB
BankStatementItem Memo Record Number (Line Item Number in Bank Statement) NUM5
CashManagementLink Link ID CHAR32
CAInvcgGroupingKey Grouping Key for Invoicing CHAR4
OriginalFinancialMgmtArea Original FM Area for FM Account Assignment FIKRS
OriglYearForFinMgmtAcctAssgmt Original Year for FM Account Assignment GJAHR
EarmarkedFunds Document Number for Earmarked Funds KBLNR
EarmarkedFundsDocument Document Number for Earmarked Funds KBLNR
Country Country/Region Key LAND1
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_CADOCUMENTGLITEM.MANDT == T006.MANDT
  • I_CADOCUMENTGLITEM.BASEUNIT == T006.MSEHI
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_CADOCUMENTGLITEM.CHARTOFACCOUNTS == T004.KTOPL
  • I_CADOCUMENTGLITEM.MANDT == T004.MANDT
Currency Key
  • Currency Key
  • Transaction Currency
  • Client
  • I_CADOCUMENTGLITEM.CURRENCY == TCURC.WAERS
  • I_CADOCUMENTGLITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_CADOCUMENTGLITEM.MANDT == TCURC.MANDT
House Bank Key
  • House Bank Key
  • Company Code
  • Client
  • I_CADOCUMENTGLITEM.HOUSEBANK == T012.HBKID
  • I_CADOCUMENTGLITEM.COMPANYCODE == T012.BUKRS
  • I_CADOCUMENTGLITEM.MANDT == T012.MANDT
House Bank Account
  • House Bank Key
  • House Bank Account
  • Company Code
  • Client
  • I_CADOCUMENTGLITEM.HOUSEBANK == T012K.HBKID
  • I_CADOCUMENTGLITEM.HOUSEBANKACCOUNT == T012K.HKTID
  • I_CADOCUMENTGLITEM.COMPANYCODE == T012K.BUKRS
  • I_CADOCUMENTGLITEM.MANDT == T012K.MANDT
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Client
  • I_CADOCUMENTGLITEM.TAXCALCULATIONPROCEDURE == T683.KALSM
  • I_CADOCUMENTGLITEM.[column in domain "KVEWE"] == T683.KVEWE
  • I_CADOCUMENTGLITEM.[column in domain "KAPPL"] == T683.KAPPL
  • I_CADOCUMENTGLITEM.MANDT == T683.MANDT