Creating infosource for ledger

[Former Member]

/nsbiw

settings for applicationm specific data sources -

---

> Financial accounting SPL -

---

> Generate data source (transfer structure) for totals table

In here i gave the name of my table SUMMARY TABLE :ZGLT1T

and in this wondow i also see this

Generate extract structure for

Totals table and line items ( both of them are checked)

And execute it.

2 generate extract structures for table ZGLT1T was generated.

and when i go back

and go to

create infosource for ledger this is what i see.

(if you can please provide me your email id i'll mail the screen shot and may be then it will be more clear)

the data sources are created for ZA ledger for both totals and line item

i aslo see a data source for ZB ledger for only totals they were in red and i clicked on it and assigned the data source.

this was done 2 months back now my doubt is

i am trying to assign datasource for ZB--> USD Ledger---- ZGLT1T -

---

line item data source. i click on the red button and give the description and check i get a mssg

NO extract structure exists for ledger table GLS1. i remeber doing the same for ZA line item data source too now what am i doing wrong.

And my doubt is when i generated datasource it said 2 extract structure were generated.

how did the ZB for totals generate??? i dont remember and all these ZA ZB ZD ZE ZF -

---

all use the same table (ZGLT1T) why did it generate for only ZA ledger???

I wanted for only ZA and ZB.

hope i was clear

CAn anyone please help me thankyou

Message was edited by: vijayanti irrinki

[Former Member]

V,

I tried to read the whole desc two times, but what you have done and what is the issue I was not able to understand completely..

I'll try to give you some directions..

1) First check if your data src is created properly...

Go to table ROOSOURCE and check the entries for your data src. Is that wat you want ? the extract structure and extract methodology etc.

2)to make sure this data src is correct and is able to extract data-- go to rsa3 and see if it's pulling any data..

3)Once these two are confirmed..

Then comes the question of infosrc assignment to your data src..

Best Luck..

-Led

[Former Member]

Hey LED,

Let me explain more clearly

I need to extract SPL data from R/3 into BW, from table ZGLT1T. from 2 different ledgers ZA and ZB. ZA and ZB both use ZGLT1T table

the first step i did was to generate extract structure.

i gave the summary table ZGLT1T and executed i got a mssg 2 extract structures were generated sucessfully.

Now what are the 2 extract structures?? is it one for the totals and one for line item? i checkedgenerate extract structure for both TOTALS and LINE ITEM.( in generate extract structure screen)

Now my question is how do i generate extract structure for ZB ledger Line Items. I already have the extract structure for ZB ledger TOTALS.

ok under FI_SL Assign Data Source to a ledger

Ledgr. Desp. Tab. TotalRecd/DS. D. Stat. LineItem/DS. Stat

ZA USD ZGLT1T 3fi_sl_za_tt green 3fi_sl_za_si gre

ZB USD ZGLT1T 3fi_sl_zb_tt green empty red

ZD UK ZGLT1T empty red empty red

ZE IND ZGLT1T empty do do do

ZF EU ZGLT1T empty

ZI FR ZGlT1T empty

So here is how the FI_SL Assign Data source To a ledger looks in my screen i wish i could send u a screen shot for this.

now i need to generate an extract structure for ZB line item i dont remeber who i created the extract structure for ZB totals, thsi was done 2 months back.

But i try to give the summary table(ZGLT1T) in the generate extract structure screen. only 2 extrct structures are being created. i am not sure which ones i assume they are 3fi_sl_za_tt and 3fi_sl_za_si (totals and line item.

Hope i was clear hmmm.

Message was edited by: vijayanti irrinki

[Former Member]

Go to SE11

and select data type and give your extract structure name to see the description as to which extract structure corresponds to header and line item data.

If you want to create one extract structure..

at the same page SE11 give your ES name in data type and move forward...

Best Luck..

-Led

[Former Member]

Hi,

I still couldnt get this problem solved can someone please help.

Thankyou.

[Former Member]

The infosource does not automatically exist in BW as it is a customized datasource, but it will propose an infosource under the radio button "application proposal". Use that infosource.

regarding the other question, it creates all the necessary datasources for extraction from the Ledger. It is up to you to use what you need.

Rishi