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
- 8836 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
HI guys i am reently learning sap fico how is the course and i want to know how the sap fico in real time implementation guidelines can any send me how
What are special periods used for?
Which interface change sql requirements in the sap development system to those of the database?
In customizing "company code productive" means what? What does it denote?
what mean ny cut over activities, p/l, b/s amount how will update
What is an “asset under construction”?
Tell me the 3 to 4 functional specification?
Tell me about the tax reports in sap
How are input and output taxes taken care of in sap?
hello sap guru's...while creating outbound delivery VL01n i getting a error..msg no VL461,VL248..i saw solution step's in sap.scn.com....even i could not proceed this outbound delivery..plz give a detailed explanation to solve error..thanking u senior's...junior
Explain ‘field name for partitioning’ in co-pa : co-pa
How do you define key figures in sap system? : cost center accounting
Hello friends i am preparing For SAP FICO, can u please suggest me how can i find the jobs openings?, how shall i prepare for it? and on what area i should more focus on? which kind of questions can enterviewer can ask me and how shall i reply. can please get any reference from your side.. please. i am just craving to get the job please help me....... please reply me on E-mail: g.amresh@gmail.com ....
In asset accounting what is the organizational assignments?
What are the requirement of using dunning?
