C_CAOpenItemListItem

Open Item List Items | view: CCAOPENITMLSTITM | TRAN | Extraction: Not supported | Component: Contract Accounts Receivable and Payable
Tables used: DFKKOP_LISTPT001TKA02T005DFKK_VT_H
Column Name Description
CAOpenItemListUUID Key for Business Partner Item (in OI Lists)
CADocumentNumber 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
💲 Transaction Currency (TransactionCurrency):
CAAmountInTransactionCurrency Amount in Transaction Currency with +/- Sign
CATaxAmountInTransCurrency Tax Amount in Transaction Currency with +/- Sign
💲 Clearing Currency (CAClearingCurrency):
CAClearingAmountInClearingCrcy Clearing amount in clearing currency
CATaxAmountInClearingCrcy Tax Amount 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
DocumentDate Journal Entry Date
CAPostingDate Posting Date in the Document
CANetDueDate Due date for net payment
CAClearingDate Clearing Date
CAPostingDateOfClearingDoc Clearing Document Posting Date
Column Name Description
CADoubtfulOrValueAdjmtCode Doubtful Item Entry/Individual Value Adjustment Show values
CAIsDownPaymentRequest Item is a Down Payment/Down Payment Request Show values
CAClearingStatus Clearing Status Show values
CAClearingPostingIsReset Clearing posting reversed Show values
Column Name Description Domain name
BusinessArea Business Area GSBER
Segment Segment for Segmental Reporting FB_SEGMENT
ProfitCenter Profit Center PRCTR
CAContract Reference Specifications from Contract VTREF_KK
ContractAccount Contract Account Number CORR_VKONT_KK
CAClearingDocumentNumber Clearing Document or Printed Document AUGBL_KK
CAProviderContractAuthznGroup Authorization Group BEGRU
Master Data Relations Join Conditions
Business Partner Number
  • Client
  • Business Partner Number
  • C_CAOPENITEMLISTITEM.MANDT == BUT000.CLIENT
  • C_CAOPENITEMLISTITEM.BUSINESSPARTNER == BUT000.PARTNER
Clearing Reason C_CAOPENITEMLISTITEM.CACLEARINGREASON == TFK001A.AUGRD
Document Type
  • Document Type
  • Client
  • ?
  • C_CAOPENITEMLISTITEM.CADOCUMENTTYPE == TFK003.BLART
  • C_CAOPENITEMLISTITEM.MANDT == TFK003.MANDT
  • C_CAOPENITEMLISTITEM.[column in domain "APPLK_KK"] == TFK003.APPLK
Account for offsetting tax posting in down payments
  • Client
  • ?
  • Account for offsetting tax posting in down payments
  • C_CAOPENITEMLISTITEM.MANDT == SKA1.MANDT
  • C_CAOPENITEMLISTITEM.[column in domain "KTOPL"] == SKA1.KTOPL
  • C_CAOPENITEMLISTITEM.CADOWNPAYMENTOFFSETTAXACCOUNT == SKA1.SAKNR
General ledger account
  • General ledger account
  • Client
  • ?
  • C_CAOPENITEMLISTITEM.CARECONCILIATIONACCOUNT == SKA1.SAKNR
  • C_CAOPENITEMLISTITEM.MANDT == SKA1.MANDT
  • C_CAOPENITEMLISTITEM.[column in domain "KTOPL"] == SKA1.KTOPL
Company Code
  • Client
  • Company Code
  • C_CAOPENITEMLISTITEM.MANDT == T001.MANDT
  • C_CAOPENITEMLISTITEM.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • Transaction Currency
  • C_CAOPENITEMLISTITEM.MANDT == TCURC.MANDT
  • C_CAOPENITEMLISTITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • C_CAOPENITEMLISTITEM.TRANSACTIONCURRENCY == TCURC.WAERS
Tax on Sales/Purchases Code
  • Client
  • Tax on Sales/Purchases Code
  • ?
  • C_CAOPENITEMLISTITEM.MANDT == T007A.MANDT
  • C_CAOPENITEMLISTITEM.TAXCODE == T007A.MWSKZ
  • C_CAOPENITEMLISTITEM.[column in domain "KALSM_D"] == T007A.KALSM
Transaction Currency
  • Client
  • Company Code Currency
  • Transaction Currency
  • C_CAOPENITEMLISTITEM.MANDT == TCURC.MANDT
  • C_CAOPENITEMLISTITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • C_CAOPENITEMLISTITEM.TRANSACTIONCURRENCY == TCURC.WAERS