Skip to Content
author's profile photo Former Member
Former Member

Generic extraction using function module...

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jan 09, 2007 at 12:00 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.