Hierarchy
⤷ FI-SL-IS (Application Component) Information System
⤷ GRWT (Package) Report Painter / Report Writer
Basic Data
Data Element | SIGN_FLAG1_1 |
Short Description | +/- sign check: all columns |
Data Type
Category of Dictionary Type | D | Domain |
Type of Object Referenced | No Information | |
Domain / Name of Reference Type | XFELD | |
Data Type | CHAR | Character String |
Length | 1 | |
Decimal Places | 0 | |
Output Length | 1 | |
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 | 8 | All |
Medium | 12 | All columns |
Long | 18 | All columns |
Heading | 0 |
Documentation
Definition
If a +/- sign check is active from sets, you can define it so all columns are used for the +/- sign check
General information on +/- 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 |