Hi, Experts:
We have a Generic Datasource, which is from a view based on multiple tables created by ourself in ECC. The datasource load data into an ODS in BI. I found that for a field "Supplier" in extractor, I can see value populated when run transaction RSA3 in ECC. But when check in ODS, the field "Supplier" is blank for some of the data, where suppose to have value populated. In transfermation rule, field "Supplier" has driect asignment from datasource to ODS. I can see the value of "Supplier" for those records in PSA.
Because of the limit of max 16 key fields in ODS, Field "Supplier" is not a key field for the ODS. But there is another field called "xref_num", which is a key field. "xref_num" is the uniq combination of field "Supplier" with other fields sach as "Product".
I really don't understand why the value is not populated in ODS for this field. Has anyone seen similar problem before? Any suggestions for trouble shooting?
Thanks,
Jenny