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
- 8631 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
Where to assign activity type in cost centers? Or how to link cost centers & activity types?
In asset accounting what is the organizational assignments?
What is a screen layout? : fi- general ledger accounting
Explain the purpose of the account type field in the gl master record?
how do you capitalize auc in sap? : fi- asset accounting
What is a document in sap? : fi- general ledger accounting
Hi SAP friens, i am a beginner in SAP-FICO and started giving interviews...i am struggling and lost couple of interviews because I couldnot tell any tickets/issues...can you help me by sending some tickets/issues to my mail id - rajendranmba@gmail.com...it would be of great help to me to clear the interview...please help.
What is SAP landscape experience? Who will deal with this? How much experience does a candidate have?
What is depreciation key? : fi- asset accounting
what is diff.between production by order and product cost collector?
what is the form name for use functional spec? what are the steps in functional specs?
What happens in an actual costing run?
What is the use of cost elements report? How do you access cost element reports in sap system? : cost center accounting
Explain the two ways used to create asset masters? : fi- asset accounting
what is the use of primary cost component split in PC? How would you calculate the overheads per qty without using costing sheet?
