11/20/2023 0 Comments Sap b1 transtype list![]() Of course this feature is only to query data and not to update or post new data as you know SAP Business One database cannot be modified via SQL queries and only via the provided APIs (be it DI-API or Service Layer). SAP table definition for column alias TRANSTYPE - schema Business One 8.8. Full details are available in the document Working with SAP Business One Service Layer “4 SQL Query” chapter.Ĭheck also this great video to see it in action! Let me explain with some samples how you can easily use this feature. This is a great feature that I’m happy to share as I’m sure you will appreciate!!! List of object types SAP Business One ORDR, Sales Order, DocEntry OPCH, A/P Invoice, DocEntry ORPC, A/P Credit Memo, DocEntry OPDN, Goods. And there is no any special table with TransType values and descriptions. As of SAP Business One 10.0 FP 2011 you can directly create SQL queries via Service Layer and run them directly without previously requiring the creation of a view. TransType value is stored in ObjectType column of according table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |