how do I accses to valuation class from material type ?

[former_member385413]

I use this query

select dd.* ,ff.*
from
sapsr3.MARA ma
,sapsr3.T134 tt,
sapsr3.t025k hh,
sapsr3.T025 dd,
sapsr3.T025t ff
where
ma.MANDT=110
and matnr='000000000030000057'
and
tt.MTART=ma.MTART
and tt.mandt=ma.mandt
and hh.KKREF=tt.KKREF
and hh.mandt=tt.mandt
and dd.KKREF=hh.KKREF
and dd.MANDT=hh.MANDT
and ff.SPRAS='E'
and ff.MANDT=dd.MANDT
and ff.BKLAS=dd.BKLAS

but I receive 8 record for one material

I want A valuation class for each material

[VolkerBarth]

Is that a question related to the SAP SQL Anywhere DBMS?

(If not, please choose a different primary tag, otherwise the according topic experts will probably do not notice your question. - Note, I do not know what tag would be appropriate, I'm not familiar with those tables and reports.)

EDIT: I turned my comment into an answer (although it is none) because comments are now hidden by default, and I fear the original poster may not notice my comment otherwise.

[former_member385413]

I do not know what tag would be appropriate

[VolkerBarth]

Sorry, I do not know, either. But it certainly does not relate to the SQL Anywhere database system.

Here's the official "Help topicabout using tags".

Would some of the "Material"/"MM" tags fit here, such as "MM (Materials Management)"? And you coult then add "SQL" as a secondary tag.