Link between Work Area and Characteristics(CBIH02)

[Former Member]

hi Experts,

I am new to this community.I have a requirement where in i need to show the detailed characteristics of work area.

Work area is stored in table CCIHT_WAH and class is stored in KLAH Table.

The final value is stored in table AUSP.

For each Work Area there is a separate class for Month(Say Jan,feb etc).It is represented by a single class value in KLAH Table but when i am trying to link this table with KSSK, I am getting different combinations as Month is different for different Work Areas.There is no direct link between CCIHT_WAH and AUSP Tables so how should i establish a link between these tables?

I am using CCIHT_WAH,CCIHT_IHVA,KLAH,KSSK and AUSP Tables.

Pls help me in this matter.

[Former Member · Accepted solution]

Hi Brajesh,

As per ur logic there is a llink between AUSP-OBJEK and CCIHT_IHVA-RECN but when i checked these tables bothe these fields are of different data types and their field length is also different.Can u pls help me to link these tables?

Regds,

Sam.

[Former Member · Accepted solution]

Hi Sam,

Sorry for delay in rmy reply. I was out for business travel, so didn't got a chance.

Regarding your queries, instructions to fetch the characteristic values based on Work Area and Class as Selection criteria are as follows:

Step 1: Go to CCIHT_WAH table and fetch RECN field value using WAID as Selection Criteria

Step 2: Go to CCIHT_IHVA table and fetch RECN and IHVALCAT (Class Name) field value using RECNROOT = CCIHT_WAH -RECN as Selection Criteria.

Step 3: Go to KLAH table and fetch CLINT (IntClas No) field values using CLASS = CCIHT_IHVA-IHVALCAT.

Step 4: Go to KSML table and fetch IMERK (Intchar No) field values using CLINT = KLAH-CLINT

Step 5: Go to CABN table and fetch Characteristic details using ATINN = KSML-IMERK.

Step 6: Go to AUSP table and fetch (characteristic Values) using OBJEK = AsterikCCIHT-IHVA-RECNAsterik and ATINN = KSML-IMERK.

Hope this helps you.

Thanks,

BrajeshK

[Former Member]

Hi Brajesh,

Thank u very much.My problem is solved now.Giving full points to u.

Really a very useful answer.Thanx a lot...

Regds,

Sam

[Former Member]

Hi Brajesh,

How to link KLAH and CABN Tables? I tried by using "CLINT" but I found no value for CLINT in my CABN Table.As per ur logic I am getting link between Work Area and Characteristics.Only thing I am missing is a link between Class and Characteristics.

Pls help me in this matter.

Regds,

Sam.

[Former Member]

Hi Brajesh,

Thanx a lot for ur Reply.

I am using Work Area and Class as Selection Criteria.Based on a particular Work Area(WAID in CCIHT_WAH) and Class(IHVALCAT in CCIHT_IHVA) I have to retrieve values from AUSP Table.Can u tell me how to interlink Work Area,Class and Characteristics?

Regds,

Sam

[Former Member]

This message was moderated.

[Former Member]

Hi Sam,

Please explain the scenario in more details, particularly how month is assigned to Work Area and what is the usage?

Thanks,

BrajeshK

[Former Member]

Hi Brajesh,

Thanx for ur reply.I am using the following steps to save the data.

Tcode CBIH02->Press F8->Select a Work Area->Industrial Hygiene and safety(ctrlshiftF7)->Entered data into fields and then Saved.

I want to retrive these data against the Work Area.How to fetch these data.

Pls help me in this matter.

Regds,

Sam

[Former Member]

Hi Sam,

To retrieve the data Saved in Work Area as Characteristic Values under Value assignments, following logic should be used.

Step 1: Go to CCIHT_WAH table and fetch RECN field value using WAID as Selection Criteria.

Step 2: Go to CCIHT_IHVA table and fetch RECN field value using RECNROOT = CCIHT_WAH -RECN as Selection Criteria.

Step 3: Go to CABN table and fetch ATINN field value using ATNAM = "Characteristic" as Selection Criteria.

Step 4: Go to AUSP Table and fetch ATWRT field value using OBJEK = CCIHT_IHVA-RECH and ATINN = CABN-ATINN as Selection Criteria.

This should give the characteristic values stored in Work Area.

Let me know, if this is what you are looking for.

Thanks,

BrajeshK