2007 Nov 19 7:16 AM
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
2007 Nov 19 7:23 AM
2007 Nov 19 8:52 AM
CAN u PLEASE GIVE ME THE TECHNICAL SPECIFICATION FOR THE SAME.
THANX