Skip to Content

Tables via Browser

Hello Experts,

Can you tell me how to access tables such as

AFRU and  AFKO

and how can I confirm that a formula (say total scrap = all scrap confirmed - BOM scrap allowance)  = X in  $$.00     ??

How can I find total returns from a cutomer via a sales order type??

much appreciated.

Verroz

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 22, 2012 at 05:45 PM

    Hi Verroz,

    Let me try to explain you, i don't feel i made the sales return clear to you.

    How can I find total returns from a cutomer via a sales order type??

    1. Identify the return from a customer via sale order type in MB51 transaction. Apart from this there are many reports in SD module to find out the reports, see some of them below

    MC+A - Customer wise Returns

    MC+M - Material wise Returns

    MC+Y - sales organisation wise Returns

    MC-A - Sales office wise Returns

    MC-M - Sales employee wise Returns

    You can refer below threads for more details

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

    2. Regarding usage of inspection type 06

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

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

    http://help.sap.com/saphelp_46c/helpdata/en/92/b808b1d52a11d2962200a0c930e04c/content.htm

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

    http://boardreader.com/thread/Customer_return_inspection_type_06_6t927X19lho.html

    As i told you in earlier reply, there are many ways to map this in SAP. SO most of them are explained in the above link, please refer, also you can search in forum.

    Return delivery can be mapped with inspection type 05 with movement type 655 or inspection type 06 with movement type 651.

    How to do it, refer below links

    http://scn.sap.com/thread/2127372#11037979

    Best regards,

    Sharat

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 21, 2012 at 05:37 PM

    Hi Verroz

    and how can I confirm that a formula (say total scrap = all scrap confirmed - BOM scrap allowance)  = X in  $$.00
    ??

    For this use the logic as,

    First find out orders in which you have booked scrap through table AFRU tha tis from confirmation.

    Then with respect to that go to RESB table and input order number you found out, and get details of operation scrap, component scrap etc from their.

    Ask technical person to write logic as per your calculation and find final value.

    Use AFKO, AFPO tables for necessary filters for logic for orders.

    How can I find total returns from a cutomer via a sales order type??

    If you are using QM inspection for return deliveries then this can be tracked.

    For sales returns or return delivery hope if you have activated inspection type 05 for the material, then inspection lot will get created.

    With respect to this lot, you can accept the quantity in your returns storage location with usage decision, that time material gets accounted in your plants with 321 movement type with reference to sales order return document number.

    You can use this to track your sales returns.

    There are multiple ways to map this in SAP, may be you get more replies on this from others.

    Best regards,

    Sharat

    Add comment
    10|10000 characters needed characters exceeded