Skip to Content
avatar image
Former Member

Report or Transaction to pick up billed documents without an Output ?

Hi

Could someone please advise on the best way we can pick up and analyse any billing documents that have been billed correctly, posted to accounting but have not created an output - apart from if customer is on Invoice list

Many thanks for your assistance

Tony

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Dec 19, 2011 at 02:59 PM

    Hi,

    There is no such standard SAP report available for this purpose.

    You will have to develop a Z report for this using VBRK and NAST tables.

    Display all VBELN from VBRK table where VBRK / RFBSK (Posting Statuas) = "C" and there is no corresponding entry in the NAST table under OBJKY (VBRK / VBELN = NST / OBJKY)

    Hope this helps!

    Best regards,

    Rahal

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 19, 2011 at 03:30 PM

    Hi Tony

    First option is you have to copy the VF05 report to ZF05 report. and in the ZF05 report you have to include NAST table.in that report

    Second option is use SQVI. Execute the query created.In this query you club VBRK,VBRP and NAST tables.Please find the link which may help you

    http://help.sap.com/saphelp_erp2005/helpdata/en/b7/26ddebb1f311d295f40000e82de14a/frameset.htm

    Regards

    Srinath

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 19, 2011 at 08:12 PM

    There is no standard transaction code available for this, either you have to develop an ABAP query using tables VBRK and NAST, with billing status field in the selection criteria or you can copy the program SD70AV3A (t.code VF31) and add additional coding to display a column with billing documents that does not have the outputs added, even after billing.

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 20, 2011 at 08:22 AM

    Have you tried VF31 ?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 20, 2011 at 08:23 AM

    Alternatively, have q query report to look at table VBRK, VBRP, and NAST table.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      NAST-OBJKY needs to be in 10 char.

      Add this in your codes:

      CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

      EXPORTING

      INPUT = VBRK-VBELN

      IMPORTING

      OUTPUT = VBRK-VBELN.