Report on Customers

[Former Member]

Hi Gurus,

Please could you help me answer if the following is possible?

A report to find out when a Bill To or Ship To was last used

A report to identify all accounts that have been marked with u201CDo not useu201D

A report to identify any duplicate Bill To or Ship To entries

I realy appreciate for time taken to reply on this.

Thanks

Bawa

[Former Member]

hello, friend.

for your first issue, i seem to recall we used "Exceptions" for this. don't recall the t-code. but you can see it in Easy Access. will post again if i find it.

regards.

Edited by: jonathan y on Jan 7, 2009 10:33 AM

[Former Member]

Hi Gurus,

Any more suggestions? As this is not working for me... Kindly help!

Thanks!

Bawa

Edited by: Bawa Bawa on Jan 21, 2009 2:11 PM

[Former Member]

Not working for you?!

Man, I think you got pretty much worthy information from everyone.

If you are looking for standard reports so you don't have to develop reports, well.. Sorry.

Regards,

Franck

[former_member217082]

Hi Bawa

For one of your query , If you want to find out when a Bill to party or Ship to party was last used then use the following tables

VAKPA - Sales order by partner function

VKDFS - Billing Initiator

VEPVG - Delivery Due Index

VRKPA - Bills by partner functions

VBSK - Collective processing of Sales document Header

Regards

Srinath

[Former Member]

"A report to find out when a Bill To or Ship To was last used"

- Used where? Do you mean in a specific SD document type or other usage?

"A report to identify all accounts that have been marked with u201CDo not useu201D "

- In which field did you maintain that text? Define table-field if possible.

"A report to identify any duplicate Bill To or Ship To entries"

- Where? A duplicate is determined on which criteria? Define table-field if possible.

Depending on your further definition there can be a standard report for some of those and for some you may need to create a query yourself.

[Former Member]

Hi Gurus,

I have sorted out the last 2 requirements but still struggling on the 1st one which is -

1) A report to find out when a Bill To or Ship To was last used

I need this report to identify if certain customers with partner functions BP or SH were active in given period.

Please help me in sorting tihs out...

Regards

Bawa

[Former Member]

Hi Bawa,

To avoid direct selection of sales documents (orders, deliveries, invoices) and in general to speed up the report, you could use SAP index tables:

- VAKPA (Sales Index: Orders by Partner Function)

- VLKPA (SD Index: Deliveries by Partner Functions)

- VRKPA (Sales Index: Invoices by Partner Functions)

These tables are used by SAP when you search sales documents for a specific partner, for example in VA05.

If you want to be able to use these index tables for another partner function, this is done by maintaining tables TINPA or TVIND in Customizing. In this case, reorganize the affected indexes so that you can use the index is updated for desired (new) partner functions. Check OSS Note 128947 - Correction of SD document indexes with RVV05IVB.

This way it would fast to know when a specific customer has been used for instance as a ship-to-party.

Hope this info is useful.

Best Regards,

Franck

SAP Freelance Consultant

[Lakshmipathi]

Dear Bawa

In order to generate VF05 based on Bill to Party, do the following.

Go to IMG path --> Sales and Distribution --> Sales --> Lists --> Set Updating of Partner Index. Here, maintain the following values.

Transaction Group:::::Partner Function

::::::::::::7::::::::::::::::::::::::::::PY

::::::::::::7::::::::::::::::::::::::::::SH

::::::::::::7::::::::::::::::::::::::::::SP

::::::::::::7::::::::::::::::::::::::::::BP

By doing so, in VF05, based on Bill to Party, you can execute the report and you will be in a position to find out when that bill to party was used. Of course, you can select any other partner functions also and generate the report accordingly.

thanks

G. Lakshmipathi