Question Re: Costing Data for Material in Technology Q&A

Costing Data for Material

former_member293102 — Wed, 29 Jan 2014 18:39:23 GMT

Dear Experts,

I need to capture all the data from different tabs of below screen and also the circled fields in BW data model. What would be the best approach.

Which standard datasource is closest to provide this info.If there are no standard datasources for it, which tables are involved ? KEKO and CKIS looks close. What would be the other tables involved ?

Re: Costing Data for Material

RamanKorrapati — Thu, 30 Jan 2014 05:48:19 GMT

Hi,

Please take MM consultant help and find the base tables.

Or You can try on your own by using F1 help on particular field, next screen use technical settings.

You will get base table and field names also.

Once you base tables, thru table name you can search on Google engine for data sources.

You need material master data sources also.

for master data source search at ECC Tx - RSA5, use MATERIAL*

There are MM Data sources which start with 2LIS_02*,. please check 2LIS_04_P_MATNR.

Thanks

Re: Costing Data for Material

Former Member — Thu, 30 Jan 2014 07:35:46 GMT

Hi Mihir,

Check if you can use COPA extractors. I think you can easily find material costing related data in COPA. But first check if COPA is being used in ECC or not.

Thanks

Re: Costing Data for Material

Former Member — Thu, 30 Jan 2014 12:07:00 GMT

Hi ,

For your requirement

Check the below data source for you requirement ... (DS high lighted in red holds most of the fields you are looking for).

0CO_PC_PCP_01 Product Cost Planning: All Calculations

0CO_PC_PCP_02 Product Cost Planning: Released Calculations

0CO_PC_PCP_03 Product Cost Planning: Itemizations Costing

0CO_PC_PCP_04 Product Cost Planning: Itemizations Costing - Prices

0CO_PC_PCP_10 Product Cost Analysis: Overview

0CO_PC_PCP_20 Product Cost Analysis: Cost Component Split

0CO_PC_PCP_30 Product Costing Analysis: Itemization

For description of cost component you can install n make use of the below data sources.

0COSTCOMP_ATTR	Cost Components
0COSTCOMP_TEXT	Cost Components

Check for the source tables : KALM, KALD, KALS, KALV, KALA CKHS, CKIS ...

Regards

Re: Costing Data for Material

shanthi_bhaskar — Thu, 30 Jan 2014 21:32:49 GMT

you might need CKHS, MBEW, MBEWH other than what you mentioned already.

Re: Costing Data for Material

former_member293102 — Fri, 31 Jan 2014 10:45:10 GMT

Hi Prashanth,

Thanks for your valueable inputs. What if need info from CK13N. Seems like the details coming from CK13N is different from MM03. Same screens but different values.

Can you help ?

Regards,

Mihir

Re: Costing Data for Material

Former Member — Sun, 02 Feb 2014 14:53:39 GMT

Hi Mihir,

Yes details coming from CK13N are different from MM03...

The data sources provided in my earlier mail are with respect to CK13N.You can make use of the data soruce provided from my earlier reply.

If you want the sources which extracts data referring to MM03 are 0MATERIAL_ATTR, 0MAT_SALES_ATTR,0MAT_PLANT_ATTR...

regards