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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi

I have tried to do a quickview report, but am struggling to get the joins to work

VBRK-VBELN with NAST-OBJKY

Help ??

Thanks

Tony

[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.

[Former Member]

Have you tried VF31 ?

[Shiva_Ram]

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,

[former_member217082]

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

[Former Member]

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