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
8255 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 a contract? : fi- accounts payable

0 Answers

What is the difference between distribution and assessment?

0 Answers

what is delta posting red foreign exchange.

0 Answers Patni,

What is the relevance of defining chart of account?

0 Answers

What is the purpose of 0 (zero)tax code?

3 Answers

What do you understand by resources? What are the different resource type? : cost center accounting

0 Answers

How many years we can open at a time in asset a/c?

4 Answers Cap Gemini,

What do you mean by cost carrier ?

1 Answers Kaar Technologies,

Explain asset history sheet? : fi- asset accounting

0 Answers

how to delte g/l if transaction are updated. :- hi expertise how to delete the g/l a/c if the transaction are updated in. whether any possibility to delete. let me know. thanks in advance ganesh kumar.

4 Answers

Define the term "fiscal year"?

0 Answers

About Complete Withholding Tax ? What is Client Requirement is there ? Business Things ?

2 Answers CA, PWC,

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