Extraction 0FI_GL_4 - WBS-element is missing

[Former Member]

Hi,

I'm struggling with the extraction of 0FI_GL_4. In the extraction we have created an additional field on top of PROJK with the conversion to 24 Char, ZZ_PROJK. However, when we run the extraction both fields are not filled and thus missing in the target ODS. The field is also missing in the PSA.

Funny is that I have tested the extraction in R/3 using transaction RSA3. When testing, the fields are filled correctly. So somewhere between extraction from R/3 and BW the values get 'lost'.

It also seems that things can go wrong when I enter a source system when testing in RSA3. In the Development and Quality assurance R/3 the fields are not filled when I enter the Dev. or Qualtity Ass. source systems as target. Can this have anything to do with it, maybe in terms of RFC-settings?

Our current plug-in BW is 2003_1_620 and for R/3 2004_1_46C so problems mentioned in the OSS notes are not relevant.

Any helpful suggestions or solutions are of course rewarded.

Kind regards,

Hans de Klein

[Former Member]

Hans,

check if in RSA6 for your datasource/added fields you unchecked all the flags (only in exit, hidden and so on...)

Let me know !

Bye,

Roberto

[Former Member]

Roberto,

All the fields are unchecked. Only companycode and fiscal year/period are checked for selection.

[Former Member]

Is it possible that the problem has anything to do with delta-loads vs. full loads? I see the DataSource is marked for delta-loads and in the loads I use for extraction to BW I use a full-load...

Are there any known problems with this?

[Former Member]

Siegfried,

I have done a new extraction after I replicated the DataSource again, however without any luck.

Any more suggestions? Solving this issue would really make me happy!

[Former Member]

Maybe a new insight:

I mentioned that I had checked the extraction using RSA3. Now it seems that the field PROJK is filled when I DO NOT enter a target system, and that field PROJK is empty when I enter the target system.

Does this problem ring a bell to any of you?

[Former Member]

I don't know if I right understood, but you have no problem to see your field in BW (replication and so on)...you see it empty !! is it right ?

Are you sure that your userexit works and you see your field filled in RSA3?

[Former Member]

Yes, I have no problem the see the field itselve. It is empty.

And the user-exit seems to work fine when I test it in R/3 (RSA3). All the custom fields are filled in this extractor checker.

[Former Member]

Hi Hans,

the first thing I would try is to replicate the datasource again and reactivate the communication structure. Because you can see the fields in RSA3 you should also see them in the PSA. Let us know!

regards

Siggi

[Former Member]

Sandhya and Siegfried,

Both thanks for your reply. However, in this case there is no startroutine for the transferstructure.

Replicating the datasource + reactivate the communication structure is an option. I will try to make a new extraction this evening. However, in my opinion it is doubtful this will work. During transport to the Production environment the DataSources were replicated and the communication structure was activated. Anyway, I'm desperate so I will give it a shot

[Former Member]

Hi Hans,

your R/3 transport went well I hope?

Siggi

[Former Member]

some pointers:

-- Possibility 1) Check if there is any transfer start routine or transfer rules which are causing this elimination of values. Since the values are not appearing in the PSA, there is a possiblity that those values could have been eliminated in the Transfer start routine.

-- Regarding giving the source system id in the rsa3 for dev n quality, it might not give any output, since the source system id represents the source of the data and not the target system of the data.