SAP tables or report showing PGI Date and Invoice Date

[Former Member]

Greetings.

Is there a report or transaction that can be run that shows both PGI date and Invoice date? Or if possible which tables I would need that I can join if necessary to create a query?

I run a test currently of all shippments for a given plant by delivery note, order, BOL, actual pgi date, ship-to etc.  using table LIKP. How can I obtain invoice information to add to this query I am running?

Thank you.

[Former Member]

This message was moderated.

[Former Member]

Hi,

Yoy want to develop a Z-report, for PGi date and Invoice Date for particular slaes order. From  Document flow VBFA table we can get precceding document i.e delivery number and invoice number by these, you can develop Z-report.

[former_member182378]

Mark,

As a side comment: (While creating your report) please take into consideration that for a delivery there could be multiple invoice documents.

In other words number of delivery : number of invoices :: m:n

Because of invoice combination and invoice split.

E.g.: PGI is at a delivery (header) level, but this delivery could be split in to 2 invoices each having its own invoice creation date.

[Former Member]

TW,

Good point. And thank you all for your input.

I was wondering. Is Billing Date the same as Invoice Date? I often see the terms used together. If this is the case then can I just use Billing Date from LIKP?

Just so you know I am basically an SAP super user and I am using SQVI to perform this query so I am trying to keep the number of joins to a minimum.

Thanks again.

Mark

[former_member182378]

Mark,

Is Billing Date the same as Invoice Date? 

Could be same.

Invoice date comes from the customer master. It populates in the PGI date in the header of the delivery document.

- If field actual PGI date is blank or

- if the field actual PGI date is not different from invoice date then the invoice date is same as billing date in the billing document.

- if in VF01/2, field billing date is not manually given as a different date than invoice date.

Or else different.

Billing date is the date when the postings shall take place to respective G/L accounts.

If this is the case then can I just use Billing Date from LIKP?

Yes, please test by passing delivery number in table LIKP for 2 cases - billing document created, billing document not yet created; see what is the value of field FKDAT (billing date).

Added:

To explain with another example -

In the sales order, the INCOTERMS are taken from the CMR but the user can change the incoterms in the sales order (in VA01 / 2).

Thus when user is not changing the INCOTERMS in the sales order, then incoterms are same in the cmr and the sales order.

If user is changing the INCOTERMS in the sales order, then incoterms are not same in the cmr and sales order.

If you have any questions, please convey.

Message was edited by: Type Writer

[Former Member]

Hi Mark

you can join

MKPF-BUDAT= PGI date

LIKP= Delivery Number .MKPF has the delivery Number as Key Field.

VBRK will give you Invoice date

Hope that Helps.

[Former Member]

Hi Verma ,

Use LIKP to get the information about the PGI date

Use VBRK to get the information about Invoice Date.

Use VBFA to track the Delivery of the Invoice and wise versa.

If you provide more information about your actual requirement, forum friends can guide you in a better way. Sometimes we need to validate the status of the document also. Then use VBUK or VBUP.

Regards

Vinu

[Former Member]

Hi Venu

This is Mark's requirement .I just replied to his query.

Regards

[Former Member]

Okie. sorry

[Former Member]

Vinu,

Essentially what I want to do is create a report to review and confirm that orders/deliveries are PGI'ed before being Invoiced. I figure if I can run a report by delivery#/BOL and include PGI date and Invoice date, that the Invoice date is at least the same day or after the PGI date.

What key field iin VBRK would I join in LIKP? LIKP-VBELN?

Thank you.

Mark

[Former Member]

Hi Mark ,

As per your comment, i understand that you create the invoice before PGI done. Is it true? It is possible to create the invoice without PGI done but as per the standard SAP  process, billing will be done once PGI is completed.

To meet your requirement

Pass the Delivery Number to VBFA table and fetch all the Billing document created with reference to Delivery. Then pass the Billing number to VBUK to fetch the creation date. You can get the Actual PGI date from LIKP. Please remember that we can enter the actual PGI date before PGI in delivery document manually.

I would recommend the following option to fetch the PGI Date.

Pass the delivery number in MKPF - XBLNR and fetch the Entry Date (MKPF - CPUDT). It will be your PGI date

Regards

Vinu

[former_member182378]

Mark,

What key field iin VBRK would I join in LIKP? LIKP-VBELN?

To find out the billing documents which are created with reference to a delivery,

From table VBFA, pass VBELV  (Preceeding document) = delivery number

- fetch VBELN

For PGI date:

From table LIKP, pass VBELN = delivery number

- fetch WADAT_IST (Actual GI date)

- if field WADAT_IST is empty, then fetch WADAT (Planned goods movement)

For Invoice creation date:

From table VBRK, pass VBELN = billing document number

- fetch ERDAT