Skip to Content

Under what condition the "0RECORDMODE" in DSO will be filled?

Hi, experts:

Really really need some help here:

1. I create a DataSource (file) and have a field (either UPDMOD or ROCANCEL, mapped to 0recordmode).

2. This Datasource has delta process set to "After images"

3. This DataSource has either Direct access allowed or Not allowed

4. Two infopackages, one for initializing  and the other for delta

5. I have 6 record in file, load with initializing infopackage

6. A standard DSO with default settings.

7. Transformation did not map 0recordmode

8. 6 record is successfully loaded into DSO and activated

9. I modified the file, but adding a new record and adding two new record and mark an existing one to be "D" (delete).

10. Delta infopackage into PSA ,successfully keep the "D" in the entry

11. DTP to DSO, in the new data table, the "D" disappears.  It does not exist in the column "RECORDMODE".

What did I do run?  Under what condition I will be ablel to view the "D" in the new data table of DSO and activated table?

Am I missing something?

Thanks in advance!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    May 11, 2012 at 07:49 AM

    Hi,

    The type of values that will be populated in the recordmode field depends on the type of delta supported by your datasource.

    In case of AIE (After Images at time of Extraction) datasource, "D" wont be available.

    Go to RSA2 and check what is the delta type of your datasource.

    Then go to table "RODELTAM" . In this table against  each delta type you can find what values of Record Mode are possible.

    Let me know if you require more info on anything mentioned above.

    Regards,

    Sid

    Add comment
    10|10000 characters needed characters exceeded

  • May 11, 2012 at 07:56 AM

    Hi,

    Values for 0RECORDMODE depends on the delta type of the Data source. As your Data source is of AIE type, it generates only After images. Go thought this document for better understanding on 0RECORDMODES. How the data will be generated for different type of Data source types has been explained with example

    http://scn.sap.com/docs/DOC-12223

    Regards
    Chandu

    Add comment
    10|10000 characters needed characters exceeded

  • May 11, 2012 at 08:34 AM

    Hi,

    For delta type AIE recordmode D is not possbile.  That means it cant handle deleted records.

    Check this document for better understanding of recordmodes.

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/5080c337-81e5-2c10-97af-8929424f3a4b?QuickLink=index&overridelayout=true&46321222724499

    Regards,

    Aravind.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 11, 2012 at 07:55 AM

    Hi,

    On a related note, if your Datasource supports "D" and you are getting it in PSA but not DSO, probably you have not mapped it in the transformation (under technical field mappings), in this case all records are treated as After Images (since blank values will be populated for this fields and reordmode = blank implies after image).

    If you map the recordmode in transformation than this record will be available in your change log table with appropriate recordmode value.

    Regards,

    Sid

    Add comment
    10|10000 characters needed characters exceeded