7KEX PCA Excel Upload Plan values in GLPCT different from spreadsheet

[former_member355038]

Hi

Using 7KEX we have uploaded PCA values into SAP for periods 1-12, when running report s_alr_87013336 the values are shown correctly for each period however when I check the table GLPCT and the line item report the values are different from the report s_alr_87013336 & the excel file.

The question I have is why do the excel figures & report s_alr_87013336 not the same as the figures in the table GLPCT?

Pls note I am looking at Balance sheet accounts.

thanks in advance

[werner_marcher]

Hi!

Here some more information about the report S_ALR_87013336

. This report belongs to the group of drill-down/interactive reports.

This means that those reports are always aggregating/cumulating account

values in the following way:

'From'-Period: 0 (this is hard-coded in the system and cannot be

influenced by the selection criteria in the field

'From period')

'To'- Period: selected period in the selection criteria.

This is because the drill-down reports like S_ALR_87013336 should

provide the ability to show the stock values of the BALANCE SHEET

accounts ands so it has to accumulate the values from period 0 to the

selected period. Furthermore, report S_ALR_87013336 shows only values

for balance sheet accounts.

Please also consider the attached note 180906 which explains the

different update logic for the periodic data transfer programs, namely,

1KEH, 1KEK, 1KEI and 1KEJ. I am sure your postings you mentioned have

been made by any of these periodical transfer programs.

So please consider the described update logic of the tables GLPCA (line

items) and GLPCT (totals table). So if you want to see the balance over

the periods 1 - 12 in TN KE5Z you only have to inout in the period

field in TN KE5Z 12 - 12 and NOT 0 - 12.

BR

Werner