help with cluster table konv

[Former Member]

I am building a SQL query to use the BI QlickView. I stopped for 2 weeks because I can not do this:

"SELECT KNUMV, kposn, kwert FROM KONV WHERE kschl = 'ZCOR'."

I know that KONV is a "cluster table" and therefore can not access it.

But so far only found two tables that are part of KONV:

* KONH (Conditions Header)
* KONP (Item Conditions)

However kposn fields and are not kwert these two tables.

Can anyone help me figure out where it comes from fields and KPOSN KWERT?

Best Regards,
Alex Pereira Mahmud

[Former Member]

I am building a SQL query to use the BI QlickView. I stopped for 2 weeks because I can not do this:

"SELECT KNUMV, kposn, kwert FROM KONV WHERE kschl = 'ZCOR'."

I know that KONV is a "cluster table" and therefore can not access it.

But so far only found two tables that are part of KONV:

* KONH (Conditions Header)
* KONP (Item Conditions)

However kposn fields and are not kwert these two tables.

Can anyone help me figure out where it comes from fields and KPOSN KWERT?

Best Regards,
Alex Pereira Mahmud

[Former Member]

Hi,

check this table NVKONV (IS - H conditions )which contains these two fields.

thanks.

[Former Member]

Hi,

I need access this information from Oracle.

When i typed "SELECT * FROM SAPR3.NVKONV" i saw this message:

however, if enter in transaction s11, and find table NVKONV, i saw this message:

NVKONV not exist!.

The NVKONV is a cluster table, view or else?

[Former Member]

Hi,

this is a transparent table.

thanks.

[Former Member]

Hi,

For me this table not exist. What is your version of SAP? My SAP is v.4.7..

It's possible there isn't  this table in my version?

Best Regards

Alex Pereira Mahmud

[Former Member]

Oh sorry mine is ECC 6.0 and this table exists. It may happen that table is newly added.

[Former Member]

All right. You have any idea about my problem?  I was thinking in create a view with fields i need.

[Former Member]

Hi Alex,

As per my understanding from your forum, fetching condition data details from sap to Oracle through where condition.

We have two table where we can get above mentioned fields.

1. KONV (Cluster table)

2. J_1IKONV (Transparent table)

Here you will get same fields as you mentioned But you can not get same data as we get from KONV table.

So try 2nd table 'J_1IKONV' for your requirement.

Hope it will help you.

Thanks,

Regards,

Praveen Reddy

[Former Member]

Hi, Reddy,

Thanks for your comments.

The table "j_1ikonv" exists, but has no data. You know why?