Table and Report for generating the list of Profit Centers

[Former Member]

Dear Forum,

Could you please advise which tabe to use to get the list of Profit Centers under a particular Company Code. Also would appreciate if someone could guide as to how to find out the table and the field name for particular information, such as Profit Centers or Cost Centers.

[Former Member · Accepted solution]

HI,

profit center master data: tab. CEPC. assignment to comp. code: tab. CEPC_BUKRS.

Can you be more specific with your second question?

best regards, Christian

[Former Member · Accepted solution]

Hi Christian,

Thanks for the help. My second question was how could we know which table to use for generating a particular list. Is there a way to find out the table name and field let's say for Cost Centers.

Also when I use the table CEPC, I can see the Profit Centers but the table does not display the Company Codes, even though I choose the field for Company Code. Am I doing something wrong?

Thanks once again for the help.

Regards

[Former Member · Accepted solution]

HI,

the easiest case for finding table/field names is this one (example for account number): you are viewing T-code FAGLL03 (a particular account number). Place the cursor on that field (account number), press F1 and technical information (F9). A sub screen appears, where the table name is listed (hopefully), below the "table name" is a "table category" and then the field name. If the table category is "transparent table" you are fine, in our case table is SKA1 field SAKNR.

In the cost center case the appearing "table" CSKSZ is a structure not a table. But when viewing the structure (eg SE11 or just doubleclick the "table name") you find in the structure an include called CSKS and thats the table where cost center master data is stored.

There are numerous otherw ays to find table names / fields, but thats one o fthe most common.

Regarding profit-center / company code: the table is not CEPC but "CEPC_BUKRS". You can find that by using T-code SE16, key in "CEPC*" and press F4, which lists all tables starting with CEPC.

Best regards, Christian

[Former Member · Accepted solution]

Hi Christian,

Thanks for the great help. However, regarding the cases where we find the 'Structure Name' rather than table, how do we deduce the 'Table Name' from the Structure ? I tried following your advice, but could not get the same. I don't think it is a general rule to infer the first four characters as table name, like in case of Cost Centers, where we say the table name is CSKS in the structure CSKSZ. Am I correct?

Regards,

[Former Member · Accepted solution]

HI,

yes you are right, just skipping the "Z" from CSKSZ is not the general way. What you can do is: In SE11 when you are viewing the structure, the short description in theis structure (Cost center: CSKS + CSKSD + CSKT) helps you (as there are tables listed). Apart from that, double-click the component type from the component "KOSTL" and tick the "where-used-list" button. CHoose table fields, execute.

This data element is used in a number of tables (around 500) so its up to you to find the right one (use the search help, key in "master" and view the selected entries texts, the one for CSKS is named "cost center master data").

Another thing: just use an internet search engine, key in (for example) "profit center" "company code" "combination", view the results...

So there is not a single way to get what you are looking for...

Best regards, Christian

[Former Member · Accepted solution]

Hi Christian,

Thanks a lot, it was really a very great help.

Best Regards,