doubts in reports

[Former Member]

HI All,

This is Pavani...Iam goin to attend interview this week...I hav no R/3 system

installed in my PC...This is my first interview....Iam very nervy.

I need ur help regarding tables n fields involved in the following reports.

1. Report to list by customer, the out standing payment amount due, the invoice date will be used to Determine for the invoice open date, the program will give company sales group and report totals.

2. Report in Material Master that outputs Material Valuated Stock, grouped by Material type and Plant. The output shows Material No., Storage Location, Unit of Measure and description in addition to group totals.

3. Vendor Performance Report that lists Vendor Name, Materials Supplied, Planned & Actual Delivery Times, Payments Terms and Prices.

4. reports in SD module such as sales order report, which covers all organization levels, delivery status, invoice status, shipping details and partner function details.

5. report on late shipment for the past four quarters, for the selected customers for specific sales organizations.

6. Interactive report for sales order’s their statuses along with their availability date and available quantity for the past quarters

I really need ur help....ponts will be rewarded....

Thanks in advance,

Pavani.

[Former Member · Accepted solution]

Hi Pavani,

You situation is understandable. But this is a Mini Project altogether

1. Accounts Receivables - BSID (FI Line Items), BSAD (FI Line Items), KNA1 (Customer Master), VBRK (Billing Header), Billing Doc No is the link between VBRK and BSID.

2. Stock Report - MARD (Plant, Storage Locationwise Current Stock), MARA (Material Master For Material Type), MAKT (Material Description)

3. Vendor Performance - EKKO (PO Header), EKPO (PO Item), EKET (Schedule Lines), MKPF (Material Document Header to Read GRNs), MSEG (Material Document Item), LFA1 (Vendor Master), T052* Tables (Payment Terms).

4. SD Reports - VBAK (Sale Document Header), VBAP (Sale Document Item), VBEP (Sale Document Schedule Lines), VBUK (Sale Order Status), VBUP (Sale Order Item Status), VBFA (Sales Document Flow), VBPA (Sales Partners), LIKP (Delivery Header), LIPS (Delivery Items), VTTK (Shipment Header), VTTP (Shipment Item), VBRK (Billing Header), VBRP (Billing Item), KONV (Condition Structure), J_1IEXCHDR (Excise Invoice Header), J_1IEXCDTL (Excise Invoice Item).

5. Late shipment details can be obtained with the help of above tables.

6. Availability Check is always futuristic. Getting details for past period, as per my knowledge is impossible.

I could give only table names. For your requirement, the field list from each table will be pretty big. Other friends of this forums might help you.

Also from these tables you cannot generate report with simple queries. You have to do lot of calculations and comparisons to generate reports. You have to consider reversals, cancellations, exceptional situations in order to generate correct reports.

Hope information is useful to you.

Regards,

Hema

Message was edited by:

Hema Nagarajan

As Mr.Vijay said it is better not to put fake experience. I have interviewed many candidates for a positions in our company. I was able to identify very easily that the person has put fake experience. Moreover when you project yourself as experienced candidate no one will ask you about reports. You'll be asked questions on Performance Tuning, Enhancements, Interfacing kind of stuff. You have to prepare well and be bit careful. Theoretical knowledge will not work.

Sorry I've dampened your spirit.

Good Luck,

Hema

[Former Member]

Hi,

I dont think they are going to ask you all these questions if you are a fresher. Just study the basics of the ABAP commands. You dont need to know all these stuff at your level.

Anyways my answers

1. Report to list by customer, the out standing payment amount due, the invoice date will be used to Determine for the invoice open date, the program will give company sales group and report totals.

A). BSEG, BKPF, KNA1

2. Report in Material Master that outputs Material Valuated Stock, grouped by Material type and Plant. The output shows Material No., Storage Location, Unit of Measure and description in addition to group totals.

A). MSEG, MBEW, MARD, MARA, MARC

3. Vendor Performance Report that lists Vendor Name, Materials Supplied, Planned & Actual Delivery Times, Payments Terms and Prices.

A). LFA1, MSEG

4. reports in SD module such as sales order report, which covers all organization levels, delivery status, invoice status, shipping details and partner function details.

A). VBAK- VBAP Sales order header and item LIKP and LIPS for delivery related information and KNVP for partner function details

5. report on late shipment for the past four quarters, for the selected customers for specific sales organizations.

A). VTTK, VTTP - Shipment header and line items and KNA1

6. Interactive report for sales order’s their statuses along with their availability date and available quantity for the past quarters

A). VBAK and VBAP sales order header and item and VBUK for sales order status

Hope this helps

Cheers

VJ

[Former Member]

HI Vijayendra,

thnx for ur quick response...i really appreciate that...but iam goin to attend as a experienced candidate...but i don't hav any experience in abap...wud they ask how u did above reports...wat kind of question i cud expect regarding above reports...u gave me table

names n i also want fields used in those reports.

regards,

pavani.

[Former Member]

Generally they wont ask field level information. All they would want to know is whether you have really worked on that and what that report is supposed to be doing and what challenges you have encountered in developeing that report.

My advice is DO NOT show EXPERIENCE unless you really have it. I conduct technical interviews in my comapny and i can easily identify a fake experience. So however good you prepare for a set of questions it is very easy for a seasoned technical consultant to identfy a fake experience.

Suggest you to work on your basic ABAP skillset rather than byhearting the report details above.

All the best

Cheers

VJ

[Former Member]

ya i know...Iam in US...but there is no requirement here for freshers...all they r looking is for experienced candidates...so iam forced to fake experience even though iam not interested....cud u pls help me in this regard?

As u said u take interviews....wat questions wud u ask for above reports?

n how to answer those questions?

Cud u pls help me get thru this interview?I really need ur help.

I know this is too much to ask but i really need ur help.

regards,

Pavani.