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
- 8848 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
How the system will know that april is your first posting period?
What are the top 3 questions you have to ask before going to start the implimentation of project?
1. What is Spec? 2. If you run AP program without giving next payment rundate then system what erros throughs? 3. How do you calculate depreciation in SAP? 4. What depreciation Terms? 5. Where so you assign the plant?
What is a posting key? : fi- general ledger
What is a special period? When do you use it?
What is a chart of accounts and types of coa in sap ?
You are entered a credit memo posting to vendor who is linked to a customer on 1st of May 2003 for your company code but you have not specifically entered the same data in customer till now. You have lots of entries appearing in the vendor and customer account prior to that date of May 2003 also. You are making a manual payment to the vendor ? select out of the following which statements are correct. a. Credit memo document will get the special payment term as per vendor master definition. b. Customer items will not be shown while paying the vendor as customer is not linked. c. Customer items will be shown only postings after the date 1st May 2003. d. All items of customer and vendor will be available for payment provided payment is same from 1st May 2003. e. All items of customer and vendor will be available for payment provided Special GL items are also selected in selection screen irrespective of the activation date
What is iterative processing of cycles? : co- cost center accounting
What are the segments in asset master ? : fi- asset accounting
What is the configuration setting to be done for posting the accrual in the actual costing run?
What do you mean by operation scrap?
Where is the configuration setting to be done for carrying out revaluation of planned activity prices in various cost objects?
what is a transfer variant? : fi- asset accounting
What is periodic processing in fi-aa? : fi- asset accounting
How many dunning levels can be defined? : fi- accounts receivable
