Problem with reference table

[former_member210541]

Hi experts,

I am trying a DB lookup.

For character type fields it is working fine, but when i am trying to fetch value of a FLTP type field, I get the following error

Reference field referring to a different table for field ATFLV

Please help me with this.

[christianlechne]

Hi

can you please provide a screenshot of the DB lookup expression you have modeled. Especially the name of the table you are querying is of interest. If it is a standard table the name is sufficient, if it is a Z-Table the structure would be of interest especially if you have assigned any reference tables to your FLTP field

BR

Christian

[former_member210541]

Hi Christian,

It is a standard table, I am fetching data from AUSP.

[christianlechne]

Hi Tee Gee,

this error has nothing todo with the type of the field but with the definition of the DB table. The FLTP fields of AUSP reference to the table T006. Within BRFplus there is a check (CL_FDT_DB_LOOKUP->CHECK_FIELD_MAPPING) that checks for the field mapping if the field has a reference table assigned to it and if this si the case if the reference table is different to the original table that the DB lookup is executed on. If this is the case the error message that you see is raised. This type of "configuration" is not supported in BRFplus.

How to overcome that? If you want to query the table and map that field you have to wrap the query into a static class method and use a procedure call expression to call that method.

Wrapping the table with a view (simple old-sytle DDIC or CDS won't do the job - BRFplus is too clever here ;-))

Hope that helps

Cheers

Christian

P.S. As a moderator I have to tell you that the picture you use is against the RoE of SCN. You have to use a real picture (and I do not think that you are Messi right )