SAP CRMDAMLOPR Table – CRMDAM:::: Attribute Values for Logical Information Objects

The CRMDAMLOPR table in SAP ERP or S/4HANA stores CRMDAM:::: Attribute Values for Logical Information Objects data. There are total 7 fields in CRMDAMLOPR table. The CRMDAM:::: Attribute Values for Logical Information Objects 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 CRMDAMLOPR table. It is in CRM – Digital Asset Management (CRM_DAM) ABAP package and is part of the Digital Asset Management (CRM-MKT-DAM) module.

SAP CRMDAMLOPR Table Fields

Following is the list of fields that are available in SAP CRMDAMLOPR table. The primary key fields of the table are MANDT (Client), OBJECT_ID (ID for documents and relations), PROP_NAME (Attribute of a document or a relationship), PROP_INDEX (KPro: General counter (uniqueness in DB)).

Field Description Data Element Check Table Data Type
MANDT Client MANDT CLNT (3)
OBJECT_ID ID for documents and relations SDOK_DOCID CRMDAMLOIO CHAR (32)
PROP_NAME Attribute of a document or a relationship SDOK_PROPN SDOKPROP CHAR (25)
PROP_INDEX KPro: General counter (uniqueness in DB) SDOK_INDX NUMC (5)
IO_CLASS Document class SDOK_CLASS CHAR (10)
PROP_VALUE Attribute Value SDOK_PROPV CHAR (64)
PROP_SECI Attribute feature (shortened) SDOK_PROPI CHAR (12)