Programme SAP SAPDBTIF - Treasury Information System

Description
The logical database SAPDBTIF (TIF - Treasury Information System)contains data from the Treasury areas Loans, Securities, ForeigneExchange, Money Market, Options and Derivatives.
The logical database TIF consists of the higher-level structure VZKOPF(general data) and the lower-level structures VZDARL (loan data),VZWERTP (securities data), VZOPTO (date on derivatives and options),VZTRDAT (flow datan) and VZSUMME (totals records in local and positioncurrencies which are available at events which use the same name.
The events GET VZKOPF, GET VZTRDAT and GET VZSUMME are used by allareas.
The events GET VZWERTP, GET VZDARL (loan data) and GET VZOPTO are usedif the corresponding Treasury areas are selected.

Authorization checks
F_INFO_BUK

Selection fields
Depending on the selection screen (see selection screens) you havechosen from the logical database, not all fields are shown.

Mandatory fields
Mandatory field divide the logical database into the five areasSecurities (field P_JWERTP), loans (P_JDARL), foreign exchange(P_JDEVI), money market(P_JGELD) and derivatives (P_JDERI).
You must select at least one of these areas and you can combine anynumber of them. Optional fields are only selected if they relate to theselected areas, e.g. the field securities account (S_RLDEPOT) is onlyrelevant in connection with securities.

Optional fields

Company code (S_BUKRS)
You can select company codes which are maintained in the ImplementationGuide (IMG) under Corporate structure --> Definition --> Financialaccounting --> Create company code.

Portfolio (S_RPORTB)
You maintain portfolios in the Implementation Guide under Treasury -->Treasury Management --> Basic functions --> Organization --> Portfolio.A portfolio is a group of securities accounts.

Securities account (S_RLDEPO)
The securities accounts maintained in the Treasury areas are used asselection criteria. A group of securities accounts may be groupedtogether in a portfolio.

Product category (S_SANLF)
The product category is the level above product type. The productcategory is fixed in the system and cannot be freely defined.

Product type (S_SGSART)
Product types are defined in the IMG (Implementation Guide) for each ofthe five Treasury areas under Master data -> Maintain product types andare assigned to only one product category.

ID Number (S_RANL)
The securities ID number refer to the master data maintained in TR-TMSecurities.

Contract number (S_RANLVD)
The loan contract number refers to the loan contracts created in TR-TMLoans

Transaction (S_RFHA)
Only relevant for foreign exchange, money market and derivatives. Itidentifies a financial transaction within a company code.

Account assignment reference (S_REFKON)
The account assignment reference identifies the balance sheet accountin Financial Accounting to which a securities position in a securitiesaccount, a loan or a financial transaction is to be posted. It ismaintained in master data.

Currency (S_SBWHR)
You can select position or transaction currency. In addition, the localcurrency shows positions in the company code currency.

Bilance sheet indicator (S_BILK)
The balance sheet indicator is used for securities and loans todetermine which transactions are to be assigned to which balance sheetitems in the BAV statement, in accordance with German accountinglegislation for insurance companies.
For loans, you maintain this indicator in the loan contract and forsecurities is it maintained in the position indicator.

Asset group (S_GLZB)
Asset group in line with SCB groupings. Relevant for securities andloans.

Start of term (S_DBLFZ)
Securities: start of issue. Only for product types bond, convertiblebond and warrant bond.
Loans: Start date of loan.
Derivatives, options: Start of term of a transaction.
Money market: Start of term of a transaction.

End of term (S_DELFZ)
Securities: Final maturiy of a security, only for product types bond,convertible bond and warrant bond.
Loans: End of term of a loan.
Derivatives, options: End of term of a transaction.
GMoney market: End of term of a transaction.

Repayment type (S_TILGART)
Type of repayment (e.g. bullet repayment).

Interest rate type (S_ZINSTY)
Fixed, constant, variable linked to a reference interest rate. Other:Formule for calculating interest contained in conditions.
Fixed variable: fixed interest rate, e.g. Year 1: 4%, Year 2: etc.
Relevant for loans and interest-bearing securities.

Interest rate (S_PKOND)
Maintained in master data under conditions. (as a percentage).

Reference interest rate (S_ZSREF)
Interest rate based on a base rate (e.g. LIBOR + 3%)

Quotation type (S_NOTTYP)
Only securities: Quotation type e.g. securty, option, future,etc

Business partner (S_PARTNR)
For securities: Issuer
For loans: Issuer, Main borrower.
Others: Counterparty

Unit number (S_RKLAMM)
Used for loans and borrower's notes if several loans are used tofinance one object.

Interest calculation method (S_ZBMETH)
The various methods are defined as fixed values in the SAP system. Theyare assigned to the corresponding objects.

Business area (S_RGSBER)
Can be maintained in IMG under Corporate structure --> Definition -->Financial Accounting --> Create business area.

Depositary bank (S_DPBANK)
When you create a securities account it has to be assigned to adepositary bank. It is a role category of a business partner. Onlyrelevant to securities.

Securities account number (S_PDNR)
The number used at the depositary bank to keep track of the securitiesaccount. Only relevant to securities.

Security type (S_WERTTY)
Type of security (bearer instrument = 1, registered instrument = 2,registered instrument with limited transferability = 3. Only relevantto securities. The security types are defined as fixed values in thesystem.

Classification (S_KLASS)
A freely definable classification for managing securities.

Issuer call (S_DKEMI)
Call date of a bond if the issuer calls it prior to final maturity.

Key date (P_DSTICH)
Positions are calculated and make available in the structure VZSUMME asper the key date. To determine positions per key date,RFVWLSP-SREPORTING (see Internal control parameters) must not be set to'B'.

Update planned records first P_UPDATE)
If the parameter P_UPDATE is set, the cash flow is updated before flowdata are selected and generated until the end of the term, if onlyavailable in part in the database. Otherwise the flow data are takenfrom the database. (Loans and securities). Wertpapier)
The remaining balancs of a loan contract is only displayed in fieldVZSUMME-BSALDO if P_UPDATE is set. Using this option is very time-consuming.

Position incl. planned records (P_SUPLAN)
If P_SUPLAN is set, both planned and actual values are used tocalculate the field values in structure VZSUMME. the total.
Irrespective of this indicator, structure (VZTRDAT) contains bothplanned and actual records.

Due date (S_DBEWEG)
In VZTRDAT, all flows are supplied which have a position value date/due date which correspond to the selection criteria from S_DBEWEG.(Exception: RFVWLSP-SREPORTING = 'B'. Seee Interne control parameters)

Evaluation per fiscal year (P_GSJ)
Parameter P_GSJ ensures that data are selected for a specific fiscalyear. If you set this indiciatro, the date fields P_DSTICH and S_DBEWEGare set to the fiscal year of the company code concerned.

Internal control parameters
Control parameter RFVWLSP-SREPORTING is automatically evaluated by the
logical database. To set this parameter, you only need to incorporatestructure RFVWLSP in your own ABAP using a tables instruction and tofill it using a MOVE TO RFVWLSP-SREPORTING. The database programthen evaluates it independently.
Permitted values for RFVWLSP-SREPORTING are blank, 'E' and 'B'.

RFVWLSP-SREPORTING = 'E'
Using the internal control parameter RFVWLSP-SREPORTING you can alsostart the calculation of positions by using S_DBEWEG-HIGH in additionto using P_DSTICH (this applies to loans and securities.) For thispurpose, the first entry in table S_DBEWEG is evaluated.
This is useful, e.g. for position trend lists if you are interested ina position at the start and the end of the period under review(S_DBEWEG).

RFVWLSP-SREPORTING = 'B'
When calculating positions for analysis purposes, you can useRFVWLSP-SREPORTING = 'B' to ensure that all position changes withstatus planned and actual are included in the calculation (applies tosecurities).
The date for the key date is always blank for this variant.
At the same time, all planned records for nominal interest (TZ) andrepayment (TT) with a due date within S_DBEWEG are made available instructure VZTRDAT. This control paramter is used, e.g. for calculatingpositions per key date for market risk management.
Selection screens of a logical database are selected when you create aprogram under --> Attributes. If you do not choose a selection screenthe basic screen (screen no. 1000) is used. It contains all possibledatabase selection parameters. If you change the selection instructionsthe system automatically regenerates it, and it is then available inall programs you call up.
NEW-PAGE

Available fields
Available fields are marked with an X
Selection screen variant
Field description 1000 902
P_JDARL X X
P_JWERTP X X
P_JDERI X X
P_JDEVI X X
P_JGELD X X
S_BUKRS X X
S_RPORTB X X
S_RLDEPO X X
S_SANLF X X
S_SGSART X X
S_RANL X X
S_RANLVD X X
S_RFHA X X
S_REFKON X
S_SBWHR X
S_BILK X
S_GLZB X
S_DBLFZ X
S_DELFZ X X
S_TILGART X
S_ZINSTY X
S_PKOND X
S_ZSREF X
S_NOTTYP X
S_PARTNR X X
S_RKLAMM X
S_ZBMETH X
S_RGSBER X X
S_DPBANK X
S_PDNR X
S_WERTTY X
S_KLASS X
S_DKEMI X
P_DSTICH X
P_UPDATE X
P_SUPLAN X
S_DBEWEG X
P_GSJ X