Genearate a Report for the following data

[Former Member]

Hi All

The following is of my requirement

<b>Selection Screen Should be as follows:</b>

Plant (required) <b>QALS-WERK</b>

Storage Location <b>MCHB-LGORT</b>

Material Number <b>QALS-MATNR</b>

Batch Number <b> MCHB-MATNR</b>

MRP Controller <b>MARC-DISPO</b>

Inspection Lot Number <b>QALS-PRUEFLOS</b>

Inspection Lot Creation Date <b>QALS-ENSTEHDAT</b>

Inspection Lot Origin <b>QALS-HERKUNFT</b>

PO Number <b>QALS-EBELN</b>

Vendor # <b>EKKO-LIFNR</b>

Goods Receipt Date <b>MKPR-BUDAT</b>

Delivery Number <b>QALS-KTEXTLOS</b>

Marked in House Date

Sterile Load # <b>ZC012-STBAT</b>

Supplying Plant <b>EKKO-RESWK</b>

Profit Center <b>QALS-PRCTR</b>

<b>Radio Buttons for Selection Screen:</b>

• Show all stock (not just Q stock)

• Show only past due stock (GR Date + GR processing time > today)

• Include Serial Numbers

<b>Fields for report:</b>

Plant <b>QALS-WERK</b>

STO/PO <b>QALS-EBELN</b>

Delivery/Production Order # <b>QALS-KTEXTLOS</b>

Sterile Load # <b>ZC013-STTYP</b>

Inspection Lot Number <b>QALS-PRUEFLOS</b>

Material <b>QALS-MATNR</b>

Old Material <b>MARA-BISMT</b>

Serial #s (all serial #s with material <b>ITOB-SERNR</b>

batch combination)

Batch <b>QALS-CHARG</b>

Sloc (all SLOCs with Q status items) <b>MCHB-LGORT</b>

Batch Exp Date <b>DFBATCH-MHD_IO</b>

Quantity (in each SLOC) <b>MCHB-CINSM</b>

Profit Center <b>QALS-PRCTR</b>

Date Marked In House <b>ZTMODE-TDATE</b>

GR Date <b>QALS-ENSTEHDAT</b>

Expected GR Processing Time <b>MARC-WEBAZ</b>

Date Moved to NCMR <b>MKPF-BLDAT</b>

Days in House System date – ZTMODE-TDATE

Days in QI System date - <b>QALS-ENSTEHDAT</b>

Days from QI <b>QALS-ENSTEHDAT - MKPF-BLDAT</b>

Days in NCMR System date - <b>MKPF-BLDAT</b>

MRP Controller <b>MARC-DISPO</b>

MRP Controller Name <b>T024D-DSNAM</b>

Standard Cost <b>MBEW-STPRS</b>

Extended Standard Cost <b>MCHB-CINSM * MBEW-STPRS</b>

How we can develop a report for the above, because they havn't given any conditional checking. Supress if any Ztables used.

i would appreciate if you can send an earliest reply and reward points for the same.

if any queries just reply me i can clarify.

Regards

Prabhu

[Former Member]

Hi Prabhakar,

Well you can opt for ALV display...

You want to generate report based on plant data..

Once the user enters the plant, you can extract the remaining info from table MARA, QALS, EKKO.

The radio buttons will decide your selection critera.

I dont think any functional guy will give you everthing spoon feeded. You will have to explore those tables and the relevant fields.

In case you are finding it to difficult to get the relations between the tables or finding list of tables,

i shall send u docs which will help u solve the problem.

Give me ur email id

Regards,

Tanveer.

Mark helpful answers

Message was edited by: Tanveer Shaikh

[Former Member]

This message was moderated.

[former_member188685]

Hi Prabhakara Rao,

Don't feel Bad, Try to start coding on your Own, if you struck up with some thing ask the forum , we are ready to share what ever we can. But Don't try to give the specification , and ask us to write a Report.....

Try to utilize forum for your Doubts...

Regards

vijay

[Former Member]

Hi Vijay,

I am appreciating your reply, but i tried my level best for past few days, but i couldn't get solution for this. At last only i depends on forum.

I think you understand my problem.

Regards

Prabhu

[Former Member]

HI

GOOD

AS PER YOUR REQUIREMENT YOU WANT TO CAREA TE A REPORT USING TEH FOLLOWING CRETERIA.

SO I HOPE YOU CAN CREATE A SELECTION SCREEN AS PER YOUR REQIREMENT AND YOU WANT TO ACCESS THE DATA FROM YOUR GIVEN FILEDS FROM GIVEN TABLES.

YOU MENTIONED THAT THERE IS NO CONDITION GIVEN TO YOU.

THERE MUST BE SOME KIND OF CONDITION FOR THIS PARTICULAR REPORT IF CONDITION WONT BE THERE THAN WHAT IS THE USE OF CREATING A SELECTION SCREEN AND SELTING DATA FROM THE DATABASE TABLE.

YOU ASK YOUR FUNCTIONAL CONSULTANT AND GIVE THE CONDITION I HOPE I CAN HELP YOU BETTER AFTER THAT.

THANKS

MRUTYUN

[Former Member]

Hi

Based on the above said scenario, i have to develop a report. Here in this report the conditions which we have to take from selection-screen input data only not other than this.

Here is the challenging work they have assigned me, they don't want to give any other specifications. Based on their thought we have to check the tables and find relevant fields for solving the above said report.

Regards

Prabhakar

[Former Member]

What do you mean by NO conditions, the parameters for selections are your conditions. You have got the fields that you have to display as the output.

The specification cannot be clear than this.

What exactly are you looking for?

Regards,

Ravi

[Former Member]

Hi Prabhu,

I think the best way is to sit with the IT Analyst and understand what information they require.

Ask your IT guy to walk you through the screens and understand what information they want to pick up.

write down which SAP tables you want to lookup for the data and how you can relate them.

using the selection screen fields write a select and pick up the record and then display the data as per the report output.

Cheers

VJ