Characteristic value of material code

[former_member515644]

Hi,

I have to add 4 fields in report based on the characteristic value of the material. My requirement is listed below for your kind consideration:

for each Material item VBAP-MATNR Include in the report only if this Characteristic value is set: Class type KLART Class CLASS =
Characteristic ATNAM = from input selections Char.Value ATWRT


for configurable materials: Characteristic: Only when Material is configurable, KZKFG='X" item A1 U1OSD_DET03 (ATWRT) From class type 300, class U1OSD001, read assigned value of characteristic item A2 U1OSD_DET11 (ATWRT) item A3 U1OSD_DET04 (ATWRT) item A4 U1OSD_DET12 (ATWRT)

2 categories : for each material VBAP-matnr and other if mara-kzfkg ='X'. display value.

Kindly suggest select query for the same or any function module with full code.

Thanks.

[former_member515644]

Hi,

I have to add 4 fields in report based on the characteristic value of the material. My requirement is listed below for your kind consideration:

for each Material item VBAP-MATNR Include in the report only if this Characteristic value is set: Class type KLART Class CLASS =
Characteristic ATNAM = from input selections Char.Value ATWRT


for configurable materials: Characteristic: Only when Material is configurable, KZKFG='X" item A1 U1OSD_DET03 (ATWRT) From class type 300, class U1OSD001, read assigned value of characteristic item A2 U1OSD_DET11 (ATWRT) item A3 U1OSD_DET04 (ATWRT) item A4 U1OSD_DET12 (ATWRT)

2 categories : for each material VBAP-matnr and other if mara-kzfkg ='X'. display value.

Kindly suggest select query for the same or any function module with full code.

Thanks.

[FredericGirod]

Did you try by your self to make a SQL trace on standard SAP transaction ? to understand how SAP made the SELECT between the tables, How the tables are link and maybe to find yourself some FM

If you never search by yourself you will never understand how to do your job

[former_member660513]

https://answers.sap.com/questions/7780118/function-module-to-read-attributes-value-from-clas.html