topic Table for billing document in Application Development and Automation Discussions

Table for billing document

Former Member — Fri, 20 Feb 2009 12:29:04 GMT

Hello Experts,

Could you please tell me how would I differentiate a billing doc number and a doc number for debit/credit memo creation.

Both are stored in the same table right ?

How would I get to know that to which billing doc number the following debit/credit memo has been generated from DB.

Please help me would be appreciated.

Regards,

Ranjith N

Re: Table for billing document

Former Member — Fri, 20 Feb 2009 12:40:26 GMT

Hi,

Tables:

VBRK - Header details.

VBRP - Iteam Details.

Thanks,

Neelima.

Re: Table for billing document

SantoshKallem — Fri, 20 Feb 2009 12:43:11 GMT

Credit memo is sales order,

Credit note is billing document.

vbak, vbap for sales order information

vbrk, vbrp for billing information

Re: Table for billing document

ThomasZloch — Fri, 20 Feb 2009 12:45:41 GMT

You can distinguish by VBRK-VBTYP, for document flow see table VBFA.

Thomas

Re: Table for billing document

Former Member — Sat, 21 Feb 2009 04:40:08 GMT

Hi,

How would I get to know that to which billing doc number the following debit/credit memo has been generated from DB.

Eg : 90036307 is my credit memo number.

and let say 90036306 is the billing doc number....

how would I know tat to which billing doc this credit memo no has been generated from DB.

Please help me would be appreciated.

Regards,

Ranjith N

Re: Table for billing document

Former Member — Sun, 22 Feb 2009 10:00:02 GMT

VBRK-VBTYP = 'K' " Credit Memo Request

VBRK-VBTYP = 'L' " Debit Memo Request

Thanks

Rajesh

Re: Table for billing document

Former Member — Sun, 22 Feb 2009 10:02:09 GMT

Correcting to the earlier:

VBRK-VBTYP = 'O' " Credit Memo

VBRK-VBTYP = 'P' " Debit Memo

Thanks

Rajesh

Re: Table for billing document

Former Member — Sun, 22 Feb 2009 14:44:38 GMT

use VBFA table, give ur credit memo as subsequent doc number and execute u'll get the preceding doc number.

кu03B1ятu03B9к

Re: Table for billing document

Former Member — Mon, 23 Feb 2009 05:08:52 GMT

we can differentiate a billing document and a credit/debit memo based on the billing type field.

table : VBRK is the Billing Document: Header Data which has field FKART (billing type)

F1 - Order Related Invoice

F2 - Delivery Related Invoice

L2 - Debit Memo

G2 - Credit Memo

Regards

Re: Table for billing document

Former Member — Wed, 24 Jun 2009 13:18:40 GMT

closed..