Out Put Screen

[Former Member]

Hello Guys,

I need to generate a PP report in which the input screen is as follows.

which is done, Now the out put screen will be like this

DATE

DAY

LINE

DUTY HRS

   1.  Date and day

   2.  Line – Data can be derived in this column by

• Pass Material (MKAL-MARA), Plant (MKAL-WERKS) which is entered in the input screen in the table MKAL to get the value of production line (MKAL-MDV01), Group (MKAL-PLNNR), Group counter (MKAL-ALNAL) and Prod.Ver. (MKAL-VERID). In this case only one set of data can be derived or material specific data will be derived.

Please help me with some piece of code how to generate this kind of out put and how to fill that Line column by joining DB tables.

[former_member195270]

you have to create list output report.

[Former Member]

Write a select statement  for that simplay like(according to ur info we have only one table )

So FYI..

Select matnr werks mdvo1 plnnr alnal verid

from mkal

into internal table <itab>

where matnr eq S_matnr

werks eq P-werks.

in <itab> u got different records just display on list report.

Regards

Mahesh

[Former Member]

Up to LINE displaying  is above code after that we have write the heading in those blocks.

I hope its Basic question May be Moderator will delete this thread .

Regards

Mahesh:

[Former Member]

hello,

Your query could be as simple as

SELECT * FROM mkal into table it_mkal

   WHERE matnr IN s_matnr  AND

       werks IN s_werks  AND

       verid IN s_verid  AND

       bdatu GE p_bdatu2 AND

       mdv01 NE '' and

       mksp EQ ''.

--> replace the * above with the fields that you need instead and declare the table it_mkal accordingly.

Here is a SCN thread which explains how to write SELECT query.

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

Thread for Production version info

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

ALV report thread

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

http://www.erpgenie.com/sap/abap/code/abap28.htm

http://abaplovers.blogspot.com/2008/04/simple-sap-abap-alv-report.html

Also use the ALV functionality to display the result.

best regards,

swanand

[Former Member]

Hello all,

Some what i got the point but need some more clarification. How exactly to pass the material and plant combination to get the production line, group, Group counter and prod. version and to list that in 3rd column, i.e under Line column, 

plz help me out, i am in tensed.

[Former Member]

You have fill the all items under single LINE col or separately ...

Don't write that type of words " plz help me out, i am in tensed."

Regards

Mahesh

[Former Member]

Thnk u all,

N how to build the field catalog as per the below. this ll be the out put display

[former_member491621]

Hi Lora,

You may have to use classical report if you want to display the data as shown in the pic.

You may not be able to do so using ALV Grid. It is possible using ALV List display.

Please search for FM REUSE_ALV_LIST_DISPLAY.(though you may have to struggle to get the proper alignment)