SAP ABAP Data Element DCIND (+/- sign indicator (Report Writer))
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       GBSE (Package) FI-SL sets
Basic Data
Data Element DCIND
Short Description +/- sign indicator (Report Writer)  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type DCIND    
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 10 +/- ind. 
Medium 15 +/- sign ind. 
Long 30 +/- sign indicator 
Heading
Documentation

Definition

How the rows are displayed in Report Writer reports depending on whether the column value is positive or negative.

Use

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