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.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / antonio
If clearing doc number is same as doc number, then it is a
clearing doc, and you can exclude it
Is This Answer Correct ? | 3 Yes | 0 No |
Folks, Can somebody enlighten on doing inter company eliminations without using consolidation module(EC-CS).Can we capture the G/L line items directly (FBL3n)and do some ABAP to get the desired results
Link between Product costing to CO-PA?
What is an (asset) transaction type in fi-aa? : fi- asset accounting
name three distinct characteristics of fi-gl? : fi- general ledger
How do you configure the sapscript form financial statement version?
Tell me some important tickets in fico?
What do you understand by profit center? : cost center accounting
what is different between company code &controlling area
What is profitability analysis (co-pa)? : co- general controlling
What is meant by framework? Is the framework related only to automation or it is applicable to manual testing too?
Explain derived depreciation? : fi- asset accounting
What is the use of PL Account Statement Type?Tell one scenario where more than one retained account earnings accounts will have to be maintained for more than one PL accounts statement type