I_LoanContrPostedItemData

Posted Item for Loan Contract | view: ILCPOSTEDTIMD | TRAN | Extraction: Full or Incremental | Component: Loans Management
Tables used: VDBEKIVDBEPI
Column Name Description
CompanyCode FK Company Code
PostedDocumentID FK Document Number of Document Header (Loan)
PostedDocumentActivityNumber Activity number
Column Name Description
💲 Currency of nominal amount (CashFlowItmNominalAmtCrcy):
CashFlowItmNominalAmt Nominal amount
💲 Position Currency (Currency of Position Amount) (CashFlowItemPositionCurrency):
CshFlwItmAmtInPosCrcy Amount in position currency
💲 Settlement Currency (CashFlowItemSettlementCurrency):
CshFlwItmAmtInSettlmtCrcy Settlement Amount
Column Name Description
Column Name Description
CashFlowItemCalcDate Calculation Date
CashFlowItemDueDate Due date
CashFlowItemPaymentDate Payment Date
CalculationPeriodStartDate Start of Calculation Period
CalculationPeriodEndDate End of Calculation Period
CashFlowItemGenerationDate Flow data key: System date
CashFlowItemGenerationTime Transaction data key: system time
CshFlwItmSettlementDate Settlement date
CashFlowItemEnteredDate First Entered On
CashFlowItemEnteredTime Time of Creation
CashFlowItemEditedDate Last Edited On
CashFlowItemEditedTime Last Edited At
CashFlowItemBillDueDate Due Date for Bill
CashFlowItemPostingDate Posting Date in the Document
CshFlwItmTransfToFinAcctgDte Date of transferal to FiAc
Column Name Description
CashFlowItemPostingDirection Debit/credit indicator Show values
CalcPeriodStartDateIsExclusive Exclusive Indicator for the Start of a Calculation Period Show values
CalcPeriodEndDateIsInclusive Inclusive Indicator for the End of a Calculation Period Show values
CalcEndDteIsInclusive Inclusive indicator for beginning and end of a period Show values
CshFlwItmClrgDteIsInclusive Inclusive Indicator for Clearing Date Show values
DebitCrdtCtrlActyType Activity indicator for debit/credit control Show values
LoanCshFlwItmActivityCat Activity Category (Posting Area) Show values
CshFlwItmDirectionOfFlow Direction of Flow Show values
CashFlowItemReversalStatus Reversal indicator Show values
Column Name Description Domain name
CashFlowItemType Flow Type SBEWART
CashFlowItemReferenceType Reference flow type SBEWART
CashFlowItemCategory Flow category SBEWZITI
CashFlowItemPercentageRate Percentage rate for condition items DECV3_7
CashFlowItemSource Source of flow record CHAR1
CashFlowItemSequenceNumber Transaction data key: Consecutive number NUMC4
AccrDefrlRefFlwCat Refer.flow category in accrual/deferral flow records SBEWZITI
CashFlowItemEnteredBy Entered By SYCHAR12
CashFlowItemEnteredSource Source of Initial Entry CHAR10
CashFlowItemEditedBy Employee ID SYCHAR12
CashFlowItemEditedSource Editing Source CHAR10
LoanMainBrwrCustNmbr Main Borrower Customer Number KUNNR
AccountingDocument Document Number of an Accounting Document BELNR
LoanContractID Contract Number RANL
LoanClassfctnNmbr Classification Number for Finance Projects RANL
LoanLifeCycleStatus Status of data record STATI
LoanAcctAssgmtRef Account Assignment Reference in Financial Assets Management USTRU
ReverseDocument Reverse Document Number BELNR
WvrWriteoffDocument Doc.no. of debit pos. doc.header (only for inc.pmnt records) RBELKPFD
CshFlwItmBusTransNmbr Daybook no. VVRPNNR
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • I_LOANCONTRPOSTEDITEMDATA.MANDT == T001.MANDT
  • I_LOANCONTRPOSTEDITEMDATA.COMPANYCODE == T001.BUKRS
Account Credit Posting
  • Client
  • ?
  • Account for credit posting
  • I_LOANCONTRPOSTEDITEMDATA.MANDT == SKA1.MANDT
  • I_LOANCONTRPOSTEDITEMDATA.[column in domain "KTOPL"] == SKA1.KTOPL
  • I_LOANCONTRPOSTEDITEMDATA.CSHFLWITMCREDITPOSTGACCT == SKA1.SAKNR
Account Debit Posting
  • Client
  • Account for debit posting
  • ?
  • I_LOANCONTRPOSTEDITEMDATA.MANDT == SKA1.MANDT
  • I_LOANCONTRPOSTEDITEMDATA.CSHFLWITMDEBITPOSTGACCT == SKA1.SAKNR
  • I_LOANCONTRPOSTEDITEMDATA.[column in domain "KTOPL"] == SKA1.KTOPL
General ledger account
  • Client
  • Company Code
  • General Ledger Account
  • I_LOANCONTRPOSTEDITEMDATA.MANDT == SKB1.MANDT
  • I_LOANCONTRPOSTEDITEMDATA.COMPANYCODE == SKB1.BUKRS
  • I_LOANCONTRPOSTEDITEMDATA.CSHFLWITMGLACCOUNT == SKB1.SAKNR
Condition Type
  • Client
  • ?
  • Condition Type (Smallest Subdivision of Condition Records)
  • I_LOANCONTRPOSTEDITEMDATA.MANDT == TZK01.MANDT
  • I_LOANCONTRPOSTEDITEMDATA.[column in domain "RANTYP"] == TZK01.RANTYP
  • I_LOANCONTRPOSTEDITEMDATA.FINCONDITIONCONDITIONTYPE == TZK01.SKOART
Business Area
  • Client
  • Business Area
  • I_LOANCONTRPOSTEDITEMDATA.MANDT == TGSB.MANDT
  • I_LOANCONTRPOSTEDITEMDATA.LOANBUSINESSAREA == TGSB.GSBER