Skip to Content

Hi All,

Recently i started to work BPC consolidation project. As per my client business needs, need a data source(based on ledger) to pull data from ecc to BW and BW to BPC.

This is data flow:

Ecc system Data source —-> BW(standard info cube)—–> BPC(consolidation model/environment)

We need to generate ledger based data source with help FI team.

First read this below sap help link, its easy to understand steps which i followed.

http://help.sap.com/saphelp_erp2004/helpdata/en/f3/3a69377f2b8032e10000009b38f8cf/content.htm

Or

Generated DataSource for Special Ledger – Spezielle Ledger – SAP Library

How to find the base tables for your requirement.

There is table T800A whihc stores all table types(TT and SI).

/wp-content/uploads/2013/07/1_246464.jpg

From above table you will get TT or SI respective table names. We planned to use total tables with ledger. so i went above table and filtered thru TT.

We need to go with GLT1 which is TT type.

But in  my case my source table was pooled table(GLT1) and sap won’t support if i disturb pooled tables.

/wp-content/uploads/2013/07/1_246464.jpg

So with help FI/ABAP team, we copied in transparent table. so my table name – ZZGLT1T (Summary table, its filled by Custom insert program)

/wp-content/uploads/2013/07/1_246464.jpg

By using table we are going to generate a extract structure. We can go with SBIW(ECC side) path, like below

SBIW–> Settings for application specific data sources(PI)–> finance accounting SPL—> Generate transfer str for totals table

/wp-content/uploads/2013/07/1_246464.jpg

or you can use Tx – BW01, you will get below screen. Enter the table name, as per needs choose totals reocrds or line items. but my case is totals reocrds

/wp-content/uploads/2013/07/1_246464.jpg

Execute it,

You will get pop –up: crate object direct entry. Give the package and save. Create new transport request and save, continue.

/wp-content/uploads/2013/07/1_246464.jpg

. After the success you will get pop message on status bar(Below)

/wp-content/uploads/2013/07/1_246464.jpg

So as per the naming conversion my extract structure name was ZZGLT1B.

Next step we need to Assign ledger to data source.

use Tx –  BW03. first you will see like below screen shot, data source(total record – data source) column was blank.

/wp-content/uploads/2013/07/1_246464.jpg

How to assign data source to ledger:

Select data source cell(column wise) respective ledger row(Z8). like below screen(union of red &green color)

/wp-content/uploads/2013/07/1_246464.jpg

click on that cell which indicated data source column(cell) respect to Z8, click on choose(F2, icon magnifying glass from tool bar).

you will get pop box with proposed data source name, enter descriptions, like below:

/wp-content/uploads/2013/07/1_246464.jpg

(Active delta process was un-selected so its indicates not active to my data source at last image.)

Continue with saving object and capture in Transport request. You will get directly data source maintenance  screen as below. do the required selections nd save it.

/wp-content/uploads/2013/07/1_246464.jpg

Once you saved the data source, you data source name will appear opposite respective ledger , as show below  screen.

/wp-content/uploads/2013/07/1_246464.jpg

Now my data source was generated based on ledger. you can check data validation at RSA3. once the data source was ready then replicate into bw side and activate.remaining steps are same.

i will keep updating if any comes…

Thanks for reading….

To report this post you need to login first.

28 Comments

You must be Logged on to comment or reply to a post.

    1. CH Raman Post author

      Hi Kamal,

      Its bit FI functional related. Am not much aware of FI functions

      I try to give what i had:

      ZZGLT1T was custom table created around 8 years back and filling thru insert program and they may be used in abap reports. For BPC consolidation purpose we need to build data source based on a specific ledger(Z8).

      Actually while creating ledgers(GCL1) we need to maintain total tables info also. in that way my ledger Z8 was under TT type.

      Thanks

      (0) 
  1. Venu Gopal Boddapati

    Thanks Raman, Your docuemnt helps me learn a new topic today.

    Raman.. I think when we need to extract data related to Special Ledgers into BW this is only the way we have right ? Am I correct ?

    AND

    Same process can we use for any other FI related data extractions? Please revert.

    Thanks,

    Venu

    (0) 
    1. CH Raman Post author

      I think when we need to extract data related to Special Ledgers into BW this is only the way we have right ? Am I correct ? Yes.

      Same process can we use for any other FI related data extractions? Please revert. No.We have lot of FI Standard extrcators depend on that we need to use.

      Thanks

      Raman

      (0) 
  2. Praveen S

    Hi Raman,

    I really liked this page and it helped me a lot in getting more insight into special ledger.

    Just need couple of clarifications

    1. You said you “We need to go with GLT1 which is TT type.”

    Please let me know how to find all the tables related to TT type.

    2. After entering T-code: BW03, i see data source(total record – data source) column was blank. And all the rows have the table which was created ZZGLTIT. Can you please explain what does that list means..?


    Thanks in advance.

    (0) 
    1. CH Raman Post author

      Hi Sriram,

      If you read my doc properly then your first doubt was answered.

      1. Use table T800A, keep filter on tabletype – TT and execute it.

      You will get the table list which are TT type.

      2. about blank no idea. All ledgers might be part or related to mentioned table.

      please check at your system and seek FI team help. its FI related functionality.

      Thanks

      (0) 

Leave a Reply