how to get all the orders for a user in his Costcenter

[former_member1059510]

Hello everybody,

I need to get all the Orders of a User in his Costcenter (KOSTL). Can you please support me with the Tables that I need to call and the Fields that I can join together to get this Information.

From my search I think I would need to use the Tables 'CSKS' and 'AUFK' but I do not know how to relate them together and get the list of Orders only for the connected User.

Please tell me if I need to clarify more.

Thank you all for your support.

Best Regrds,

Hatem.

[TammyPowlas]

Have you tried running KSB1/KSB1N for the cost center, and then look at the orders posted to it in the auxiliary account assignment field on the report? That would be more accurate (in my view) than you trying to do the joins yourself.

[former_member1059510]

Hello Tammy,

Actually I am quiet new in this developpment area and I need to display a list of Orders in a Fiori App. Could you please support me with Table names and fields for my search .

Many Thanks,

Hatem