1 Reply Latest reply: Jul 15, 2012 2:59 PM by sree ravinutala RSS

Sales oreder report

sree ravinutala
Currently Being Moderated

Hi ,
I have a requirement to create report which will accept range of sales order numbers and customers
(Sold to party) from a user and display the  sales order number , Customer Purchase order no ,
Customer Purchase order date , and Sales Order Creation date .

Can you provide related tables and genral structure of logic for the ABAP program .

Thanks in advance .
Sreedhar R

  • Sales oreder report
    sree ravinutala
    Currently Being Moderated

    *&---------------------------------------------------------------------*
    *& Report  ZSR_ASSIGN12
    *&
    *&---------------------------------------------------------------------*
    *&
    *&
    *&---------------------------------------------------------------------*

    REPORT  ZSR_ASSIGN12.

    TABLES: VBAK.
    Data : t_vbak type vbak,vbeln like vbak-vbeln.

    Select-options : T_vbeln for vbak-vbeln , T_Cust for vbak-kunnr.

    Select * from vbak into t_vbak  where vbeln in T_vbeln AND kunnr in T_Cust.

     

      Write: / 'Sales order --' ,T_vbak-vbeln.
      Write: / 'Customer purchase order --' ,T_vbak-bstnk.
      Write: / 'Customer purchse order date --',T_vbak-bstdk.
      Write: / 'Sales order creation date --',T_vbak-erdat.


    Endselect.

    If sy-subrc  ne 0.
      Message i999(zw) with 'No records found'.
    Endif.

    Sales order    5145
    Customer purchase order    DG-19970801-1
    Customer purchse order date    01.08.1997
    Sales order creation date    01.08.1997
    Sales order    5180
    Customer purchase order    DG-19970905-3
    Customer purchse order date    05.09.1997
    Sales order creation date    05.09.1997