- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
I_LoanContrPlndItmData
Planned Items for Loan Contract
| view: ILCPLNDITMD | TRAN
| Extraction:
Full or Incremental
| Component: Loans Management
Tables used:
VDBEPP
- 🔑 Keys (5)
- 💰 Amounts (3)
- ∑ Quantities
- 📅 Dates (13)
- ☰ Categorical (9)
- Other (16)
- 🔗 Relations (11)
| 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 | |
|---|---|---|
| 💲 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 | |
|---|---|---|
| CashFlowItemGenerationDate | Flow data key: System date | |
| CashFlowItemGenerationTime | Transaction data key: system time | |
| CashFlowItemEnteredDate | First Entered On | |
| CashFlowItemEnteredTime | Time of Creation | |
| CashFlowItemEditedDate | Last Edited On | |
| CashFlowItemEditedTime | Last Edited At | |
| CashFlowItemCalcDate | Calculation Date | |
| CashFlowItemDueDate | Due date/calculation date | |
| CashFlowItemPaymentDate | Payment Date | |
| CalculationPeriodStartDate | Start of Calculation Period | |
| CalculationPeriodEndDate | End of Calculation Period | |
| CshFlwItmSettlementDate | Settlement date | |
| LoanCshFlwItmIntrstFixingDte | Interest rate fixing date |
| Column Name | Description | |
|---|---|---|
| CashFlowItemPostingDirection | Debit/credit indicator | Show values |
| CashFlowItemReversalStatus | Reversal 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 |
| Column Name | Description | Domain name | |
|---|---|---|---|
| CashFlowItemEnteredBy | Entered By | SYCHAR12 | |
| CashFlowItemEnteredSource | Source of Initial Entry | CHAR10 | |
| CashFlowItemEditedBy | Employee ID | SYCHAR12 | |
| CashFlowItemEditedSource | Editing Source | CHAR10 | |
| CashFlowItemType | Flow Type | SBEWART | |
| CashFlowItemReferenceType | Reference flow type | SBEWART | |
| CashFlowItemCategory | Flow category | SBEWZITI | |
| ReverseDocument | Reverse Document Number | BELNR | |
| LoanLifeCycleStatus | Status of data record | STATI | |
| CashFlowItemPercentageRate | Percentage rate for condition items | DECV3_7 | |
| CashFlowItemSource | Source of flow record | CHAR1 | |
| LoanClassfctnNmbr | Classification Number for Finance Projects | RANL | |
| CshFlwItmBusTransNmbr | Daybook no. | VVRPNNR | |
| AccrDefrlRefFlwCat | Refer.flow category in accrual/deferral flow records | SBEWZITI | |
| WvrWriteoffDocument | Document number of waiver/write-off document | BELNR | |
| AccountingDocument | Document Number of an Accounting Document | BELNR |
| Master Data Relations | Join Conditions |
|---|---|
Currency position
| |
Currency settlement
| |
Nominal Currency
| |
Company Code
| |
Account Credit Posting
| |
Account Debit Posting
| |
Condition Type
| |
Account Assignment Reference
| |
Business Area
| |
Customer Number
|
| Other Relations | to Master Data Relations ↑ | Join Conditions |
|---|---|
Product Type
|