Data load through ABAP Praogram

[Former Member]

Hi,

I have an issue with a data source that I need ti load data through ABAP Programming.

Can anyone suggest me step by step analysis for extraction of data through ABAP Programming.

[former_member214274]

Hi Satish,

I think I couldnt get your issue here, if the selection records you are not able to see, then how you are getting 20k records in BI?

Can you please explain what is your issue/requirement?

Thanks,

Akanksha

[Former Member]

I think my question is not clear.

I have a table 'DD02T' for which:

In Ecc it has 70000 records while in BI it is fetching only 20000 records.

below is the code:

can anyone suggest me how can i get the total records in BI.

[former_member214274]

Hi Satish,

Can you paste your code as text as I am not able to see the image.

Thanks,

Akanksha

[Former Member]

CLEAR : dbtab.

SELECT SINGLE tabname FROM dd02t INTO dbtab

        WHERE ddtext = 'UCMI_S_ITEM_PROP2 fuer Item'.

TRY.

     CREATE DATA dref TYPE STANDARD TABLE of (dbtab)

                                     WITH NON-UNIQUE DEFAULT KEY.

ASSIGN dref->* TO <w>.

SELECT * FRON (dbtab) INTO TABLE <w>.

LOOP AT <w> ASSIGNING <wa>.

DO.

[former_member214274]

Hi Satish,

DD02T is a standard R3 Table.

In your code there is a filter applied on dd02t-

" WHERE ddtext = 'UCMI_S_ITEM_PROP2 fuer Item'.

remove this line to get all the records to BW.

Thanks,

Akanksha

[Former Member]

But this text is a lookup from other table "/1FB/MD___8200DL".

this table is present in ECC and has 12000 records but I couldn't find this table and text in BI

[RamanKorrapati]

Hi,

If you have the same table at bw side why we do extraction of same table data.

So BW won't holds that table.

That's why we designed data flow and loading data to bw.

Thanks

[former_member214274]

Hi Satish,

Then it is working fine I guess.

Why you need all the 70K records from DD02T?

Also I couldn't get your statement "couldn't find this table and text in BI"

Regards,

Akanksha

[Former Member]

So how can I get the table "/1FB/MD___8200DL" and correspnding text

'UCMI_S_ITEM_PROP2 fuer Item'  to BI side raman?

[RamanKorrapati]

Assuming as your data source will be based on function module.

then you need to implement a logic to pull text data as well.

Take abap expert help and pull text as well.

on same time data source need to have a text field which can hold text values.

Another way:

You can maintain master data source/text based on your ecc table.

Thru text data source(custom) you load txt data into bw obejcts.

[ravi_chandra3]

Hi

Do u want to load the data from DS to further BW Objects or from table to GDS.

If this is not your requirement then please explain your requirement clearly.

Regards,

RaviChandra.

[ccc_ccc]

Hi Satish,

Could you please explain more about requirement like which table you want extract data so that contributors may know better idea/solution for this.

And also I guess do not have standard template like how to extract data by using ABAP program, it may change as per requirement.

So please let me know your requirement.

Thank you,

Nanda

[Former Member]

Hi Satish,

You have to create a generic data source in RSO2.

If you more specific in using ABAP program, then create a generic data source using function module.

Thanks,

Shakthi Raj Natarajan.

[Former Member]

Also try the below search,

Search in SDN "Functional Module Based Generic Datasource"

Search in SDN "How to Create Generic DataSources Which Use the Delta Queue (NW2004)"

Thanks,

Shakthi Raj Natarajan