I am wondering how is created the Remarks field in Journal Entry form? It contains a string which describes the journal entry origin and sometimes it contains the Business Partner Code. I would like to know the origin table, field of the string (only the string without BP Code).
I would like to write a query which contains all available TransType, and one string remark field for every TransType field.
I wrote the following, but it is not good because the string contains Business Partners Code, more than one line for each TransType field, and doesn't contain every existing TransType type.
SELECT DISTINCT convert(integer,TransType) As TransType, LineMemo from JDT1 ORDER BY TransType