Skip to Content
0

SAP BOFC 10.0 query on backend SQL Dimension tables

Aug 01, 2017 at 07:55 AM

49

avatar image
Former Member

Hi Experts,

When I see SQL Dimension tables in BOFC SQL database, the characteristic columns usually filled in with their ID instead of Code which is actually shown from BOFC front end.

But is it possible to get tables or views in SQL database which actually shows the rows and columns in similar way as we could see from BOFC front end?

For example :

Entity Dimension from BOFC

ID Name Description Currency

1 IN India INR

2 JP Japan JPY

Currency Dimension from BOFC

ID Name Description

11 INR Indian Rupees

21 JPY Japanese Yen

If I see in SQL database the Entity table displays as follows:

P_ID P_NAME P_LDESC2 C_CURRENCY

1 IN India 11

2 JP Japan 21

Values 11,21 in the currency column are the IDs of INR,JPY respectively. It doesn't show INR, JPY as it shows in the entity dimension table.

Is it possible to get the view/table in SQL database which can show the dimension details same as we see from BOFC front end ??

Thanks in Advance

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Marc Kuipers
Aug 01, 2017 at 10:29 AM
0

Hello Shalin,

You can do this via linking the tables in SQL (either with INNER JOIN or in this case just a direct WHERE clause)

For your example, you can use this:

select a.id, a.name, a.ldesc1, b.name from ct_entity a, ct_curncy b where b.id = a.curncy

Thanks Marc

Share
10 |10000 characters needed characters left characters exceeded