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
8307 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

rules for creating asset downpayment account

0 Answers Accounting, TCS,

Can you assign more than one company code to a company ?

0 Answers

Hi Gurus, I have faced a problem while trying to post a withholding tax. I configure the withholding tax fully and after that i have also assigned it to vendor of my company code.When i'm posting that vendor a/c with withholding tax, the tax has been calculated, but when i'm trying to post it delivers an error message to me- i.e. "could not determine the year for TDS certificate number range". Plz, help me out from this.

1 Answers

Interest calculation indicator Z1 does not exist in table T056U

1 Answers

How Systems post value in Gl Account at the time of Goods Delivery, Billing means what is the System Configuration or tell me the FI-Sd Configuration

1 Answers

Define the relationship between controlling area and company code?

0 Answers

What is year end closing? How do you perform a carry forward commitment? : cost center accounting

0 Answers

What is ment by NOTED ITEMS.plz any 1 explain me

5 Answers SAT InfoTech,

How many statistical objects can be selected in when you post an FI document where CCtr, PCtr, OM are active?

2 Answers

how validations and substitutions are useful?

3 Answers

What is short-end fiscal year?

0 Answers

What is reconciliation account?

0 Answers

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