Cash Flow
Technical name:0CML_CASHFLOW
Technical Data
Type of DataSource |
Transactional data (flow data) |
Application Component |
Consumer & Mortgage Loans (CML) |
Available from OLTP Release |
SAP R/3 Enterprise Financial Services 2.0 (EA-FINSERV 2.0) |
Available from PlugIn Release |
2003_1 |
RemoteCube-enabled |
No |
Use
This DataSource is based on the extractor function module FVD_BCT_CASHFLOW_EXTRACT. This extractor is set up exclusively for the full update.
You use this DataSource to load the flow–based key figures into the corresponding InfoCube.
The DataSource loads the flows for all the loans you have selected. At present, you have to enter the company code as the minimum selection criterion. You can also select one or more product types.
The system determines the capital changes for each flow, that is to say, the effect of the flow on the capital (such as the remaining capital or the effective capital, for example).
In addition to the position differentiating characteristics, the system also extracts the relevant units of local currency, position currency, profit/ loss currency and nominal currency.
Delta Update
There is no delta update.
Origin Fields from the Extract Structure
Field in the extraction structure |
Description of field in extraction structure |
Origin table |
Field in the origin table |
BAMT3HW |
Premium/discount (local currency) |
Calculation using FM ACCUMULATION_INIT (Structure REVAL) |
BAMT3HW |
BAMT3WR |
Premium/discount (position currency) |
Calculation using FM ACCUMULATION_INIT (Structure REVAL) |
BAMT3WR |
BATHW |
Unscheduled repayment: Debit position (local currency) |
Calculation using LOAN_AMOUNT_CALCULATE (Structure: RLOAM) |
BATHW |
BATNWR |
Unscheduled repayment: Nominal (position currency) |
Calculation using LOAN_AMOUNT_CALCULATE (Structure: RLOAM) |
BATNWR |
BATWR |
Unscheduled repayment: Debit position (position currency) |
Calculation using LOAN_AMOUNT_CALCULATE (Structure: RLOAM) |
BATWR |
BATZHW |
Unscheduled repayment: Incoming payment (local currency) |
Calculation using LOAN_AMOUNT_CALCULATE (Structure: RLOAM) |
BATZHW |
BATZWR |
Unscheduled repayment: Incoming payment (position currency) |
Calculation using LOAN_AMOUNT_CALCULATE (Structure: RLOAM) |
BATZWR |
BAVWR |
Disbursement obligation (position currency) |
Calculation using LOAN_AMOUNT_CALCULATE (Structure: RLOAM) |
BAVWR |
BBUCHHW |
Book value (local currency) |
Calculation using FM ACCUMULATION_INIT (Structure REVAL) |
BBUCHHW |
BBUCHWR |
Book value (position currency) |
Calculation using FM ACCUMULATION_INIT (Structure REVAL) |
BBUCHWR |
BBWHR |
Amount (position currency) |
VDBEPI |
BBWHR |
BHWBETR |
Payment amount (local currency) |
Calculation using FM ACCUMULATION_INIT (Structure REVAL) |
BHWBETR |
BHWHR |
Amount (local currency) |
VDBEPI |
BHWHR |
BKAUFHW |
Acquisition value (local currency) |
Calculation using FM ACCUMULATION_INIT (Structure REVAL) |
BKAUFHW |
BKAUFWR |
Acquisition value (position currency) |
Calculation using FM ACCUMULATION_INIT (Structure REVAL) |
BKAUFWR |
BKGVHW |
Exchange rate gains and losses (local currency) |
Calculation using LOAN_AMOUNT_CALCULATE (Structure: RLOAM) |
BKGVHW |
BKKWR |
Commitment capital according to condition header (position currency) |
Calculation using LOAN_AMOUNT_CALCULATE (Structure: RLOAM) |
BKKWR |
BMIWR |
Capital reduction (position currency) |
Calculation using LOAN_AMOUNT_CALCULATE (Structure: RLOAM) |
BMIWR |
BNWHR |
Nominal amount |
VDBEPI |
BNWHR |
BPTHW |
Scheduled repayment: Debit position (local currency) |
Calculation using LOAN_AMOUNT_CALCULATE (Structure: RLOAM) |
BPTHW |
BPTWR |
Scheduled repayment: Debit position (position currency) |
Calculation using LOAN_AMOUNT_CALCULATE (Structure: RLOAM) |
BPTWR |
BPTZHW |
Scheduled repayment: Incoming payment (local currency) |
Calculation using LOAN_AMOUNT_CALCULATE (Structure: RLOAM) |
BPTZHW |
BPTZWR |
Scheduled repayment: Incoming payment (position currency) |
Calculation using LOAN_AMOUNT_CALCULATE (Structure: RLOAM) |
BPTZWR |
BRIHW |
Effective capital (local currency) |
Calculation using LOAN_AMOUNT_CALCULATE (Structure: RLOAM) |
BRIHW |
BRINWR |
Nominal effective capital (position currency) |
Calculation using LOAN_AMOUNT_CALCULATE (Structure: RLOAM) |
BRINWR |
BRIWR |
Effective capital (position currency) |
Calculation using LOAN_AMOUNT_CALCULATE (Structure: RLOAM) |
BRIWR |
BRPHW |
Remaining capital according to debit position (local currency) |
Calculation using LOAN_AMOUNT_CALCULATE (Structure: RLOAM) |
BRPHW |
BRPNWR |
Nominal remaining capital according to debit position (position currency) |
Calculation using LOAN_AMOUNT_CALCULATE (Structure: RLOAM) |
BRPNWR |
BRPWR |
Remaining capital according to debit position (position currency) |
Calculation using LOAN_AMOUNT_CALCULATE (Structure: RLOAM) |
BRPWR |
BUCHST_DL |
Posting status of flow for loan |
Derived |
BUCHST_DL |
BUKRS |
Company code |
VDBEKI |
BUKRS |
BVAHW |
Value-Dated capital (local currency) |
Calculation using LOAN_AMOUNT_CALCULATE (Structure: RLOAM) |
BVAHW |
BVAWR |
Value-Dated capital (position currency) |
Calculation using LOAN_AMOUNT_CALCULATE (Structure: RLOAM) |
BVAWR |
BVKWR |
Contract capital (position currency) |
Calculation using LOAN_AMOUNT_CALCULATE (Structure: RLOAM) |
BVKWR |
BVZWR |
Current contract capital (position currency) |
Calculation using LOAN_AMOUNT_CALCULATE (Structure: RLOAM) |
BVZWR |
BZBETR |
Payment amount (payment currency) |
Calculation using FM ACCUMULATION_INIT (Structure REVAL) |
BZBETR |
BZKWR |
Current commitment capital (position currency) |
Calculation using LOAN_AMOUNT_CALCULATE (Structure: RLOAM) |
BZKWR |
DBSYS |
R/3 system, name of central database system |
Calculation using FM ACCUMULATION_INIT (Structure REVAL) |
DBSYS |
DBUDAT |
Posting date in the document |
VDBEKI |
DBUDAT |
DDISPO |
Payment date |
VDBEPI |
DDISPO |
DFAELL |
Due date |
VDBEPI |
DFAELL |
DTRANS |
Flow data key: System date |
VDBEPI |
DTRANS |
DVALUT |
Value date |
VDBEPI |
DVALUT |
EEBETR |
Profit/loss amount (profit/loss currency) |
Calculation using FM ACCUMULATION_INIT (Structure REVAL) |
EEBETR |
EHBETR |
Profit/loss amount (local currency) |
Calculation using FM ACCUMULATION_INIT (Structure REVAL) |
EHBETR |
GSART |
Product type |
VDARL |
GSART |
GSBER |
Business area |
VDARL |
GSBER |
HDN_KUNNR |
Main borrower customer number |
VDARL |
HDN_KUNNR |
HKONT |
General ledger account in Accounting |
VZZBEPP |
HKONT |
KTOPL |
Chart of accounts |
T001 |
KTOPL |
NTRANS |
Flow data key: Sequential number |
VDBEPI |
NTRANS |
RANL |
Contract number |
VDBEKI |
RANL |
RBELKPFD |
Document number of document header (loan) |
VDBEKI |
RBELKPFD |
RHABEN |
Account for credit posting |
VDBEPI |
RHABEN |
RKLAMMER |
Classification number for finance project |
VDARL |
RKLAMMER |
RPOSNR |
Activity number |
VDBEPI |
RPOSNR |
RREFKONT |
Account assignment reference in Financial Assets Management |
VDARL |
RREFKONT |
RSOLL |
Account for debit posting |
VDBEPI |
RSOLL |
RSTBLG |
Reversal document number |
VDBEKI |
RSTBLG |
RUZBEL |
Accounting document number |
VDBEKI |
RUZBEL |
RZEBEL |
Document number of document header for debit position (only for IP records) |
VDBEKI |
RZEBEL |
SANTWHR |
Position currency (currency of position amount) |
VDBEPI |
SBWHR |
SBEWART |
Flow type |
VDBEPI |
SBEWART |
SBEWZITI |
Flow category |
VDBEPI |
SBEWZITI |
SNWHR |
Currency of nominal amount |
VDBEPI |
SNWHR |
SPLWHR |
Profit/loss currency |
Derived from VZZBEPP |
SPLWHR |
SREFZITI |
Reference flow category in accrual/deferral flow records |
VDBEPI |
SREFZITI |
SSIGN |
Direction of flow |
VDBEPI |
SSIGN |
SSOLHAB |
Debit/credit indicator |
VDBEPI |
SSOLHAB |
TILGUNG |
Total of outstanding repayments (active) |
Calculation using FM ACCUMULATION_INIT (Structure REVAL) |
TILGUNG |
TTRANS |
Flow data key: System time |
VDBEPI |
TTRANS |
UEBERZ |
Total of all overpayments in the contract |
Calculation using FM ACCUMULATION_INIT (Structure REVAL) |
UEBERZ |
UPDMOD |
BW delta procedure: Update mode |
Calculation using FM ACCUMULATION_INIT (Structure REVAL) |
UPDMOD |
VERSCH |
Total of remaining open postings |
Calculation using FM ACCUMULATION_INIT (Structure REVAL) |
VERSCH |
WAERS |
Local currency |
T001 |
1. WAERS |
WZBETR |
Payment currency |
Derived from VZZBEPP |
WZBETR |
ZINS |
Total of outstanding interest (active) |
Calculation using FM ACCUMULATION_INIT (Structure REVAL) |
ZINS |
Special Features of the Extractor
This extractor determines only flow-based capital amounts. If you want to determine contract-based capital amounts, or capital amounts from flows and master data, you have to update this information from the ODS contract capital amounts (0CML_O03) to the data target.
The
extractor determines the cash flow for the loan and the corresponding capital
amounts at runtime. If you have a large number of positions, this will result
in a very long runtime.