SAP list prices help

[#1]

Hi all,

I need some help in data modelling so I can pull correct records. I have 2 tables which holds list price information at 2 different levels.

Table A - In this Table, List price (KBETR) is maintained at VKORG/VTWEG/MAT_GRP1 Level

VKORG	VTWEG	MAT_GRP_1	MATNR	DATBI	KBETR
GB	10	121	ABCD	2014-01-20	$100

Table B - In this Table, List price (KBETR) is maintained at VKORG/VTWEG Level

VKORG	VTWEG	MATNR	DATBI	KBETR
GB	20	ABCD	9999-12-31	110

What I am looking for is

When user selects 121 value from list box MAT_GRP_1--> As the DATBI is expired (< Today()) I want dashboard to go and pick up KBETR from Table 2 which is 110.

Any suggestions?

Thanks a lot

MC

[#2]

I think I found solution to this..not an easy one as I have to do several transformations but eventually got there