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.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
GIVE ME THE EXAMPLE OF TICKET.
What is asset super number in sap? : fi- asset accounting
whome to report a functional consultant ?
Fipay_gts001 Sap global trade services (sap GTS) can not be reached during an automatic payment process.The check in sap GTS couldn't be made due to missing or incorrect settings in customizing of sap GTS (technical incompleteness) this is error because of I am not able post F110 I tried through dmee, edi also not able to run this programme ,kindly help any one
What is the use of account payable in fi?
Hello all, a doubt on F-32 knock off clearing. I am using F-32, partial payment tab, for knocking off between Receivable (DR) and Collection (DZ). Senario: If the collection amount (DZ) is more than receivables (DR), after the entry when i check in FBL5N and F-32 open items, the Collection (DZ) amount is unchanged eventhough a part of the amount is paid against Receivables DR. Lets say, DR-500, DZ - 1000. After entry DR gets cleared. but DZ remain 1000. Could any one help me on this?
How to get currency while creating Purchasing Order
How many chart of accounts can a company code have?
Explain manual secondary cost planning? : co- cost center accounting
IN GL, AR & AP WHICH FIELDS WE WILL BE CONTROLED AT THE TIME OF DOCUMENT POSTING BY USING FELD STATUS GROUP ?
what r the month end activites for a consultant which enduser cannot do?
What is the purpose of payment methods and when are they stored?