on 06-12-2006 6:43 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Venkata,
Pls check whether the newly added fields were in "HIDDEN" in the datasource. This can be a reason.
Thanks,
Krish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi venkata
can you send the steps how you did that
and if possible code also
Regards
Vasu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.