Hierarchy
SAP_FIN (Software Component) SAP_FIN⤷
EC-CS (Application Component) Consolidation⤷
FC00_UC (Package) Cons: General consolidation (cannot be assign.to FC01-FC09)
Basic Data
| Data Element | FC_LINETYPEFLG |
| Short Description | Use Row Type Indicators |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | FC_FLG_USE | |
| 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 | RowTypeInd |
| Medium | 15 | Row Type Ind. |
| Long | 20 | Row Type Indicators |
| Heading | 3 | RTI |
Documentation
Definition
The row type indicator is a character at the beginning of a data row, which determines the row type.
Valid indicators / supported row types:
'1' Header row
'2' Data row
'3' Row with long text
'4' Row with hierarchy information
Use
When row type indicators are used, each row (except for comment rows) must begin with a valid indicator. This means that rows that begin with an invalid indicator are automatically interpreted as comment rows. If field separators are used, the indicator must be separated from the first data field.
When row type indicators are NOT used, the first row that is not a comment row is interpreted as the header row, and all following rows are interreted as data rows.
Procedure
SAP recommends using row type indicators whenever it is possible to:
- specify multiple (different) header rows within the same file
- read long text or hierarchy information
Examples
Excerpts of files for the Flexible Upload for various types of data (field separator is ';', comment character is '*')
- Reported financial data
- Using row type indicators:
* ledger; dimension; version; fiscal year; period; cons unit
1;1C;01;100;1999;012;C1000
* item; subitem; partner unit; value in local currency
2;10320200;100; ;1000
2;10320300;100; ;2000
2;10330100; ;C2000; 500
...
1;1C;01;100;1999;012;C2000
...
- Without row type indicators:
* ledger; dimension; version; fiscal year; period; cons unit
1C;01;100;1999;012;C1000
* item; subitem; partner unit; value in local currency
10320200;100; ;1000
10320300;100; ;2000
10330100; ;C2000; 500
...
* Reported data for cons unit C2000 in a separate file
* An alternative would be to include the 'cons unit' field in the data row
- Financial statement items (using row type indicators)
* Cons Chart of Accounts
1;ZZ
* Item; item type; dr/cr sign; where-used ind.; lang.; medium text
2;10000000;2;+;A;EN;Assets
2;10300000;2;+;A;EN;Noncurrent Assets
2;10320000;2;+;A;EN;Property, Plant and Equipment
2;10320300;1;+;A;EN;Operating Equipment
...
* Item; language; long text
3;10320300;EN;Other assets including
3;10320300;EN;operating equipment
...
* Item; from-item; to-item
4;ZZ ;BALSHEET
4;BALSHEET;10000000
4;10000000;10300000
4;10300000;10320000
4;10320000;10320001;10329999
...
1;ZY
...
History
| Last changed by/on | SAP | 19990223 |
| SAP Release Created in |
