Use BSEG as it will have both cleared and open items details unlike BSIS/BSAS which will have only one set of them. Also as you will have all the fields from BKPF which form primary key in BSEG even performance issue should not be there.KTOPL is chart of accounts so you need to pass the value. Check with your functional guy for the value. Regards, Lakshmi Narayana. S On Mon, 27 Dec 2010 15:47:24 +0530 "rajivvarma via sap-dev" wrote>
Posted by rajivvarma (call center management) > on Dec 27 at 4:21 AM
Hi Experts, > >In my requirement i need to create report with following fields > >Company code,Account Document number,Doctype,Fiscal year,Entry date,posting date,currency,posted by,Document header text.-BKPF > >GL account,Amount-BSEG/BSIS??(which table is preferable) > >GL account Text-SKAT?? > >I am trying to create Adhoc report with data base SDF and Added table SKAT > >but i am getting error in below code > >select single * from skat > > where spras = sy-langu > > and ktopl = ? > >and saknr = bseg-saknr > > >In the above code what i should mention to ktopl field > >Please guide me table to fetch GL account text,or tell me Logical data base from where i can get even GL account text with out adding table SAKT to logical data base SDF. > >Which table is preferable to add document item amount with GL account-BSIS/BSEG(cluster table) > >Thanks®ards, > >Rajiv. >
| | | ---------------Original Message---------------
From: rajivvarma
Sent: Monday, December 27, 2010 4:21 AM
Subject: GL account text with account document number
Hi Experts,
In my requirement i need to create report with following fields
Company code,Account Document number,Doctype,Fiscal year,Entry date,posting date,currency,posted by,Document header text.-BKPF
GL account,Amount-BSEG/BSIS??(which table is preferable)
GL account Text-SKAT??
I am trying to create Adhoc report with data base SDF and Added table SKAT
but i am getting error in below code
select single * from skat
where spras = sy-langu
and ktopl = ?
and saknr = bseg-saknr
In the above code what i should mention to ktopl field
Please guide me table to fetch GL account text,or tell me Logical data base from where i can get even GL account text with out adding table SAKT to logical data base SDF.
Which table is preferable to add document item amount with GL account-BSIS/BSEG(cluster table)
Thanks®ards,
Rajiv. |
| __.____._ Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| | Most Popular White Papers
In the Spotlight  _.____.__ |
