Shulou(Shulou.com)06/01 Report--

This article introduces the metadata design of database tables in Salesforce and SAP Netweaver. The content is very detailed. Interested friends can use it for reference. I hope it will be helpful to you.

Salesforce

When we create new application objects or write some stored procedure code in force.com, force.com does not generate physical database tables or compile stored procedure code, but takes lightweight operations to write the corresponding metadata into storage, which can generate the necessary physical models at run time through the system engine.

When we need to modify the application schema object in the development process, all the changes in Editor are simple metadata modifications, which are very lightweight.

ABAP

If an existing database table in ABAP is not activated after editing, the changes are not visible to the entire ABAP workbench. A newly created table cannot be used at all if no runtime object- runtime object is generated.

The following figure shows a new ABAP database table:

If no runtime object is generated, neither other programs nor ABAP DDIC objects can be used.

SAP HANA

Similar to salesforce and SAP ABAP DDIC, look at an example.

Use SQL SELECT TOP 1000 * FROM "SAPAG3". "COMM_PRODUCT" to query the contents of this table.

What should I do if I want to query all its metadata with SQL according to the name of the table COMM_PRODUCT?

SELECT * FROM "SYS". "TABLE_COLUMNS" WHERE SCHEMA_NAME = 'SAPAG3' AND TABLE_NAME =' COMM_PRODUCT'ORDER BY POSITION

The metadata from the query is shown in the following figure:

About Salesforce and SAP Netweaver database table metadata design is shared here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.