customer master data table KNVV is missing

[Former Member]

Hi All

I a trying to cancel the billing document using transaction VF11. System shows error as " customer XYZ customer master data table KNVV is missing"

Please advice how to proceed?

Thanks and regards

satyaprasad

[Former Member · Accepted solution]

Hi,

Goto the T.Code "Se11/SE16".

Enter the table name as "VBRK".

Enter your invoice number.Execute.

Check the value of "VKORG(Sales Organisation)","VTWEG(Distribution Channel)" and "SPART(Division)".

Or you check the same in "VF03" screen also.

Make a copy of the above three fields.

Goto the T.Code "Se11/SE16".

Enter the table name as "KNVV".Enter your customer number in "KUNNR" and the values of "Sales organisation,Distribution channel and division" into their respective fields.Execute.

Check if there are any entries.The result should be no entries so that only you will receive this error message.

If you created the customer with out sales area,while creating the order only it will give you an error message as "No customer master record exists for sold-to party XXXXXXX

Message no. VP199".

As the partners are defined in sales area data only.

Regards,

Krishna.

[Lakshmipathi]

Just make a try.

Go to VF02, key in the billing document and execute. Check at header level what sales area you could see. Now go to XD02, key in the customer code (both sold to party and payer) and ensure that those customers are created in one sales area.

Next go to SE16, key in KNVV maintain the above customer codes and execute. Check which is missing. As you would be aware Table KNVV stores sales area data.

Last but not least, I am literally surprised why in VF11, system is throwing that error when it was suppose to throw at sale order creation stage itself.

thanks

G. Lakshmipathi