AR Invoice showing incorrect stock quantity

[Yoseph]

Dear SAP Team,

We have encountered an issue at our customer related to an AR Invoice.

In the AR, there is a UDF: U_KD_BRNG_PJK Row=1 Variable=11 INV1.U_KD_BRNG_PJK.
For example, in the AR Invoice the value appears as 281100, but when we run a query, the result shows 0.

Our question: why does the query return 0, while in the AR Invoice the value is clearly shown as 281100?

Additional information:

The UDF is Alphanumeric with a length of 20 characters.

This issue only occurs in one invoice.

Thank you for your assistance. 

[Lakshmipathi]

The reasons could be

since INV1.U_KD_BRNG_PJK is defined as Alphanumeric (length 20), it is stored as a string, not a number. If your query is trying to treat it as a number (e.g., using SUM, CAST, or numeric comparison), it may default to 0 if the string isn't parsed correctly.

The value 281100 may look clean in the UI but contain leading/trailing spaces, non-printable characters (e.g., carriage return, tab), invisible formatting from copy-paste or integration. These can cause SQL functions to misinterpret the value.

If your query includes a WHERE clause or joins that filter out the invoice, it may return 0 because the row is excluded. Double-check that the invoice number is included in the query result set.

Since this issue occurs only in one invoice, compare it with others where the query works. Look for differences in how the UDF was populated — manually vs. via integration, copy-paste, etc.