SAP Business One Transtype table or file

[former_member268870]

Dear Experts,

I have a request to write a Query from the OJDT table and also reference the 'Origin' field (OJDT.TransType). This brings back the TransType code, which I need to translate back to the name displayed on the screen... JE, IN etc...

I have found a thread with a provided list (https://blogs.sap.com/2017/04/27/list-of-object-types/), but it does not have TransType DR or AC (Fixed Asset entries). Now I am concerned that this list is not a full list....

My question is: Is the transtype not stored in a table that I can link to OJDT.TransType? If not, where can I get a FULL list of TransTypes?

I appreciate your input,

Marli

[former_member268870]

I added the wrong link: Here is the correct one: https://archive.sap.com/discussions/thread/1832259

[zal_parchem2]

Hello Marli. This piece of code is from an SQL created fairly close to what you are describing.

The most important point in the CASE is the ELSE section.

CASE 
WHEN T0.TransType = 13 THEN 'A/R Invoices'
WHEN T0.TransType = 14 THEN 'A/R Credit Memos'
WHEN T0.TransType = 15 THEN 'Deliveries'
WHEN T0.TransType = 16 THEN 'Returns'
WHEN T0.TransType = 18 THEN 'A/P Invoices'
WHEN T0.TransType = 19 THEN 'A/P Credit Memos'
WHEN T0.TransType = 20 THEN 'Goods Receipt PO'
WHEN T0.TransType = 21 THEN 'A/P Returns'
WHEN T0.TransType = 59 THEN 'Goods Receipt'
WHEN T0.TransType = 60 THEN 'Goods Issue'
WHEN T0.TransType = 67 THEN 'Inventory Transfers'
WHEN T0.TransType = 69 THEN 'Landed Costs'
WHEN T0.TransType = 162 THEN 'Inventory Revaluations'
WHEN T0.TransType = 202 THEN 'Production Order'
WHEN T0.TransType = 10000071 THEN 'Inventory Posting'
ELSE 'Research' 
END AS 'Details', 

The whole point of this is to find a TransType which I have not covered in the rest of the SQL - I just filter the results and looking specifically for the word "Research" and add whatever TransType I have missed in the WHENs.

Have been able to find each piece of information using that.

Maybe a small tip to get that info you need???

PS - this CASE comes from SQL covering the Reconciliaton between the Inventory Audit Report and the GL Account - that is why it is not complete. There are a TON of TransType codes out there!!!

Regards - Za;

[kothandaraman_nagarajan · Accepted solution]

Its not possible to get such list directly from tables. Transaction name was added manually with transaction types. There is no direct table to get transaction name and its type.

[azizelmir]

Hi Marli,

This could be achieved by creating a User Defined table (UDT) as per the proposed solution transtype.png

to which you can you can link to OJDT.TransType.

Thank you,

Aziz El Mir

[former_member268870]

Aziz,

Thank you, that might be what I must do. But I'n still concerned about not having a full list to enter into the UDT....

Regards,

Marli

[azizelmir]

FYI

objectid-sap-b1.txt

Regards,

Aziz

[Abdul]

You have to use case in your query to put transaction name as SAP is storing only transaction numbers for ease you can got to numbering series and hover mouse on each document you will see what number SAP is saving in database for that document.

[kothandaraman_nagarajan]

Hi,

I think its same list as getting from OJDT and OINM tables.

Regards,

Nagarajan

[former_member268870]

On that thread, someone posted the list by hand...

[kothandaraman_nagarajan]

Hi,

The above thread is list of object type that will be useful for creating transaction notification and other purpose.

Only OJDT and OINM tables have the list of transaction types.

Regards,

Nagarajan

[former_member268870]

Nagarajan,

Thanks, I copied the wrong thread, here is the one I'm referring to:

https://archive.sap.com/discussions/thread/1832259

Regards,

Marli