join table MARA and CDPOS and CDHDR

[Former Member]

Hi friends,

I am trying to create a query report displaying changed historical data in MARA, such as changed date and users who made the change.

I am trying to joint the tables to create info set, but when I join material number in MARA and object ID in CDPOS/CDHDR,system told me it's a illgegal joint.

Please advise if you have any thoughts.

Thanks in advance,

Linda

[former_member184701 · Accepted solution]

dear,

1. you have posted at wrong forum. use ABAP or MM forums.

2. what is the point to create a custom report if system provides a standard one?

    did you try the t-codes MM04 and MM14 ?

3. you can not build such report just join tables - you have to add some abap in your info-set.

    but you are not familiar with abap coding. therefore use the standard reports.   

regards,

[JasonLax]

is correct: SCN Support is the support space for SAP Community Network and not SAP products. 

To get a quick (or any) response, create your new discussion in a space related to your query.  This way it will be visible to topic experts who will then see and reply to it.  The SCN Site Index contains a full listing of all SCN spaces.