Open Billing Order

[Former Member]

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.

[Former Member]

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.

__________    ____________________________________________________________

[nabheetscn]

Please check SAP standard Tcode VA05 for the same.

[Former Member]

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]

Hi,

Try the FM  ITEM_BILLING_STATUS_GET.

Thanks,

Kiran