Table for billing document

[Former Member]

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

[Former Member]

Hi,

Tables:

VBRK - Header details.

VBRP - Iteam Details.

Thanks,

Neelima.

[SantoshKallem]

Credit memo is sales order,

Credit note is billing document.

vbak, vbap for sales order information

vbrk, vbrp for billing information

[ThomasZloch]

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

Thomas

[Former Member]

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

[Former Member]

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

кu03B1ятu03B9к

[Former Member]

Hi

VBRK-VBTYP = 'K' " Credit Memo Request

VBRK-VBTYP = 'L' " Debit Memo Request

Thanks

Rajesh

[Former Member]

Correcting to the earlier:

VBRK-VBTYP = 'O' " Credit Memo

VBRK-VBTYP = 'P' " Debit Memo

Thanks

Rajesh

[Former Member]

hi

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

[Former Member]

closed..