topic Re: Open Billing Order in Application Development and Automation Discussions

Open Billing Order

Former Member — Fri, 08 Nov 2013 05:52:16 GMT

Hi,

I need some help to get the open and closed billing orders. What tables do i need to access and is there any FM to get the billing orders.

Input will be : payer(kunnr) and sales organization(vkorg).

output will be : The output will display the sales order list with address details.

Any help appropriate will be appreciated.

Thanks.

nabheetscn — Fri, 08 Nov 2013 05:59:40 GMT

Please check SAP standard Tcode VA05 for the same.

Former Member — Fri, 08 Nov 2013 06:22:59 GMT

Hi,

You can extract the information as mentioned below. It is very simple and straight forward.

-> Get the all sales orders from VBAK table as per your inputs ( VKORG,KUNNR).

-> Get the Billing documents from the VBFA tabel Where VBELV = VBAK-sales order

and VBTYP_N = 'M' ( invoice or billidocument)

So you have the all list of sales orders and billing documents in your table).

Find the status of billing.

Go to VBUK table where VBELN = VBFA-VBELN AND

and get the biiling statuses from the fileds ( FKSTK FKSAK). ( CHECK THE DOMAIN VALUES)

Not Relevant

A Not yet processed

B Partially processed

C Completely processed

Thanks,

Kiran.

__________ ____________________________________________________________

Former Member — Fri, 08 Nov 2013 07:08:18 GMT

Hi,

Try the FM ITEM_BILLING_STATUS_GET.

Thanks,

Kiran