SAP Treasury Module Tables – Full List

Here is a list of important 388 tables used with SAP Treasury Module (SAP TR). You will get more technical details with screenshots of each of these SAP TR tables by clicking on the name link.

 

sap tr module tables
 

Treasury: Foreign exchange swap rates

Control indicators for financial mathematic calculations

Supplements to Analysis System for Table T056R

Commodity Price Volatilities

Exchange Rate Volatilities

Reference interest rate volatilities

Correlation Type

Text Table Correlation Type

Treasury: Clearing Account for Payment Requests

Treasury Rates Table

Default Settings for Risk Evaluations

Volatilities – Definition of Volatility Name

Volatility Types 1

Descriptions of Volatility Types

Statistics Type for Parameterizing Estimation Functions

Text Table Statistics Type

Volatilities – Master Data

Volatilities – Flow Data

Security price volatilities

Correlations from Abstract Instruments

Security Index Volatilities

Reference Int. Rate Volatilities with Curve Info.

Table DDIC buffering (migration)

Liquidity Item Hierarchy Attributes (Header)

Liquidity Item Hierarchy Relationship

Liquidity Item Hierarchy Text

Liquidity Calculation – Other Actual Accounts

Liquidity Calculation – Other Accounts

Liquidity Calculation – Accounts with Assignment Information

Liquidity Calculation – Accounts with Assignment Information

Liquidity Calculation – Settings for FI Mechanisms

Liquidity Calculation – Assignemnt of Acct to Query Sequence

Liquidity Calculation – Global Settings

Liquidity Calculation – Company Codes

Liquidity Calculation – Lock for Forecast

Relationship: Commitment Items – Liquidity Items

Liquidity Calculation – Query Sequences

Liquidity Calculation – Queries for Sequence

Liquidity Calculation – Texts for Query Sequences

Liquidity Calculation: Replacement of Business Area

Liquidity Calculation – Header for Manual Transfer Postings

Liquidity Calculation – Settings for Invoice Exit

Liquidity Calculation – Line Items for Bank Statement Docs

Liquidity Calculation: Forecast Line Items from Loans

Liquidity Calculation – Line Items for Other FI Documents

Liquidity Calculation – Forecast Line Items for FI Documents

Liquidity Calculation: Actual Line Items at Top Level

Liquidity Calculation – Line Items for Manual Transfers

Liquidity Calculation – Forecast Line Items for MM Documents

Liquidity Calculation – Forecast Line Items for FI Documents

Liquidity Calculation – Forecast Line Items for MM POs

Liquidity Calc. Forecast – Line Items, Purchase Requisitions

Liquidity Calculation-Forecast Line Items from Sales Orders

Liquidity Calculation: Forecast Line Items from TR Trans.

Liquidity Items

Relationship: Liquidity Items – Commitment Items

Liquidity Items – Texts

Liquidity Calculation – Queries

Liquidity Calculation – Proposal Fields for Conditions

Liquidity Calculation – Other Fields for Conditions

Liquidity Calculation – Further Tables for Conditions

Liquidity Calculation – Tables for Query Fields

Liquidity Calculation – Ranges for Queries

Liquidity Invoices – Query Texts

Liquidity Calculation – Totals Records

Liquidity Calculation – Forecast Totals Records

Liquidity Calculation: Totals Records at Top Level

Start and End of Term of a Forward Transaction

Index types

Security price type – Text table

Index definition (security index)

Security price type – Text table

Index Values (Secur. Index)

Commodity Curve Type

Commodity Curve Type Text Table

IS-B: Extended interest rate table

Yield Curve Types (Header Information)

Yield Curve Types (Values)

Replacement of currencies for yield curve types

Yield Curve Types (Texts)

Deviation range of ref. int. rates depend. on exact time

Reference interest rate table dependent on exact time

Beta factors

Beta factor type

Risk Management evaluation type – definition

Market Data: Conversion: Basis Spread: Quotation Type

Market Data: Code Conversion Quotation Type Commodities/CPE

Market Data: Price Type Conversion: Commodities / DCS

Market Data: Code Conversion for Index Type

Mkt Data: Assign New Key for Curr. Symbols

Mkt Data: Assign New Key for Curr.Type

Market Data: Assign New Keys for Stock Exchanges

Market Data: Assign New Key for Index Name

Mkt Data:Ass.New Key for Index Type

Mkt Data: Assign New Key for Ref. Interest Rate Name

Mkt Data: Assign New Key for Volatil. Type

Market Data: Assign New Key for Securities/Key 1

Mkt Data: Assign New Key for Sec. Price Type

Quotation Check Table

Quotation description table

Quotation Price Information Table

Quotation Source

Quotation Source Description

Quotation Type

Quotation Type Description

Address-object relationship

Address table

Message collector with time stamp

Partner-Bank relationship

Partner-Vendor relationship

Texts for T037S

Account Assignment References acc. to Transaction Type

Exchange rate indicators

Text table for T068A

Assignment of Exchange to Market Identifier Code

Credit Spread Type

Credit Spread Type – Texts

Market Data Provider for Commodity Forward Rates

Market Data for Forward Rates

Market Data Provider for Commodity Forward Rates (Texts)

Exchange Rate Calculation Indicator

Target group table

Texts for table TD05 target groups

IS-IS: Texts for TD05_AT

Reasons for generating incoming payments immediately

Reasons for generating incom.pmnts immed. (texts)

Flow types for incoming payment rejections

Allocation of program-internal flow types

Internal Level of Financial Assets Management

Name for Internal Level of Financial Assets Management

Heritable Building Right Indicator for Collateral Objects

Type of Heritable Building Right (Descriptions)

IS-IS: Payment terms with adjustment days

IS-IS: Payment terms with adjustment days

Price source

Partner-Object Relationship

Commodities: Quotation Names

Texts for Quotation Names

Commodities: quotation sources

Texttable for commodity quotation sources

Commodities: quotation types

Commodities: quotation types

Calendar Definitions for Financial Centers

Calendar Definitions/Mapping for Financial Centers

Table with data from calendar upload file

Print parameters for each sub-application

Administration of Risk Management areas (indep. of client)

Field catalog for Risk Management

Field catalog for Risk Management, chracter. dependencies

Field catalog, allocation to Risk Management areas

Basis field catalog Risk Management (fixed fields)

Basis field catalog Risk Management, character. dependencies

User data fields per document

Correspondence Interface: Definition of Letter Categories

Corresp.interface: Letter-module relationship

DARWIN text interface: Document groups

ISIS: Document groups (descriptive text)

Inc. Pmnts: Editing per Activity Type (Loans, Real Estate)

Classification of bonds

Text table for TW01 (Classification of bonds)

Type of shareholding

Text table for TW02 (Type of investment)

Details about structure of shareholding

Text table for TW03 (Investment structure)

Legal form (Plc, Corp, Ltd…)

Text table for TW04 (Legal form)

Insurance branch

Insurance branch (Text)

BAV group 4/77 appendix 8

BAV group (Text)

SCB group

SCB group (Text)

Fin.acctng group

Fin. acctng group (Text)

Premium reserve fund list

Relationship table TW09 – RANTYP

Premium reserve fund (Text)

Subsection

Relationship table TW10 – RANTYP

Subsection texts

Balance sheet indicator

Balance sheet indicator (Text)

BAV asset group 501

BAV group 501 (Text)

Table for storing offer reasons

Table for storing offer reasons (text)

Reference between product type and repayment type

References between product type and security classification

Customizing table for SCB indicator

Text table for TW18 SCB indicators

Security category

Security category (text)

Funds category

Fund category (text)

Table for possible deposit types

Table for possible deposit types TEXT

Listing key

Listing key – Text table

Price notations

Price notations – Text table

Price markdowns

Price markdowns – Text table

Security price type

Security price type – Text table

Allocation of program-internal flow types

Stock exchange table

Class data sec. index numbers

Class data sec. index names

Sec.-index class data

Forms of address key translations

Translation for saluation key

Translation table for virt. object categories

Translation table for address category

Translation table for partner-partner relationship

Basis Spread Definition

Basis Spreads: Market Data

Table for maintenance of ratings

Table for the maintenance of ratings (Text)

Legal entity

Relationship table for contracting party classification

Legal Entity (Text)

Customer application type

Customer application type (text)

Stock indicator

Stock indicator (Text)

Changes in net assets

Changes in net assets (Text)

Tax office stock indicator

Tax office indicator (Text)

BAV asset group stmt 101

BAV asset group stmt 101 (Text)

BAV asset group stmt 102

BAV asset group stmt 102 (Text)

BAV asset group stmt 201

BAV asset group stmt 201 (Text)

Asset group C11/76 Asset 6 (Annual stock overview)

Asset group R11/76, appendix 6 (Text)

Appendix group R11/76, appendix 1-5 and R2/87, append. 1-2

Asset group R11/76, append.1-2 and R2/87 append.1-2 (text)

Asset type in acc. with BAV PRF3 and PRF8, sub-section 7

Asset type in acc.with BAV PRF3 and PRF8, sub-sect. 7 (Text)

Control of cost elements for BAV statements

Asset classes relationship table — BAV- Sub-section

Relationship key contracting party classification

Relationship key contracting party classification (Text)

Regulatory reporting list control

Indicator for list selection

Allocation: Valuation area for internal stock indicator

Asset Type According to Regulatory Accounting Requirements

Asset Type in acc. with Reg.Acctng Requirements / Text

BAV asset group stmt 600

Check table for indicator SNW600

BAV asset group stmt 600 / Text

Premium reserve fund list

Premium reserve fund list number / Text

Subsection

Subsection / Text

BAV asset group stmt 102

BAV asset group stmt 102 / Text

Check table for R5/97 appendix 3/4

Text table for indicator appendix 3/4 circular R5/97

Indicator for circular R5/97 appendix 5

Text table provision of security according to app. 5 R5/97

Indicator for circular R5/97 appendix 8

Text table for indicator reason for message appendix 8 R5/97

Indicator for circular R5/97 appendix 10

Relationship table indicator R5/97 append. 10 for prod. cat.

Text table indicator appendix 10 R5/97 mix type

Customizing regulatory reporting field control for contract

Headings for BAV Lists

Product categories

Product categories text

Flow categories

Table of relationships between flow types (ref. flow types)

Flow types relationship key

Posting control table

Definition of flow types

Texts for relationship indicators

Texts for posting control indicator

Flow type groups text table

Flow types text table

Flow type groups check table

Customizing: Accrual/Deferral Flow Types

Flow Types: Interest Basis for Accrual/Deferral

Allocation of program-internal flow types

Control table for CH regulatory reporting (BPV)

Name of grouping table acc.to R11/76 app.4 – Contract.party

Company code: Additional data

Financial Assets Management status definition

Darwin: Customer default values per co.cd/trn.type for KNB1

Value table for intra-entity loan groups

Text table for table TZD1

Texts for TZC37

Calculation base value table

Text table for TZFB Calculation base

Condition Groups

Allocation: Calculation type – KOPO fields

Condition type-dependent detailed description skopo

Allocation: Calculation type – KOPO fields

Condition groups: Texts (language-dependent)

Texts for condition type-dependent detailed description

Correspondence activities

Correspondence activities (texts)

Transition matrix of internal status

Financial Assets Management Product Types

Financial Assets Management product types

Financial Assets Management product type texts

Partner and address management installation parameters

Application area / external role allocation

External role

External roles (Texts)

Grouping of external roles (in application)

Grouping of external roles (Texts)

Internal role of partner

Partner internal role (Texts)

Currency units

Currency Units – Texts

Price notations

Form-of-Address Key

Salutation key

Object categ.for objects which addresses can be assigned to

Key for partner share types in objects

Internal position/employee group

Alloc.of application/role category/dunning parameters

Relationship – Reference relationship link

Texts for keys of partner share types

Internal position/employee group text table

Relationship category of partner-partner relationship

Search and replace strings for phonetic partner search

Activities and their internal status area

Resubmission periods (Deadline reminder)

User-Specific Settings

User-Specific Settings

Datafeed: Translation Table

Datafeed: Environment

Datafeed: Printer/Login Information for Asynchronous Users

Datafeed: Market data

Datafeed: Temporary market data copy for workflow

Individual Settings: Spreadsheet

Datafeed: Permitted Instrument Classes

Datafeed: Instrument Classes Text table

Datafeed: Permitted Market Data Sources

Datafeed: Datafeed Name Text Table

Datafeed: Market Data Monitoring

Datafeed: Log file

Datafeed: Table of Operating Modes

Datafeed: Text Table Operating Modes

Datafeed: Workflow activation

Datafeed: Permitted Mkt Data Sources

Datafeed: Datafeed Names Text Table

Master Data Listed Options and Futures

RM: Authorization Group

RM: Authorization Group (Text)

Scenario Header Table

Scenario Database: Yield Curve Types

Stock, subscription rights, investment certificates

Asset master for securities

Securities listing

Description of Free Security Attribute

Attribute Values for Long Attributes

Texts for Attribute Values for Long Attributes

Attribute Values for Short Attributes

Texts for Attribute Values for Long Attributes

Suffix to Security Attribute

Texts for Suffixes of Free Security Attributes

Free Security Attributes

Tab Page Name: Modifiable in Customizing

Text Table for TPMT_TABNAME

Tab Page Name: Modifiable in Customizing

Text Table for TPMT_TABNAME

Securities additional information

BAV Data

BAV Master Data Without History Management

BAV data change – NOT USED

Variable BAV Master Data

Partner/role object relationship

Collector for batch input KNA1 from RF-VV

Collector for batch input KNB1 from RF-VV

VZPARO – VZGPO allocation

User data central partner and address management

Partner addit. data (general part)

Partner / role list

Sort values for object

Alternative condition item – conditions

Table condition items

Partner / Role / Object relationship

Payment splitting

Also refer the list of SAP TR module tables