This article contains introduction about SAP ABAP OData, tcodes, tables, table fields, function modules, application components & OData PDF tutorials.
OData stands for Open Data Protocol. This http based protocol is used for building and consuming RESTful Application Programming Interfaces (APIs). An API is used for interacting between two applications. In SAP, OData is used for providing the API standard for interact SAP systems with other external applications for querying & updating the SAP data using ABAP. Comparing to other RESTful method based APIs, OData based APIs have more benefits by providing the metadata, relationship & custom queries.
SAP OData services can be used by
- Fiori apps
- SAP Cloud Platform Mobile Services
- Other custom applications
SAP OData Tcodes
Here is a list of possible transaction codes dealing with OData in SAP.
- SAIL: OData Service Registry – CLB_GW_SRV_C
- OData Annotation Mapping Transaction – CBESH_TR_OD
- Register POWL for OData consumption – /UI2/POWL
SAP OData Tables
Here is a list of possible system tables storing OData related data in SAP.
- Common oData Customizing Setting – FIORI_COMMON_CUS
Table Fields with OData data
Here is a list of possible table fields which are may be used for storing OData related data in SAP.
- ANNOTATION_LINK – Collaboration: OData Annotation Resource URL
- REQUEST_URI – Collaboration: OData Resource URL
- RELATIVE_URL – Collaboration: OData Resource URL
- SERVICE – Collaboration: OData Service
- SERVICE_NAME – Collaboration: OData Service Name
- SERVICE_ROOT – Collaboration: OData Service Root
- RESOURCE_PATH – Collaboration: OData Resource Path
- REQUEST_URI – Collaboration: OData Request URL
- ODATA_SERVICE_ID – OData Service ID
- ODATA_SERVICE_ID_UC – OData Service ID in Upper Case
- ODATA_SERVICE_NAME – OData Service Name
- ODATA_SERVICE_ENTITY – OData Service Entity
- ODATA_SERVICE_DESCR – OData Service Description
- ODATA_SERVICE_DESCR_UC – OData Service Description in Upper Case
- DO_NOT_FILTER_EMP – No Filtering of Employees in OData Search
- PARTNER – SD OData Default Sales Employee Partner Function
- REF_TYPE – Service Builder: OData Text Reference Type
- REF_OBJNAME – Service Builder: OData Text Reference Object Name
Function Modules for OData in SAP
Here is a list of possible function modules which may be used with OData related processes in SAP ABAP programs.
- /IWBEP/FM_SBOD_UPD_ANNOTATION – SB – OData – DB Update Annotations
- /IWBEP/FM_SBOD_UPD_ASSOCIATION – SB – OData – DB Update Associations
- /IWBEP/FM_SBOD_UPD_ASSOC_SET – SB – OData – DB Update Association Sets
- /IWBEP/FM_SBOD_UPD_CTYPES – SB – OData – DB Update Complex Types
- /IWBEP/FM_SBOD_UPD_ENTITYSETS – SB – OData – DB Update Entity Sets
- /IWBEP/FM_SBOD_UPD_ENTITYTYPES – SB – OData – DB Update Entity Types
- /IWBEP/FM_SBOD_UPD_EXP_COLL – SB – OData – DB Update Collection Expression
- /IWBEP/FM_SBOD_UPD_EXP_PATH – SB – OData – DB Update Path Expression
- /IWBEP/FM_SBOD_UPD_EXP_RECORD – SB – OData – DB Update Record Expression
- /IWBEP/FM_SBOD_UPD_EXP_REC_MAP – SB – OData – DB Update Record Expression Mapping
- /IWBEP/FM_SBOD_UPD_EXP_SIMPLE – SB – OData – DB Update Simple Values
- /IWBEP/FM_SBOD_UPD_FUNCIMP – SB – OData – DB Update Function Imports
- /IWBEP/FM_SBOD_UPD_FUNCIMP_PAR – SB – OData – DB Update Function Import Parameters
- /IWBEP/FM_SBOD_UPD_MODEL_REFS – SB – OData – DB Update Model References
- /IWBEP/FM_SBOD_UPD_NAVPROPS – SB – OData – DB Update Navigation Properties
- /IWBEP/FM_SBOD_UPD_PROPERTIES – SB – OData – DB Update Properties
- /IWBEP/FM_SBOD_UPD_REF_CONST – SB – OData – DB Update Referential Constraints
- /IWBEP/FM_SBOD_UPD_RFC_DEST – SB – OData – DB Update Model References
- /IWBEP/FM_SBOD_UPD_TERM – SB – OData – DB Update Terms
- /IWBEP/FM_SBUI_OD_MAIN_INIT – SB: UI initialize OData plugin
OData handling Components in SAP
Here is a list of possible components / sub modules which may be dealing with OData related processes in SAP. List contains sub module name, then containing component and description.
- BC-DWB-TOO-ODS – BYI3000534 – odata Service tools
- CA-GTF-CBN-ODT – EBJ0000053 – Contextual Business Navigation OData Backend Adaptation lay.
- CA-GTF-CBN-ODT – U4Y0000003 – Contextual Business Navigation OData Backend Adaptation lay.