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
Explain the two ways used to create asset masters? : fi- asset accounting
What is the impact on the old balance when the reconciliation account in the vendor master is changed?
Difference between structure and unstructured in MT940 In Bank reconciliation statement?
Differentiate between account assignment model, recurring entries, and sample document. : fi- general ledger accounting
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)
What is reconciliation account?
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 the significance of sender & receiver cost elements & cost centers?
WHAT ARE THE STEPS INVOLVED WHILE DATA UP LODGING IN LSMW
Explain asset history sheet? : fi- asset accounting
What are correspondence types in ar / ap?
Is it possible to change an existing b/s gl account to the p&l type? : fi- general ledger 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 purpose of a "document type" in sap?
How is operation scrap maintained in sap?