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
8750 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 are posting keys? State the purpose of defining posting keys?

0 Answers

tell me about record types IN COPA?

1 Answers HCL,

How can the default settings be maintained for cost elements per company code?

0 Answers

What is a document header? : fi- general ledger

0 Answers

Can we create Sub Groups in FI/CO Under Current Assets like salary advance, Advances for purchase of materials for staff if we can create how it is or is there other way to maintian sub groups

2 Answers

What is mySAP ERP. How is it different to SAP ERP.

1 Answers Accenture,

What is individual processing of gl accounts? : fi- general ledger

0 Answers

Out of the following masters select the ones which can be blocked for Transactions in FI? a. Bank Master b. Cost Center c. GL Account d. Ship to party ? customer e. Activity Type

1 Answers

What is meant by Document Splitting in SAP

13 Answers

SAP FICO support level interview questions

2 Answers IBM, Sabero,

How do you assign a fiscal year variant to a company code?

0 Answers

How to post a raw material in two different G/L accounts? when the material procured from domestic and foriegn.

3 Answers Cap Gemini,

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