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
8636 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 the customization to be done when we save the purchase order sys should pass the mail to manager purchases for approval or release

0 Answers

after entering (transation data) in the company code if our clint want to change the company code what is the procedure to change..

1 Answers IBM,

What is fi/co consolidation and give the steps to customization for fi consolidation?

0 Answers Intelligroup,

Whwre are the number ranges assigned to document type ?

3 Answers Accenture, Capita,

We have 4 Co. Codes in India out of which one is Indian Head Office, 4 Co. Codes in US out of which one co. code is head office US and 5 Co. Codes in France and one out of which is head office there. Now, company wants that reports of India can be collectivily seen and maintaned and same with others. They also want the consolidated reports of all the three countries. How can I configure it plz?

1 Answers

Terms of Payment

2 Answers

Will first logic’s global data quality connector for sap manage my international data?

0 Answers

Hi All. IN AR once the first dunning is sent to the client, after that how the system will know the next dunning need to be sent?

4 Answers Mphasis,

What is automatic payment programmer? What are all the steps to configure it?

3 Answers

what is a transfer variant? : fi- asset accounting

0 Answers

What is internal order?

1 Answers

How many co codes can be asigned to a single controling are and what is basic requirements?

5 Answers HP,

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