The CRM_R3_ORG_DAT table in SAP ERP or S/4HANA stores Organizational Data for Objects from R3 data. There are total 15 fields in CRM_R3_ORG_DAT table. The Organizational Data for Objects from R3 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_R3_ORG_DAT table. It is in CRM: Special Set Types for Individual Objects (CRM_PRODUCT_INDOBJ) ABAP package and is part of the Objects (CRM-MD-PRO-OBJ) module.
SAP CRM_R3_ORG_DAT Table Fields
Following is the list of fields that are available in SAP CRM_R3_ORG_DAT table. The primary key fields of the table are CLIENT (Client), PRODUCT_GUID (Internal Unique ID of Product).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | * | CLNT (3) |
| PRODUCT_GUID | Internal Unique ID of Product | COMT_PRODUCT_GUID | RAW (16) | |
| VALID_FROM | Valid From (Time Stamp) | COMT_VALID_FROM | DEC (15) | |
| VALID_TO | Valid To (Time Stamp) | COMT_VALID_TO | DEC (15) | |
| UPNAME | Name of the User Who Last Changed the Set | COMT_UPNAME | CHAR (12) | |
| HISTEX | History Exists | COMT_HISTEX | CHAR (1) | |
| LOGSYS | Original System | COMT_LOGSYS | CHAR (10) | |
| VAL_FR | Valid From | CRMT_OBJ_VALID_FROM | DATS (8) | |
| COSTCENT | Cost Center | CRMT_COST_CENTER | CHAR (10) | |
| MNTNPLANT | Maintenance Plant | CRMT_MAINT_PLANT | CHAR (4) | |
| PLANPLANT | Planning Plant | CRMT_PLAN_PLANT | CHAR (4) | |
| BUS_AREA | Business Area | CRMT_BUSINESS_AREA | CHAR (4) | |
| CNTR_AREA | Controlling Area | CRMT_CNTRLLNG_AREA | CHAR (4) | |
| STNDG_ORD | Standing Order | CRMT_STANDING_ORDER | CHAR (12) | |
| STLMT_ORD | Settlement Order | CRMT_SETTLMENT_ORDER | CHAR (12) |
