Skip to end of metadata
Go to start of metadata

Symptom

Sum of accruals value shown in drill down list mismatch with accruals in sales volume(S060/S469)

Important facts that you need to know

Display sales volume(turnover)

vs

Drill-down list (verification level)

Shows the sales volume written to the statistics (S060 or S469 in extended rebate). This is the volume from all invoices (including rebate documents like rebate credit memo), which have been posted to FI accounting.

 

Shows the invoices which have received the rebate condition, and have been posted into FI accounting. Rebate documents are not included in the drill-down list display.

 

 

Old rebate procedure

vs

New rebate procedure

Display drill down list relies on data selection from rebate index table VBOX, then for each selected billing number, pricing requirement in access sequence and pricing procedure is checked and pricing preparation is called before it derives rebate condition info from the corresponding billing document data.

 

Display of drill down list replies on data entry in table S136. Relevant billing numbers and condition record number can be read out from S136 entries directly. Then rebate value and billing info can be derived from relevant DB tables.

Usually 'Sales volume'(turnover) and 'Drill-down list'(verification level) do show the same figures, but not in all cases.

These two displays are for different purposes, they simply cannot be compared to each other in all cases.

General checking steps for the mismatch situation

General analysis steps for rebate accruals mismatch in sales volume display and drill down list

Several known reasons which could cause incorrect statistics in S060

  1. Applying BW modification note 1062462 - Inactive conditions with 2LIS_11_VAKON / 2LIS_13_VDKON:
    Wrong rebate statistics update due to modification note 1062462

  2. Inappropriate customizing change for info structure S060/S469 via T-code: OMO1:
    One SD Rebate customizing setting that MUST NOT be changed

  3. Statistics data from archived billing documents exists in S060/S469

    To avoid such problem, please refer to note 1426093. By using the report SDBONARCH, all billing documents that cannot be archived receive an entry in the database (DB) table BONARCH.  This table is read when billing documents are archived.  If an entry exists in this table for a billing document, this billing document is not archived.

Several known situations which could happen for drill-down list display

  1. When there're rebate documents(Manual accruals, Partial settlement, etc) exist for the rebate agreement:
    Rebate documents are not taken into account when displaying drill-down list

  2. When billing is cancelled and cancellation billing is not posted to FI:
    Cancellation billing not released into accounting causes different accruals value shown in drill down list

  3. When OLD rebate procedure is used. If there's some inappropriate customer modification in pricing requirement/userexits, which causes pricing preparation run fails during drill-down list display, then the relevant billing(and its rebate accruals) cannot get displayed in drill-down list.

Related Content

Related Documents

General analysis steps for rebate accruals mismatch in sales volume display and drill down list

Wrong rebate statistics update due to modification note 1062462

One SD Rebate customizing setting that MUST NOT be changed

SD rebate processing affected by billing archiving

Rebate documents are not taken into account when displaying drill-down list

Cancellation billing not released into accounting causes different accruals value shown in drill down list

Related SAP Notes/KBAs