on 2005 Jul 21 3:43 AM
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.
Vijayanti,
What do you mean by generating an extract structure for a table. Did you create a generic data source on a table?
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
Hi,
Can someone help me with the above problem please.
Thankyou.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Z ledgers here are for the diff countries
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.