SAP Note 21799 - Output balance carried forward in a report

Symptom:

Question: How can you define a report using the Report Writer, that prints the balance carried forward?
Keyword: Report Writer, HSLVT, TSLVT, KSLVT, MSLVT.

Other terms

----- SUPPORTGUIDE 20010330131459 -----
REPORTWRITER, SGRW_DOCU_CONS_NOTE
SGRW_OM SGRW_PS SGRW_PC SGRW_SL SGRW_PCA SGRW_EC SGRW_LIS

Reason and Prerequisites

Question

Solution
In many applications, balance carried forward and up to 16 period values are stored in the database together. In this case, the Report Writer allocates the balance carried forward to the period Zero.

Example: in the application FI-GLX 'Extended General Ledger' or FI-SL 'Special Purpose Ledger', the balance carried forward is stored in local currency in the field HSLVT. The amounts in local currency for periods 1 - 16 are stored in fields HSL01 - HSL16. To display the balance carried forward in local currency in one column, use basic key figure HSL and assign period zero to the column. Accordingly, for the balance carried forward in group currency use basic key figure KSL, in transaction currency use basic key figure TSL, and for quantities use basic key figure MSL together with period zero.