Selection criteria - Open billing documents and billing documents in FI

[Former Member]

Hello,

I am trying to create a new customized report for the billing documents with the Material sales text in it..

The requirement is to have the selection criteria check boxes in the initial selection screen which is in similar to the transaction VF05.

Can someone please help me with the field names for the check boxes to include in program, because i can see they have used a standard structure FACOM with the field names VBOFF and VBALL(in VF05). but I am unable to find the exact fields in the table VBRK where the status is being updated.

Thanks in advance for the help.

Regards

Girish

[Former Member]

Thanks for the quick reply Alan and Kumar.

VBUK and VBRKUK shows the status of the documents which are processed/partially/fully/not yet processed.

But here i am looking to implement the check box with the billing documents that have not yet posted to accounting (similar to the selection criteria VF05). where is this status being updated?

Thanks in advance.

[Former Member]

VBRKUK-BUCHK <> 'C' is what you need.

[former_member186385]

Hi Girish,

Status will be updated in VBUK and VBUP tables

If you need Open billing documents, check VBUK -FKSTK with value A     

in the output you will get list of all open billing documents

[Former Member]

I believe what you need is to declare 2 radio buttons similar to VF05.

And for open status, you could just check VBRKUK-FKSTK.