SAP CRM_ODATA_NAV Table – Navigation property mapping

The CRM_ODATA_NAV table in SAP ERP or S/4HANA stores Navigation property mapping data. There are total 4 fields in CRM_ODATA_NAV table. The Navigation property mapping table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CRM_ODATA_NAV table. It is in OData services for CRM (CRM_ODATA) ABAP package and is part of the Business Partners (CRM-MD-BP) module.

SAP CRM_ODATA_NAV Table Fields

Following is the list of fields that are available in SAP CRM_ODATA_NAV table. The primary key fields of the table are ENTITY (Entity Name), NAV_PROPERTY (Navigation Property Name).

Field Description Data Element Check Table Data Type
ENTITY Entity Name CRMT_ODATA_ENTITY_NAME CHAR (40)
NAV_PROPERTY Navigation Property Name CRMT_ODATA_NAV_PROP CHAR (40)
TARGET_NAV_PROPERTY Target Navigation Property Name CRMT_ODATA_TARGET_NAV_PROP CHAR (40)
REMOVE Exclude Property from Service CRM_ODATA CRMT_ODATA_EXCLUDED CHAR (1)