topic Re: Billing AMount in Application Development and Automation Discussions

Billing AMount

Former Member — Mon, 14 May 2007 07:41:05 GMT

Hi,

can anybody know from which table i can get billin doc no.,billing amount and check clearing amout related with this billing doc no.?

plz reply me.

thanks in advance.

Re: Billing AMount

Former Member — Mon, 14 May 2007 07:44:29 GMT

Hi,

Check the table VBRK,VBRP , BSID,BSAD.

Regards

Re: Billing AMount

Former Member — Mon, 14 May 2007 07:48:17 GMT

Hello,

Tables :

1, VBRK :Billing Document: Header Data

Fields :

1, VBELN :Billing Document

2, NETWR

Regards,

Deepu.k

Re: Billing AMount

Former Member — Mon, 14 May 2007 07:50:48 GMT

VBRK - Billing Doc Header table

VBRP - Billing Doc Item table

VBRK-VBELN is the billing Doc No

VBRK-NETWR - Billing Doc Amount(header level)

VBRP-NETWR - Billing Doc Amount(Item level)

Accounting doc created for this billing doc are in the tables BSID (Open item) and BSAD (closed items)

Pass the Customer(KUNNR) and VBELN (billing Doc field) to these tables and take the clearing amount values (BSID-WRBTR or DMBTR field).

Reward points if useful

Regards

Anji

Re: Billing AMount

Former Member — Mon, 14 May 2007 08:10:15 GMT

Thanks for answer

but i want vendor billing document no and i already check this fields and also get check amount from 'PAYR' table. and in my program it display all billing amount for all billing doc no but i want only that billing amount for which check is already made so i want that check amounts.

i hope u understand my problem.

so plz reply me if u got any link between billing amoun for vendor and its check amount.