08-31-2007 5:48 AM
HI .
am using BSEG table to get g/l account is there any other table where i can get g/l account number and lifnr.
Regards
Prajwal.k
08-31-2007 5:58 AM
08-31-2007 6:42 AM
Hi,
Table : BSAK - Accounting: Secondary Index for Vendors (Cleared Items)
BSIK - Accounting: Secondary Index for Vendors
reward if useful.
08-31-2007 6:45 AM
Hi,
Try in <b>ARIX_BSAK</b> table, it contains both HKONT(G/L account number) and LIFNR(vendor).
If u use BSEG table, since it is a cluster table you cannot use inner joins. Also, it takes time to retrieve data. If you want to find the table which contains HKONT field, then goto SE90 tcode , Under Repository Information System click Abap Dictionary-->Fields---->Table Fields. Give the field name and check for the table which contains this field. First get HKONT(G/L account number) and then try for LIFNR(vendor number) in another table.If u do like this u will get the data fastly.
Try and reward if found useful.