CRUD is an acronym for Create, Read, Update and Delete operations are four basic functions in databases. In OData, it follows the same definition. Let’s elaborate:
- Create: Any operation that sends data/instruction from UI Front End to SAP Backend to create an entry is a Create Operation.
- Read: Any operation that upon instruction from UI Front End, SAP Backend fetches data and sends to UI Front End is a Read Operation.
- Update: Any operation that sends data/instruction from UI Front End to SAP Backend to update/edit an existing entry is an Update Operation.
- Delete: Any operation that sends data/instruction from UI Front End to SAP Backend to delete/remove/deactivate an entry is a Delete Operation.
Example: An UI Interface intends to create a Sales Order based on input data and update a ZTable with Sales Order number till delivery happens. When User fills in data and asks backend to create Sales Order, it’s a Create Operation. Then User wants to read all Sales Order ready for delivery in ZTable. Backend fetches the information and sends back. This operation is a Read Operation. User realizes that a text instruction for a Sales Order would be helpful for Delivery Person. The text is sent to backend and Sales Order is modified by Update Operation. Lastly, upon successful delivery, the user wants the record to be deleted from the ZTable. UI sends the instruction with the Sales Order number and the record is removed.