topic Re: Table COST relationship in Application Development and Automation Discussions

Table COST relationship

krzysztof_stachnik — Mon, 23 Nov 2015 15:49:12 GMT

Hi Gurus,

I'm new in queries world I'm building InfoSet for finance team where everything was going smooth to this point.

It is actually very simple one, just MAPL, PLPO, CRHD and CRCO.

But now I have to add also one information from COST table (field TKG008) and I'm not able to find relation between COST and any of tables mentioned above.

Can you please suggest

Regards

Re: Table COST relationship

Former Member — Mon, 23 Nov 2015 15:55:29 GMT

You can go to the finance team and ask them to show you a report that has COST and one or more of the other tables. Then use ST05 to examine the tables that were used.

Rob

Re: Table COST relationship

RaymondGiuseppi — Tue, 24 Nov 2015 07:16:37 GMT

You could try to add table CSSL between CRCO and COST


SELECT *
  FROM crco
  JOIN cssl
    ON crco~kokrs EQ cssl~kokrs
    ON crco~kostl EQ cssl~kostl
   AND crco~lstar EQ cssl~lstar
  JOIN cost
    ON csll~objnr EQ cost~objr.

Regards,

Raymond

Re: Table COST relationship

krzysztof_stachnik — Tue, 24 Nov 2015 11:01:49 GMT

Thank you Raymond

This link is correct. I had to redefine join conditions for other tables, but it is working

Regards

Krzysztof