I_LoanContrPlndItm

Planned Items for Loan Contract | view: ILCPLNDITM | TRAN | Extraction: Full only | Component: Loans Management
Tables used: VDBEPP
Column Name Description
CompanyCode FK Company Code
LoanContractID Contract Number
CashFlowItemGenerationDate Flow data key: System date
CashFlowItemGenerationTime Transaction data key: system time
CashFlowItemSequenceNumber Transaction data key: Consecutive number
Column Name Description
💲 Settlement Currency (CashFlowItemSettlementCurrency):
CshFlwItmAmtInSettlmtCrcy Settlement Amount
💲 Position Currency (Currency of Position Amount) (CashFlowItemPositionCurrency):
CshFlwItmAmtInPosCrcy Amount in position currency
Column Name Description
Column Name Description
CashFlowItemGenerationDate Flow data key: System date
CashFlowItemGenerationTime Transaction data key: system time
CashFlowItemDueDate Due date/calculation date
CashFlowItemPaymentDate Payment Date
CalculationPeriodStartDate Start of Calculation Period
CalculationPeriodEndDate End of Calculation Period
LoanCshFlwItmIntrstFixingDte Interest rate fixing date
LoanCshFlwItmCalcDte Calculation Date
Column Name Description
CalcPeriodStartDateIsExclusive Exclusive Indicator for the Start of a Calculation Period Show values
CalcPeriodEndDateIsInclusive Inclusive Indicator for the End of a Calculation Period Show values
CashFlowItemPostingDirection Debit/credit indicator Show values
Column Name Description Domain name
CashFlowItemSource Source of flow record CHAR1
CashFlowItemCategory Flow category SBEWZITI
CashFlowItemPercentageRate Percentage rate for condition items DECV3_7
CashFlowItemType Flow Type SBEWART
Master Data Relations Join Conditions
Currency position
  • Client
  • Position Currency (Currency of Position Amount)
  • I_LOANCONTRPLNDITM.MANDT == TCURC.MANDT
  • I_LOANCONTRPLNDITM.CASHFLOWITEMPOSITIONCURRENCY == TCURC.WAERS
Currency settlement
  • Client
  • Settlement Currency
  • I_LOANCONTRPLNDITM.MANDT == TCURC.MANDT
  • I_LOANCONTRPLNDITM.CASHFLOWITEMSETTLEMENTCURRENCY == TCURC.WAERS
Company Code
  • Client
  • Company Code
  • I_LOANCONTRPLNDITM.MANDT == T001.MANDT
  • I_LOANCONTRPLNDITM.COMPANYCODE == T001.BUKRS