topic Out Put Screen in Application Development and Automation Discussions

Out Put Screen

Former Member — Mon, 21 Jan 2013 13:09:25 GMT

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.

Re: Out Put Screen

former_member195270 — Mon, 21 Jan 2013 13:26:36 GMT

you have to create list output report.

Re: Out Put Screen

Former Member — Mon, 21 Jan 2013 15:04:24 GMT

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

Re: Out Put Screen

Former Member — Mon, 21 Jan 2013 15:07:58 GMT

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:

Re: Out Put Screen

Former Member — Mon, 21 Jan 2013 15:11:20 GMT

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

Re: Out Put Screen

Former Member — Mon, 21 Jan 2013 16:19:31 GMT

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.

Re: Out Put Screen

Former Member — Mon, 21 Jan 2013 16:35:58 GMT

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

Re: Out Put Screen

Former Member — Tue, 22 Jan 2013 07:49:14 GMT

Thnk u all,

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

Re: Out Put Screen

former_member491621 — Tue, 22 Jan 2013 17:35:48 GMT

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)