Seniors please help me in this Report
Hi Seniors,
PLEASE HELP ME WITH THIS REPORT.
I KNOW THE FUNTIONALITY OF THE REPORT AND I AM NOT ABLE TO PUT
IT IN TO THE ABAP PROGRAM..
REPORT NAME : CUMULATIVE BILL
FUNCTIONAL AND TECHNICAL SPECIFICATIONS
SELECTION-SCREEN FIELDS
WERKS -
TABLE: EKPO--- PLANT
LGORT -
TABLE: EKPO--- STORAGE LOCATION
EBELN -
TABLE: EKPO .. PURCHASING DOCUMENT NUMBER
NOTE : FOR THIS EBELN NUMBER SELECTED IN THIS FIELD THE NEXT FIELD SHOULD BE REACTED. MEANS FOR THE PURCHASING DOCUMENT SELECTED HOW MANY INVOICE ARE MADE SHOULD ONLY DISPLAY FOR THE BELOW FIELD.THE NEXT FIELD IS GIVEN BELOW.
BELNR -
TABLE: RBKP--- Document number of an invoice document
THE ABOVE FIELD BELNR SHOULD DIPLAY ON THE BASIS OF NUMBER SELECTED IN EBELN.
FUNTIONAL EXPLINATION : FOR A PARTICULAR PURCHASE ORDER(EBELN) HOW MANY INVOICES(BELNR) ARE MADE SHOULD BE DISPLAYED.
OUTPUT SCREEN FIELDS
TOP BOX SHOULD DISPLAY IN THIS FORMAT.
PLANT
-WERKS
-EKPO
. BILL NO:-XBLNR--
PROJECT
-POST1
---TABLE
-PROJ
DATE :
BUDAT--
VENDOR
-NAME1
-TABLE
-LFA1
. WO NO :
BELNR--
ADDRESS -
STREETTABLE
-ADRC
--
OUTPUT FIELDS IN THE FUNTIONAL SPEC .
1)SLNO--
2) DESCRIPTION
-3) QTY UP TO PREVBILL
---4) AMOUNT UPTO PREVIOUS BILL
-5)CURRENT QUANTITY
6)CURRENT RATE
-7) CURRENT
AMOUNT -
8)CUMILATIVE QUANTITY----9)CUMILATIVE AMOUNT.
THESE ARE THE FIELDS THAT SHOULD BE DISPLAYED IN THE OUTPUT IN A ROW ..
ELOBORATING FIELDS RELATED TO THE OUTPUT SCREEN.
1) DESCRIPTION : TXZ01 ---EKPO
2) QTY UPTO PREVIOUS BILL.-----
3) AMOUNT UPTO PREVIOUS BILL---
4) CURRENT QUANTITY FIELD NAME : MENGE----- NOTE: THIS FIELD SHOULD GET THE QTYS OF THE PARTICULAR INVOICE SELECTED IN THE SELECTION SCREEN THAT
IS BELNR.
5) CURRENT RATE------NETPR ---FOR THAT QTY MENTIONED IN WORK ORDER
TABLE EKPO
6) CURRENT AMOUNT------ MULTIPLYING THE PREVIOUS 2 FIELDS THAT IS CURRENT QUANITY AND CURRENT RATE (GIVE THIS FIELD CURRENT AMOUNT
7) CUMULATIVE QUANTITY----- SHOULD BE DONE BY ADDING THE FIELDS
QTY UPTO PREVIOUS BILL AND CURRENT QUANTITY .
8) CUMILATIVE AMOUNT-----WE GET IT BY MULTIPLYING CURRENT RATE WITH CUMILATIVE QUANTITY.
EXPLANATION FOR THE 2ND AND 3RD FIELDS
2) QTY UP TO PREVIOUS BILL : SHOULD GIVE THE QTY ACCORDING TO THE SELECTION-SCREEN FIELD .BELNR IF BELNR IN THE SELECTION SCREEN CONTAINS 10 INVOICE FOR A PARTICULAR WORKORDER EBELN
SELECTED..
AND WE SELECT ONE INVOICE FOR EXAMPLE 6TH INVOICE .
IT CONTAINS SOME MATERIALS AND QTY FOR THAT METERIALS
BUT IN THE FIELD OF QTY UP TO PREVIOUS BILL THE QTY OF THE PREVIOUS INVOICE OF THAT PARTICULAR WO SHOULD BE DISPLAYED..
THE IS QTY OF THE PREVIOUS INVOICES OF 12345 = QTY UP TO PREVIOUS BILL + CURRENT QTY GIVES CUMILATIVE QTY FIELD ..
OR
ADDING OF 12345+6 = CUMULATIVE QTY OF CURRENT QTY GIVES
QTY UP TO PREVIOUS BILL.
EITHER WAY WE CAN GET THE OUTPUT .
PLEASE HELP WITH THE ENTIRE PROGRAM OR LOGIC .
PLEASE SEND ME THE CODING TO MY MAIL nalini2sweet@gmail.com