report from SAP

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #22082
    Arthur.ntagarama
    Participant

    Hi,

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

    Thanks

    #22817
    Edward TEdward 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 1 year, 2 months ago by Edward TEdward T.
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.
Page last updated by Arthur.ntagarama on