Invoice/credit number - which table?

[Former Member]

Hi friends,

I have to create a new report and I need to include the information:

"INVOICE/CREDIT NUMBER"

I have never seen this in SD before. Does anybody have a clue where I can find the table and the name of the field?

Thank you,

Roger

[Former Member]

Hi Roger,

This is a information related to SD and Billing. i will give you some transaction codes realted to Sd which would help you to get the fields yourself in future. Just run the transaction realted and open a document, put cursor on a particular field and click on technical info you will get data realted to tables and fields which would help you:

http://sap-img.com/sap-sd/sap-sd-transaction-codes-list.htm

For your question particular some of our friends ahve already replied to try as per what i have told Use TCODE: VF02 and try it out.

HELP IF IT HELPS

Regards

Srini

[Former Member]

Hi,

You can find invocie and credit memo data in VBRK and VBRP tables.

VBRK is header table

VBRP is item table.

But in VBRK table there is a field VBTYP(sales document catagory).

If this field values is '<i><b>M</b></i>' then this document is invoice.

If this field is '<i><b>O</b></i>' then document is credit memo.

If this field is '<i><b>P'</b></i> then document is credit memo

Thanks,

shyla

[reazuddin_md]

Hi Roger,

All the data related to billing will be stored in VBRK/VBRP.

Invoice and Credit number will be stored @ billing header level.so you can find the same in VBRK table.

billing document number: VBRK_VBELN

find it in SE11- enter table name:VBRK & see the text of VBELN.

to see the records in VBRK , goto SE16 enter table name VBRK & enter your search words.