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.
Answers were Sorted based on User's Feedback
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 |
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 |
what does line means?
Hello ALL My user posting the frieght clearing he is getting error on Bill Accounting issue frieght clearing provision account is not getting cleared at the time of accounting He has done sucessfully GRN but in account frieght clearing in not appering can any body give me suggestion on same Regards vamsi
Name some settlement receivers for co internal orders?
what is lot numbers in automatic payment? How to make it?
Why do you need cost element accounting? : co- general controlling
What is a document header? : fi- general ledger
1)how many tr's you have moved in support project? 2)tell me the complete process of idoc's? 3)what are the interfaces you have dealt wih in your project?
Give some examples of gl accounts that should be posted automatically through the system and how is this defined in the system?
What is generally configured in the payment term as a default for baseline date?
What is difference between SA, RA & AB ?
What is the document change rule? : fi- general ledger
one vendore for compaany maintain by the 2 reconsaligations,1st one is service 2nd is production is avilble,posting is also done for service reconsalization. at the time you can change for reconsalization option where is it avilble