Valuation Type with material list as on date

[Former Member]

Hi Guys,

Business needs a T.Code where they need to reflect the material list with valuation type as on date. I am confused on what or which table we should use? Also even we create new Z-report with matl n valuation type, we also need there Company code, plant as well.

Do we have any such standard Transaction code meeting the requirement? If not then which fields we may select? Pls help.

[anand_sagarsethi · Accepted solution]

Its not as on date, its as today in MBEW. Once you open the table you will understand which fields you have to select.

You could have find this answer with a search.

If you need historic by Year and period: MBEWH.

Use report MM60 and change the layout to include Valuation type.. You will get what you want.

Regards

Anand

[Former Member · Accepted solution]

MSTA n MM60 I can look out for but how to get the total receipt, total issue quantity of the same material with their respective dates? Pls help

Since Business is asking for the following:

Input Data
Material	Plant	Storage Location	Material Type

Output Data

Material

Material Description

Material Type

B UOM

Valuation Class

Valuation Type

Storage Location

Stock

Price

Plant

Total Receipt

Total Issue

Last Receipt date

Last Issue date

Last Receipt Qty

Last Issue Qty

[anand_sagarsethi · Accepted solution]

IN that case your report is to built customly..

Mseg table will be used for your receipt and issues.

if receipts-issue is your available stock then simply do  sum by shkzg (debit credit field, s-h)

you will get your quantity, valuation type, everythin you want from there.

Thanks

anand

[JL23 · Accepted solution]

You have a strange way to ask questions.

You initially asked for a master data report and this turns now into a kind of global statistic for movements. Take this requirement to your ABAPers.

Also review you discussion online in SCN

there is no need to post the same reply to several people since everyone can see it if it is just posted once.

[Former Member · Accepted solution]

Thanks for your reply Anand.

Can you pls explain in detail a bit regarding MSEG table for receipt issues since when I am running the mseg table the input fields do not hv the material field but the usual material doc, purchase doc fields etc and in output we can get the material details against those docs. Is there any other report from where I can pick the receipt and issue qty and dates respectively. Also please explain abt the structure of SHKZ so that it would help me to get a clear view in allotting the fields in one Z-report.

Am new to the functional side so kindly help.

[Former Member · Accepted solution]

Thanks Jurgen for your reply. Actually the first post is what the business had asked previously and then on date the business dropped more requirement to the same. Sorry if it has disturbed you. Since I am having doubt so thought of taking help from you superiors.

[anand_sagarsethi · Accepted solution]

Mkpf is master header table, & mseg is the item table. mseg do have matnr field that specify material numbe. You have to join these tables on there primary keys i.e. Material doc number, and where will execute on your matnr, the material you want to report. And shkzg =s is receipts and when =h is your goods issue.

thanks

anand

[Former Member · Accepted solution]

Thanks Anand. Let me try as per ur suggestions.

[Former Member]

MSTA n MM60 I can look out for but how to get the total receipt, total issue quantity of the same material with their respective dates? Pls help

Since Business is asking for the following:

Input Data
Material	Plant	Storage Location	Material Type

Output Data

Material

Material Description

Material Type

B UOM

Valuation Class

Valuation Type

Storage Location

Stock

Price

Plant

Total Receipt

Total Issue

Last Receipt date

Last Issue date

Last Receipt Qty

Last Issue Qty

[JL23]

In table MSTA you will find the creation date of a view per organization, based on that an ABAPer will be able to "calculate" which views existed per date.

[Former Member]

MSTA n MM60 I can look out for but how to get the total receipt, total issue quantity of the same material with their respective dates? Pls help

Since Business is asking for the following:

Input Data
Material	Plant	Storage Location	Material Type

Output Data

Material

Material Description

Material Type

B UOM

Valuation Class

Valuation Type

Storage Location

Stock

Price

Plant

Total Receipt

Total Issue

Last Receipt date

Last Issue date

Last Receipt Qty

Last Issue Qty