report from SAP

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • November 1, 2018 at 9:33 am #22082
    Anonymous
    Inactive

    Hi,

    How can i generate the report which show date of PR link with LPO till to GRN or posting of Payment.

    Thanks

    August 12, 2019 at 1:44 am #22817
    Edward T
    Participant

    Hi Arthur,

    You can create a query or simple report program for this purpose. The tables you will need are :
    PR data can get from EBAN
    PO data can get from EKKO + EKPO
    GR data can get from MKPF + MSEG
    IR data can get from RBKP + RSEG
    And PO history from EKBE

    The logic should follow this:

    1. SELECT BANFN, BNFPO, LFDAT, FRGDT, EBELN, EBELP, …
    FROM EBAN

    2. SELECT EBELN, EBELP, AEDAT, …
    FROM EKKO INNER JOIN EKPO
    WHERE EKKO~EBELN = EBAN~EBELN
    AND EKPO~EBELP = EBAN~EBELP

    3. SELECT EBELN, EBELP, VGABE, BELNR, BUZEI, BUDAT,…
    FROM EKBE
    WHERE EBELN = EKKO~EBELN
    AND EBELP = EKPO~EBELP

    4. If you need details for GR then
    get from MKPF + MSEG
    Where MKPF~MBLNR = EKBE~BELNR
    and MKPF~MJAHR = EKBE~GJAHR
    and MSEG~ZEILE = EKBE~BUZEI
    (for EKBE~VGABE = ‘1’)

    5. If you need details for Inv Receipt then
    get from RBKP + RSEG
    Where RBKP~BELNR = EKBE~BELNR
    and RBKP~GJAHR = EKBE~GJAHR
    and RSEG~BUZEI = EKBE~BUZEI
    (for EKBE~VGABE = ‘2’)

    Thanks,
    Edward

    • This reply was modified 5 years, 4 months ago by Edward T.
    March 30, 2023 at 2:00 pm #46853
    Arusi kumari
    Guest

    To generate a report from SAP, you need to follow a few steps. First, navigate to the Definitions → Reports section and choose “New” from the context menu. On the Report tab, fill in a name into the Name field and choose a filter name in the query. Then, enter the Directory, File Name and click “Generate” to create the report. Once the report is generated, it must be saved. Z reports are created when the client’s reporting requirement cannot be fulfilled with the SAP standard report. In such cases, a functional consultant’s role is to create the Z report to meet the specific requirements of the client.

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.