0FI_GL_4 Data Source

[Former Member]

Hi !

I changed the 0FI_GL_4 Data Source, adding 0GL_ACCOUNT as an option to filter in BW infopackage.

I ran successfully the code below:

Update ROOSFIELD set SELECTION = 'X' where

OLTPSOURCE = '0FI_GL_4' and

FIELD = '0GL_ACCOUNT'

1- Atfer replicating this datasource in BW side, I could see 0GL_ACCOUNT in my infopackage.

2- I ran an infopackage using for example 0GL_ACCOUNT = 0031100000.

3- After finishing successfully the load, it brings to me all account instead of only 0031100000.

Do I need to change another flag in R/3 or BW side ?

Thanks in advance.

[dielom]

Hi Leandro,

First, if you want to change a selection field, you need to do it in RSA6, checking the selection flag. I wouldn't touch the table..

Not always the filter is just checking the flag, I don't know particulary 0FI_GL_4, but the filter might be done in the Function Module logic.

Where have you updated that field? 0GL_ACCOUNT is an infoobject, so it's in BW. If you want to filter in the InfoPackage, you need to filter in ERP, so it's a field (HKONT) and not an Infoobject.

For 0FI_GL_4, if you check transaction RSA2, you'll see that selection is impossible, so I'm not sure if changing the table value manually would be enough.

Hope this helps.

Regards,

Diego

[Former Member]

Hi Diego !

I used the R3 field in my update comand not an infoobject. I have just post with a wrong name in my first message. I think change manually that flag is not enought to use at BW side even if it appears in my infopackage to use as a filter.

Thanks for you reply,

Leandro.

[dielom]

Hi Leandro,

Yes, the filter must be in the logic. Also, of you think about this particular datasource, it reads from table BSEG, so if you read BSEG by account, it could take a long time (and you cannot even create an index because it's a cluster table..).

If you are only interested in accounts, and not documents, you should try another datasource, like 0FI_GL_6.

Regards,

Diego

[Former Member]

Hi Leandro, how you modify value in table ROOSFIELD ?

We need activate the Field for selection too

Thank you

[Former Member]

I fix the problem :

1) Go to SE16 and List values

2) Select the Record for Modify

3) /h

4) Change in debug mode the value "SHOW" to "EDIT" in Line :

if code = 'SHOW'.

Use the Pencil.

5) F8