Interested to Buy Any Domain ? << Click Here >> for more details...
Hi all,
we are exporting data from SAP to excel file depending on
company code , fiscal year , date range from tables bkpf and
bseg for gl balance, bsid and bsad for customer , bsik and
bsak for vendor it works fine.
But i want to exclude the clearing doc entries from
selection.As i added condition to exclude data with document
type not 'AB' it won't work.
Please suggest the way to exclude clearing doc. entries from
SAP.
- 2 Answers
- 8752 Views
- I also Faced
- E-Mail Answers
Answer Posted / chintan joshi
If your requirement is not to get the mere document but to
get Open Item or Cleared item, be it any, never use table
BSEG and BKPF. Use following tables.
1. For GL open item - BSIS and for cleared items BSAS.
2. For Customer Open Item - BSID and cleared Item BSAD.
3. For Vendor Open Items - BSIK and cleared Item BSAK.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Bad Debts :- Friends, Kindly advice how do we configure Bad debts in FI
Explain the importance of asset classes in the sap software?
What is a functional area in sap ?
What is the difference between "costing based" (cb) and "account based" (ab) co-pa ?
What is the new fi-gl in fi in ecc? : fi- general ledger
Sir, I am configuring the interestin gl account, but i could not generate the report. like bank od a/c ledger, Interest on OD ledger. How I will generate this report in fico.
What is chart of account?
Explain tolerance in transaction processing? : fi- accounts receivable
What is Difference between Cost center and Profit center. Can any one explain me?
What is an asset class catalog? : fi- asset accounting
What do you mean by value field groups? : co-pa
What is a sort version? : fi- asset accounting
What is individual processing of gl accounts? : fi- general ledger accounting
What is a call-up point? : co- cost center accounting
Differentiate between the parking and the holding of documents : fi- general ledger accounting
