Difference between S_ALR_87012093 and FBL1N

[venkat2411]

Hi friends,

we know in FBL1N we can see all items (open and cleared) for a particular period.

what is S_ALR_87012093 report used for? is it same as FBL1N? 

For example, if I take period 7 all items in the FBL1N and compared to S_ALR_87012093 for period 7 will it match?

we are getting some differences in the amounts while comparing both. please suggest how to check it.

Thanks in advance.

[karlheinz_bingel]

Hello,

the transaction S_ALR_87012093 runs report RFKUML00 to get information about vendor business. It means the report only take care about items posted with sales-related posting keys. Table TBSL:

PK Posting Key Name D/C AccTy Sls-Rel

01 Invoice S D X
02 Reverse credit memo S D X
11 Credit memo H D X
12 Reverse invoice H D X
21 Credit memo S K X
22 Reverse invoice S K X
31 Invoice H K X
32 Reverse credit memo H K X

Transaction FBL1N runs report RFITEMAP and it shows you all selected postings, i.e. payments, clearings or special ledger postings.

Best regards,

Karlheinz