cancel
Showing results for 
Search instead for 
Did you mean: 

Report S_ALR_87012186

Former Member
0 Kudos

Dear Experts,

My client wants to see all customer accounts which are inactive in last 6 months. There should not be any sales document created on them. He needs to block them.

I have tried to run standard report S_ALR_87012186 with (Accounts W/O sales) tick indicator, but still it showing all customers which have sales document created on them. There is no effect on the output.

I also tried SAP OSS but not able to find any related SAP note. (1178818 ,1097806 , 869192 , 1585301 ,1365420 ) None of these SAP Notes talks about correction in (Accounts W/O sales) tick.

I am not able to understand the behavior of this tick,

Can you please help me in fulfilling the requirement.

Is this report useful in my requirement or SAP has some other standard report or i need to develop some Z report which filters data using different sales tables.

Please Guide.

Thanks

Sidharth Garg

Accepted Solutions (0)

Answers (4)

Answers (4)

amit_tunara
Active Contributor
0 Kudos

Hi Sidharth,

I have answer this question in below thread.

http://scn.sap.com/thread/3443378

Actually there is a specific way to design the layout for the report with a filter on Sales with 0.00 value.

Follow the steps given in my reply to Pradeep (with many screen shot in one reply).

You will get your desired result.

Regards,

Amit

former_member216765
Participant
0 Kudos

Hi

Try standard analysis in MCTA.

0 Kudos

Hai Mr Sidharth,

S_ALR_87012186

Indicator: Display Accounts without Sales?

If you select this parameter, the system also displays the accounts in the company code without line items.

Since most of the Standard tables records the data entry.

Here we want the list of data where entries not made.

You can ask abaper to create a z report to display the list of

Customer code where in Kunnr not having entry in VBAK.

Regards,

OD


Lakshmipathi
Active Contributor
0 Kudos

Many options are there but, I prefer to validate in either of the following method

Option-1

You pass the customer code (KUNNR) in VBAK table by maintaining some date range.  For whatever customer code, if system has not generated any data, then you can conclude, those customers are inactive

Option-2

If you execute FBL5N, there you can see one selection option "Cleared items".  If you select this and execute for a given period, system will populate all customer codes who have paid during that period.  Whichever is very old or whichever customer code system has not populated, you can conclude, those customers are inactive

Last but not least, the TCode what you tried would also work which is similar to Option-1 suggested above.

G. Lakshmipathi