In this post, I will try and describe everything you need to know about the SAP crmd_m1o_srm_inx table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for CRMD_M1O_SRM_INX what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from CRMD_M1O_SRM_INX....Right lets get started!
Object Name: CRMD_M1O_SRM_INX
Dictionary Type: Transparent table
Description: Order Data Storage (MOM and SUS)
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| CLIENT | MANDT | CLNT | 3(0) | * | Client | MANDT | TEST | CRM | ||||
| GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| SUPPLIER | BU_PARTNER | CHAR | 10(0) | * | Business Partner Number | BU_PARTNER | BPA | BUPA | PARTNER | CRM | ||
| SCENARIO | CRMT_M1O_SCENARIO | CHAR | 10(0) | SAPMarkets One Order: Scenario | CRM_M1O_SCENARIO | CRM | ||||||
| SCEN_PROC_TYP | CRMT_M1O_SCEN_PROC_TYP | CHAR | 10(0) | SAPMarkets One Order: Scenario Transaction Types | CRM_M1O_SCEN_PROC_TYP | CRM | ||||||
| BUYER | BU_PARTNER | CHAR | 10(0) | * | Business Partner Number | BU_PARTNER | BPA | BUPA | PARTNER | CRM | ||
| BUYER_NAME | BU_NAMEOR1 | CHAR | 40(0) | Name 1 of organization | BU_NAME | CRM | ||||||
| CREATED_AT | CRMT_CREATED_AT | DEC | 15(0) | Transaction was Created at this Time | BCOS_TSTMP | CRM | ||||||
| PO_NUM | CRMT_PO_NUMBER_SOLD | CHAR | 35(0) | Sold-To Party's External Reference Number | TEXT35 | CRM | ||||||
| M1O_SOBJECT_ID | CRMT_OBJECT_ID | CHAR | 10(0) | Transaction ID | CRM_OBJECT_ID | CRM_OBJECT_ID | CRM_ORDER_OBJECT_ID | OBJECT_ID | CRM | |||
| OBJ_ID | CRMT_OBJECT_ID | CHAR | 10(0) | Transaction ID | CRM_OBJECT_ID | CRM_OBJECT_ID | CRM_ORDER_OBJECT_ID | OBJECT_ID | CRM | |||
| STATUS | CRM_J_STATUS | CHAR | 5(0) | Object Status | CRM_J_STATUS | BSV | CRM | |||||
| GROSS_VALUE | CRMT_GROSS_VALUE_CUM | CURR | 15(2) | Total Gross Value of Document in Document Currency | WERTV8 | CRM | ||||||
| CURRENCY | CRMT_CURRENCY | CUKY | 5(0) | * | Currency | WAERS | FWS | CRM | ||||
| DESCRIPTION | CRMT_PROCESS_DESCRIPTION | CHAR | 40(0) | Transaction Description | CRM_PROCESS_DESCRIPTION | CRM | ||||||
| M1O_IND_CONFIRM | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| M1O_IND_INVOICE | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| M1O_IND_ERS | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| M1O_FIN_CONFIRM | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| M1O_FIN_INVOICE | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| M1O_FIN_ERS | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| M1O_IND_ASN | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| M1O_FIN_ASN | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| NOTIFIED | CRMT_M1O_NOTIF_STATUS | CHAR | 1(0) | Status of Supplier Notification | CRMT_M1O_NOTIF_STATUS | CRM | ||||||
| NOTIF_DATE | CRMT_CREATED_AT | DEC | 15(0) | Transaction was Created at this Time | BCOS_TSTMP | CRM | ||||||
| USER_BP | BU_PARTNER | CHAR | 10(0) | * | Business Partner Number | BU_PARTNER | BPA | BUPA | PARTNER | CRM |