Skip to Content
avatar image
Former Member

SAP report based on Production date

Hi,

I'm looking for a SAP transaction code which has Production Date as a search criteria. I used QA33 and COOISPI but they don't have the prod date search criteria. Could you guys please help me with this?


QA33 search criteria

COOISPI Search criteria

Thanks

Pandu

QA33.png (39.0 kB)
COOISPI.png (62.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Oct 28, 2015 at 10:31 PM

    Do you mean the absolute and relative dates on COOISPI report which are at bottom.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Pandurangan,

      SE16N is a table browser.  Other transactions to try which can display the same data:  SE16 and SE17.  In some companies, end users are permitted access to these transactions.

      Also, if you have access to create queries (SQVI or SQ02/SQ01) you can easily create a query that will allow display of the data.

      Best Regards,

      DB49

  • Nov 02, 2015 at 06:59 AM

    Hi,

    Please select Document goods movement in List (T-code  Coois.). In requirement date define production date against which you want to view result. It will show you goods receipt date.

    Regards

    Muhammad Umar

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Muhammad,

      I'll need to ask the SAP administrator to run that tcode for me. I don't have access to it. however I can access COOISPI t-code. Is there a production date equivalent in COOISPI?

      Thanks

      Pandu

  • avatar image
    Former Member
    Oct 28, 2015 at 09:32 PM

    Pandurangan,

    First tell us what you mean when you say "production date"?

    Best Regards,

    DB49

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 02, 2015 at 03:56 AM

    Hi,

    Use SQVI and generate your own query with Tables AUFK and AFPO with field AUFNR. Mark Dates as selection list.

    Thanks With Regards,

    Dinesh V.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 02, 2015 at 01:23 PM

    Apologies for the not following up. Production date in the Basic Date 1 tab.

    I DON'T have access to the backend DB. I can only access from front end GUI.

    Appreciate all your response!

    Thanks again.


    prod date.png (36.8 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Hi

      Do you actually have batches with that specific date? I can very well see batches with the date (see below screen shot). As far as hierarchy is concerned click on list and you will see them as list. At least explore basic things in transactions.

      Regards

      Rahul

      Macro 1.JPG (46.5 kB)
  • Nov 03, 2015 at 09:16 PM

    Hello,

    Not sure what is the output that you want to see.. maybe you can use MB51.

    You have the posting date and entry date. Note that if you filter with the movement type used for the GR (e.g.: 101), that date will be the production date.

    If this is not what you expect, maybe will help if you clarify what is the output that you want to see..

    Kind Regards,

    Mariano

    Add comment
    10|10000 characters needed characters exceeded