Skip to Content
avatar image
Former Member

record count validation - Using SLT replication

Dear all,

I am using SLT data provisioning technique to replicate data from ecc to hana. when i try to replicate VBAP from ecc to hana, replication went successful. when i try to validate the record count, ecc and hana record count are not matching.

i am using se16 in ecc against "no of entries"  in "Run time of information" tab of table definition in hana.

please advise how can i validate the record count of hana with ecc after SLT? why i am seeing this difference in record count?

Thanks,

Raghu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 21, 2013 at 02:12 PM

    Hi Raghu,

    SE16 is client dependant and HANA not always (if not client specified on logon).

    Try to select count(*) from vbap where MANDT= '<client number>'

    Regards, Fernando Da Rós

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Raghu

      One of the possibility that HANA is showing more records than ECC is, Are you uploading the data from ECC to HANA to a existing table or a newly created when you do the replication. If you are uploading to an existing table, that may contain entries and showing up more count. To avoid this, in SLT advance replication (IUUC_REPL_CONTENT) select the table and enable drop content before loading option.

      Thanks

      Prashanth