Solved: Please help me to write the reports

Former Member · ‎08-22-2007

Hi everyone, This is rohith here, Please can anyone help me out to write the reports

1. Developed material master details report. Input of material and plant as select-options and material type as parameter. Output list will have quantity by material group and plant.

2. Created an Interactive report for displaying vendor information. Based on the selection made the corresponding Vendor Bank Details are listed such that the line selected in the basic list was visible along the secondary list.

3. Developed an ALV report lists all deliveries that have been shipped but not yet billed

4. Generated a report which displays vendor invoice details.

Former Member · ‎08-22-2007

hi Rohit,

Welcome to SDN.

Design the Selection screen first with MATNR & WERKS as Select-options.

and Material type as Parameteres.

declare the req internal tables to fetch the data from DB tables .

Validate the selection screen fields with their check tables according to req..

write the logic of fetching the data in START-OF- SELECTION.

and display the output internal table in the output list.

Reward points if useful

Cheers,

Chandra

Former Member · ‎08-22-2007

hi Rohit,

Welcome to SDN.

Design the Selection screen first with MATNR & WERKS as Select-options.

and Material type as Parameteres.

declare the req internal tables to fetch the data from DB tables .

Validate the selection screen fields with their check tables according to req..

write the logic of fetching the data in START-OF- SELECTION.

and display the output internal table in the output list.

Reward points if useful

Cheers,

Chandra

Former Member · ‎08-25-2007

HI Thanks for the useful info, but it would be great help if you please can ginve info about all the reports please if you can give the particular table and fields for all the reports as i am a fresher i am little bit confused abt this.

Former Member · ‎08-25-2007

hi,

first go to the transaction

press F1 on the field u want, go for tecnical information, there u can see the field name,and table name.

now u can develop report based on select statements.

former_member198275 · ‎08-25-2007

Hi rohit,...

you r a freshers it is not a big problem. Do u have any functional spec of that reports..do u have that???

Former Member · ‎08-27-2007

Hi ,

I do have some knowledge of finding the fields and some functional things but i wanted the tables and fields because in my present job there have given this as an assignment and i should do it very accurately so i wanted some help