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

[saravanan_a]

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.

[former_member192683]

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.

[saravanan_a]

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.

[Former Member]

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 .

[saravanan_a]

Thanks Amer,

I have seen below comment in some threads

"Check in the following IMG in SRM System...

Cross Applicaiton componets->SAP Product-> Basic settings->Define output format and storgae format of product IDs ."

When I checked my SRM 7.1 system. I got below screen.

What should I change here to resolve my issue.. Also I am not sure whether change will help me to fix or not.

I am not interested to write routine to delete leading zeros. Because leading zeros are loading fine into cube for 1000's of records but showing error  only for some among them.

Thanks.

[Former Member]

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.

[RamanKorrapati]

Hi saravana,

pls below  link have note, pls go thru it.

http://uabw_extrc_codeinclud_template.benxbrain.com/de(bD1lbiZjPTAwMQ==)/index.do?onInputProcessing=...

http://uab_ce_rep_lcl_gd.benxbrain.com/de(bD1lbiZjPTAwMQ==)/index.do?onInputProcessing=brai_thread&0...

http://www.stechno.net/sap-notes.html?view=sapnote&id=555566

Thanks

[saravanan_a]

Thanks Raman, but I am not clear with content what exactly need to be done. SDN links would have been much helpful.

All,

Any other updates on this, real time solutions.please suggest.

~Thanks.