Table Joins

[Former Member]

Dear All ,

I am trying to get some billing data. iit gives below error message when i execute this report.

ZCM:001 no entries found.

used the below tabe and table joins

Table Join(s)

VBRK

VBRP

MARC

KONV

KNA1

KNA1VV

Key Join(s)

VBRK-VBELN To VBRP-VBELN

MARC-MATNR To VBRP-MATNR

MARC-WERKS To VBRP-WERKS

KONV-KNUMV To VBRK-KNUMV

KONV-KPOSN To VBRP-POSNR

KNA1-KUNNR To VBRK-KUNAG

KNA1-KUNNR To KNA1VV-KUNNR

could u pls assist me whether i have to change any table or key joins.

Regards

Visvanathan

[eduardo_hinojosa]

Hi

The problem must be in KNA1VV. It's a view (KNA1 and KNVV). So replace it by KNVV.

Regards

Eduardo

[Former Member]

Thanks

[Lakshmipathi]

Dont consider KNA1 with tables like VBRK, VBRP. Without considering KNA1, table join other tables and execute. In fact, I dont know why you considered MARC table since the indication was to see billing data for which VBRK and VBRP is enough.

thanks

G. Lakshmipathi

[Former Member]

Dear Laksmipathy,

i need material orign and profit centre hence i used MARC table.

error occured when i join KNA1VV with any other table.

Regards

Visvanathan

[Lakshmipathi]

As I said already, dont consider KNA1 and execute with other tables.

thanks

G. Lakshmipathi

[Former Member]

I think KONV table u can not used for Table join.