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
- 8663 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 a resource in co? : co- cost center accounting
What is the difference between a product cost collector and production order?
1. I want to create an installment method payment term whereby my customer pays 50% as Advance Payment & 50% Net 45 days. How to configure the 50% advance payment term in OBB8 as system does not take negative days say -1 . I have created Z100 as 50% Advance Payment & 50% Net 45 days, Z101 as 50% Adv Pyt and Z102 as 50% Net 45 days in OBB8 and then assigned the same in OBB9 to Z100, 1, 50%, Z101 and Z100, 2, 50%, Z102. But the payment terms Z101 should be having -1 days instead of 0 days. How to configure this or achieve the payment term of advance payment? 2. My purpose is that during FB70, I should get a warning message that advance payment has not yet been received for this customer having this installment payment term Z100. It should not let me post the invoice unless 50% adv pyt has been received. At present we are not using Down Payment functionality. But I assume that without the Down Payment functionality the same cannot be achieved. Please confirm this. How can I achieve the above requirements? 3.Dear Group - Our Purchasing Dept has asked me to create a new payment term with the following terms: "Payable 90% upon delivery, 60 days net, 10% upon acceptance, 60 days net". So when we receive the invoice, we get a 10% discount off the total price, due within 60 days. The balance is due 60 days after that. Any ideas on how I would configure this using transaction OBB8. IT IS VERY URGENT FOR ME KINDLY SEND ME THE ANSWER ON MY E.ID-sahu.suryakanta@hotmail.com.
If you want to learn Free Sap FI Course online join "SAP Fi Free online Course group" on FB
When we configure Electronic bank statement first time. Do we need help of ABAP team at the time of configuring the same?
What are the categories of update requests?
In accounts receivable, what’s the difference between the ‘residual payment’ and ‘part payment’ methods of allocating cash?
What is key figure? : cost center accounting
Is it possible to change an existing b/s gl account to the p&l type? : fi- general ledger accounting
Explain automatic payment program configuration? : fi- accounts payable
What do you understand by cost center, profit center in controlling? : cost center accounting
What is a credit control area in sap ?
Explain controlling (co) in sap? : co- general controlling
What is short-end fiscal year?
List some of the exchange rate type?
