Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think I found solution to this..not an easy one as I have to do several transformations but eventually got there