Question Re: Lookup in FOX using REFDATA in Technology Q&A

Lookup in FOX using REFDATA

Former Member — Thu, 14 May 2015 15:02:55 GMT

Hello Everyone,

I'm trying to do a look up in FOX to read Prices from another DSO. In my case, I won't be able to use "|" method as I need to loop Reference Data to apply some conditions. Prices DSO has the data at granularity customer & material, validity dates, price type. Filter was restricted to Plan DSO. Pricing DSO is already part of MP and Agg Level.

I don't see my code is working... even in debugging XF_REF_DATA internal table has Plan Data, not reference data. Am i missing something? I can see reference data for "|" method. Please let me know if you need more information. Thanks a lot for all your help.

Code:

CURDATE = VARV( 0DAT ).

FOREACH MATERIAL, CUSTOMER.

FOREACH MATERIAL_REF, CUSTOMER_REF,CALDAY_REF, CALDAY_FR, CALDAY_TO, CURRENCY, KNART IN REFDATA.

IF MATERIAL_REF = MATERIAL AND

KNART = 'ZNLP' AND

CURDATE >= CALDAY_FR AND

CURDATE <= CALDAY_TO.

L_LPRC = { 0KNVAL, CALDAY_REF, #, CUSTOMER_REF,CURRENCY,KNART, MATERIAL_REF, CALDAY_FR, CALDAY_TO }.

ENDIF.

ENDFOR.

{ 0PRICELIST, #, USD, CUSTOMER, #, #, MATERIAL, #, # } = L_LPRC.

ENDFOR.

Regards,

Benarji.

Re: Lookup in FOX using REFDATA

cornelia_lezoch — Thu, 14 May 2015 21:06:59 GMT

Hi Benarji,

your loops don´t work, becasue with the

FOREACH MATERIAL, CUSTOMER

you are within one combination of material and customer.

within this you can not do another loop for the same char.

regards

Cornelia

Re: Lookup in FOX using REFDATA

Former Member — Tue, 19 May 2015 17:21:23 GMT

i'm trying to loop reference data in the 2nd loop, not the current package.

Re: Lookup in FOX using REFDATA

cornelia_lezoch — Thu, 21 May 2015 10:20:56 GMT

well, but as you experienced it - it is not working the way you defined the loops.

In your code you have to change as following:

1) take the material out of the fields to be changed, because of the IF MATERIAL_REF = MATERIAL

2) do the loops as below:

FOREACH CUSTOMER_REF, CALDAY_REF, CALDAY_FR, CALDAY_TO, CURRENCY, KNART IN REFDATA.

IF KNART = 'ZNLP' AND

change the logic here, you used the terms in wrong direction:

CALDAY_FR <= CURDATE AND

CALDAY_TO >= CURDATE.

L_LPRC = { 0KNVAL, CALDAY_REF, #, CUSTOMER_REF,CURRENCY,KNART, CALDAY_FR, CALDAY_TO }.

ENDIF.

ENDFOR.

foreach customer.

{ 0PRICELIST, #, USD, CUSTOMER, #, #, #, # } = L_LPRC.

ENDFOR.

what is still strange, if there are more than one data redord foun within the reference data, the last one will win ...

regards

Cornelia

Re: Lookup in FOX using REFDATA

Former Member — Tue, 09 Jun 2015 06:41:23 GMT

Hi Benarji,

You can seperate the 2 loops.You can try this..

FOREACH MATERIAL, CUSTOMER,MATERIAL_REF, CUSTOMER_REF,CALDAY_REF, CALDAY_FR, CALDAY_TO, CURRENCY, KNART IN REFDATA.

IF MATERIAL_REF = MATERIAL AND

KNART = 'ZNLP' AND

CURDATE >= CALDAY_FR AND

CURDATE <= CALDAY_TO.

L_LPRC = { 0KNVAL, CALDAY_REF, #, CUSTOMER_REF,CURRENCY,KNART, MATERIAL_REF, CALDAY_FR, CALDAY_TO }.

**pass the value here

{ 0PRICELIST, #, USD, CUSTOMER, #, #, MATERIAL, #, # } = L_LPRC.

ENDIF.

ENDFOR.

this should work. Also make sure that whatever characteristics you have used after FOREACH is selected as characteristics to be changed .

Let me know the result..after trying this..

Thanks,

Tharun