I_CAPaymentLot

Payment Lot | view: ICAPAYMENTLOT | TRAN | Extraction: Not supported | Component: Contract Accounts Receivable and Payable
Tables used: DFKKZKT001TKA02
Column Name Description
CAPaymentLot Payment Lot
Column Name Description
💲 Currency Key for the Totals (TotalAmountCurrency):
TotalDebitAmount Total debit postings
TotalCreditAmount Total credit postings
Column Name Description
Column Name Description
CreationDate Creation Date
CreationTime Creation Time
LastChangeDate Last Change Date
LastChangeTime Time of Change
DocumentDate Journal Entry Date
CAPostingDate Posting Date in the Document
ValueDate Value date
Column Name Description
CAApplicationArea Application Area Show values
CAIsChequeLot Check Lot Show values
CAIsSeparateLineItemInGL Create Line Item in General Ledger Show values
CAPaymentLotStatus Status of the payment lot Show values
CAPaymentLotCategory Category of Payment/Payment Lot Show values
Column Name Description Domain name
CAPaymentLotSearchTerm Search Term for Payment Lot KEYZ2_KK
CreatedByUser Created By XUBNAME
LastChangedByUser Name of Person Who Changed Object USNAM
ProfitCenter Profit Center PRCTR
CAExchangeRate Exchange rate KURSF
CANumberOfPaymentLotItems Number of Items NUM06
BankStatementShortID Short Key for Bank Statement (Surrogate Key) KUKEY_EB
Master Data Relations Join Conditions
Business Area
  • Client
  • Business Area
  • I_CAPAYMENTLOT.MANDT == TGSB.MANDT
  • I_CAPAYMENTLOT.BUSINESSAREA == TGSB.GSBER
Business Place
  • Client
  • ?
  • Company Code
  • Business Place
  • I_CAPAYMENTLOT.MANDT == J_1BBRANCH.MANDT
  • I_CAPAYMENTLOT.[column in domain "GLO_BUPLA_TYPE_CODE"] == J_1BBRANCH.BUPLA_TYPE
  • I_CAPAYMENTLOT.COMPANYCODE == J_1BBRANCH.BUKRS
  • I_CAPAYMENTLOT.BUSINESSPLACE == J_1BBRANCH.BRANCH
Clearing Reason I_CAPAYMENTLOT.CACLEARINGREASON == TFK001A.AUGRD
Document Origin Key I_CAPAYMENTLOT.CADOCUMENTORIGINCODE == TFK001.HERKF
Document Type
  • Client
  • Application Area
  • Document Type
  • I_CAPAYMENTLOT.MANDT == TFK003.MANDT
  • I_CAPAYMENTLOT.CAAPPLICATIONAREA == TFK003.APPLK
  • I_CAPAYMENTLOT.CADOCUMENTTYPE == TFK003.BLART
Reconciliation Key for General Ledger
  • Client
  • Reconciliation Key for General Ledger
  • I_CAPAYMENTLOT.MANDT == DFKKSUMC.MANDT
  • I_CAPAYMENTLOT.CARECONCILIATIONKEY == DFKKSUMC.FIKEY
Company Code
  • Client
  • Company Code
  • I_CAPAYMENTLOT.MANDT == T001.MANDT
  • I_CAPAYMENTLOT.COMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • I_CAPAYMENTLOT.MANDT == TKA01.MANDT
  • I_CAPAYMENTLOT.CONTROLLINGAREA == TKA01.KOKRS
Transaction Currency
  • Client
  • Transaction Currency
  • I_CAPAYMENTLOT.MANDT == TCURC.MANDT
  • I_CAPAYMENTLOT.CURRENCY == TCURC.WAERS
House Bank Key
  • Client
  • House Bank Key
  • Company Code
  • I_CAPAYMENTLOT.MANDT == T012.MANDT
  • I_CAPAYMENTLOT.HOUSEBANK == T012.HBKID
  • I_CAPAYMENTLOT.COMPANYCODE == T012.BUKRS
House Bank Account
  • Client
  • House Bank Key
  • Company Code
  • House Bank Account
  • I_CAPAYMENTLOT.MANDT == T012K.MANDT
  • I_CAPAYMENTLOT.HOUSEBANK == T012K.HBKID
  • I_CAPAYMENTLOT.COMPANYCODE == T012K.BUKRS
  • I_CAPAYMENTLOT.HOUSEBANKACCOUNT == T012K.HKTID
Other Relations | to Master Data Relations ↑ Join Conditions
Bank clearing account
  • Bank clearing account
  • Client
  • Company Code
  • I_CAPAYMENTLOT.CABANKCLEARINGACCOUNT == TFK012.BVRKO
  • I_CAPAYMENTLOT.MANDT == TFK012.MANDT
  • I_CAPAYMENTLOT.COMPANYCODE == TFK012.BUKRS