Generic extraction using function module...

[Former Member]

HI Gurus,

Iam using BI 7.0 version in BW and ECC 5.0 as R/3 source..

I created a Generic data source and extracting data through function module....

I had done the full load and i need to run the Delta load....

Can any one guide me what type of delta should i use...

I have 2 delta types here

1) Time stamp

or

2) Calday

I dont have any Cal day in my cube...i have fiscper in ther cube...

What should i use the delta specific field name either for Time stamp or for Cal day

I have all these filds ..Please guide me..

BUKRS Company Code

ANLN1 Main Asset Number

ANLN2 Asset Subnumber

BDATU Date validity ends

KOSTL Cost Center

WERKS Plant

GSBER Business Area

STORT Asset location

KOSTLV Cost center responsible for asset

AKTIV Asset capitalization date

MEINS Base Unit of Measure

MENGE Quantity

TXT50 Asset description

DEAKT Deactivation date

GJAHR Fiscal Year

AFABE Real depreciation area

ZUJHR Asset acquisition year (currently not used)

ZUCOD Sub-classification of asset acquisitions(currently not used)

KANSW Cumulative acquisition and production costs

KNAFA Accumulated ordinary depreciation

NAFAG Ordinary depreciation posted in the current year

ANSWL Transactions for the year affecting asset values

NAFAV Proportional accumulated ordinary depreciation

AFASL Depreciation key

NDJAR Planned useful life in years

NAPRZ Ordinary depreciation percentage rate

AFAPL Chart of depreciaton for asset valuation

PHASE Depreciation phase

METSTU Multilevel Method

AFPROZ Depreciation percentage rate

WAERS Currency Key

Full points will be rewarded for appropiate solution...

Please guide me..

Thanks,

Vishwanath.

[m_verbaan2]

Hi Vishwanath,

The fields that you mention (Timestamp/Calday) should reside in R/3, not in the cube.

From the fields you mention none can be used for these 2.

You need to use another delta-mechanism.

Possibly you can use change docs (tables CDHDR/CDPOS). Check when your Asset-related data is changed this creates entries in mentioned tables. If so you can write additional ABAP-code in your FM to delta-enable the extractor.

Another option is using ALE-delta. I have no time to give you all the details, how-to's etc but you can search SDN.

Grtx,

Marco