Material characteristic link at loc level cant find

[former_member584840]

I am trying to find the link between characteristic and material location.

ie in my APO material master, I have got a characteristic entered at location level, via class 400 to use in Block planning.

If I enter the material master, I can see the description, but I am trying to find the exact link, so that I can create reports, table joins etc

between the two.

I have got lost within the tables of AUSP etc, and also tried many function modules, and debugging, but have been unable to get the link.

Specifically I want to be able to go backwards as well as forwards.

ie given a chracteristic, give me the material locations that are linked to this characteristic.

Note - this is within CDP class on a class 400.

Would appreciate if anyone is able to point me to something I can use!
thanks

j

[rajkj · Accepted solution]

Hi John,

For useful table join conditions, pl check the view KSAUSPOB. The characteristic values (ATINN, ATWRT), and KLART) and class data (CLINT and KLART) are available from the tables AUSP and KSSK. These tables are linked by OBJEK data field. Then, another table INOB-OBJEK gives the UID of the container (material master) and concerned table name(/sapapo/matkey).

i.e.

INOB-CUOBJ = KSSK-OBJEK

SELECT A.MATID FROM /SAPAPO/MATKEY A, INOB B WHERE A.MATID = B.OBJEK

Thanks,

Rajesh

[former_member584840 · Accepted solution]

Thanks Rajesh,

This is very helpful and has bought me closer to the answer.

For the material I am looking at, I still cant get the match though.

From material side, I get this far.

MATID 
JqyzYzd50Z}X08002W097G 
LOC 
JrJIyezG2c}X08002W099m 
MATLOC 
Jr}mCGhM2Y3X08002W099m 

CUOBJ 
900005 

And using this CUOBJ in INOB draws a blank.

Though INOB has another CUOBJ that links to the material ID

CUOBJ   

900360 

OBJEK 

JqyzYzd50Z}X08002W097G  

OBTAB 

/SAPAPO/MATKEY 

and this CUOBJ is also in KSSK

KSSK does have an object with this class but it doesnt match the characteristic in AUSP

OBJEK

000000000000900360

KLART

400

CLINT

98

If I come the other way and look for the object that has the characteristic in AUSP, it is a different object.

KSSK

OBJEK

899895

KLART

400

CLINT

98

AUSP

OBJEK

899895

ATINN

4484

KLART

400

ATWRT

CHARACTERISTIC RED

I am getting close within debug though as somewhere in this code

/SAPAPO/CL_MC01_CCV===========CM00F

FUNCTION /sapapo/mc01_ccd_valsscr_init.

There is an internal table GT_VAL which has the characteristic value.

I just need to figure out exactly how it is populated.

Looking again at the performance trace, it doesnt seem to go near AUSP, so maybe it is getting the characteristic from somewhere else.

Thanks for you help.

John

[former_member584840 · Accepted solution]

Aha.
Found it within

CL_IBRT_CFG_FROM_DB===========CM007

TABLE
/SAPAPO/MATLOC
returns
CUOBJ
(eg 900005)

Table
IBIN
CUOBJ
(eg 900005)

returns
IN_RECNO
JrqCoNpb0ZxX08002W097G

Table
IBINVALUES
IN_RECNO
JrqCoNpb0ZxX08002W097G

Returns
SYMBOL_ID
13457

table
IBSYMBOL
SYMBOL_ID
13457

returns the characteristic
ATINN
4484

ATWRT
CHARACTERISTIC RED

Thanks