Hierarchy
SAP_FIN (Software Component) SAP_FIN⤷
FI-SL-IS (Application Component) Information System⤷
GRWT (Package) Report Painter / Report Writer
Basic Data
| Data Element | SIGN_COL |
| Short Description | Column for testing the +/- sign flag |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | CHAR3 | |
| Data Type | CHAR | Character String |
| Length | 3 | |
| Decimal Places | 0 | |
| Output Length | 3 | |
| Value Table |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | ||
| Default Component name | ||
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 10 | Check col. |
| Medium | 15 | Check column |
| Long | 20 | Check column (sign) |
| Heading | 3 | CC |
Documentation
Definition
If a +/- sign check is active from the sets and should only be applied to a certain column, you must enter the number of the column from which the amount for the sign check is to be used.
General information on the +/- sign check
In Report Writer, you often need to display a row only when the value of a column is positive or negative. The number of this column is defined in the layout parameters.
Using the +/- sign indicator, a field value or set can be selected so that the respective row is only displayed if the relevant column value is positive or negative.
Possible entries:
- ' '
- (Default setting) The row is always displayed.
- '+'
- The row is displayed only if the value in the column is positive (or 0).
- '-'
- The row is displayed only if the value in the column is negative.
You define whether the +/- sign check is active and which column is used for the +/- sign check in the layout parameters for the +/- sign indicator ("Row totals" screen, "+/- sign indicator" in the report definition.
Example
Account set with balance sheet accounts:
The bank accounts appear either on the assets or the liabilities side of the balance sheet, depending on their +/- sign. A simple example is shown below:
------------------------
|Balance sheet accounts|
------------------------
--------------|---------------
---------|--------- ---------|---------
| Assets | | Liabilities |
|-----------------| |-----------------|
| | | |
Bank acct 1 Bank acct 2 Bank acct 1 Bank acct 2
(with +) (with +) (with -) (with -)
If bank account 1 contains the amount +1000.00 and bank account 2 contains the amount -1000.00 in the database, the resulting list will be as follows:
-----------------------------------
| Bank acct 1 | +1000.00 |
|* Assets | +1000.00 |
-----------------------------------
| Bank acct 2 | -1000.00 |
|* Liabilities | -1000.00 |
-----------------------------------
|** Total | 0.00 |
-----------------------------------
Add-on
The +/- sign check can be executed for several columns. In the case, the +/- sign check is used separately on each non-formula column. If we enhance the above example, so that bank account 1 contains the amount -500.00 in the previous year and bank account 2 has +500.00 in the previous year, the list appears as follows:
| Year | Prev. year |
-------------------------------------------------
| Bank acct 1 | +1000.00 | |
| Bank acct 2 | | +500.00 |
|* Assets | +1000.00 | +500.00 |
-------------------------------------------------
| Bank acct 1 | | -500.00 |
| Bank acct 2 | -1000.00 | |
|* Liabilities | -1000.00 | -500.00 |
-------------------------------------------------
|** Total | 0.00 | 0.00 |
-------------------------------------------------
History
| Last changed by/on | SAP | 20010607 |
| SAP Release Created in |
