how to join KLAH and CAWN ??

[Former Member]

Hi all,

I need to fetch Charcterstic(ATBEZ) and charc value(ATWRT) from CAWN and CABNT based on CLASS field in KLAH for Equipment Master.

Thanks

Kiran

Moderator message: please invest some research effort before asking.

Edited by: Thomas Zloch on Mar 13, 2011 1:34 PM

[former_member585060]

Hi,

Check with the below relation

EQUI-EQUNR = AUSP-OBJEK

AUSP-ATINN = KSML-IMERK

KSML-CLINT = KLAH-CLINT

KLAH-CLINT = CABN-CLINT

CABN-ATINN = CAWN-ATINN

Regards

Bala Krishna