Need a report - list of customers that are not set up for billing in customer master

[Former Member]

Hello SAP people,

Please help me with this: need a report - list of customers who are not set up for billing in customer master. The reason I am looking for this report is we recently ran into an issue where we billed a customer but that customer location was not set up to be billed too in customer master and will never be - company decision. So user is looking for this report to help them not assign customers to bill-to-party function which are not set up for billing.

Please help!!!

[Lakshmipathi]

Had I been in your position, first I would list out all the order types being used for a given sales area. Next, I would check what are the item categories assigned to those sale order types and finally, I pass all those item categories in TVAP table, where the field FKREL should be blank. Now you have a list of item categories which are not relevant for billing. If I am correct, it would be only one in your case. Now table join VBAK with VBAP where you pass that KUNNR and PSTYV and execute. You will get the desired result.

[former_member183501]

Hi,

Based on which criteria do you decide that the customer is not going to be billed? Apart from Bill to party which user assigns later?

list of customers who are not set up for billing in customer master

What Account group does user select while creating such customers?

Are there multiple people responsible for maintaining a customer master based on views ?

[Former Member]

Hi!

I'm not exactly sure what criteria the business uses the customer is not going to be billed for their service repairs as I tried asking that and haven't gotten a straight answer yet. Hopefully, this week I can get a response. Yes, there are multiple people responsible for maintaining a customer based on views. In my company, the sales admin in another country is responsible for maintaining a customer. They use Account group sold to party to create such customers but haven't set up the financial views for this. These customers have multiple locations but they don't want to bill certain locations for this customer. Don't have a clear answer on why they have decided on it. Expecting a reply this week. There are some people who can change and update certain views in the customer master but that varies from locations (different employees in different countries).

[phanikumar_v3]

Have you tried VCUST Tcode with option customers without SD data...

(Check Table KNVV too for better visibility Vs KNA1)

Phanikumar

[Former Member]

Nope that didn't work but OV50 kinda worked. That gives me the mass customer list. Thanks though.

[Lakshmipathi]

but haven't set up the financial views for this

Still, system would allow to generate billing document and that is why, I had not suggested this transaction code. Your original requirement is

that customer location was not set up to be billed

and I presumed, the partner functions are same in which case, OV50 will not give a correct picture.

Also, as I already highlighted, item category not relevant for billing would be very minimal in which case, it would be better to cross check with one customer with the steps what I had suggested.