Skip to Content
avatar image
Former Member

LO data source initialization and delta table

Dear All,

i am using PP work center data source 2lis_04_arbpl and 2lis_04_p_matnr,

I am loading data in bi using initializ delta load,

I need table in ECC where initialization(timestemp) indicator stored for this(or LO) dataslorce once we do initialization from BI for this data source.

and same for subsequent delta request that in which table of ECC last delta request indicator(time stamp) stored.

I need this because i am enhancing some filed in this data source.

Thanks

Dushyant

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 06, 2010 at 09:16 AM

    Delta queue related tables:

    TRFCQOUT: Client dependent (sender) pointer table per queue name (DataSource) and destination (recipient)u2192counter and reference to LUWs in ARFCSDATA

    – ARFCSSTATE: Link between TRFCQOUT and ARFCSDATA

    – ARFCSDATA: Compressed data for tRFC/qRFC u2192 actual data is stored in clusters

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      In this case,

      You should adopt change document header/item (tables: CDHDR, CDPOS) and change pointer (Tables: BDCP und BDCPS).

      Please approach ABAPers they know about the above concept, ask them to record the application data changes with respect to dela data(ie nothing but new/change of application data).

      Please dont confuse with change document and change pointer concept its nothing to do with delta its a generic in all sap system which act with respect to document posting.

      We once dealt the above situation.........first the delta record of datasource was loaded into bw and the next new generic datasource was created to managed and sent the enhanced field data with required delta image looping on the ztable which loaded with respect to changes on change header.

  • avatar image
    Former Member
    Jan 06, 2010 at 04:27 AM

    Dear All,

    i am using PP work center data source 2lis_04_arbpl and 2lis_04_p_matnr,

    I am loading data in bi using initializ delta load,

    I need table in ECC where initialization(timestemp) indicator stored for this(or LO) dataslorce once we do initialization from BI for this data source.

    and same for subsequent delta request that in which table of ECC last delta request indicator(time stamp) stored.

    I need this because i am enhancing some filed in this data source.

    Thanks

    Dushyant

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 08, 2010 at 04:14 AM

    HI

    we can check delta in R/3 side table for time stamp ROOPRMSC ...

    thanks..

    vijender

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi All,

      Have anybody analyzed the exacat table which stored the latest delta request time/timestamp of datasource once delta rquest has been requested from BW?

      Thanks.