Skip to Content

Product ID longer than customizing setting (SRM to BI 7.3)

Hi Experts,

When loading data from SRM to BI, am getting error "Product ID longer than customizing setting".

Data source : 0BBP_TD_CONTR_2

in RSA3 am getting PRODUCT_ID as 1234567890

But at BI side, in PSA itself am getting the value as 0000000000000000000000000000001234567890.

Say 1000 of such records are there, while loading to cube only around 20 records are accumulating in error stack with the above said error.

Please clarify below points

1.) Why out of 1000 records only 20 records showing such error?

2.) Why such leading zeros are added at BI side?

3.) How shall I resolve this error?

4.) Is the Sap note : 685646 applicable for my scenario?

Thanks,

Saravanan.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Feb 13, 2013 at 01:00 PM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 05, 2013 at 03:23 PM

    go to your PSA on those 20 records and double click on the record to open one in full displaymode this way you can see there may be underlying data in front of 00000000 .. or you could write a quick routine in the transformation

    shift <field> left deleting leading '0'.

    U write ur code like this

    data a(9) value '000012345'.

    SHIFT a LEFT DELETING LEADING '0'.

    write:/ a.

    Output will be : 12345

    Or use this method also

    data a(9) value '000012345'.

    Call function 'CONVERSION_EXIT_ALPHA_OUTPUT'

    Exporting

    input = a

    Importing

    output = a.

    write a.

    output:

    12345.

    either way will work .

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Saravanan A

      it seems the leading zero is already unckeched there, i have a feeling you will need to look at the data to make sure it is correct i have a feeling there are underlying object in the row, go to psa and look at the erroneous record and open 1 with a good record and match it to see whats off.

  • Posted on Jun 11, 2013 at 11:15 AM

    Hi Amer,

    No difference between records.

    I have a doubt, Prod ID Length at table COMC_PR_FORMAT at SRM is it by default 18 ? Can we change to any other value or it must be of length 18 ?

    Because,

    • Product_ID field at BI end is of length Char (40). Conversion routine : PRIDB.

    • Back end table at SRM "COMM_PRODUCT" have PRODUCT_ID of length 40.

    Now I doubt whether I can alter table COMC_PR_FORMAT length to 40 from 18 or I should not change this.

    Please suggest.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 28, 2016 at 06:29 PM

    I had exactly the same issue. Solved by using PRIDB_INPUT conversion routine.

    You can use the following code in your transformation in abap routine.

    IF strlen( product_id ) < 40.

    CALL FUNCTION 'CONVERSION_EXIT_PRIDB_INPUT'

    EXPORTING

    input = product_id

    IMPORTING

    output = product_id_result.

    EXCEPTIONS

    lenght_error = 1

    OTHERS = 2.

    ENDIF.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.