Vendor Opening Balance Requirement

[Former Member]

hello sir/madam.

Kindly send me the tables cresponding to the field given below.

Fields on selection screen (input screen) : Vendor Code , Company Code , Date from to .

Fields in the (output list ) Posting date ,Document Date , Document Number , Business area , Reference document number , Debit/credit , amount , currency , text.

[Former Member]

Hi,

Check BKPF, BSEG,BSIK,BSAK for all that values.

tc

saji

[Former Member]

Hi ,

you can use BKPF for accounting header information from which you can get

BELNR (Document Number ) ,

XBLNR (Reference Document Number)

BLDAT (Document Date in Document)

BUDAT(Posting Date in the Document)

rest of field you can get from BSEG table , for tax related information you can check BSET , for vendor opening balance use BSIK .

assign points if helpful.....

regards

Deepak.