Feb 26, 2011

Transport Chart of Accounts and Company Code Chart of Accounts dependent Data

If you want to transport the Chart of Accounts, there are 2 parts that you need to keep in mind in order to transport it.

First part, you transport the Chart of Account itself with Tcode OBY9. In this transaction you transport only the General part of the Chart of Account as account numbers, descriptions, type of account and other general data.

As soon as you open the transaction it will ask you to provide a transport request for your activity.

Select Transport Request
After selecting the transport, you need to specify the Chart of Accounts number / Code that you wish to transport.
Select Chart of Accounts Code / Number
Then you will access to OBY9 main screen where you can select different options.
OBY9 - Main Screen - Transport Chart of Accounts
Here select "Accounts in Chart of Accounts" and also "name in all languages", so if you have more than one language in your system it will transfer the descriptions in all the languages that you have maintained.

As part of this transaction you can also have the chance to include in your transport request other FICO account determinations such as, FI account determination, AM account determination, CO account determination, MM, HR and SD.

By doing this you only transport the General part of the Chart of Accounts but you do not include the Company Code dependent settings of your individual accounts. If you have only 1 Company code, that is not a mayor problem. But ... if you have several company codes that uses the same chart of accounts that can be a real maintenance problem to create or maintain that in each individual environment. 

As part of my experience, I've been working in an implementation where the customer had 43 Company Codes. Yes, I am not mistaken, they had 43 and all in the same country and province. So in this case we needed something quicker in order to maintain and transport the Chart of Accounts for that huge amount of Companies.

As I mentioned before, I was talking about 2 parts for this process...

The second part of this process is to Transport the Company Code dependent data. For this there is no official transaction (as far as I know) and you need to get yourself inside of the transport management to do a couple of things manually.

Assuming that you already have a transport request created, you will use Tcode: SE09 - Transport Organizer; and select the "Display" button.
SE09 - Transport Organizer
SE09 - Display Transports

You will get the list of all your transports. Then select the transport that you will use to include this activity. Ex. like this transport that I created. Do a double-click in your sub-activity / transport task.

Transport Request selection.



In your "Objects" tab where you have the details of the information that you have in that transport, modify your transport by clicking in "Pencil icon" to edit your transport. Add a line like this 
TABU Object Type and Object name SKB1
 Include R3TR (Object) as Program ID, TABU Object Type (which means "Table of Contents") and then in Object Name SKB1 which is the table that has the Company Code Dependent data for the Chart of Accounts.

Once you add the line, do a double click to indicate which are the keys of the table that you want to transport.

SKB1 Keys
As you can see in this example, "200" represents the Golden client where I am transporting from, "1000" the Company Code data that I want to transport and "*" for all records in that key.

Also in this example you can see that I included Company Codes 2000 and 3010.

You can include here as many entries or Company Codes that you want following this concatenated logic.


If your Company and/or Project needs to implement this, or any of the functionalities described in my Blog, or advise about them, do not hesitate to reach out to me and I will be happy to provide you my services.

2 comments:

  1. It works good !!
    Thanks for the solution

    ReplyDelete
  2. The client number made the difference. Thank you

    ReplyDelete