Search This Blog

Value Display with Currency/Quantity Unit

Certain values of output fields may refer to units (such as kilogram) or currencies (such as Euro). To display these values in the correct unit-specific format (with the correct number of digits after the comma, for example), you must assign these fields to a currency or unit. There are three ways how you can do this in the field catalog:

You use fields CFIELDNAME and QFIELDNAME (see below) to assign value fields to a currency or unit field. This ensures that when totals are calculated for this column, these are displayed separately by unit.

The field catalog also contains an entry for the unit field. If you do not want to display the unit as a column in the list and do not want to allow users to interactively show it as a column, you can mark the field catalog entry for the unit field as a technical field by setting field TECH. This makes sense, for example, if the unit is always unique and therefore explicitly output in the list header by the caller.

For initial value or currency fields, you must consider the following points:

Totals calculation and display of value fields

Value of unit field

not initial

initial

Value of value field

not initial

Unit-specific display of digits after the comma in the list and in the totals

For such cells, ALV introduces the unit SPACE. In the totals display, this unit is given as a separate unit.

initial

Unit-specific output as '0' (provided field NO_ZERO of the field catalog is initial). When calculating totals, the ALV uses the value '0' and the unit specified.

Output as SPACE. The value field is ignored when the totals are calculated.

Value or Unit for the Entire Column

For fields that use the same quantity or currency unit for all column values, the field catalog contains fields CURRENCY and QUANTITY (see below). You use these fields to determine a unit for your value field (such as USD or KG). This makes sense, for example, if there is only one unit or currency for the entire column (which has been entered by the user, for example). In this case, the output table does not need any additional fields.

There is one field in the internal output table that contains the associated unit.

Relevant Fields in the Field Catalog

Field name

Comp. type

Dtype(length)

Value range

Use

CFIELDNAME

LVC_CFNAME

Char(30)

SPACE, name of a field in the output tablee

Defining a reference to currency units. The ALV links the field specified in FIELDNAME to the field for currency units specified in CFIELDNAME. The field specified in CFIELDNAME must have a separate entry in the field catalog.

CURRENCY

LVC_CURR

Char(5)

SPACE, name of a currency

Explicitly specifying a currency (such as DEM, USD). The ALV displays the values for the column specified in FIELDNAME according to the conventions for this currency.

QFIELDNAME

LVC_QFNAME

Char(30)

SPACE, name of a field in the output table

Defining a reference to quantity units. The ALV links the field specified in FIELDNAME to the field for quantity units specified in QFIELDNAME. The field specified in QFIELDNAME must have a separate entry in the field catalog.

QUANTITY

LVC_QUAN

Char(3)

SPACE, name of a unit

Explicitly specifying a unit (such as KG). The ALV displays the values for the column specified in FIELDNAME according to the conventions for this unit.

For splitting document in General Ledger View you can following this step.
1. Adding new ledger. this step is optional if you only using one leading ledger (sap "0L").
>Financial Accounting (New) > Financial Accounting Global Setting (New) > Ledgers > Ledger
> Define Ledgers for General Ledger Accounting