Importing tables for t-code CKM3N

[Former Member]

Hi,

I need to prepare a cost component breakdown for material ledged on same lines as CKM3N.

I understand the CKM3N pulls data from following tables-

CKMLKEPH - Material Ledger: Cost Component Split (Elements) CO - Actual Costing/Material Ledger

MLCD - Material Ledger: Summarization Record (from Documents) CO - Actual Costing/Material Ledger

MLKEPH - ML Document: Cost Component Split (Elements) for Values CO - Actual Costing/Material Ledger

CKMLLACR - ML Activity Type: Period Record/Currency Record CO - Actual Costing/Material Ledger

CKMLMV004 - Process model: Withdrawals CO - Actual Costing/Material Ledger

MLMST - Material Ledger Document: Costing Run Header Data CO - Actual Costing/Material Ledger

MLPRKEPH - ML Document: Cost Component Split (Components)for Prices CO - Actual Costing/Material Ledger

MLPRKEKO - ML Document: Cost Component Split (Header)for Prices CO - Actual Costing/Material Ledger

I just wanted to understand the underlying joins between the table. A person close to me suggested that CKMLKEPH table is sufficient however, I noticed it does not contain the material as well as plant fields.Please help

Enclosing screenshot for your perusal.

Sincerely

Ankur Garg

[Former Member]

Hi,

I need to prepare a cost component breakdown for material ledged on same lines as CKM3N.

I understand the CKM3N pulls data from following tables-

CKMLKEPH - Material Ledger: Cost Component Split (Elements) CO - Actual Costing/Material Ledger

MLCD - Material Ledger: Summarization Record (from Documents) CO - Actual Costing/Material Ledger

MLKEPH - ML Document: Cost Component Split (Elements) for Values CO - Actual Costing/Material Ledger

CKMLLACR - ML Activity Type: Period Record/Currency Record CO - Actual Costing/Material Ledger

CKMLMV004 - Process model: Withdrawals CO - Actual Costing/Material Ledger

MLMST - Material Ledger Document: Costing Run Header Data CO - Actual Costing/Material Ledger

MLPRKEPH - ML Document: Cost Component Split (Components)for Prices CO - Actual Costing/Material Ledger

MLPRKEKO - ML Document: Cost Component Split (Header)for Prices CO - Actual Costing/Material Ledger

I just wanted to understand the underlying joins between the table. A person close to me suggested that CKMLKEPH table is sufficient however, I noticed it does not contain the material as well as plant fields.Please help

Enclosing screenshot for your perusal.

Sincerely

Ankur Garg

[Former Member]

These are table names(First screenshot didnt get to fit properly)

CKMLKEPH - MLCD MLKEPH -CKMLLACR - rCKMLMV004 - MLMST -  rMLPRKEPH - MLPRKEKO

[lucas_oliveira]

Hi Ankur,

Nothing particularly related to HANA here so I'm moving this to space.

BRs,

Lucas de Oliveira

[Former Member]

thanks Lucas. Hi any updates on this..i would really appreciate your feedback

Thanks

Ankur

[Former Member]

Lucas could u move this to ERP Financials-Controlling section please ? I dont know how to do it would be grateful

[Former Member]

If I understand your requirement, you want to replicate the logic / table joins of a given program?  You may have to use a few experimentation tools:

One such tool I would suggest would be transaction SQVI to experiment with the tables and create joins and test the results without first writing an ABAP program.

Another possibility would be to use a SQL trace (ST05) and examine the joins of the trace after you've run the CKM3n.  Finally, transaction SAT might be useful to run the transaction CKM3n and examine the logic and call traces, etc.