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
8778 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 APP in SAP FICO?

6 Answers

we are using 3 testing tools in live environment what are they and what is the difference between each other

3 Answers Polaris, TCS,

Bad Debts :- Friends, Kindly advice how do we configure Bad debts in FI

0 Answers

Please give me customization setting for FI/Co - CIN?

1 Answers HCL,

Hi, My questions is, What is the procedure for deleting a ledger. I am not asking blocking. I am asking deleting a ledger.

4 Answers

hi this is ganesh what is expected package for 3 years experiance person in SAP(FICO)

2 Answers

error msg no-f.5071 in down payment. what would be the entry for clearing this open items..in f-44..?

0 Answers HCL,

Which function type has to be used for using "at exit-command" ?

0 Answers

What are the important organizational elements of co? : co- general controlling

0 Answers

In down payment configuration through OBXR what concept behind for in SAP for down payment Key

0 Answers

What do you understand by profit center? : cost center accounting

0 Answers

When entering foreign currency fi transactions describe the various ways in which the exchange rate is derived by sap?

0 Answers

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