SAP PaPM writer function: Error: " cannot insert NULL or update to NULL: FS_PER_GUID_"

[former_member744458]

Dear Experts,

we are trying to use the PaPM Writer function to write results to a custom database table in S/4.

This table has the field FS_PER_GUID_ as the table key (along with MANDT (Client)).

When activating the writer function in PaPM we get the error message " cannot insert NULL or update to NULL: FS_PER_GUID_"

Why is PaPM trying to insert NULL? Shouldn't this field always be populated?

Some additional information on our Setup:
Model writer Type: Delete and Insert
Processing Type: Executable

The output function of the writer function is a model table with source Data Dictionary and the table name of the custom table.

We are using PaPM with SP 12.

Thank you for your help.

[former_member744458]

We just saw that the output model table has an exclude flag on the field FS_PER_GUID_.

I tried removing this flag but whenever I activate the model table PaPM automatically checks it again. Is it possible that PaPM doesn't allow the use of FS_PER_GUID_ in this way?

[former_member738675 · Accepted solution]

Hi Michael,

Good day!

This error is happening as you need to populate the FS_PER_GUID_. In the Writer function under the Output tab, we've tried adding the formula: NEWUID() to FS_PER_GUID_ to ensure that this field is populated. From here, you'll be able to proceed in activating and running the function.

Thanks and best regards,

Neil

[former_member744458 · Accepted solution]

Hi Neil,

we thought it was possible to transfer the value in FS_PER_GUID_ of the input function.

Populating the field with NEWUID() solved the Problem.

Thanks a lot!

Michael