cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Trying to find a field from B1 Journal Entry in a table of HANA

Felipe_Caru
Explorer
0 Kudos
158

Hello everyone. I am writing this to ask for some help finding a field in HANA that I can see in B1 when creating a journal entry.

image.png

 

I have activated "see system information" option, and when I try to see what that "Origen" field says, it says:
Origen -> [Form=392 Item=20 Pane=0]
Origen (box where you have data) -> [Form=392 Item=24 Pane=0 Variable=66]

I've tried to search for it in either OJDT or JDT1 but haven't found it. Anyone can tell me in which table can I find that data?

Accepted Solutions (1)

Accepted Solutions (1)

ManishPant
Participant

Hi @Felipe_Caru ,

It's the [TransType] column in OJDT, these are the object type of base table.

In UI, it usually shows as Text or Short Text.

Like SI is Goods Receipt or Receipt From Production document (OIGN).

ManishPant_1-1747108519535.png

ManishPant_0-1747108512328.png

Object Types you can find the below link:

https://community.sap.com/t5/enterprise-resource-planning-blog-posts-by-members/list-of-object-types... 

 

Thanks.

Manish

 

Felipe_Caru
Explorer
0 Kudos
Hello! Thanks so much for your answer. Do you know if there's a page, or dictionary or somewhere (either in HANA or here in the web) where I can find the meaning of each TransType?

Answers (1)

Answers (1)

ManishPant
Participant

Hi @Felipe_Caru ,

📘Financial Transactions

  • OB – Opening Balance

  • BC – Closing Balance

  • JE – Journal Entry

  • CN – A/R Credit Memo

  • PC – A/P Credit Memo

  • RC – Incoming Payment

  • DP – Deposit

  • DD – Postdated Credit Voucher Deposit

  • PS – Outgoing Payments

  • CP – Checks for Payment

  • BT – Bill of Exchange – Deposit to Paid

  • JR – Journal Reconciliation

  • CI – Correction Invoice

🧾 Sales Transactions (A/R - Accounts Receivable)

  • IN – A/R Invoice
    (Also used with variations like A/R Invoice + Payment, Reserve Invoice, Debit Memo, Exempt, Export, etc.)

  • DT – A/R Down Payment Invoice

  • CN – A/R Credit Memo

  • DN – Delivery

  • RE – Return

📥Purchasing Transactions (A/P - Accounts Payable)

  • PU – A/P Invoice
    (Also used with Reserve Invoice, Internal Invoice, Debit Memo)

  • DT – A/P Down Payment Invoice

  • PD – Goods Receipt PO

  • PR – Goods Return

📦Inventory Transactions

  • SO – Goods Issue / Issue for Production

  • SI – Goods Receipt / Receipt from Production

  • IM – Inventory Transfer

  • ST – Inventory Posting

  • MR – Inventory Revaluation

  • IF – Landed Costs

⚙️Production Transactions

  • PW – Production Order

  • SO / SI – Used again for Issue/Receipt for Production

 

Manish

Felipe_Caru
Explorer
0 Kudos
Thanks @ManishPant - is there any way to know which is which? For example, in the data of SAP I have, I have a TransType of 18, and searching a TransId of those in B1, it says it is "TT" in text; so, is there a way to see the meaning of all the TransType code and the text it shows itself as in B1?