cancel
Showing results for 
Search instead for 
Did you mean: 

A different Management Report

Lakshmipathi
Active Contributor
0 Kudos

I shall be thankful if someone can give a clue on how to approach the following problem.

Suppose a company has many divisions (like Powder Division, Cold Extrusion Division) making different product lines and all these divisions are supplying to a common customer. The customer is treating the various divisions as different vendors and has allotted different vendor codes to each division. Please note each division has multiple plants.

In this case, is it possible for the supplying company to see data of all supplying divisions in a common report? The clientu2019s requirement is that Data should populate for sales, sales returns, payment terms, receivables etc.

While I could achieve sales datas by assigning some numeric value in one of the unutilised fields in customer master, I am unable to achieve the same logic for Payment Terms. For example, I have Maruthi as a customer with some 10 sold to party code in SAP to whom supplies are being made from different plants.

Now the requirement is only the text of customer should flow in the report and against this text, payment term should flow across the divisions what is maintained. For example,

	Division A     Division B     Division C

Maruthi	  DA 30	       DA 60	    DA 90

They dont want what payment term is maintain in sale order level but only interested to see from sold to party each division wise and that too in the above format

Any idea on how to achieve this logic which should not complicate the process ?? :-((

thanks

G. Lakshmipathi

Accepted Solutions (0)

Answers (3)

Answers (3)

Lakshmipathi
Active Contributor
0 Kudos
Data should populate for sales, sales returns, 
       payment terms, receivables etc.

I could arrive at some logic on all above but for Payment Terms. Anybody is there to provide some suggestions on this ??

thanks

G. Lakshmipathi

former_member188076
Active Contributor
0 Kudos

Hi Laxmipathi

If I understtod your requirement correctly then I would suggest to use Customer Group and Customer Classification to group similar customers, else with the help of enhancement add one more tab in customer master with Client's required fields and then use them in the report.

Regards

Amitesh

Lakshmipathi
Active Contributor
0 Kudos

Thanks for the suggestion which I have already in mind. But please note the client is an auto components manufacturing industry catering to all leading car manufacturers across all regions and also globally.

Under this circumstances, as I said above, there will be around 50 customer codes for one customer; let us say Cummins. Here almost all codes are created in one sales area and supplies are being from three or four divisions. One division is having multiple plants and from all these plants materials will be despatched to this customer.

Here if Sales Org is configured based on division, I can easily fulfill the client's requirement but there comes the issue. One division is having multiple sales organisation. It has been configured by somebody else.

As I repeatedly saying, client is not interested in what payment terms is maintained in sale order or billing but only interested in what is maintained in sold to party customer code and that too in the above format.

So now please let me know how from KNVV table, I can differentiate the divisions !!!!!!!! Hope I am not confusing you people )

thanks again

G. Lakshmipathi

ps: please spell my name correctly

former_member188076
Active Contributor
0 Kudos

Hi Lakshmipathi

Sorry for mis-spelling your name in my previous post.

As far as I understood , the main issue is because all the 50 customers who are same have the same name but different Customer Codes. And the client wants the Name only , not the code in the report.

If you have some empty field in Customer master as you allready thought you can use them for maitaining the required data and ABAP can fulfill your requirement by displaying only the Name after doing the sorting on the basis of Name. report will be preapred on the basis of KUNNR only but before displaying the same there will be sorting on the basis of NAME1 and KUNNR will not be displayed.

You discuss with your ABAP person and they can certainly achieve your requirement.

Regards

Amitesh

Lakshmipathi
Active Contributor
0 Kudos

Convinced that as for as payment terms is concerned, it is not possible to meet their requirement and hence this thread closed. Thanks for those who have spent time to give suggestions.

G. Lakshmipathi

former_member184555
Active Contributor
0 Kudos

Hi Lakshmipathi,

Are these customers maintained under customer hierarchy?

Do you maintain the same search term for all the sold to parties used for the customer Maruti (for example)?

Thanks,

Ravi

Lakshmipathi
Active Contributor
0 Kudos
Are these customers maintained under customer hierarchy?

No

Do you maintain the same search term

For few codes, it is unique and for rest, it is different.

thanks

G. Lakshmipathi

former_member184555
Active Contributor
0 Kudos

Hi

Can't we use the details of payment terms in KNVV-ZTERM. I could see the payment terms maintained for a customer for different sales areas in customer master.

Thanks,

Ravi

Lakshmipathi
Active Contributor
0 Kudos

Thanks for responding. My problem as I said above there are multiple codes for the same customer with same sales area. Also the Payment terms are different from one division to another. So In this case, how can I populate the data in line with the format shown above.

Client's requirement is that only customer text should flow once despite the fact that there are some 10 sold to party codes (customer name is unique) who are serviced from different divisions / plants.

Hope I have explained the requirement clearly !!!!!!!

thanks

G. Lakshmipathi