Hi all, we are exporting data from SAP to excel file depending on company co

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.

Question Posted / prashant

2 Answers
8840 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Hi all, we are exporting data from SAP to excel file depending on company code , fiscal year , d..

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

Hi all, we are exporting data from SAP to excel file depending on company code , fiscal year , d..

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

Post New Answer

More SAP FI-CO (Financial Accounting & Controlling) Interview Questions

what is reconciliation account can you directly enter document in that a/c?

3 Answers

How you support the clients. Could you expalin me prcedure of loging the tockens and how do you intract to clients. Also hom many tockens you get in a day ( on an average).

2 Answers Cap Gemini, IBM,

What is special purpose ledger?

10 Answers KPMG,

I had posted a down payment to a vendor. In addition to that i had posted the invoice to the same vendor.When i run the F110 to make the payment, I want the functionality to adjust the down payment with the invoice & to pay the balance amount. I don't want to do the down payment clearing manually in F- 54. the down payment should be done in the F110 itslef. Is it possible?. If yes what is the configuration related to this.

0 Answers TCS,

Can you recollect what are the configuration steps you did in GL, AP, AR, AND Asset accounting in your implementation project...?

2 Answers TCL, TCS,

What is the fundamental behind Field Status Groups - where all Assignments - what for used - master data level assignments?

3 Answers TCS,

What is document parking and why is it important when consideration internal control procedures and “segregation of duties”?

0 Answers

what is field status group what does it control.

2 Answers

What are the direct allocation methods of posting in co? : co- cost center accounting

0 Answers

Explain about sap fico?

0 Answers

Name the standard stages of the sap payment run?

0 Answers

Can you have multiple retained earnings accont?

0 Answers

For more SAP FI-CO (Financial Accounting & Controlling) Interview Questions Click Here