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.

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by posting key? : cost center accounting

599


Name any 5 CO tables and How do CO Consultants use the CO tables and other tables?

1308


What are organisational units in sap ?

692


What are the sub modules in sap financial accounting (fi) ?

694


Explain co automatic account assignment? : co- cost center accounting

567






1.HOW TO SPECIFY THE BANK OVER DRAFT LIMIT IN SAP TO BANK ACCOUNTS 2.IN ACCOUNTS PAYABLE FOR APP HOW TO PROCESS THE RECEIPT IN CASE FOR A VENDOR WHO IS ALSO A CUSTOMER AND FROM WHOM AMOUNT IS RECEIVABLE.

2195


How can you default certain items while creation of internal order master data?

608


How are controlling areas and company codes related?

632


What is depreciation simulation? : fi- asset accounting

772


What is gui standing? How to create /edit gui status?

646


What configuration needs to done for using mixed costing?

620


what is matrix preparation authorization. and how it is related to PMRD. What is PMRD

2763


Dear Please send me a T-Code with description for FICO.

1439


Can you explain how carry-forward happens in sap?

569


Define the term "posting period varient"?

717