SAP ABAP Data Element RSLINITFL (Line Item Dimension)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-WHM-MTD (Application Component) Metadata (Repository)
     ⤷ RSD (Package) BW: Data Basis InfoObjects and Core Services

Basic Data

Data Element	RSLINITFL
Short Description	Line Item Dimension

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	10	Line Item
Medium	15	Line Item Dim.
Long	20	Line Item Dimension
Heading	3	LI

Documentation

Line Item: This means that the dimension contains exactly one characteristic. If you set this indicator, no dimension table is created,but rather the SID table of the characteristic takes over the role of dimension table. Omitting the dimension table has the following advantages:

• When loading transaction data, no IDs for the entries in the dimension table have to be generated. This number range operation can lead to a decrease in performance in the case of a degenerated dimension.
• In the star schema of the InfoCube a possibly very large table, depending on the cardinality, is omitted. The SQL-based queries are therefore more simple. In many cases, the database optimizer can choose better execution plans.

However, there is also one disadvantage: A dimension indicated as a line item cannot accept additional characteristics at a later time. This is only possible for normal dimensions.

Example:

A line item is an InfoObject such as an order number, for whose attributes one or a few facts are listed in the fact table of the InfoCube.

History

Last changed by/on	SAP	20130604
SAP Release Created in