SAP Loans Management in FS (FS-CML) Tables Full list

Here is a list of important 686 SAP standard tables used with SAP Loans Management in FS component (SAP FS-CML) coming under SAP FS (Financial Services) Module. You will get more technical details of these SAP FS-CML tables by clicking on the respective table name link.

Offer/Acceptance Reservation Indicator

Offer/Acceptance Reservation Indicator

Treasury: Loans Transferred

Residence Time for Loans – Archiving

Admin. Table for Reorganization of Loan Document Data

Loans: External usage types of a rental unit

Reference Records of Loan Reference Unit for Disbursement

Records of Loan Reference Unit for Open Items

Saved Ref. Records Open Items per Business Operation No.

Reference Recs of Loan Ref. Unit for Val-Dated Cumulation

Dunning and interest data for batch input

Table for collateral keys

Text elements for TD01 Collat.sec.type

Table of Loan Classes

Text Table for TD02 Loan Classes

Define Loan Type

Texts for Table TD03 security types

Reason for Notice

Text table for TD04 (notice types)

Document type

Value table for type of file

Text table for TD061 Type of File

Texts for document groups

Document group

Text table for TD06 document types

Document groups dependent on statuses of transaction types

Purpose of loan

Purpose of loan (Texts for table TD07)

Loan Maturity

Term of loan (texts)

Indicator for special treatment of loan

Indicator for special treatment of loan (texts)

Home statement

Home statement (texts)

Storage location indicator for file original documents

Filing indicator name for file original documents

Type of offer or contract acceptance

Text table for TD13 (Contact/offer acceptance type)

Value table for tax preferential treatment ID

Text table for TD14 (Tax preferential treatment ID)

Residential development financing types

Residential development financing types (text table)

Borrower’s note security value table

Texts for borrower’s note loan securities

Branch office

Branch office text table

Business regions

Business region text table

Organizational Unit (Contract Management)

Organizational Unit (Contract Management)

Allocation of key for wording / Order

Texts for TD20

Special arrangement indicators

Texts for special arrangement indicators

Loan notice types

Notice Type for the Loan

Notice arrangements (lender)

Notice arrangements (lender)

Notice Arrangement for Borrower

Notice arrangements (borrower)

Distribution Channel

Distribution Channel

Form selection legal dunning procedure in loans

Form selection for dunning notices

Alloc. of trans.codes to ok-codes and screen overview

Allocation of OK-codes to the trans.codes

Loans master data field control

Field Control Loan Master Data Loans for Business Operations

Non-Accept.Reason

Reason for non-acceptance (texts for TDA5)

Account Determination Open Item Transfer Posting

Account Determination Open Item Transfer Posting

Accounting Principles for Parallel Valuation

ALE Export Relevance per Company Code

ALE Processing Groups

ALE Processing Groups Text Table

ALE Export Relevance Per Loan

Check Table: Permitted Defaults Posting Date per Application

Field Catalog – Applications

Field Catalog – Applications Text Table

Flow Types per Posting Application Additional Data

Activity Type – Control of Requirements

Customizing Table for Roles Relevant for BaFin

Invoice categories

Description of Billing Categories

Bill Format (Paper Bill / Paperless Bill)

Description of Bill Format (with Print / without Print)

Settings for Billing

Form line items (credit stnd.check, doc.values, csh budget)

Text table for TDBL (debit and income types)

Processing Options for CLI Differ. for Each Bus. Op. Subcat.

Text Table for Flow Grouping to Calculate Int. on Arrears

Exception Table for Inflow Behavior

Exception Table for Outflow Behavior

Header Entry for Control of Inflow Behavior

Header Entry for Control of Outflow Behavior

Default Posting Date

Texts: Default Posting Date

General Control Data of Capital Transfer

Indicator Manual Postprocessing

Texts for Manual Postprocessing Capital Transfer

Capital Transfer Reasons

Texts Capital Transfer Reasons

Repayment Change Indicator Capital Transfer

Texts for Repayment Change Indicator Capital Transfer

Templates for Capital Transfer

Texts for Capital Transfer Templates

Transfer Behavior Capital Transfer

Texts for Transfer Behavior

Settings/Preassignments for Capitalization of Overdue Items

General Control Data

Customizing Table: Reason for Postprocessing Capitalization

Customizing Table: Reason for Postprocessing Capital. Texts

Reason for Capitalizn

Reason for Capitalization: Texts

Assignment of Status Field No. to Credit Bureau Field Name

Assignment of Status Profile to Credit Bureau Field

Define Parameters for Credit Bureau

Processing Characteristics

Processing Characteristics

Processing Characteristics Text Table

Values for Processing Characteristics

Values for Processing Characteristics

Processing Characteristic Value Text Table

Processing Characteristic Value Text Table

Processing Characteristics

General Control Data

Change Category

Change Sub-Category

Change Sub-Category Text Table

Change Category Text Table

Table of Credit Life Insurance Rates

Text Tables for CLI – Rates

Table of Credit Life Insurance Rates

Table of Occupational Keys for Credit Life Insurance

Consumer Loans: Correspondence Without Correspondence Tool

Field Catalog – Components

Field Catalog – Componenets Text Table

Field Catalog – Components Variants

Field Catalog – Components Varients Text Table

Condition Category

Texts for TDCONDCATEGORY

Condition Verification: Permitted Condition Constellation

Condition Verification: Permitted Condition Constellation

Condiotion Verification: List of Customizable Checks

Condition Verification: Texts for Customizable Checks

Condition Verification: Define Field Properties

Condition Verfier: Field Item Customizing

Condition Verification: Define Permitted Field Values

Condition Verification: Update Checks and Define Msge Type

Condition Verification: Permitted Flow Categories

Condition Verfication: Permitted Calculation Categories

Currency-Dependent Default Setting of Conditions

Fields for Correspondence, e.g. Action if Undeliverable

Field Control for Condition Item

List of Application Functions Supported (Condition Table)

Correspondence Tool: Optional Text Modules

Definition of Custom Text for Correspondence Tool

Customer-Specific Solution for Borrowing

Control Table Customizing Checks

Field Catalog – Customizing Field Status

Tabstrips Control

Tabstrip Text Control

General Control Data

Payment info. for reactivated items after borrower change

Reason for the Borrower Change

Text Table for Borrower Change Reason

Status Transfer Matrix

Determination of Counter Method Using Dunning Procedure

Control Dunning Using Product Type

Settings/Preassignments for Deferral

General Control Data

Customizing Table: Reason for Postprocessing

Customizing Table: Reason for Postprocessing Texts

Reason for Deferral

Texts for Reason for Deferral

Value table 1 User-specific loans key

Value table 2 User-specific loans key

Value table 3 User-specific loans key

Value table 4 User-specific loans key

User-specific loans key 1 text table

User-specific loans key 2 text table

User-specific loan key 3 text tables

User-specific loan key 4 texts

General control data

Reasons for Manual Postprocessing

Texts for Reasons for Manual Postprocessing

Disbursement: Template

Disbursement: Sample Text

Fields for Correspondence, e.g. Action if Undeliverable

Reason Categories

Reason Descriptions

Assign a New Key to Escrow Flow Category for FIMA

CML Corr.: Assignment of Posting Area – ISR Partic. Number

CML Corr.: Sequence for Printing Items

CML Corr.: Invoice Header

CML Corr.: Invoice Positions

Exception Table for Controlling Outflow Behavior

Header Entry for Controlling Outflow Behavior

Field Catalog – Field Catalog

Field Catalog – Field Groups

Field Catalog – Field Groups Text Table

Field Catalog – Field Catalog Text Table

Permitted Flow Types Per Region

Evaluation Criteria

Incoming Payment: Order of Evaluation Criteria

Incoming Payment: Assignment Table

Incoming Payments: Assignment Criteria Texts

Hierarchy Plan

Hierarchy Settings

Outgoing Payment Sequence of Evaluation Criteria

Outgoing Payment Assignment Table

Outgoing Payment Evaluation Criteria

Outgoing Payment Evaluation Criteria Texts

Processing Rules for Contracts with Stop Codes

Do Not Use: Insurance Categories

Do Not Use: Insurance Categories

Temporary Use: Insurance Categories – Texts

Field Catalog for Converting Modification Groups

Assignment Condition Type to Flow Type Grouping – IOA Calc.

Interest on Arrears Active in BO Interest on Arrears Calc.

Assignment of Flows to Flow Type Grouping – IOA Calculation

General Control Data for Interest on Arrears Calculation

Flow Types Without Recalculation

Text Table for Profile Definition IOA Calculation

Assignment of Product Type to Profile and Flow Type Grouping

Profile Definition for Interest on Arrears Calculation

Template for Interest On Arrears Calculation

Template Texts for Interest on Arrears Calculation

Trivial Amount per Currency and Profile IOA Calculation

Payment Plan Hierarchy

Texts for Payment Plan Hierarchy

Customizing Table, Definition of Processing Rules

Text Table for Rule Key

Definition of Correspondence Class

Predefine Correspondence Class Assignment for Partner

Correspondence Class Texts

GBA control table-Output

Collat.securities preferential treatment ID table

Collat.securities special treatment ID text table

Indicator Table Guarantee Type 1

Indicator Table Guarantee Type 2

Text Table Indicator Guarantee Type 2

Text Table for Guarantee Type 1 Indicator

Pledge status indicator table

Pledge status indicator text table

Loan report layout parameters

Condition Types per Application Partial Function Loans

Flow Types per Application Subfunction for Loans

General Data for Discharging Loan

Application subfunction for loans

Name of Application Subfunction in Loans

Default Sttng of Permitted Roles and Roles for Partner Copy

Activate Localization

Define Country-Specific Functions

Text Table for Country-Specific Functions

Loan Origination: Control Parameters

Loan Origination: Assignment of Sales Channels

Loan Origination: Permitted Charges/Insurance Policies

Loan Origination: Permitted Charges

Loan Origination: Business Partner Data for CLI Calculation

Loan Origination: Assignment of Conditions

Loan Origination: Assignment of Payment Methods

Loan Origination: Assignment of Insurance Rates

Loan Origination: Loan Originator

Loan Origination: Assignment of Loan Purpose

Loan Origination: SAVE modules for saving loans

Loans: Manual Dunning Level

Loans: Text for Manual Dunning Level

Customizing: Automatic Incoming Payment Postprocessing

Hidden Fields for Loans

Field Texts for Consumer Loans

“Billed but Not Due” Charges

Define Country for Extension Note to Payee

Assign Note to Payee in PMW

Assign Note to Payee in PMW

Receivables Interim Account for Business Operation Notice

Texts for Receivables Interim Account

Object construction methods table

Indicator for Condition of Object

Indicator for Condition of Object (Description)

Indicator for Collateral Object Fixtures and Fittings

Indicator for Collateral Object Features (Description)

Indicator: Area Description for Object

Object Area Description Indicator (Description)

Texts for TD01 Object Construction Methods

Part of building name

Text table for TD02 part of building name

Valuation qualification indicator

Valuation qualification ID// Text for TD03

Type of valuation procedure

Type of valuation procedure// Texts for TDO4

Valuation rating base

Rating base valuation// Texts for TDO5

Administration cost types

Text table for administration cost elements

Property Conditions for Collateral Objects

Property Conditions for Collateral Objects (Description)

Application Descriptions CML

Application Indicators Text Table

Exception Table for the OP Lock Tool

Payment Lock in Lock Management per Application

Field Catalog – Organization Profiles

Field Catalog – Organization Profiles Text Table

Field Catalog – Organizational Unit

Loan Origin

Loan Origin: Text Table

Selection, Modification- and Reference Fields

Selection, Modification and Reference Field Texts

File register definition

File register definition texts

File functions

File Functions Texts

File register/function allocation

Alloc. of activity type and flow category to condition type

File categories

File categories

Assignment Dunning Level Payment Status Stop Codes

Payment Method for Credit Life Insurance Included in Loan

PPM: Condition Types for Payment Plans

U.S. Incoming Payment: Reasons for Qualified Overpayments

Payment Cat.

Payment Cat.Description

Prepayment Criteria

Flow Type for Prepayment Criteria

Priority of Prepayment Criteria

Texts for Prepayment Criteria

Assignment of Product Type to IP Distribution Plan

Field Catalog – Assignment of Profiles to Products

Assignment of Product Category to Payment Hierarchy

Field Catalog – Profile

Field Catalog – Field Status for Profiles

Field Catalog – Profiles Text Table

Attribute: Field Description


Description Attribute

Attribute Hierarchy

Attribute Type

Description of Attribute Type

Structure/Table Names for Unrestricted Attribute Usage

Log Imported Transports for Attributes

Prefix for Attributes and Profiles

Product Category

Description Product Category

Product, Master Data

Product Description

Version of a Prodcut, Master Data

Assignment of Transaction Code to Product Category

Version Attribute

Version Attribute Category Field

Version Attribute Category Field: Multiple Value Fields

CML Correspondence Role Type

Description of the Correspondence Role Type

IS-IS Loans installation parameters for company codes

IS-IS Loans: Installation parameters on client level

Valuation of loan contract

References to Basis Amounts (Calculation Bases, Cap Amnts)

Text Table for References to Basis Amounts

Remittance Code

Remittance Code Description

Assignment of Remittance Code to Postal Code

Cash Flow Behavior in the Payoff

Texts for Communication Status

Communication Status Payoff

General Control Data for Payoff and Notice

Distribution Methods for Fields in Receivables List

Text Table for TDREPAY_MMETHOD

Condition Type Determination for the Payoff

Payoff Reasons

Texts for Payoff Reasons

Customizing for Receivables List

Name of Items in Receivables List

Rejection Reasons

Texts for Rejection Reasons

Flow Type Groups for Receivables List for Payoff

Text Table for TDREPAY_RLFLOWST

Table for Payoff and Notice Templates

Texts for Payoff Templates

Active Currencies for Rounding

Repayment Plan: Relevant Condition Types

Repayment Plan: Relevant Condition Types

Foreign currency loan with special coverage

Possible assignees

SEPA Activation per Company Code

Set Additional Posting Information per Appliation

Special interest indicators text table

Special interest indicator for loans

Assignment and Prioritizing of Flow Types to Payment Cat.

Texts for possible assignees

Stops

Stop Actions

Assign Stop Actions to Stops

Text Elements for TDSTOP_ACTION Stop Actions

Stop Applications

Text Elements for TDSSTOP_APPL Stop Applications

Text Elements for TDSTOP Stops

BP: Business Partner – Role Type

BP: Business Partner – Name of Role Type

System Table – Reasons for Suspense

Text Table for TDSUSPREASON

CML: Link Parallel Position Management per Company Code

Internal Checks for Flow Types in Customizing

Activate Country-Specific Functions

Pushbutton Text for Loans Master Data Tabstrip(User Exit 14)

Alloc.of application/role category/dunning parameters

Alloc.of application/role category/dunning parameters

Dunnable payment methods for incoming payments in loans

Flow Types Excluded From Waiver Display

Reasons for Automatic Waiver of Charges

Language Table for Automatic Waiver of Charges

Waiver Rules

Texts for Waiver Rules

Customizing prima nota

Prima nota customizing texts

Loan Document Data Summarization: Administration Table

Summarization of Loan Document Items: Carryforward Records

Value Characteristics of Risk Classes

Description of Risk Classes TRISKCLASS

OBSOLETE: Previous Solution: BOs Transferred from Loans Area

OBSOLETE: Previous Solution: Loans Flows Transferred

Sales data for acct statements

Work Table for GBA 24c

Referenzzinssatztabelle

VZZBEPP Ausnahmefelder für Vergleich

Vom Vergleich ausgeschlossene Darlehen

Konfiguration je Benutzer

Test neue Fima: Grunddaten und VDARL

Test neue Fima: VVZZKOPO

Test neue FIMA: VZZBEPP

Test neue FIMA: VZZKOKO

Tab. for document values temporarily stored for background

Posting applications control table

Posting applications control table

Predefinitions

Control of incoming payments

Definition of criteria/memo rec. grouping/inc.pmnt distrib.

Flow control of advance payments and overpayments

Incoming payment distribution basic configuration

Incoming payment distribution criteria value table

Text table TVZ01 / Incoming payment distribution

Text table for incoming payments distribution criteria

Value Table Credit Type Regulatory Reporting

Text Table Credit Type Regulatory Reporting

Value table credit class regulatory reporting

Text table for credit class regulatory reporting

Offer/Acceptance Reservation Indicator

Offer/Acceptance Reservation Indicator

Flow Type Groups Definition for Cash Flow Display

Trans. type – Trans. type groups allocation for cash flow

Flow types per posting application

Texts for transaction type groups

Relationship: Flow type – External flow type

External flow types for evaluations

Texts: External flow types for evaluations

Assign Contract Type – Relationship Cat. – Activity Cat.

Separation, sort documents for posting interface

Assign flow to a unit category

Allocation: Flow type groups and print columns in reports

Reversal logic of individual posting activities

Assign Contract Type – Activity Category

Assign Activity Category – Reversal Transaction Grouping

Activity-dependent one-time conditions

Texts entry activities REHER

Processing group

Name of Clerk (Processing Group)

Processing Type

Name of Processing Type

Assign clerk

Flow Type Group

Name of Flow Type Group

Assign Flow Type to Flow Type Group

Account group

Name of Account Group

Assignment of G/L account to account group

Selection Key

Name of Selection Key

Processing category

Name of Processing Category

Processing Key

Name of processing key

Assignment of Processing Categories to Processing Key

Name of User Function Keys

Pmnt PP: Default Susp. Acct Cust. for Refund by Bank Transf.

Payment PP: Default Payment Meth. for Refund by Bank Transf.

Account Clearing: Excluded Flow Types

Account Clearing: Amount Limits

Account Clearing: Checks at Contract Level

Account Clearing: Checks at Customer Account Level

Internal Bank Numbers for Returned Direct Debit Charges

Payment Type

Payment Cat.Description

Logic for creating and updating value date reference units

Release object for release procedure

Definition of release objects

Release procedure: Object hierarchy for release

Release object text

Release status definition for the release procedure

Release status parameters

Release status definition texts

Event-controlled modification of condition items

Event-controlled modification of condition items

Event-controlled modification of condition items

Event-controlled modification of condition flows

Event-controlled modification of condition items

Correspondence Activities

Product type numbers

Number components

Number components (Text)

Standard check digit procedure table

Addon for Product Types of Asset Management

Incoming payment distribution prioritization

Types of restraint on drawing

Type of restraint on drawing: Text table

Form of address / Letter / ID

Form of address / Letter / ID

Transaction allocation – Date / Transaction / Number

Transaction code – Correspondence activity allocation

Table with Dates for Auto Debit Run

Auto Debits, Historical Data

Result Table for Auto Debit Collection

File with documents for loan allocation

Admin. Table for Reorganization of Loan Document Data

Index Table for the Loan Document Data Archiving

Carryforward Records for Reorganization of Loan Doc. Items

Carry-Forward Recs of Loan Doc. Item Reorg. bef. EURO Convsn

Loans

Print and dispatch control data for VDARL

Do Not Use: Insurance Policies for Loan (Relationship Table)

Loan objects relationship table

Collateral for loan (relationship table)

Loans: Currency Data Before EURO Conversion

References from Premium Plans to Relevant Objects

Direct Debits Per Contract

Loan Contract – Data of Repayment Plan

Drawings on Disbursement

Disbursement Drawings Before EURO Conversion

Payment advice note table

Selection conditions for loans

Flow Data: Document Header for Actual Record

Shadow Table for VDBEKI (Restrictions)

Document relationship between FI and subledger document

Posted line items for document header

Flow Data / Actual Position Before EURO Conversion

Shadow Table for VDBEPI (Restrictions)

Flow Data – Planned Item

Flow Data / Planned Items Before EURO Changeover

Bill Control

Billing History

Billing Items

Collateral Value Building Value

Administration costs

Land value collateral value

Revenue value collateral value

Debit types-Header data

Debit types-Items

Collateral Value Gross Revenue Value per Building Part

Collateral Val. Real Value Other

Collateral Value Real Value Resid. Prop./Part-Owners.

Business Operation: Entered and Activated Flow Data

Flow Data / Planned Items Before EURO Changeover

Business Operation: Header

Business Operation: Header

Business Operation Insurance Data

Data for Capitalization of Overdue Items

CAPTR: Master Data of Capital Transfer

Data Selection for Credit Bureau

History of Data Supplied to Credit Bureau

Table of Data Reported to Credit Bureau (Per Loan)

Header and Totals Records for Data Reported to Credit Bur.

Partner Data Reported to Credit Bureau (Pro Loan)

Cash Flow Management

Processing Characteristics: Change Documents

Change Pointers Loan

Storage of unique links between FI and CML doc

Payments to be Posted Later

Data Storage for Report RFVD_GROSS_TO_NET

Results of Interest on Arrears Check

Check Interest on Arrears – Open Items

Table for Global Parameters

VDCHK_TRL_REV

Business Operation: CLI Rescission/Notice

Rescission of Business Operation

Display Interval for Cash Flow

Loans: Search Index for Correspondence (Document Finder)

Control Table for Creation of Correspondence

Condition Table

Texts for Condition Table

Versions of Condition Tables

Conditions in the Condition Table

Texts for Conditions

Condition Items in the Condition Table

Assignment: Product —> Condition Table

Data Transfer – Loans – Flows – Actual Records

Table for entering loan numbers and customers

TR-EDT: Transfer Loans

Loans: Header Data – Lines Layout

Loans: Header Data – Columns Layout

Loans: Header Data – Version Layout

Borrower Change Without Capital Transfer

Deferral Data

Number of Times in Arrears per Days Past Due Category

Disbursement Specific Header Data

Disbursements That Were Not Released

Dunning run data per loan and dunning run

Parameters of Dunning Run for Treasury Loans

Dunning run data per loan and dunning run

TEMPORARY USE: Escrow-Specific Master Data

Escrow Reference Table for VDARL

TEMPORARY USE: Escrow Condition Headers

TEMPORARY USE: Escrow Condition Items

Master Data Extension and Skip

Loan: Relationship Partner/Role Object

Encumbrances on real estate table

Loans Interested Parties

Collateral Objects

Determination of collateral value/Expert report of object

Object building parts

Main file header

Do Not Use: Insurance – Header Data

Do Not Use: Insurance – Fields with Changeable Content

Original Documents Without Model Account Int. on Arrears

Progress (Interest) of Model Account IOA Calculation

Calculation Details for Interest on Arrears Calculation

Condition Header Data Before EURO Conversion (Loans)

Condition Item Data Before EURO Conversion (Loans)

Worklist File for Bal. Sheet Transfer / Acct Assignment Ref.

Processing Characteristics per Loan

Contracts/Credit (life ins., build.savings etc) basic data

Maturity data for collateral (Life insurances)

Loans: Mapping Table Data Fields for Descriptions

Condition Table: Header

Condition Table: Modification Item

Condition Table: Variant Item

Message Type for the Condition Type

Note to Payee

Borrower’s note loan order data

Order Data for Borrower’s Note Loans Before EURO Conversion

Prima nota number

Customizing prima nota number

Assign prima notas to super prima nota

File header

File item

Customizing table for Reference Interest Rate

Assignment of Partner to Remittance Code

Payoff Master Data

Risk Classification for Individual Value Adjustment

Loan collateral in acc. with BAV/PRF4

Collateral in securities in acc. with BAV/PRF5

Records for new auto debit (SEPA direct debit)

SEPA DD – Lead Time Determination

Settings for Access Sequence (SEPA Direct Debit)

Overview of mandates used in Loans Management

CML specific Customizing for Payment Method (SEPA)

SEPA Return Codes

SEPA Return Codes (Text)

SEPA Return Reasons

SEPA Return Reasons (Text)

Special Arrangements for Collateral

Status table for loan CATT procedures

Assign Stop to Loan

File documents for loan allocation

Table for preemption conditions

Loan carry-forward totals

Rule Set for Waiver Profile

Texts for Waiver Profile

Waiver Profile Header

Loan Worklist for Postprocessing

Assign Partner / Correspondence Class not Required

Pmnt Postproc.: Header for a Payment Postprocessing Activity

Payment Postprocessing: Payment Inform. for a PPP Activity

Payment Postprocessing: Payments for a PPP Activity

Recall of SEPA Credit Transfers

Payment Postprocessing: Usage of a Payment Postpr. Activity

Relationship Agent/Activity Type/Object

Payment Details for the Loan

Table for Writing Off Trivial Amounts

Release data (Informative data for the release procedure)

Central entry table for release procedure

Table of Links Between Loan and Insurance Policy

Insurance Tracking Vendor Portfolios

Customizing Table for System Settings

Click here to know details about SAP transaction codes used with Loans Management in FS.