SAP Knowledge Base Article - Preview

3233262 - Order of records not as expected when loading from HCPR with AMDP script within the Transformation.


When data is loaded with HANA runtime from a HCPR, then the resulting dataset does not have the expected order. This happens when:

  • The runtime of the DTP+TRFN is HANA and
  • The Transformation has a Start routine and also at least one field routine (AMDP) and
  • The source of the DTP is a HCPR
  • No DTIS is used


  • The TRFN has at least one Field Routine (AMDP) and
  • The fields RECORD and SQL__PROCEDURE__SOURCE__RECORD are not filled



  • SAP BW/4HANA 1.00
  • SAP BW/4HANA 2.00
  • SAP BW/4HANA 2021
  • SAP BW/4HANA 2023


SAP BW/4HANA all versions


start script, field script, casting, lpad,  , KBA , BW4-DM-TRFN , SAP HANA execution in Transformation and DTP , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.