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
- 8765 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
Is there any possibility to copy (into secondary storage devise) the data of company . Please advise
cost accounting cost of ordering raw materials 1000 per order packing material 5000 per order cost of inventory raw material 1p. per minute packing material 5.p. per unit p.m production rate 200000 units per month
What is an account group? : fi- general ledger accounting
What is a po history? : fi- accounts payable
What is an (asset) transaction type in fi-aa? : fi- asset accounting
explain 2 business scenarios which do you feel have considerable significance and what kind of solutions did you offer while working on the projects?
WHAT IS THE DIFFERENCE BETWEEN HOLD, PARKED, SAMPLE, RECURRING AND ACCRUAL/DEFFERAL? WHAT IS THE MEANING OF RECONCILIATION? WHAT PURPOSE WE DO THE RECONCILE? WHAT IS THE MEANING OF SPL GL? WHAT ARE THE CUT OVER ACTIVITIES? WHAT IS THE MEANING OF GAP ANALYSIS? PLZ EXPLAN?
How many dunning levels can be defined? : fi- accounts receivable
What is a posting key and what does it control in sap ?
What happens when the revaluation is done in actual costing run for the previous period?
What do you mean by chart of accounts? What is it used for?
Hai... friends i dont know this is right or wrong but depends on my position ask this question. any one know the SAP FICO genuine back door job in software. iam married but some reason can i take divorce so iam very disturbed. so in this position i will not able to concentrate and not able to face interview. so iam asking backdoor but i have strong knowledge on subject. pls help me. my qualification M.Com ( 2009 ). contact my mail id : phani01011983@gmail.com. cont me as early as possible. thank you.
Describe mass change/how do you achieve this? : fi- asset accounting
explain true reversal, how is it different from regular reversal? : fi- general ledger accounting
What do you mean by value field groups? : co-pa
