topic Re: SD DOCUMENT FLOW REPORT PROBLEM in Application Development and Automation Discussions

SD DOCUMENT FLOW REPORT PROBLEM

Former Member — Thu, 07 May 2009 07:27:30 GMT

Hi,

I am writing a SD document flow report which captures data from quotation, sales order, fulfillment order and finally invoice.The problem is, for example, if there is more than 1 invoice against a particular sales order, the report is capturing only 1 invoice details and ignoring the rest.How to solve this problem.Pls suggest.

Thanks in advance.

Anand Gupta.

Re: SD DOCUMENT FLOW REPORT PROBLEM

Former Member — Thu, 07 May 2009 07:30:58 GMT

Hi,

I think in u r report u r READing invoice tabel to get the invoice. But Loop the invoice table, then u will get all values..

Kiran...

Re: SD DOCUMENT FLOW REPORT PROBLEM

Former Member — Thu, 07 May 2009 07:36:26 GMT

u have to process ur data by looping on invoice.

means

Loop at IT_VBRP.

READ TABLE IT_VBAK.....

READ TABLE IT_VBAP-------

ENDLOOP.

Re: SD DOCUMENT FLOW REPORT PROBLEM

Former Member — Thu, 07 May 2009 07:55:40 GMT

Hi,

Thanks for ur help.But suppose in cases of sales orders, where there are no invoices, those Sales orders would not be captured if I loop using invoice.Pls suggest

Thanks and regards

Anand

Re: SD DOCUMENT FLOW REPORT PROBLEM

Former Member — Thu, 07 May 2009 08:09:34 GMT

Hi,

In this case, when you are looping over the sales order, select all the invoices from the subsequent document and put the document type as M. You will get all the invoices.

Shouldnt be a problem. All you need to do is loop it accordingly

Thanks,

Babu Kilari

Re: SD DOCUMENT FLOW REPORT PROBLEM

Former Member — Thu, 07 May 2009 08:14:01 GMT

Hi,

Thanks, can u pls elaborate it, if possible.to be exact I m looping on invoices not sales orders. then how open SO's would be picked.

Regards

ANAND

Re: SD DOCUMENT FLOW REPORT PROBLEM

Former Member — Thu, 07 May 2009 08:16:48 GMT

hi,

to find open SO .... u have to calculate pending order qty . then wherever the pending order qty should be greate than 0. that is open SO .


******************************************************
*       Fill Pending and Delivered Quantity          *
******************************************************
        it_final-kwmeng = it_vbap-kwmeng.                   "order quantity
    SELECT *
                 from vbup
                 into table it_vbup
                 where vbeln = it_vbap-vbeln
                 and posnr = it_vbap-POSNR.

    READ TABLE IT_VBUP WITH KEY VBELN = IT_VBAP-VBELN POSNR = IT_VBAP-POSNR.
    IF SY-SUBRC EQ 0.
      IT_FINAL-lv_status = IT_VBUP-LFSTA.
    ENDIF.
    SELECT *
                 from vbfa
                 into table it_vbfa
                 where VBELV = it_vbap-vbeln
                 and POSNV = it_vbap-posnr.

    loop at it_vbap into wa_vbap where vbeln = it_vbak-vbeln.

      MOVE-CORRESPONDING wa_vbap to it_VBAPVB.
      append it_VBAPVB.

    endloop.

    loop at it_vbEp where vbeln = it_vbak-vbeln.

      MOVE-CORRESPONDING it_vbep to IT_VBEPVB.
      append it_VBEPVB.

    ENDLOOP.

    CALL FUNCTION 'RV_SCHEDULE_CHECK_DELIVERIES'
      EXPORTING
        fbeleg                        = it_vbap-vbeln
        fposnr                        = it_vbap-Posnr
*   FVERRECHNUNG                  = ' '
*   FS073_ALT                     = ' '
*   IF_NO_SORT                    = ' '
      tables
        fvbfa                         = it_vbfa
        fvbup                         = it_vbup
        fxvbep                        = it_VBEPVB
*   FVBLB                         =
        fvbap                         = it_VBAPVB
     EXCEPTIONS
       FEHLER_BEI_LESEN_FVBUP        = 1
       FEHLER_BEI_LESEN_FXVBEP       = 2
       OTHERS                        = 3
              .
    IF sy-subrc <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
    ENDIF.
    LOOP AT it_VBEPVB WHERE POSNR = IT_VBAP-POSNR.
      IT_FINAL-KWMENG_d = IT_FINAL-KWMENG_d + it_VBEPVB-VSMNG. " COMPUTE DELIVERY QTY
    ENDLOOP.
    IT_FINAL-KWMENG_p = IT_FINAL-KWMENG - IT_FINAL-KWMENG_d.  "COMPUTE pENDING QTY
    free : IT_VBEPVB[] , it_VBAPVB[] , it_vbup[] ,it_vbFA[].
    "    APPEND FINAL DATA

Re: SD DOCUMENT FLOW REPORT PROBLEM

Former Member — Thu, 07 May 2009 09:02:00 GMT

Hi,

Thanks, but problem not yet solved.

Thanks and regards

Anand

Re: SD DOCUMENT FLOW REPORT PROBLEM

Former Member — Thu, 07 May 2009 09:09:22 GMT

plz describe more...where exactly the roblem.