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
8630 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 activity rate?

1 Answers IBM,

What is the basic difference in customizing in profitability analysis as compared to other modules?

0 Answers

What is a Bill of Exchange? Why is it used?

20 Answers Adhunik,

WHAT IS FREE SELECTION?

1 Answers Tech Mahindra, Wipro,

what is IBMS when we define House Bank?

2 Answers IBM,

what is chart of account and how many chart of accounts can be assigned to a company?

2 Answers

Situation:- We are following fiscal year is Jan to Dec. we purchased an asset for Rs 1,00,000 /- and we are calculated on this asset depreciation is 10%. At the time of 12th period (Dec) my client is realized that we should have been charged at 5% instead of 10% depreciation. Question:- How you will adjust the depreciation to 5% which has already been charged with 10% on the previous periods (i.e Jan to Nov). Note: it has been changed the depreciation key to 5% on Dec month and same assigned to the particular asset master data. Your valuable suggestion on this much appreciated.

2 Answers Mphasis,

What is recurring entries and why are they used?

0 Answers

some tickets?Issues

1 Answers

How to balance carry forward in SAP. Both Monthly and Yearly. Thanks.

1 Answers

Explain the input variance? : co- cost center accounting

0 Answers

difference b/w profit center & profitability analysis?

4 Answers

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