on 2010 Feb 16 12:39 PM
Dear All,
in which table i can get Prd number, materail number, class type assigned to this materail, class, & their characteristics Values
Regards
Madhu
Request clarification before answering.
Hi,
For order details you can refer to AFKO, AUFK & AFPO. For the characteristics & values pasted the tables below. Not in front of the system, but guess the field is CUOBJ or OBJEK should be equal to order number, check on that & you should be able to build the link from there.
KLAH Class Detail
CABN Characteristic Detail
AUSP Characteristic Values
CAWN Characteristic Values
CAWNT Characteristic Value Texts
KSML Characteristic Allocation to Class
KSSK Material Allocation to Class
Regards,
Vivek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kumar,
Let me try to explain you on how to get the characteristic values.
I checked as Vivek suggested in AFKO-CUOBJ but found no values for production orders.
If you know the production order,then input the order number in to CAUFV table and extract the material number and feed in to INOB-OBJEK(with full 18 digit format like 000000000012000244 if 12000244 is a material number) and INOB-OBTAB give the table MARA (for material characteristics) or MCH1(for batch charcteristics) and execute.
You will get INOB-CUOBJ with respect to Class type.Take this CUOBJ,clas type and feed in to AUSP-OBJEK(with full 18 digit format),AUSP-KLART,system will give all the characteristic values with respect to class type.
Hope it helps,let me know if you require any other info.
Hi Girish,
Can you let us know the stg grp of the material? Also can you briefly explain how you have configure the material / order?
If the idea is to read the header material's class & characteristics as maintained in the material master, we can straight read from MARA or MARC & pass it to INOB to get the details isnt it?
Regards,
Vivek
Hi , Please find below tables
Characteristics :
CABN Characteristics ( o.a. batch/vendor)
CABNT Characteristics description
CAWN Characteristics ( o.a. material)
CAWNT Characteristics description
AUSP Characteristic Values
Class types and objects :
TCLAO Several class types for object
TCLA Class types ( vb. lfa1 => v10 en 010)
TCLAT Class type text
TCLT Classifiable objects
TCLC Classification status
Links :
INOB Link between Internal Number and Object
KLAH Class header data
KSSK Allocation Table: Object (vb.matnr) to Class
KSML Characteristics for a class (internal number)
MCHA Batches
MCH1 Batches
MCHB Stock : batches
Regards
SANIL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 23 | |
| 13 | |
| 5 | |
| 5 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 3 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.