executable prog

[Former Member]

HELLO,

want 3 radiobutton 1)PR(purchase requisition) 2) RFQ (reguest for quotation) 3) Quotation

1)If PR button is selected in Input

1. Date of PR(table-fieldname)- MEREQ3321 -BADAT

2. PR number-EBAN – BANFN

3. PO creation date. MEPO_TOPLINE –BEDAT

4. PO numberMEPO_TOPLINE - EBELN

5. Number of dates PR pending. . Subtract third field with first field (3-1)

2) If RFQ button is selected in input .

1.RFQ Date RM06E-ANFDT

2.RFQ Number RM06E-ANFNR

3.Quotation Date EKKO-IHRAN

4.Quotation Number RM06E-ANFNR

5. Number of dates RFQ pending. . Subtract third field with first field (3-1)

3)If Quotation button is selected in input1.

1.Quotation Date EKKO-IHRAN

2. Quotation number RM06E-ANFNR

3. PO creation date MEPO_TOPLINE –BEDAT

4. PO number MEPO_TOPLINE - EBELN

5. Number of dates Quotation pending . Subtract third field with first field (3-1)

logic:

This is date wise analysis for entire cycle involved in Procurement.

There will be one input screen for which will give output for 3 cycles (PR/RFQ/Quotation).

Input screen will have only one from and to date option. And below that there will be 3 selection buttons as PR/RFQ/Quotation.

This is the requirement..Can some one help me how to do that .i'm new to this programming..i don't have much knowledge in programming.

Thanks u in anticipation.

regards,

padma.

[Former Member]

Hi Padma

Selection-screen should look something like below:

tables: ekko, ekpo, eban.
select-options: s_aedat for ekko-aedat obligatory.
parameters: p_pr  radiobutton group rad1 default 'X',
            p_rfq radiobutton group rad1,
            p_qu  radiobutton group rad1.

For Extracting PR Details, check table EBAN.

For RFQ and Quotation Details check table EKKO & EKPO.

All the details that have to be displayed can be brought from the talbes that i have provided above.

Hope this helps you.

Kind Regards

Eswar