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
- 7736 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
What is the impact on the old balance when the reconciliation account in the vendor master is changed?
Is any one can you help me by providing the details of 1. companies in which SAP implemented since 2008 on words to till date , implemented partners ,duration of the projects,team size & if possible no of plants of a particular projects. 2.Recently i have completed my SAP SICO now iam preparing my CV ( going with 3+years experience) but since iam living in remote village i don't have access to the persons who are having knowledge of these things so please help me by providing required details. 3. I am waiting for your positive responds, please mail me to jagadeeshparimi@yahoo.com
During document postings, under what circumstances would sap display the following warning / error message: “calculated rate deviates from document header rate by x%”?
what do you mean by the reversal posting?
What is cost center group? : cost center accounting
Will pricing be changed for mysap business suite on linux?
What are fiscal year variants and how are fiscal periods opened and closed?
In sap fico what are the terms of payment and where are they stored?
What is the report painter?
Name some settlement receivers for co internal orders?
What do you mean by net postings? : fi- general ledger
What is the use of sales returns in fi?
What are the components in financial statement version? : cost center accounting
How can the default settings be maintained for cost elements per company code?
what is the journal entry for bank guarantee? And under which account group(asset or liabilities)it will come and T CODE for posting bank guarantee ? pls elaborate ........
