Table COST relationship

[krzysztof_stachnik]

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

[krzysztof_stachnik]

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

[Former Member]

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

[RaymondGiuseppi]

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

[krzysztof_stachnik]

Thank you Raymond

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

Regards

Krzysztof