cancel
Showing results for 
Search instead for 
Did you mean: 

Extract structure

Former Member
0 Kudos

Hi,

I generated a extract structure for a table and it created many ledgers, L0 local direct posting ledger

LR local rollup ledger

Z1, Z2, ZA,ZB,ZD,ZE,ZF,ZI,ZN,ZS,ZT and ZU ledegers.

now i need to assign totals record- datasource for which ledger should i assign?

Help,

Thankyou.

View Entire Topic
Former Member
0 Kudos

Vijayanti,

What do you mean by generating an extract structure for a table. Did you create a generic data source on a table?

Thanks.

Former Member
0 Kudos

Well this is what i did i went into SBIW , settings for application specific data sources-> financial accounting-> special purpose ledger

Generate transfer(=extract structure) for summary table

in here i gave the name of the table and executed it.

and then

SBIW , settings for application specific data sources-> financial accounting-> special purpose ledger

and go in to create infosource(=datasource) for ledger

in here i see many ledgers corresponding to the same table.

and previously when i checked in there were only 2 but now there are a list and the description tells me diff country names.

which ledger should i pick now to assign a totals record datasource??? and also should i have to assign Line items datasource too??

Thankyou

Ashwin
Active Contributor
0 Kudos

Hi!

yopu assign only the summary table to your infosource. what i dont understand is why you have so many extract structures. to be clear the name of the extract structure for summary table ends with "B" so you can identify your extract structure easily.

with regards

ashwin

Ashwin
Active Contributor
0 Kudos

Hi!

i think so far... there is no problem in your steps.. but i think you might have created extract structures to the line items as well because this option is by default selected.

with regards

ashwin

Former Member
0 Kudos

Hey ashwin,

yes i did check that option too.

but why is that none of the extract structure end with B?

and to which should i assign a datasource?

Ashwin
Active Contributor
0 Kudos

Hi!

I think the names that are shown here are not the name of the extract structure but the name of a ledger. in your case you have a seperate ledgere for each country. hence you have to create a seperate datasource for each ledger. <i>Within a client, a DataSource can only be assigned to one ledger</i>.

if you want to store all theledger data in a single datatarget with in BW system. then create a info source and assign all these data sources to the same infosource. but you have to maintain the TRules seperatly.

each data source will provide summary information from a ledger.

hope it solves your problem.

with regards

ashwin