EDM-Datatypes for NUMC(9) and NUMC(10)

[#1]

Hello,

in our Datamodel are fields with NUMC of langth 9 and 10. I have assigned Edm.Int32 and Edm.Int16. In both cases I get an error while generating runtime artefacts. If I generate the artifacts anyway my requests to the service dumps with error message:

Im Programm "/VWK/CL_SB_PROCESS__01_DPC_EXTCP    
" ist im Include


 "/VWK/CL_SB_PROCESS__01_DPC_EXTCM003 
" in Zeile 24



der folgende Syntaxfehler aufgetreten:
Das Datenbankfeld oder der Ergebnistyp der Aggregatfunktion GUFID und
die Komponente "ID" von "ET_ENTITYSET" sind nicht kompatibel.

[sreehari_vpillai]

consider NUMC as a string. It is not an Integer type.

Couldn't you change the data type in your structure to Int, then try putting the Edm.Int16 ?

or Give char instead of NUMC (which I used to do for such cases ) - Numc always come with zeros,.

[AshwinDutt]

Hello Gerrit,

When ever we import fields having Data Type as NUMC, service builder itself automatically picks/assigns appropriate Edm Types. As far as i have seen it picks up Edm.String with appropriate Max Length.

Structure -

GW Model -

Please try to use Edm.String and check.

Regards,

Ashwin

[Former Member]

Thank you for your response. In my case there where also Edm.String assigned, but then I got the issue, that I receive prepending zeros. In some sap gw guide I read to switch NUMC to Int but it don't work in my case. I've tried to shift the zeros in DPC_EXT but that don't solve my issue.

[AshwinDutt]

Hello Gerrit,

After using Edm.String, what was the issue encountered when you tried to shift the zeros in DPC_EXT ?

Regards,

Ashwin

[Former Member]

I didn't press redefine in SE80 so I created the code not in the _EXT-Class.