Seniors please help me in this Report

[Former Member]

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 -

---

STREET—TABLE-ADRC--

OUTPUT FIELDS IN THE FUNTIONAL SPEC….

1)SLNO--2) DESCRIPTION-3) QTY UP TO PREVBILL---4) AMOUNT UPTO PREVIOUS BILL -5)CURRENT QUANTITY6)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 .

😎 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

[Former Member]

Rather than asking the forum to do your job for you, please try coding this yourself. If you have problems, get back to the forum then.

And please don't use all caps. It makes it much harder to read.

Rob

[Former Member]

Nalini,

Take the step by step directions try to build your program... if you find any difficulty in the middle just pose the question at that time.... every one will be ready to answer your questions....

eg:

take the first line...

REPORT NAME : CUMULATIVE BILL

design a report program with the above given name in se38...

then second line.....

SELECTION-SCREEN FIELDS

WERKS -

---

TABLE: EKPO--- PLANT

LGORT -

---

TABLE: EKPO--- STORAGE LOCATION

EBELN -

---

TABLE: EKPO….. PURCHASING DOCUMENT NUMBER

build select-options: with the above mentioned 3 fields

3rd direction.....

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.

work accordingly....

If you devide the spec like this... it would be easy for you to build the program...

try it once... you can do it nalini....don't fear with that spec...

gud luck nalini...