Skip to Content
avatar image
Former Member

SAP tables or report showing PGI Date and Invoice Date

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Nov 14, 2012 at 08:10 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Nov 14, 2012 at 05:49 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Nov 15, 2012 at 10:43 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 27, 2016 at 02:24 PM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded