Skip to Content

how do I accses to valuation class from material type ?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 06, 2017 at 02:02 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded