on 06-20-2013 6:33 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.