cancel
Showing results for 
Search instead for 
Did you mean: 

Enhancement fields - Replication of Data Source problem

Former Member
0 Kudos

Hi,

I am using standard Data Sources: 0FI_GL_4, 0FI_AR_4 AND 0FI_AP_4 for extraction of data from R/3 in to SAP BW. I am appending the new required fields for the above mentioned extractors by using enhancements.

After replicating the <i><b>replicate data source</b></i> in BW side, we observed that the enhanced fields of 0fi_gl_4 were replicating in transfer structure of SAP BW side, but 0FI_AR_4 AND 0FI_AP_4 fields were not replicating at transfer structure of BW.

Please advice me - is there any setting or coding part i need to perform to add newly enhance fields in transfer structure of data source: 0FI-AR-4 AND 0FI-AP-4.

Thanks & Best Regards,

Venkata.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Venkata,

Please try the below 2 approaches to get this working.

1st Approach.

-


Go to RSA6 and select your data source and unhide your fields.

2nd Approach.

-


If the above does not help this is what you should check.

The properties of all the fields of a Data Source is stored in a table called ROOSFIELD (DataSource Fields).

Step 1 ->Please go to SE11 and open the table - ROOSFIELD. Give the name of your Data Source in the Selection field OLTPSOURCE of the selection screen.

Step 2 -> Run this and check the 2 properties SELECTION and NOTEXREL of the enhanced fields of the data source.

Step 3 -> The enhanced fields should have the SELECTION field as ' ', 'P' or 'X'. It should not be 'A'.

Similarly the NOTEXREL field for the enhanced fields should be 'Y' and not 'N'.

These 2 fields would need to be updated in case they are not set.

There are several NOTES available if the above diagnosis are correct.

Hope this helps.

Thanks & Regards,

SH

Former Member
0 Kudos

Hi SH,

Thank you very much for yours replay.

I have replicated all the above mentioned steps.

1. In RSA6, hide field for enhance field was unchecked already.

2. In the table ROOSFIELD for a given data source, SELECTION = 'P' and NOTEXREL = 'Y'.

Still my enhanced fields are not populating at transfer structure.Please help me at earliest.

Thanks & Best Regards,

Venkat.

Former Member
0 Kudos

Hi Venkata,

Could you pls. check whether you are able to see the required fields in Datasource/Trans. structure tab of InfoSource.If the fields are not transferred to transfer structure then pls. transfer the fields.

Regards,

P B

Former Member
0 Kudos

Hi

If that was the case - You have not transferred the fields in Datasource/Trans structure tab, then I wonder how the enhanced fields of 0FI_GL_4 were visible to you?

Regards

Pradip

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Venkat,

After enhancing the extract structure did you remove the tick in hide check box in T-Code RSA6 for data sources 0FI_AR_4 AND 0FI_AP_4 .

Regards,

Prakash

Former Member
0 Kudos

Hi Venkata,

Pls check whether the newly added fields were in "HIDDEN" in the datasource. This can be a reason.

Thanks,

Krish

Former Member
0 Kudos

hi venkata

can you send the steps how you did that

and if possible code also

Regards

Vasu