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.
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
How to estimate the Cost step by step ?
Can anyone please explain what is Rolling valuation(SAP) in relevant to foreign currency valuation...?
Hi I'm looking for two SAP Project Manager (one specialized in MM/PP, one in FI) for Automotive, based in Compiègne (Oise, France). Should somebody give me an idea to find these persons ? thanks a lot !
What is number range interval? : cost center accounting
Define depreciation areas? : fi- asset accounting
What is a posting period and how does the system identifies posting period?
what do you mean by the tolerance group?
if New plant is arrived what are the pre checks we will perform from Controlling end?
what is documentation in SAP FI? and what is reporting in SAP FI?
Define the term "field status varient"?
Hello, How is T code OBXZ different from OBXL? Also, how to use T code OBXZ.
What are the segments of the customer master record? : cost center accounting
What is collective processing of gl accounts? : fi- general ledger
Hello every, I have my MBA in finance in 2011 I was working for NBFC. Now I am decided to join in sap fico course. But the fact is I forgot all accounting knowledge. Zero accounts knowledge. How may eligible for sap fico course, is there any problems to face during course regarding accounts etc. What are the problems basically peoples like me face in fico course and after getting a job.
What is an asset value date? : fi- asset accounting