In this post, I will try and describe everything you need to know about the SAP crmd_order_index 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_ORDER_INDEX 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_ORDER_INDEX....Right lets get started!
Object Name: CRMD_ORDER_INDEX
Dictionary Type: Transparent table
Description: Index table for one-order document
| 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 | ||||||
| HEADER | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| ITEM | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| OBJECT_TYPE | CRMT_SUBOBJECT_CATEGORY | CHAR | 10(0) | CRMC_SUBOB_CAT | Business Transaction Category | CRM_OJ_NAME_PROCESS | CRM_SUBOBJ_CATEGORY | CRM_OBJECT_TYPE_PROCESS | SUBOBJ_CATEGORY | CRM | ||
| PROCESS_TYPE_IX | CRMT_PROCESS_TYPE | CHAR | 4(0) | Business Transaction Type | CRM_PROCESS_TYPE | CRM_PROCESS_TYPE | CRM_PROCESS_TYPE | PROCESS_TYPE | CRM | |||
| CURR_PHASE | CRMT_CURR_PHASE | CHAR | 3(0) | Phase | CRM_PHASE | CRM_PHASE | PHASE | CRM | ||||
| IMPORTANCE | CRMT_IMPORTANCE | CHAR | 1(0) | * | Opportunity/Lead Priority | CRM_IMPORTANCE | CRM | |||||
| PARTNER_NO | CRMT_PARTNER_NO | CHAR | 32(0) | Partner Number | CRM_PARTNER_NO | CRM | ||||||
| SALES_ORG | CRMT_SALES_ORG | CHAR | 14(0) | Sales Organization | HROBJEC_14 | CRM_ORGMAN_SALES_ORG | SALES_ORG | CRM | ||||
| DIS_CHANNEL | CRMT_DISTRIBUTION_CHANNEL | CHAR | 2(0) | Distribution Channel | CRM_DISTRIBUTION_CHANNEL | CRM_ORGMAN_DIS_CHANNEL | DIS_CHANNEL | CRM | ||||
| DIVISION | CRMT_DIVISION | CHAR | 2(0) | Division | CRM_DIVISION | CRM_DIVISION | DIVISION | CRM | ||||
| SERVICE_ORG | CRMT_SERVICE_ORG | CHAR | 14(0) | Service Organization | HROBJEC_14 | CRM_ORGMAN_SERVICE_ORG | SERVICE_ORG | CRM | ||||
| SALES_OFFICE | CRMT_SALES_OFFICE | CHAR | 14(0) | Sales Office | HROBJEC_14 | CRM_ORGMAN_SALES_OFFICE | SALES_OFFICE | CRM | ||||
| SALES_GROUP | CRMT_SALES_GROUP | CHAR | 14(0) | Sales Group | HROBJEC_14 | CRM_ORGMAN_SALES_GROUP | SALES_GROUP | CRM | ||||
| PURCH_ORG | CRMT_PURCH_ORG | CHAR | 14(0) | Purchasing Organization | HROBJEC_14 | CRM | ||||||
| PO_NUMBER_UC | CRMT_PO_NUMBER_UC | CHAR | 35(0) | Sold-to Party's External Reference No. (in Capital Letters) | CHAR35 | CRM | ||||||
| STAT_OPEN | CRMT_STATUS_OPEN | CHAR | 1(0) | Transaction is Still Open | CRM_BOOLEAN | CRM | ||||||
| STAT_PROCESS | CRMT_STATUS_PROCESS | CHAR | 1(0) | Postprocessing Required | CRM_BOOLEAN | CRM | ||||||
| STAT_RELEASED | CRMT_STATUS_RELEASED | CHAR | 1(0) | Status: Released | CRM_BOOLEAN | CRM | ||||||
| STAT_BILL | CRMT_STATUS_TO_BE_BILLED | CHAR | 1(0) | Select for Billing Document | CRM_BOOLEAN | CRM | ||||||
| STAT_SERVICE_DWP | CRMT_STATUS_SERVICE_DWP | CHAR | 1(0) | Selection Control Station | CRM_BOOLEAN | CRM | ||||||
| STAT_PLANNED | CRMT_STATUS_PLANNED | CHAR | 1(0) | Status: Planned | CRM_BOOLEAN | CRM | ||||||
| STAT_QUOT | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PRIVATE_FLAG_IX | CRMT_PRIVAT | CHAR | 1(0) | Indicator: Task is Private | CRM_BOOLEAN | CRM | ||||||
| STAT_INQ | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| STAT_CREDIT | CRMT_STATUS_CRED | CHAR | 1(0) | Credit Block on Transaction | CRMT_STATUS_CRED | CRM | ||||||
| INVCR_DATE | CRMT_INVCR_DATE | DEC | 15(0) | Billing Document Creation Date | BCOS_TSTMP | CRM | ||||||
| DATE_1 | CRMT_VALID_FROM | DEC | 15(0) | Time Dependency: Validity Start Date | BCOS_TSTMP | CRM | ||||||
| DATE_2 | CRMT_VALID_TO | DEC | 15(0) | Time Dependency: Validity End Date | BCOS_TSTMP | CRM | ||||||
| DATE_3 | CRMT_CONTACT_FROM | DEC | 15(0) | Time Stamp: Start of Customer Contact | BCOS_TSTMP | CRM | ||||||
| DATE_4 | CRMT_CONTACT_TO | DEC | 15(0) | Time Stamp: End of Customer Contact | BCOS_TSTMP | CRM | ||||||
| NO_APPT | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PRODUCT_ID | CRMT_ORDERED_PROD | CHAR | 54(0) | Product Name Entered | CRM_ORDERED_PROD | CRM_ORDERED_PRODUCT | PRODUCT_ID | CRM | ||||
| CATEGORY_ID | COMT_CATEGORY_ID | CHAR | 20(0) | Category ID | COM_CATEGORY_ID | COM_CATEGORY_ID | COM_CAT_HIER | CATEGORY_ID | CRM | |||
| CATALOG_ID | CRMT_CATALOG | CHAR | 20(0) | Catalog ID from which the line was selected | CRM_CATALOGID | CRM | ||||||
| CATALOG_ITEM | CRMT_CATALOGITEM | CHAR | 40(0) | Catalog Item (Unique Key) | CRM_CATALOGITEM | CRM | ||||||
| DESCRIPT_PARTNER | CRMT_ITEM_DESCR_PARTNER | CHAR | 40(0) | Product Number of Business Partner | PRSHTEXT40 | CRM | ||||||
| NET_VALUE | CRMT_NET_VALUE_CUM | CURR | 15(2) | Total Net Value of Document in Document Currency | WERTV8 | CRM | ||||||
| CURRENCY | CRMT_CURRENCY | CUKY | 5(0) | * | Currency | WAERS | FWS | CRM | ||||
| POSTING_DATE_HD | CRMT_POSTING_DATE | DATS | 8(0) | Posting Date for a Business Transaction | CRM | |||||||
| PATH_ID | CRMT_TERRITORY_PATH_ID | CHAR | 30(0) | Territory Hierarchy ID | CRM_TERRITORY_PATH_ID | CRM | ||||||
| IR_EXISTS | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| TEMPLATE_TYPE_IX | CRMT_TEMPLATE_TYPE_DB | CHAR | 1(0) | Template Type of CRM Transaction | CRM_TEMPLATE_TYPE | CRM | ||||||
| PFT_0 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_1 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_2 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_3 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_4 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_5 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_6 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_7 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_8 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_9 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_10 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_11 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_12 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_13 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_14 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_15 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_16 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_17 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_18 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_19 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_20 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_21 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_22 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_23 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_24 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_25 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_26 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_27 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_28 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_30 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_32 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_33 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_34 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_40 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| PFT_41 | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM |