Report creation

Former Member — Mon, 19 Nov 2007 07:16:56 GMT

Hi,

Can somebody help me to write ABAP code to create report for this logic.

1. The user would input the Auction Number, which would be a sales document no in SAP.

2. Take the Auction number and go to table A511.

3. Pass the auction into field IHREZ, USE KSCHL AS ZBID.

4. From the table pick the values IHREZ, BSTKD_E, KUNNR against each KNUMH.

5. Save the above values in an internal table.

6. Now pass every KNUMH TO THE TABLE KONP and take the value of KEBTR.

7. If the value is coming in as null leave that record(record in point 4)

8. After passing each KNUMH we will be left with record in point 4 which do not have a null KEBTR.

9. Again take the Auction number and go to table A510

10. Pass the auction into field IHREZ, USE KSCHL AS ZRES

11. From the table pick the values IHREZ, BSTKD_E against each KNUMH.

12. Save the above values in an internal table.

13. Now pass every KNUMH TO THE TABLE KONP and take the value of KEBTR.

14. The data from the above two tables needs to clubbed with respect to IHREZ, BSTKD_E

15. Now pass the value of IHREZ AND BSTKD_E IN the table VBKD and get the value of VBELN AND POSNR. Now pass these two values and get the MATNR and KWMENG.

16. Now when the above step is complete we have value of IHREZ, BSTKD_E, MATNR, and KWEMENG AND KEBTR (ZBID & ZRES), KUNNR FOR EVERY RECORD.

17. Now as per the selection criterion these records need to be filtered and presented in the format given below.

18. For the selection criterion of first radio button all records need to be presented

19. For selection criterion of the second radio button, only the records where the H1 price is equal to or greater than RP needs to be presented.

20. For the third radio button selection, the user will input the value, subtract the value from 100 .Divide the result by 100 .Note the value. Take the ratio of H1/RP. Present the records where this ratio is equal to greater than the value derived ,but leave the records where the ratio of H1/RP is equal to 1 but greater than 1.

Please help me out.Points will be reward

Re: Report creation

JozsefSzikszai — Mon, 19 Nov 2007 07:23:47 GMT

how much will you pay for doing <i>your</i> job?

Re: Report creation

Former Member — Mon, 19 Nov 2007 08:52:08 GMT

CAN u PLEASE GIVE ME THE TECHNICAL SPECIFICATION FOR THE SAME.

THANX

topic Re: Report creation in Application Development and Automation Discussions

Report creation

Re: Report creation

Re: Report creation