Hierarchy
BBPCRM (Software Component) BBPCRM⤷
CRM (Application Component) Customer Relationship Management⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages⤷
FVVW (Package) Treasury Management: Securities
IMG Activity
| ID | ERTRAGE_TREASURY_WP | Cross-Treasury Revenue List |
| Transaction Code | S_ALR_87009305 | IMG Activity: ERTRAGE_TREASURY_WP |
| Created on | 19981222 | |
| Customizing Attributes | ERTRAGE_TREASURY_WP | |
| Customizing Activity | ERTRAGE_TREASURY_WP |
Document
| Document Class | SIMG | Hypertext: Object Class - Class to which a document belongs. |
| Document Name | ERTRÄGE_TREASURY_WP |
In this section you define the sort and output sequences for a revenue list. You are able to evaluate your flow data from various points of view for a specified period via the different sort and output sequences which you specify here.
Standard settings
- No new entries for sort and output sequences are allowed.
- The technical data fields should not be changed.
- The following entries can be changed:
- The "Field title" refers to the text of the fields which will be printed in the list.
- The "Field length" (number of characters) can also be changed, should you require more space for an altered entry.
Activities
- Define the sort sequences:
- Select Sequence -> Sort sequence.
- Define the sort sequence.
- Define the output sequences:
- Select Sequence -> Output sequence.
- Define the output sequence.
Further notes
In the detail screen for the sort and output sequences you can call up all possible sort and output fields (F4). Double-click on a field and choose 'Back' to enter the selected field in the sort/output sequence.
Overview of sort and output fields:
The following sort fields are available:
ASTUECK
Number of unit-quoted securities for each securities account per 'date from'
BNOMINAL
Total nominal for percentage-quoted securities for each securities account per 'date from'. To display the data correctly, make sure field SBWHR also appears in the sort sequence and that it is
b e f o r e field BNOMINAL.
BBUCHWR
Book value of the security per securities account in the foreign currency of the company code
BKAUFWR
Acquisition value of the security per securities account in the foreign currency of the company code
BKOSTWR
Capitalized IC (acquisition value) of the security in the foreign currency of the company code
BKSTBWR
Capitalized IC (book value) of the security in the foreign currency of the company code
BKOND
Absolute interest amount (concerns unit-quoted securities)
PKOND
Interest rate in percent (concerns percentage-quoted securities)
SWHRKOND
Currency of condition item interest rate/interest amount
BNOMS
Nominal value of the security
BRSCH
Issuer industry sector (securities), main borrower (loans) or counterparty (Treasury)
BUKRS
Company code
DATUM
Date of flow
JAHR
Year
MONAT
Month
QUARTAL
Quarter
LAND1
Country of origin of issuer, main borrower, counterparty
DBLFZ
Start of term of the security/loan or start of term of the transaction in money market, foreign exchange and derivatives areas
DELFZ
End of term of the security/loan or end of term of the transaction in money market, foreign exchange and derivatives areas
DKEMI
Termination issuer
HBKID
House bank ID (for loans contract)
SGSART
Transaction type in Treasury
PEFFZINS
Effective interest rate according to conditions
SEFFMETH
Effective interest method
RANL
Security ID number
RANLVD
Loans contract number
RANTYP
Treasury contract type
RDEPOTNR
Securities account number
RDPBANK
Depository bank (partner number)
XDPBANK
Name of depository bank
RGSBER
Business area
RHANDPL
Exchange
RKEY1
Sort string 1: ID number for securities, contract number for loans and transaction number for money market, foreign exchange, derivatives
RKEY2
Sort string 2: Securities account ID for securities, otherwise blank
RKLAMMER
Loans financial project number
RLDEPO
Securities account ID
RPORTB
Portfolio position
RREFKONT
Account assignment reference
SBILK
Balance sheet indicator
SBWHR
Position or transaction currency. Also issue currency for securities.
SHWHR
Local currency
SGLZB
SCB asset group indicator
SKLASS
Securities classification
SNOTTYPE
Quotation type
SORTL
Partner ID issuer, main borrower, external business partner ID
SRATING
Rating issuer, main borrower, counterparty
SRECHTSF
Legal form issuer, main borrower, counterparty
SRECHTST
Legal entity issuer, main borrower, counterparty
SROLEXT
External role issuer, main borrower, counterparty
STILGART
Repayment type
SWERTTYP
Security type
SZBMETH
Interest calculation method
SZINSTYP
Interest category of bond: fixed, variable, fixed with variable interest calculation, and other.
SZSREF
Reference interest rate
VERKONTO
Clearing account (from master data to securities account)
ZSFELD1 bis ZSFELD9
Fields for self-defined sort criteria
The following output fields are available:
NENNSTCK
Nominal/number of units of position change
WRNENN
Inflow nominal value in foreign currency
WRNENN_S
Nominal value balance after position-changing flow in foreign currency
WRANSCH (*)
Acquisition value in foreign currency
WRANSCHS (*)
Acquisition value incl. act. IC in foreign currency
WRANSCH_S
Acquisition value balance in foreign currency after position-changing flow
WRANSCHS_S
Acquisition value balance incl. act. IC in foreign currency after position-changing flow
WRBUCH
Book value in foreign currency
WRBUCH_S
Book value balance in foreign currency after position-changing flow
WRBUCHS
Book value incl. act. IC in foreign currency
WRBUCHS_S
Book value balance including activated IC
WRAPTILG
Unscheduled repayment in foreign currency
WRTILG (*)
Repayment in foreign currency
WRSUTILG (*)
Total of repayment and unscheduled repayment
WRSZITI (*)
Total of repayment, unscheduled repayment and interest
WRBUCHTLG
Repayment book value in foreign currency
WR6BKURSGV
Security price gain in foreign currency which is chargeable in accordance with §6b EStG
WRN6BKURSGV
Security price gain/loss in foreign currency which is not chargeable
WRFW6BKURSGV
Security forex rate gain/loss in foreign currency which is chargeable in accordance with §6b EStG
WRFWN6BKURSGV
Security forex rate gain/loss in foreign currency which is not chargeable
WRSUKURSGV
Total security price gain/loss in foreign currency
WRSUKURSGV
Total security forex rate gain/loss in foreign currency
REVDEVISE
Valuation of position in forex per key date in local currency
WRREVPOS
Valuation of position per key date in foreign currency
WRMERT (*)
Manual revenues in foreign currency
WRMERTU
Manual cross-revenues in foreign currency
WRNKOST (*)
Non-capitalized incidental costs in foreign currency
WRDIVID
Dividends in foreign currency
WRDIVBRT
Gross dividend in foreign currency
WRDIVNET
Net dividend in foreign currency
WRAUSSCH
Profit distribution in foreign currency
WRAUSNET
Net profit distribution in foreign currency
WRBONUS
Bonus in foreign currency
WRBONNET
Net bonus in foreign currency
WRNOMZ (*)
Nominal interest earned in foreign currency
WRNOMZNET (*)
Net nominal interest earned in foreign currency
WRZERT (*)
Interest earned in foreign currency; total of nominal interest and accrued interest
WRSTUECKZ
Accrued interest in foreign currency
Fields for accrual/deferral of revenue
Example to explain the following fields:
The interest coupon is due on 10/07 each year. The period from 01/01/YY to 12/31/YY is taken into consideration and the fiscal year also ends by definition on 12/31 of a calendar year. The key date is the 11/01/YY.
WRSTKST
Accrued interest per key date 11/01/YY in foreign currency which results from a fictitious sale per key date.
WRZNJE
Accrued interest at fiscal year end 12/31/YY in foreign currency; part of the interest which belongs to the year just ending. You cover the period from 10/07/YY to 12/31/YY.
WRZRJR
Regular accrual/deferral at fiscal year end 12/31/YY in foreign currency; part of the interest belongs in the subsequent year. The total of WRZRJR and WRZNJE is the coupon/interest which is paid on 10/07/YY. If the key date is before 10/07/YY (e.g. on 10/01/YY), field WRZRJR remains empty.
WRZSJR
Total accrual/deferral per key date 11/01/YY in foreign currency from fields WRSTKST and WRZRJR. These are revenues which accrue during the year up to the key date 11/01/YY.
WRPREM (**)
Option/future premium in foreign currency
WRSONST (**)
Additional flow in Treasury
WRRKSTE
Refundable tax in foreign currency
WRSTEUR
Taxes in foreign currency
WRAGIO
Premium in foreign currency
WRDAMNUM
Discount in foreign currency
WRDMABGR
Accrual/deferral of discount (premium and discount) posted in foreign currency
WRSUABGR
Total of fields WRZSJR and WRDMABGR as long as the accrual/deferral of the discount was due per/before the key date and has already been posted.
WRZINSAHN
Interest-related income in foreign currency such as processing charges and commitment interest
WRZIKAP (*)
Amortization of interest in foreign currency
DATUM
Date of flow; if summarization to month or year takes place, the month-end or year-end date is displayed in the date field.
Fields with the prefix 'HW' instead of 'WR' mark the amounts in local currency of the company code to which the flow belongs.
Display fields marked with a * are supported by the whole of Treasury for evaluations.
Business Attributes
| ASAP Roadmap ID | 207 | Establish Reporting |
| Mandatory / Optional | 2 | Optional activity |
| Critical / Non-Critical | 2 | Non-critical |
| Country-Dependency | A | Valid for all countries |
Assigned Application Components
| Documentation Object Class | Documentation Object Name | Current line number | Application Component | Application Component Name |
|---|---|---|---|---|
| SIMG | ERTRÄGE_TREASURY_WP | 0 | HLA0100040 | Information System |
Maintenance Objects
| Maintenance object type | C | Customizing Object |
| Assigned objects | ||||||
|---|---|---|---|---|---|---|
| Customizing Object | Object Type | Transaction Code | Sub-object | Do not Summarize | Skip Subset Dialog Box | Description for multiple selections |
| FWT7 | T - Individual transaction object | FWT7 | WP01 | TR revenue list |
History
| Last changed by/on | SAP | 19990302 |
| SAP Release Created in |
