cancel
Showing results for 
Search instead for 
Did you mean: 

Where are the descriptions of "Reason for Issuing Note" i.e. IssReason stored?

pressfit
Participant
0 Kudos

Hello,

Referring to the field IssReason on all Credit/Debit Memos, in which table are the descriptions of the field IssReason stored? I know the current descriptions are:

1=Sales Return, 2=Post sale discount, 3=Deficiency in service, 4=Correction in invoice, 5=Change in POS, 6=Finalization of Provisional Assessment, 7=Others

But I would like to know which table they are stored in so that I don't have to use a CASE WHEN in a query and having to modify it if new descriptions are added in a future version.

Ref. http://www.saptables.net/?schema=BusinessOne9.3&column=IssReason

Accepted Solutions (1)

Accepted Solutions (1)

zal_parchem2
Active Contributor
0 Kudos

Hello Aakash - there is no associated table with IssReason. There is no associated table (like OCRD) below where you can do a JOIN to get the descriptions:

Sorry to say it is a CASE Statement. But one thing I always do with a CASE statement is finish them with an identifier easy to find. Like this:

WHEN T0.TransType = 10000071 THEN 'Inventory Posting'

ELSE '*****RESEARCH*****"

END AS 'Details',

Maybe that helps???

Best Regards - Zal

pressfit
Participant
0 Kudos

Okay, that's what I feared. Thanks for the confirmation.

Answers (1)

Answers (1)

zal_parchem2
Active Contributor
0 Kudos

Hello Aakash - more than welcome. Thanks for marking this as being answered - I am sure others have the same question...

Regards, Zal