2007 May 16 2:53 PM
Hi all,
I want to retrieve the field and field values for the characteristic description and value fields in the classification view. Please help me out, as I am not able to get the table from where I have to retrieve the data.
Thanks!!
2007 May 16 3:34 PM
Hi,
You will have to query tables MARA, AUSP, CAWN and CAWNT.
- AUSP-OBJEK = MARA-MATNR.
- Get the value of ATINN and ADZHL from AUSP for the above value.
- Now you should be able to query CAWN and CAWNT using these values.
Also you can get characteristic names from CABN table.
Regards,
Ferry Lianto
Please reward points if helpful.
Hi all,
I want to retrieve the field and field values for the characteristic description and value fields in the classification view. Please help me out, as I am not able to get the table from where I have to retrieve the data.
Thanks!!
2007 May 16 2:59 PM
Hi,
Please check this tables.
CAWN - Characteristics
CAWNT - Characteristics Description
Regards,
Ferry Lianto
2007 May 16 3:11 PM
Hi Ferry,
could you be more clear by letting me know the code to retreive the data from those fields onto the selection screen.
Thanks!!
2007 May 16 3:00 PM
Hi ,
Check out the table CAWNT where you can find the characteristic values and its descriptions.
Regards,
Jayaram...
2007 May 16 3:34 PM
Hi,
You will have to query tables MARA, AUSP, CAWN and CAWNT.
- AUSP-OBJEK = MARA-MATNR.
- Get the value of ATINN and ADZHL from AUSP for the above value.
- Now you should be able to query CAWN and CAWNT using these values.
Also you can get characteristic names from CABN table.
Regards,
Ferry Lianto
Please reward points if helpful.
2007 May 16 3:43 PM
Use function module <b>BAPI_OBJCL_GETDETAIL</b>.
ObjectKey = Material Number
ObjectTable = MARA
ClassNum = Class number/name from the classification view
ClassType = Class Type from the classification view (for example 001)
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |