I_LoanContrActlDocHdrData

Actual Document Header for Loan Contract | view: ILCACTDOCHDRD | TRAN | Extraction: Full or Incremental | Component: Loans Management
Tables used: VDBEKI
Column Name Description
CompanyCode FK Company Code
PostedDocumentID Document Number of Document Header (Loan)
Column Name Description
Column Name Description
Column Name Description
CashFlowItemPostingDate Posting Date in the Document
CshFlwItmTransfToFinAcctgDte Date of transferal to FiAc
CashFlowItemEnteredDate First Entered On
CashFlowItemEnteredTime Time of Creation
Column Name Description
CashFlowItemReversalStatus Reversal indicator Show values
Column Name Description Domain name
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
CashFlowItemEnteredBy Entered By SYCHAR12
CashFlowItemEnteredSource Source of Initial Entry CHAR10
CshFlwItmBusTransNmbr Daybook no. VVRPNNR
AccountingDocument Document Number of an Accounting Document BELNR
Master Data Relations Join Conditions
Company code
  • Company Code
  • Client
  • I_LOANCONTRACTLDOCHDRDATA.COMPANYCODE == T001.BUKRS
  • I_LOANCONTRACTLDOCHDRDATA.MANDT == T001.MANDT
General ledger account
  • Company Code
  • General Ledger Account
  • Client
  • I_LOANCONTRACTLDOCHDRDATA.COMPANYCODE == SKB1.BUKRS
  • I_LOANCONTRACTLDOCHDRDATA.CSHFLWITMGLACCOUNT == SKB1.SAKNR
  • I_LOANCONTRACTLDOCHDRDATA.MANDT == SKB1.MANDT
Business area
  • Business Area
  • Client
  • I_LOANCONTRACTLDOCHDRDATA.LOANBUSINESSAREA == TGSB.GSBER
  • I_LOANCONTRACTLDOCHDRDATA.MANDT == TGSB.MANDT