How to fectch PGR data with respect to date.

[Former Member]

I have to create a report , for which i need data of all the return deliveries for whic PGR was done yesterday. Then i have to sort deliveries according to division. Is there any table available for same ?

Regards

Jalaj

[prasanna_kumar4 · Accepted solution]

HI

For Division Wise : Division : VBAK - SPART

Sales Document Type: VBAK - AUART

Pick the Return Orders : VBAK - VBELN

Actual GI Date : LIKP - WADAT_IST

Deliverey created date : LIKP - ERDAT

Delivery Type : LIKP-LFART

Delivery Number : LIKP - VBELN

Regards,

Prasanna

Edited by: prasanna_sap on Feb 4, 2012 6:43 AM

[Former Member]

Hi,

To achieve this first you have to go to VBAK table and search with your return sales document type and date.

You will get a list of orders.

Then pass the same to LIKP to get the delivery numbers.