Question:
Hi,
I need to extract data from tables BSEG and BKPF and tried to create a generic extractor for each table. With BSEG I received an errror message "extraction from pool and cluster tables not permitted".
There are also some customer defined fields in BSEG which I need
I'm on 2.1.c so no relevant business content exists.
What are my options? combining the tables in SAP R/3?
Thanks in advance!
AO
Answer:
As you stated BC cannot help you, I think the only solution you have for that is to create an abap program that will fill a ztable from bseg and bkpf on a regular basis, and then you have to extract from that table. Think about delta issues, as bseg is huge, you have some more possibilities if you are using the last plugin.
it's not that much informations, I hope this will help you getting back in the right way anyway,
Ch
OPT,TT
_________________
_
There are only 10 types of people in the world :
those who understand binary and those who don't.
Answer:
Hi,
Thanks for your suggestion! I thinks that way is the best way to go now. We're on PI 2000_2 so that's not much help here. Does business content 0FI_GL_04 take care of this in 3.0?
Thanks!
AO
Answer:
How did you create your extractor??? I assume based on a view... try writing an ABAP program on BSEG. It works (I did it)!
cheers,
El Belgio
Answer:
Hi,
I'll try to do just that. I was thinking of first checkin out the header table BKPF and then finding the related line-items in BSEG. Could we in this way restrict the direct read by month (which is in BKPF) so that we could avoid going through all BSEG items?
Does the fact that BSEG is a cluster table pose some restrictions? (in addition to the fact that joins, views, and direct generic extraction is not possible)
Thanks!
AO
Answer:
No actual other restrictions, apart the hugeness of the table. If you are not an actual abap programmer, I suggest you to try to ask for the help of an abap programmer for this extraction part : he is the best one who would guide you towards the best solution in terms of response time during extraction (as bseg is really huge, I suggest to use the concept of logical database)
Ch
_________________
_
There are only 10 types of people in the world :
those who understand binary and those who don't.
Answer:
Hi,
Thanks for your help! I'm goin to follow your suggestions and ask our ABAPers fort their expertise in the R/3 side.
Regards,
AO
Answer:
Logical databases are not necessary. If you have good developers at hand they can probably program a much quicker select statement (you need to work with the index tables if possible at all).
cheers,
El Belgio
Answer:
check out OSS note 401646 - we have been using 0FI_GL_4 & 0FI_AR_4
for the past year in a 2.1c system!
party on
Answer:
Hi,
We're on PI 2000.2. and as I understand it we would require PI 2001.1. Any hints on how much work is related to upgrading PI levels? We have quite a lot of Z-code in the R/3 side...
AO
Answer:
Plug-In upgrades shouldn't affect your R/3 that much... unless you have fooled around in the previous Plug-Ins
cheers,
El Belgio