I_CAReturnLotItem

Returns Lot: Data for Payment | view: ICARETURNLOTITEM | TRAN | Extraction: Not supported | Component: Contract Accounts Receivable and Payable
Tables used: DFKKRKDFKKRPT001TKA02
Column Name Description
CAReturnLot Returns Lot
CAItemNumberInReturnLot Item number in a returns lot
Column Name Description
💲 Transaction Currency (TransactionCurrency):
CAReturnAmount Return amount
CAReturnCharge1 Returns Charge 1
CATaxAmountForReturnCharge1 Tax amount: Return charges 1
Column Name Description
Column Name Description
CAPostingDate Posting Date in the Document
DocumentDate Journal Entry Date
ValueDate Value date
LastChangeDate Last Change Date
LastChangeTime Time of Change
Column Name Description
CAApplicationArea Application Area Show values
Column Name Description Domain name
BusinessArea Business Area GSBER
ProfitCenter Profit Center PRCTR
LastChangedByUser Name of Person Who Changed Object USNAM
CADocumentNumber Payment document for returns OPBEL_KK
CAReturnDocumentNumber Number of the return document OPBEL_KK
CABankingCountryOfBusPart Banking Country/Region of Business Partner CHAR3
CABankNumberOfBusinessPartner Business Partner Bank Number CHAR15
CABankAccountOfBusinessPartner Account Number of Business Partner CHAR18
IBAN IBAN (International Bank Account Number) IBAN
CANumberOfReturnedCheque Number of a returned check CHECF_KK
SWIFTCode SWIFT/BIC for International Payments SWIFT
Master Data Relations Join Conditions
Document Type
  • Application Area
  • Document Type
  • Client
  • I_CARETURNLOTITEM.CAAPPLICATIONAREA == TFK003.APPLK
  • I_CARETURNLOTITEM.CADOCUMENTTYPE == TFK003.BLART
  • I_CARETURNLOTITEM.MANDT == TFK003.MANDT
Reconciliation Key for General Ledger
  • Client
  • Reconciliation Key for General Ledger
  • I_CARETURNLOTITEM.MANDT == DFKKSUMC.MANDT
  • I_CARETURNLOTITEM.CARECONCILIATIONKEY == DFKKSUMC.FIKEY
Return reason
  • Return Reason
  • House Bank Key
  • Client
  • I_CARETURNLOTITEM.CARETURNREASON == TFK045A.RLGRD
  • I_CARETURNLOTITEM.HOUSEBANK == TFK045A.HBKID
  • I_CARETURNLOTITEM.MANDT == TFK045A.MANDT
Company Code
  • Client
  • Company Code
  • I_CARETURNLOTITEM.MANDT == T001.MANDT
  • I_CARETURNLOTITEM.COMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • I_CARETURNLOTITEM.CONTROLLINGAREA == TKA01.KOKRS
  • I_CARETURNLOTITEM.MANDT == TKA01.MANDT
House Bank Key
  • House Bank Key
  • Client
  • Company Code
  • I_CARETURNLOTITEM.HOUSEBANK == T012.HBKID
  • I_CARETURNLOTITEM.MANDT == T012.MANDT
  • I_CARETURNLOTITEM.COMPANYCODE == T012.BUKRS
House Bank Account
  • House Bank Key
  • Client
  • Company Code
  • House Bank Account
  • I_CARETURNLOTITEM.HOUSEBANK == T012K.HBKID
  • I_CARETURNLOTITEM.MANDT == T012K.MANDT
  • I_CARETURNLOTITEM.COMPANYCODE == T012K.BUKRS
  • I_CARETURNLOTITEM.HOUSEBANKACCOUNT == T012K.HKTID
Transaction Currency
  • Client
  • Transaction Currency
  • I_CARETURNLOTITEM.MANDT == TCURC.MANDT
  • I_CARETURNLOTITEM.TRANSACTIONCURRENCY == TCURC.WAERS