‎2009 Oct 01 12:30 PM
Hi ppl,
I have to fetch entries from the table INOB based on the Class type (KLART = 022), Name of database table for object (OBYAB = MARA) and Key of Object to be Classified (OBJEK = material number).
But, the table INOB does not have an entry corresponding to my search criteria.
But, an entry is expected in this table.
Please let me know how are entries created in the table INOB. Which transaction updates this table.
Thanks,
David.
‎2009 Oct 01 1:03 PM
The table INOB is a master data table related to PP module. You can directly enter values into the table by clicking on "create entries" button.
‎2009 Oct 01 1:57 PM
HI David,
the filed OBJEK in INOB is a combination of material and batch number. so we cannot get the record if we query on objek.
This table is updated when we create a new batch in MSC1N transaction code.
Please find some sample code to use this table..Hope it helps.
SELECT objectid
changenr
FROM cdhdr
INTO CORRESPONDING FIELDS OF TABLE git_cdhdr
WHERE objectclas = c_classify.
IF sy-subrc EQ 0.
LOOP AT git_cdhdr INTO lwa_cdhdr.
lwa_cdhdr-id = lwa_cdhdr-objectid.
MODIFY git_cdhdr FROM lwa_cdhdr.
ENDLOOP.
IF NOT git_cdhdr[] IS INITIAL.
SELECT cuobj
objek
FROM inob
INTO CORRESPONDING FIELDS OF TABLE git_inob
FOR ALL ENTRIES IN git_cdhdr
WHERE cuobj = git_cdhdr-id
AND klart = c_klart
AND obtab = c_mch1.
LOOP AT git_inob INTO wa_inob.
clear: lv_sytabix.
lv_sytabix = sy-tabix.
wa_inob-objek1 = wa_inob-cuobj.
lv_matnr = wa_inob-objek+0(18).
lv_charg = wa_inob-objek+18(10).
endif.
Regards,
Nagaraj
‎2009 Oct 01 3:38 PM
If classification is maintained at material level, you will find the characteristic values directly in AUSP and if they are maintained at a batch level, then you will need to go through INOB to AUSP to get the same values.