cancel
Showing results for 
Search instead for 
Did you mean: 

tables will be affected when we create a billing document.

former_member219259
Participant
0 Kudos

Hi All,

I want to know what all tables will be affected when we create a billing document.

Pl answer with respect to below problem.

Some 800 invoices have been corrected with wrong Subtotal6 value.

This is affecting BW and Sales reports.

Cancelling of invoices is not an option.

I know VBRP-subtotal6 is one field if i correct it manually at table level.

But what all other tables and infostructures it will affect.

Also any other ideas on correcting the subtotal6 value.

Regards,

Aayush Jain

SAP SD Consultant

Accepted Solutions (1)

Accepted Solutions (1)

former_member219259
Participant
0 Kudos

All,

I have got the solution for this.

Program: RV15B003 (Redetermination of Subtotals) – Transaction OVG1 Basically this program is provided by SAP for rebate processing.

Should you reset rebate processing or alter the pricing procedures, the subtotals used to calculate the rebate in the billing documents may not be available.

If this is the case, you may select Recalculate Subtotals for Rebate Processing.

This is merely a program RV15B003, which is executed with the selection criteria as the desired billing document number range.

this solves my purpose.

Regards,

Aayush Jain

Answers (2)

Answers (2)

Former Member
0 Kudos

Check SAP note 1022966

former_member219259
Participant
0 Kudos

Hello Nilesh,


the SAPnote will not help. Pricing procedure has already been corrected.

I am now looking to correct the already done damage.

One solution is ofcourse cancelling the invoices and creating them again.

i am looking for some other solution.

Regards,

Aayush Jain

Former Member
0 Kudos

Hi Aayush,

Sub-total 6 only update in VBAP table and manually updating SAP standard table is not correct. Even you update sub-total 6 in ECC environment it will not automatically reflect in BI.

Also base on pricing procedure set-up if any pricing element calculation is base on sub-total 6 then manual adjustment in sub-total result in inconsistency in net value / sales document