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 / 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 |
Post New Answer View All Answers
Why do you need asset classes? : fi- asset accounting
How accrual calculation can be performed in the system? : cost center accounting
We have two diffferent bank accounts in our System that is icici bank & citi bank but the vendor wants us to pay him 100000 from two different accounts that is from axis bank and union bank so how we should configure in our sap system so that we can pay to vendor through App.
How do you open a new fiscal year in the system?
What is clearing? : fi- general ledger
Explain manual secondary cost planning? : co- cost center accounting
1)how many tr's you have moved in support project? 2)tell me the complete process of idoc's? 3)what are the interfaces you have dealt wih in your project?
How to FI integrate with MM and SD.
Explain tolerance in transaction processing? : fi- accounts receivable
What are the segments in asset master ? : fi- asset accounting
How are scrap costs shows in the standard cost estimate?
if company is incorporated on apr25, how to create a fiscal year with period 1 starting from apr25 instead of apr1? (fiscal year is apr-mar)
Can both account-based and costing based profitability analysis be configured at the same time?
Name the submodules within fi, from which fi-gl gets simultaneous : fi- general ledger
How is tax calculated in sap?