For a Sales order, what is Actual Delivery Date to Customer?

[Former Member]

Hi Experts,

I am an ABAP consultant. In a particular report, for a Sales order I am asked to display:

‘Delivery Create Date (LIKP-ERDAT)’,

‘PGI Date’,

‘Requested Delivery Date (VBAK-VDATU)’ and

‘Actual Delivery Date to Customer’.

And in addition, I also have to show:

‘No: of days between Order Create Date to Delivery Create Date’,

‘No: of days between Delivery Create Date to PGI Date’,

‘No: of days between Requested Delivery Date to Actual Ship Date’ and

‘No: of days between Order Create Date to Actual Ship Date’.

I’ve searched SCN for similar questions but I couldn’t get clarity. I’ll be very grateful if somebody can explain me how to find the ‘Actual delivery date to customer’ and what is the difference between this date and ‘Billing date’. Also, please explain, the difference between ‘Delivery Create Date’ & ‘PGI’?

[kalyan_mokirala · Accepted solution]

Hi Rashmith,

It seems the report is related to delivery. Below is the explanation for the different terms you mentioned in your question.

Delivery Create Date (LIKP-ERDAT)---- when a delivery is created with or without reference of an order system writes the date of creation time of creation and created by in the header data. Creation of delivery does not means that goods are dispatched. There are many steps further after a delivery is created before goods are dispatched.  For example I have created an order, created delivery on 01.01.2014; delivery date will always be 01.01.2014.

PGI Date (LIKP-WADAT_IST)------ Post goods issue date is the date on which goods move out of the company to carrier. This is the last step of delivery. When delivery is created system derives different dates of planning; at this stage it will determine the planned PGI date (LIKP-WADAT) and when actual PGI  happens system writes the date in LIKP-WADAT_IST which is actual goods issue date.

Requested delivery date (VBAK-VDATU)------When order is created for a  customer he asks for a material, a quantity and a date on which he wants the goods. This date on which customer wants the goods is called requested delivery date. Based on the requested delivery date system will check feasibility of delivering the goods on the requested delivery date based on the delivery scheduling.

You can get the RDD based on the below logic.

Input the delivery number in VBFA-VBELN and VBFA-VBTYP_V and get VBFA-VBELV.

Input VBFA-VBELV in VBAK table and get the value of VDATU.

Actual Delivery Date to Customer-----Actual delivery date is Actual post goods issue date (LIKP-WADAT_IST). This is the date on which goods are issued to the customer and customer is liable for billing for the goods dispatched.

Difference between the Actual delivery date (Actual goods issue date) and billing date.

Normally as per standard SAP, once goods are moved out of the company customer is liable to be for billing for the goods dispatched. So by default in standard SAP system copies the actual goods issue date (LIKP-WADAT_IST) as billing date (VBRK-FKDAT) irrespective of the date of creation of the invoice (If delivery is goods issued on 01.01.2014 and billing document/invoice is created today i.e. 14.04.2014, system by default will take 01.01.2014 as billing date). And this is the correct practice.

However  if you want the current date as the invoice creation date instead of the actual goods issue date we can control it by copy controls feature given in SAP.

So based on the copy controls setting, it may be different from the actual goods issue date/ actual delivery date.

[Former Member · Accepted solution]

Excellent clarity. Thank you very much Tilak for your patient reply. For an ABAPer nothing can be more clear than this.

Regards,

Rashmith.

[Former Member]

Order Create Date - VBAK-ERDAT

Delivery Create Date - LIKP-ERDAT

Delivery Create Date - LIKP-ERDAT

PGI Date - LIKP-WADAT

Requested Delivery Date - VBAK-VDATU

Actual Ship Date - LIKP-WADAT_IST

Using the FM:- BKK_COND_FEES_YYYY_MM_DD  get the no of days between the dates.

[Former Member]

Thanks Sandeep for your patient reply. Your answer is very helpful. Almost done. Also, please mention which field gives 'Actual delivery date to customer'.

Regards,

Rashmith.

[Former Member]

Hi Rashmith ,

Difference between delivery creation date and pgi date is

the delivery document creation date is consider as delivery creation date and pgi date is when the goods are issue to customer from plant  that date consider as goods issue date that date is updated

in likp table

LIKP-WADAT_IST

Regards,

nani

[Former Member]

Thanks nani for your reply. Another thing, is there any difference between 'Actual delivery Date to Customer' and 'Actual Ship Date'. If yes, please explain.

Regards,

Rashmith.