Table for open sales order

[Former Member]

hi all,

i want to take open sale order in my report coming in tcode VA05, so can anyone please tell me from which table can i get it?

regards saurabh.

[kesavadas_thekkillath]

just put a ST05 Sql Trace for VA05 and check the tables used

[Former Member]

Hii,

not sure but check in this table

check the table VBBE, it stores open items in the order. VBUP gives the details of the line tiems in the order.

VBBE for open orders and for G/L Account, you can consider tables like BSAD, BSID, BSIS.

regards,

Archana

[Former Member]

hi all,

thnx for reply....actually i need open sale order with respect to materials.

regards.

[GauthamV]

Did you SEARCH in SCN for ?

[Former Member]

check for entry in VBRK if its present means billing document created.

pass document number and check billing document number is coming or not

[Former Member]

Hi

VBUK -- Gives you the status of the Sales order LFGSK--overall delivery status if this is = A that is open

vbak -- header

vbap -- item

for further info contact your Functional Cons

Cheers