Skip to Content
Author's profile photo Raman Korrapati

FI-SL Generated data source 3FI_SL_XX_TT

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….

Assigned tags

      29 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K

      Your Step by Step approach is good...Thanks

      Author's profile photo Kamal Mehta
      Kamal Mehta

      Hi Raman ,

      Thanks.

      Need to know what made you go for Total Tables . Anything specific.

      Thanks

      Kamal

      Author's profile photo CH Raman
      CH Raman
      Blog 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

      Author's profile photo Kamal Mehta
      Kamal Mehta

      Thanks for the clarification.

      Author's profile photo CH Raman
      CH Raman
      Blog Post Author

      Your Welcome!!

      Author's profile photo Former Member
      Former Member

      thanks for detailed steps ... helpful stuff !!

      Author's profile photo Former Member
      Former Member

      Useful and detailed explanation. Thank you

      Author's profile photo Former Member
      Former Member

      Keep it Up RK...

      Author's profile photo Former Member
      Former Member

      Thanks for detailed explanation....

      Regards

      Satya

      Author's profile photo Former Member
      Former Member

      Hello Mr. Ramanjaneyulu Korrapati

      Gr8 explanation abt FI-SL summary database.

      Regards,

      Satendra Singh SIkarwar

      Author's profile photo Former Member
      Former Member

      Nice Document

      Regards,

      Sushant

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo CH Raman
      CH Raman
      Blog 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

      Author's profile photo Former Member
      Former Member

      Ok.. Thanks Raman.

      Regards,

      Venu

      Author's profile photo CH Raman
      CH Raman
      Blog Post Author

      Your welcome venu

      Author's profile photo Former Member
      Former Member

      Please share this kind of Information Raman, would be much helpful. Thanks.

      Regards,

      Venu

      Author's profile photo CH Raman
      CH Raman
      Blog Post Author

      Surely, i will do my best.

      Author's profile photo vinod bokade
      vinod bokade

      Great Document, thanks for sharing RK.

      Thank-You.

      Regards,

      VB

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Nice information raman about FI-SL.

      🙂

      Thanks @ Regards,

      SM

      Author's profile photo Former Member
      Former Member

      Thanks for Sharing ..useful for BI Consultant who are working on FI Part...

      Author's profile photo Former Member
      Former Member

      Thanks for your such a wonderful document on FI-SL.

      Regards,

      J.Sakthikumar

      Author's profile photo Former Member
      Former Member

      Thank you Raman. I will use this for BPC requirements. Keep Sharing 🙂

      Author's profile photo Former Member
      Former Member

      Awesome blog Ruman. Keep it up as usual

      Author's profile photo abilash n
      abilash n

      Nice one Raman. keep it up. looking for more amazing ones....

      Author's profile photo Former Member
      Former Member

      Good one.keep it up.

      Author's profile photo Roger Stein
      Roger Stein

      Link to help.sap.com (5th sentence) is broken.

      Author's profile photo Praveen S
      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.

      Author's profile photo CH Raman
      CH Raman
      Blog 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

      Author's profile photo Binit Kumar
      Binit Kumar

      Hi Raman/Everyone,

      Thanks for the step by step explanation.

      After following manual steps in Development system, do we have to perform manual step in Quality and Production or Transport process will be enough?

      Thanks,

      Binit