Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Records Missing when loading from datasource into DSO

Hi

We're loading data from PSA INTO DSO but we're missing nearly 50% records during transformation. Issue is not with key fields as I've tried to add all the fields in the key field but it's same records. By looking into DTP monitor I've founds records are missing from transformation. (picture attached.

Please analyse the code and recommend where you think my records might be missing.

Buffer text tables for reverse look ups

* Job Type

    select txtsh /bic/zjobtype

      from /BIC/TZJOBTYPE

      into table int_zjobtype

     where /bic/zjobtype ne space

       and txtsh ne space.

* Convert all the text values to upper case

    loop at int_zjobtype into w_zjobtype.

      translate w_zjobtype-txtsh to upper case.

      modify int_zjobtype from w_zjobtype.

    endloop.

    sort int_zjobtype.

    move int_zjobtype[] to int_zjobtype_h[].

*Customer

      select txtmd /bic/zpmcust

      from /BIC/TZPMCUST

      into table int_zpmcust

     where /bic/zpmcust ne space

       and txtmd ne space.

    loop at int_zpmcust into w_zpmcust.

      translate w_zpmcust-txtmd to upper case.

      modify int_zpmcust from w_zpmcust.

    endloop.

    sort int_zpmcust.

    move int_zpmcust[] to int_zpmcust_h[].

Former Member
Not what you were looking for? View more on this topic or Ask a question