length of data field value and inventory ID

[houssem_temimi1]

hello and happy new year,

Just to be sure, can you give us the maximum of lenght for

- data field and data field value

- Inventory ID and Inventory ID value

Thank you

[alexander_teslyuk]

Hello Houssem,

And happy new year to you too!

Inventory can be 128 characters long;

Data Field is 60 characters long;

The valid data field values can be defined and stored in DATA_FIELD_LIST table, DATA_VALUE column is 1024 characters long;

In case your main concern is whether the long inventory id can be saved at discrete assembly, then you should rather check DATA_ATTR column in SFC_ASSY_DATA table. It is 1024 characters long.

Br, Alex.

[sergiy_katerinich]

Hi Houssem,

This all is about to be true if you do not use ODS scripts. Otherwise you should keep in mind that, for example, Oracle has a limitation against the length of column name equal to 30 bytes (or single-byte chars). Thus you should not exceed 30-char limit of data field's names.

Regards,

Sergiy

[alexander_teslyuk]

Indeed, the limitation mentioned by Sergiy can cause errors like

ORA-00972: identifier is too long

SAP fixed some scenarios against it: see SAP Note 1884993 - Genealogy and NC extraction from WIP to ODS not working

Br, Alex.

[houssem_temimi1]

Thank you.

we are at 6.0.4.40 version

can you confirm that the limitation doen't take place for as?

Other point: I try to create a data field using activity:SY160 but I have a limitation to 36 digits

Can you verfify please

Houssem

[sergiy_katerinich]

If you use ODS processing with Oracle database, you should use field names under 30-char length.

[sergiy_katerinich]

Sorry, in the context of GUI, this limitation is even stronger: you should not exceed 23-char length because the field name will be appended with "CUSTOM_" prefix. So, total length of "CUSTOM_" plus the field name should not be greater than 30.