Report

[Former Member]

Hi Friends,

I need a report for following requirement.

1. Business is asking to create a report on sales documents for a city(a city is consisits of 2 to 3 plants)(City does not part of any SAP org structure)

2. What is the best practice to create reports on sales orders for a particular location, At what level we have to create reports (Eg plant level, Country level etc)

Your suggestions would be rewarded.

Thank you

ANil

Edited by: anil maguluri on Jul 15, 2008 6:48 AM

[Former Member · Accepted solution]

Well According to your requirment . They want a Report to be genrated City wise .

But your enterprise structure doesnt contain such org element. and a clue is 2-3 plants conatain one city .

This can be achived by doing so .

In customer master salea area tab you have lot of fields.

Sales district ( in IMG ( SD, Master DATA)use this field as a city ) and assing this in you Customer master record every ( 2-3 ) plants customers in theri records will have a same city ( sales district ) this field flows in all sales ( VBAK ) Billing ( VBRK ) documents u can fetch report accordingly.

If your sales district field is being already used for some other purpose use ( Sales group or Customer group or ABC indicator or Customergroup1,group2,group3,gropu4 ) many fields exsit just maintain master data accordingly u can get the desired report.

Regards,

Kiran.

[Former Member]

Hi,

Creating report is one option else there is a simpler way if it coesnot invovle complex calculations/modifications.

U could probably try generating the required report using ABAP Querry.There u could perform both inner and outer join of various tables and generate a simple,statistical or an AVL report.

Generally functional consultants prefer going for this option as ABAP coding could be avoided.

Task would become much simple and quicker.

Some of the useful tcodes for generating ABAP querry are SQ01,SQ02,SQ03.

I think probably u could go for this option as well.

Cheerzz..

Subbzz..

[Lakshmipathi]

Dear Anil

Depending upon the requirement, you can develop the report. For example, if the report fulfills the requirement from tables like VBRK or VBRP, you can develop accordingly. If it is not fulfilling your requirement, you can table join multiple tables and develop a report.

thanks

G. Lakshmipathi