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, 2 months ago by Edward T.