SQ01 to show condition types for the Billing doc

[Former Member]

Dear Friends,

I need to show 3 cost condition types from a invoice in SQ01

For eg

The Query has for eg

Billing Doc Material Net value ZT07 ZT08 ZT09

The ZT07/8/9 are conditiontypes

I need to link these at item level in SQ01, which tables should be linked

Please help

Kind Regards Ravi Kumar Rath

[former_member183879]

Hi

You cannot put KONV in the table query as this is a cluster table.

Instead when you are creating the query, select data source as "Logical database" instead of "Table Join" and select the logical database as VFV. This will give you the data you are looking for, if you map your select fields and output fields correctly.

[former_member217082]

Hi Ravi

Please use the following tables for SQ01

KONV Conditions (Transaction Data)

KONP Conditions (Item)

VBRP Billing Item data

T685

Regards

Srinath