searching tables

Hello Experts,

I will try to ask this question from the perspective of a user and not a developer - designer..

I have a custom report that details "cost of poor quality". High level it's a very standard approach to reporting typical COQ. 

High level it seems to be working as it should

I must test the design to assure:

a.  it's capturing all the areas of costs it should      (reqs. other modules to make transactions such as scrap all types and customer returns)

b   assure it's capturing these costs per the background formulas  ( such as total scrap =  AA  +  BB + CC =  ((total scrap))

These verifications in part need to be made by physically verifying the tables the data is pulled from.

My question is:

1. What is what is the trail to get to tables:

AFRU

RESP via AFKO

AFVC

AFVV via AFKO

AUFPL

2. Is the data stored in these tables drawn auto or must one extract it manually?

Greatly appreciated

Verroz

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 18, 2012 at 05:55 PM

    Hello Verroz,

    From user perspective i would like to you inform some of the things which may be useful according to your questions.

    1. What is what is the trail to get to tables:

    AFRU

    RESP via AFKO

    AFVC

    AFVV via AFKO

    AUFPL

    When you do certain transaction to capture the the details into database obviously it is stored in one or the other form in tables or it can be viewed in structures etc.

    Certain tables are very useful to see data upfront and can be pulled in program by designers, that we keep a side.

    As a user if i am trying to see some information in certain standard reports, and not able to get then i look through tables (if  i have authorization for SE11, SE16 transactions) and take this data and use in my analysis.

    For example, AFRU id the table which records most of the fields of production order confirmation. So any data like order yield, rework, scrap quantities etc i can get here. Similarly corresponding tables.

    To explain one more, what is what means if i create and release production order then only the reservation is created for components used in the order, so AFKO is the order header table and find corresponding reservations in RESB table for this order. It depends again on understanding and need some table or transaction reference then easy to work with.

    Hope you got your answer by this example.

    2. Is the data stored in these tables drawn auto or must one extract it manually?

    Data stored in the table can be manually downloaded through SE16 or SE11 transaction.

    If you are using them in program then it can be called in program to use the data automatically.

    In standard SAP reports and transactions where data gets picked then it is called through program automatically for the use.

    Hope this explanation helps.

    Best regards,

    Sharat

    Add comment
    10|10000 characters needed characters exceeded

Skip to Content