Skip to main content
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SAP list prices help

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



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



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


1 Reply
Not applicable

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