I_CAOpenItemListItem

Entries for Open Item Lists | view: ICAOPENITMLSTITM | TRAN | Extraction: Not supported | Component: Contract Accounts Receivable and Payable
Tables used: DFKKOP_LISTPT001TKA02T005
Column Name Description
CAOpenItemListUUID Key for Business Partner Item (in OI Lists)
CADocumentNumber Number of a FI-CA Document
CARepetitionItemNumber Repetition Item in FI-CA Document
CABPItemNumber Item Number in FI-CA Document
CASubItemNumber Subitem for a Partial Clearing in Document
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
CATaxAmountInLocalCurrency Tax Amount in Local Currency With +/- Sign
CATaxAmountInSecondCurrency Tax Amount in Second Parallel Currency
CATaxAmountInThirdCurrency Tax Amount in Third Parallel Currency
CATaxPortionInLocalCurrency Tax Portion in FI-CA Local Currency
💲 Transaction Currency (TransactionCurrency):
CAAmountInTransactionCurrency Amount in Transaction Currency with +/- Sign
CAEligibleAmountForCshDiscount Amount Eligible for Cash Discount in Document Currency
CATaxAmountInTransCurrency Tax Amount in Transaction Currency with +/- Sign
CABaseAmountForWithholdingTax Tax Base Amount
CAWithholdingTaxAmount Withholding Tax Amount (in Document Currency)
CATaxPortionInTransCurrency Tax Amount as Statistical Information in Document Currency
PlannedAmtInTransactionCrcy Planned Amount in Transaction Currency
💲 Clearing Currency (CAClearingCurrency):
CAClearingAmountInClearingCrcy Clearing amount in clearing currency
CATaxAmountInClearingCrcy Tax Amount in Clearing Currency
CACashDiscAmountInClearingCrcy Cash Discount Granted/Surcharge Levied in Clearing Currency
💲 Update Currency for General Ledger Transaction Figures (CAGLPostingCurrency):
CAGLPostingAmount Amount for Updating in General Ledger
CAGLPostingTaxAmount Tax Amount for Update in General Ledger
Column Name Description
Column Name Description
CAStartDateOfBillingPeriod Lower Limit of Billing Period
CAEndDateOfBillingPeriod Upper Limit of the Billing Period
DocumentDate Journal Entry Date
CAPostingDate Posting Date in the Document
CANetDueDate Due date for net payment
CADeferralDate Deferral to
CACashDiscountDueDate Due Date for Cash Discount
CATaxDate Decisive Date for Calculating Taxes
CAClearingDate Clearing Date
CAPostingDateOfClearingDoc Clearing Document Posting Date
CAValueDateForClearing Value date for clearing
CASEPAPreNotifExecutionDate SEPA: Date of Execution of Direct Debit Pre-Notifcation
Column Name Description
CASubApplication Subapplication in Contract Accounts Receivable and Payable Show values
CAApplicationArea Application Area Show values
CADoubtfulOrValueAdjmtCode Doubtful Item Entry/Individual Value Adjustment Show values
CAIsDownPaymentRequest Item is a Down Payment/Down Payment Request Show values
CAItemIsOnlyForSettlement Item Can Only Be Cleared Show values
CAStatisticalItemCode Type of statistical item Show values
CAChangeIsForbidden Printing - No Changes Possible Show values
CARoundingItemCode Type of Rounding Item Show values
CAInternalPostingReasonCode Reason for Automatic Creation of Posting Show values
CAWorkflowCheckProcess Editing Process To Be Confirmed Show values
CANegativePostingControlCode Control Field for Negative Posting Show values
CAPartnerSettlementStatus Status of Partner Settlement Using Billable Items Show values
CAIsPartOfJointLiability Item Is Part of a Collaborative Liability Show values
CASubstituteDocumentCategory Category of Substitute Document in FI-CA Show values
CAStatisticalCodeOfOriginItem Statistical Key of the Initiating Item Show values
CAWithholdingTaxCategory Line Item Category From Withholding Tax View Show values
CATaxIsCalculatedExternally Tax on Sales/Purchases Was Calculated by Document Show values
CAPaymentSpecificationCategory Category of Payment Specification Show values
CAClearingStatus Clearing Status Show values
CAClearingRestrictionCode Clearing restriction Show values
CAClearingPostingIsReset Clearing posting reversed Show values
CAItemIsWithdrawn Item Canceled Show values
CAItemIsExcludedFromDunning Exclude Item from Dunning Run Show values
CAIsIncludedInCollectionCase Item Is Included in Collection Case Show values
CAIsSeparateLineItemInGL Create Line Item in General Ledger Show values
CAIsCashFlowItem Document Contains Assignments from Cash Flows Show values
CAPaymentPreNotificationCode Item Included in a Payment Order Show values
CASEPAPreNotifOriginCode SEPA: Origin of Direct Debit Pre-Notification Show values
CASEPAPreNotificationRqmtCode SEPA: Requirement for a Pre-Notification Show values
CARevenueDistrCurrentStatus Current Distribution Status Show values
CARevenueDistrLastStatus Last Distribution Status Reported Show values
CACurrentFactoringStatusOfRbl Factoring: Current Status of Receivable Show values
CAFactoringCheckStsForClrgInfo Factoring: Check Status for Clearing Information Show values
Column Name Description Domain name
BusinessArea Business Area GSBER
BusinessPlace Business Place J_1BBRANCH
Segment Segment for Segmental Reporting FB_SEGMENT
ProfitCenter Profit Center PRCTR
Division Division SPART
PersonnelNumber Personnel Number PERNR
CAContract Reference Specifications from Contract VTREF_KK
CAProviderContractItemNumber Contract: Item Number VTPOS_KK
CAAdditionalContract Additional Reference Information VTREF_KK
ContractAccount Contract Account Number CORR_VKONT_KK
AltvContractAcctForCollvBills Alternative Contract Account for Collective Bills VKONT_KK
CAAccountDeterminationCode Account Determination ID KOFIZ_KK
CAAccountAssignment Acct assnmnt string for industry-specific account assngments CHAR50
CABPItemText Item text TEXT50
CANumberOfRepetitionItems Number of repetition items NUM03
CARepetitionGroup Repetition group WHGRP_KK
CAGroupingCodeForBPItems Grouping Key for Displaying Open Items CHAR3
CAWorkflowCheckReason Check Reason for Workflows Acc. to Dual Control Principle C4EYE_KK
CASubstituteDocumentNumber Number of the Substitute FI-CA Document ABWBL_KK
CADocumentNumberOfOriginItem Number of Triggering Document OPBEL_KK
CAReferenceDocument Reference document number XBLNR_KK
CAExchangeRate Exchange rate KURSF
CACashDiscountRate Cash Discount Percentage Rate PRZ23
CASupplementaryTaxCode Supplementary Tax MWSKZ
TaxJurisdiction Tax Jurisdiction TXJCD
CAWithholdingTaxSupplement Withholding Tax Supplement QSSEW_KK
CAWithholdingTaxPercentage Withholding Tax Percentage STPRZ_KK
WithholdingTaxCertificate Withholding Tax Certificate CHAR10
CAGroupingCodeForTaxItems Grouping Key for Tax Items CHAR6
CAPaymentMethod Payment Method PYMET_KK
CAGroupingForPayment Grouping field for automatic payments CHAR10
CAClearingDocumentNumber Clearing Document or Printed Document AUGBL_KK
CAGrpgCodeForTransfToCollAgcy Collection Item NUM03
PlanningLevel Planning Level FDLEV
CAAdditionalDaysForCashMgmt Additional Days for Cash Management NUM2
CAAddressOfAltvBPForPayment Address Number AD_ADDRNUM
CACardOfAltvBPForPayment Alternative Payment Card ID in Document CHAR6
CACashFlowAccount Originating Account in Cash Flow Anlaysis SAKNR
CACashFlowCompanyCode Partner Company Code for Cash Flow Analysis BUKRS
CASEPAPreNotificationNumber SEPA: Number of Direct Debit Pre-Notification PNNUM_KK
CARevenueDistrFinalRecipient Contract Account of Final Recipient VKONT_KK
SEPAMandateCAInternalID SEPA Mandate Identifier NUM06
Country Country/Region Key LAND1
Master Data Relations Join Conditions
Business Partner Number
  • Business Partner Number
  • Client
  • I_CAOPENITEMLISTITEM.BUSINESSPARTNER == BUT000.PARTNER
  • I_CAOPENITEMLISTITEM.MANDT == BUT000.CLIENT
Account Assignment Category I_CAOPENITEMLISTITEM.CAACCOUNTASSIGNMENTCATEGORY == TFK000K.KONTT
Business Partner Number
  • Business Partner Number
  • Client
  • I_CAOPENITEMLISTITEM.CAALTVBPFORPAYMENT == BUT000.PARTNER
  • I_CAOPENITEMLISTITEM.MANDT == BUT000.CLIENT
Bank Details ID of Payee
  • Business Partner Number
  • Bank Details ID of Payee
  • Client
  • I_CAOPENITEMLISTITEM.CAALTVBPFORPAYMENT == BUT0BK.PARTNER
  • I_CAOPENITEMLISTITEM.CABANKOFALTVBPFORPAYMENT == BUT0BK.BKVID
  • I_CAOPENITEMLISTITEM.MANDT == BUT0BK.MANDT
Clearing Reason I_CAOPENITEMLISTITEM.CACLEARINGREASON == TFK001A.AUGRD
Document Type
  • Application Area
  • Document Type
  • Client
  • I_CAOPENITEMLISTITEM.CAAPPLICATIONAREA == TFK003.APPLK
  • I_CAOPENITEMLISTITEM.CADOCUMENTTYPE == TFK003.BLART
  • I_CAOPENITEMLISTITEM.MANDT == TFK003.MANDT
Account for offsetting tax posting in down payments
  • Account for offsetting tax posting in down payments
  • Chart of Accounts
  • Client
  • I_CAOPENITEMLISTITEM.CADOWNPAYMENTOFFSETTAXACCOUNT == SKA1.SAKNR
  • I_CAOPENITEMLISTITEM.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_CAOPENITEMLISTITEM.MANDT == SKA1.MANDT
Account for posting taxes for down payments
  • Chart of Accounts
  • Client
  • Account for posting taxes for down payments
  • I_CAOPENITEMLISTITEM.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_CAOPENITEMLISTITEM.MANDT == SKA1.MANDT
  • I_CAOPENITEMLISTITEM.CADOWNPAYMENTTAXACCOUNT == SKA1.SAKNR
Dunning Procedure
  • Dunning Procedure
  • Client
  • I_CAOPENITEMLISTITEM.CADUNNINGPROCEDURE == TFK047A.MAHNV
  • I_CAOPENITEMLISTITEM.MANDT == TFK047A.MANDT
Check on Validity of Interest Key
  • Interest Key
  • Client
  • I_CAOPENITEMLISTITEM.CAINTERESTCODE == TFK056A.IKEY
  • I_CAOPENITEMLISTITEM.MANDT == TFK056A.MANDT
Main Transaction for Line Item
  • Application Area
  • Main Transaction for Line Item
  • Client
  • I_CAOPENITEMLISTITEM.CAAPPLICATIONAREA == TFKHVO.APPLK
  • I_CAOPENITEMLISTITEM.CAMAINTRANSACTION == TFKHVO.HVORG
  • I_CAOPENITEMLISTITEM.MANDT == TFKHVO.MANDT
Tax Code for Other Taxes
  • ?
  • Client
  • Tax Code for Other Taxes
  • I_CAOPENITEMLISTITEM.[column in domain "LAND"] == TFK007F.LAND
  • I_CAOPENITEMLISTITEM.MANDT == TFK007F.MANDT
  • I_CAOPENITEMLISTITEM.CAOTHERTAXCODE == TFK007F.STRKZ
Company Code for Automatic Payment Transactions
  • Client
  • Company Code for Automatic Payment Transactions
  • I_CAOPENITEMLISTITEM.MANDT == T001.MANDT
  • I_CAOPENITEMLISTITEM.CAPAYMENTCOMPANYCODE == T001.BUKRS
Key for Period Assignment
  • Key for Period Assignment
  • Client
  • I_CAOPENITEMLISTITEM.CAPERIODCODE == TFK001P.PERSL
  • I_CAOPENITEMLISTITEM.MANDT == TFK001P.MANDT
Destination Country/Region (for Tax Reports)
  • Destination Country/Region (for Tax Reports)
  • Client
  • I_CAOPENITEMLISTITEM.CARECEIVINGCOUNTRY == T005.LAND1
  • I_CAOPENITEMLISTITEM.MANDT == T005.MANDT
General ledger account
  • General ledger account
  • Chart of Accounts
  • Client
  • I_CAOPENITEMLISTITEM.CARECONCILIATIONACCOUNT == SKA1.SAKNR
  • I_CAOPENITEMLISTITEM.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_CAOPENITEMLISTITEM.MANDT == SKA1.MANDT
Planning Group
  • Planning Group
  • Client
  • I_CAOPENITEMLISTITEM.CASHPLANNINGGROUP == T035.GRUPP
  • I_CAOPENITEMLISTITEM.MANDT == T035.MANDT
Subtransaction for Document Item
  • Application Area
  • Subtransaction for Document Item
  • Main Transaction for Line Item
  • Client
  • I_CAOPENITEMLISTITEM.CAAPPLICATIONAREA == TFKTVO.APPLK
  • I_CAOPENITEMLISTITEM.CASUBTRANSACTION == TFKTVO.TVORG
  • I_CAOPENITEMLISTITEM.CAMAINTRANSACTION == TFKTVO.HVORG
  • I_CAOPENITEMLISTITEM.MANDT == TFKTVO.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_CAOPENITEMLISTITEM.CHARTOFACCOUNTS == T004.KTOPL
  • I_CAOPENITEMLISTITEM.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • I_CAOPENITEMLISTITEM.COMPANYCODE == T001.BUKRS
  • I_CAOPENITEMLISTITEM.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Transaction Currency
  • Client
  • I_CAOPENITEMLISTITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • I_CAOPENITEMLISTITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_CAOPENITEMLISTITEM.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_CAOPENITEMLISTITEM.CONTROLLINGAREA == TKA01.KOKRS
  • I_CAOPENITEMLISTITEM.MANDT == TKA01.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • I_CAOPENITEMLISTITEM.PARTNERCOMPANY == T880.RCOMP
  • I_CAOPENITEMLISTITEM.MANDT == T880.MANDT
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • I_CAOPENITEMLISTITEM.[column in domain "KVEWE"] == T683.KVEWE
  • I_CAOPENITEMLISTITEM.[column in domain "KAPPL"] == T683.KAPPL
  • I_CAOPENITEMLISTITEM.TAXCALCULATIONPROCEDURE == T683.KALSM
  • I_CAOPENITEMLISTITEM.MANDT == T683.MANDT
Tax on Sales/Purchases Code
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Tax on Sales/Purchases Code
  • Client
  • I_CAOPENITEMLISTITEM.TAXCALCULATIONPROCEDURE == T007A.KALSM
  • I_CAOPENITEMLISTITEM.TAXCODE == T007A.MWSKZ
  • I_CAOPENITEMLISTITEM.MANDT == T007A.MANDT
Transaction Currency
  • Company Code Currency
  • Transaction Currency
  • Client
  • I_CAOPENITEMLISTITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • I_CAOPENITEMLISTITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_CAOPENITEMLISTITEM.MANDT == TCURC.MANDT
Withholding Tax Code
  • Country/Region Key
  • Withholding Tax Code
  • Client
  • I_CAOPENITEMLISTITEM.COUNTRY == T059Q.LAND1
  • I_CAOPENITEMLISTITEM.WITHHOLDINGTAXCODE == T059Q.QSSKZ
  • I_CAOPENITEMLISTITEM.MANDT == T059Q.MANDT