Order Validation report modifications.

[Former Member]

Hello ABAP Experts,

I need your help to modify the following report with following requirement. This report is written using Field- groups and I have least knowledge about the field-group concept. Thats is the reason, I am pasting the complete code. I really appreciate your help.

Changes required in the report.

To allow the sales representatives to see billed shipments and open orders for the current month.

1) Selection Screen Changes:

u2022 Add selection by Sales group and Customer group

u2022 Add sort by: 5. Ship-to / Material

u2022 Add another selection box

[ ] Open Orders and Shipments with the current month

2) For the new selection box, subtotal sales quantity and delivery quantity.

If delivered, make the sales quantity zero in the subtotal

Current report displays, in Selection Screen

Sales org:

Person Name:

Material:

Plant:

Sales Office:

Ship to Name:

Ship to Number:

Sorts Report by :

1. Person Name

2. Material

3. Plant

4. Sales Office

Check Boxes :

1. Open Orders

2. Delayed Orders

3.Cancelled Orders

PLEASE DOWNLOAD THE COMPLETE REPORT FROM THE FOLLOWING LINK

<< Link removed >>

It would be a great help, If the program is modified according to the requirement and snd it back through send space and send link, even if u send the necessary changes to be done in the report is also appreciable.

Thanks a ton in adanvce

Mythili

Edited by: Rob Burbank on Mar 30, 2009 4:22 PM

[Former Member]

Please don't post your requirements and expect the forum to do your work for you.

Unlocked for now for a specific question about a specific change.

Post some code and if it doesn't format correctly, I'll have another try at it.

Rob

Edited by: Rob Burbank on Mar 30, 2009 5:19 PM

[Former Member]

This message was moderated.

[Former Member]

Hi Mythili,

Be clear with your requirement for the next time, Just paste the error so that we can help you clear and in time.

FORM cm_invoices_billed .
  CHECK NOT p_oporsh IS INITIAL.         "Report Open Orders
  SELECT * FROM vbrk
WHERE fkdat BETWEEN f_date AND l_date AND
      kdgrp IN s_kdgrp AND
        vkorg IN s_vkorg AND
        fkart = 'F2'.                  "Invoice
Initialize shared field group variables
    CLEAR: name1_sp1, name1_sp2, status.
    SELECT * FROM vbrp
    WHERE vbeln = vbrk-vbeln AND
          matnr IN s_matnr AND
          werks IN s_werks AND
          vkbur IN s_vkbur AND
          vgpos < 900000.                                "Exclude sub-items

I am not sure whether is your requirement is this or not.

Use VBRL table from VBRK -VBRL-VBRP......

VBRK-VBELN = VBRL-VBELN and VBRL-VBELN-VF = VBRL-VBELN.

and for delivery status check VBUP-LFSTA

and write like this

  SELECT * FROM vbrk
WHERE ( fkdat BETWEEN f_date AND l_date ) AND 
      kdgrp IN s_kdgrp AND
        vkorg IN s_vkorg AND
        fkart = 'F2'.                  "Invoice

Thanks & Regards,

Dileep .C

[Former Member]

You were asked to ask a specific question. But I dont see any improvement in the question.

Reported to SCN.

pk

[Former Member]

Hi Kishan,

Oooops , I have added question again.

I donno wht happend. Anyways I will post the specific question in another one hour.

I I need help in modifying the SELECT statement for FORM GOODS_ISSUE_DELIVERIES, which will fetch data depending on the SALES GROUP and CUSTOMER GROUP.

Hi Dilip

Dilip I really appreciate your reply, This is what I was looking for.... I will definitely try and get back to you sooon.

Thank you very much.

Thanks & Regards

Mythili