SAP Table CRMD_ORDER_INDEX stores Index table for one-order documentdata

  

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!


SAP CRMD_ORDER_INDEX dictionary attributes

Object Name: CRMD_ORDER_INDEX
Dictionary Type: Transparent table
Description: Index table for one-order document


CRMD_ORDER_INDEX field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
CLIENTMANDTCLNT3(0) *ClientMANDTTESTCRM
GUIDCRMT_OBJECT_GUIDRAW16(0) GUID of a CRM Order ObjectSYSUUIDCRM
HEADERCRMT_OBJECT_GUIDRAW16(0) GUID of a CRM Order ObjectSYSUUIDCRM
ITEMCRMT_OBJECT_GUIDRAW16(0) GUID of a CRM Order ObjectSYSUUIDCRM
OBJECT_TYPECRMT_SUBOBJECT_CATEGORYCHAR10(0) CRMC_SUBOB_CATBusiness Transaction CategoryCRM_OJ_NAME_PROCESSCRM_SUBOBJ_CATEGORYCRM_OBJECT_TYPE_PROCESSSUBOBJ_CATEGORYCRM
PROCESS_TYPE_IXCRMT_PROCESS_TYPECHAR4(0) Business Transaction TypeCRM_PROCESS_TYPECRM_PROCESS_TYPECRM_PROCESS_TYPEPROCESS_TYPECRM
CURR_PHASECRMT_CURR_PHASECHAR3(0) PhaseCRM_PHASECRM_PHASEPHASECRM
IMPORTANCECRMT_IMPORTANCECHAR1(0) *Opportunity/Lead PriorityCRM_IMPORTANCECRM
PARTNER_NOCRMT_PARTNER_NOCHAR32(0) Partner NumberCRM_PARTNER_NOCRM
SALES_ORGCRMT_SALES_ORGCHAR14(0) Sales OrganizationHROBJEC_14CRM_ORGMAN_SALES_ORGSALES_ORGCRM
DIS_CHANNELCRMT_DISTRIBUTION_CHANNELCHAR2(0) Distribution ChannelCRM_DISTRIBUTION_CHANNELCRM_ORGMAN_DIS_CHANNELDIS_CHANNELCRM
DIVISIONCRMT_DIVISIONCHAR2(0) DivisionCRM_DIVISIONCRM_DIVISIONDIVISIONCRM
SERVICE_ORGCRMT_SERVICE_ORGCHAR14(0) Service OrganizationHROBJEC_14CRM_ORGMAN_SERVICE_ORGSERVICE_ORGCRM
SALES_OFFICECRMT_SALES_OFFICECHAR14(0) Sales OfficeHROBJEC_14CRM_ORGMAN_SALES_OFFICESALES_OFFICECRM
SALES_GROUPCRMT_SALES_GROUPCHAR14(0) Sales GroupHROBJEC_14CRM_ORGMAN_SALES_GROUPSALES_GROUPCRM
PURCH_ORGCRMT_PURCH_ORGCHAR14(0) Purchasing OrganizationHROBJEC_14CRM
PO_NUMBER_UCCRMT_PO_NUMBER_UCCHAR35(0) Sold-to Party's External Reference No. (in Capital Letters)CHAR35CRM
STAT_OPENCRMT_STATUS_OPENCHAR1(0) Transaction is Still OpenCRM_BOOLEANCRM
STAT_PROCESSCRMT_STATUS_PROCESSCHAR1(0) Postprocessing RequiredCRM_BOOLEANCRM
STAT_RELEASEDCRMT_STATUS_RELEASEDCHAR1(0) Status: ReleasedCRM_BOOLEANCRM
STAT_BILLCRMT_STATUS_TO_BE_BILLEDCHAR1(0) Select for Billing DocumentCRM_BOOLEANCRM
STAT_SERVICE_DWPCRMT_STATUS_SERVICE_DWPCHAR1(0) Selection Control StationCRM_BOOLEANCRM
STAT_PLANNEDCRMT_STATUS_PLANNEDCHAR1(0) Status: PlannedCRM_BOOLEANCRM
STAT_QUOTCRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PRIVATE_FLAG_IXCRMT_PRIVATCHAR1(0) Indicator: Task is PrivateCRM_BOOLEANCRM
STAT_INQCRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
STAT_CREDITCRMT_STATUS_CREDCHAR1(0) Credit Block on TransactionCRMT_STATUS_CREDCRM
INVCR_DATECRMT_INVCR_DATEDEC15(0) Billing Document Creation DateBCOS_TSTMPCRM
DATE_1CRMT_VALID_FROMDEC15(0) Time Dependency: Validity Start DateBCOS_TSTMPCRM
DATE_2CRMT_VALID_TODEC15(0) Time Dependency: Validity End DateBCOS_TSTMPCRM
DATE_3CRMT_CONTACT_FROMDEC15(0) Time Stamp: Start of Customer ContactBCOS_TSTMPCRM
DATE_4CRMT_CONTACT_TODEC15(0) Time Stamp: End of Customer ContactBCOS_TSTMPCRM
NO_APPTCRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PRODUCT_IDCRMT_ORDERED_PRODCHAR54(0) Product Name EnteredCRM_ORDERED_PRODCRM_ORDERED_PRODUCTPRODUCT_IDCRM
CATEGORY_IDCOMT_CATEGORY_IDCHAR20(0) Category IDCOM_CATEGORY_IDCOM_CATEGORY_IDCOM_CAT_HIERCATEGORY_IDCRM
CATALOG_IDCRMT_CATALOGCHAR20(0) Catalog ID from which the line was selectedCRM_CATALOGIDCRM
CATALOG_ITEMCRMT_CATALOGITEMCHAR40(0) Catalog Item (Unique Key)CRM_CATALOGITEMCRM
DESCRIPT_PARTNERCRMT_ITEM_DESCR_PARTNERCHAR40(0) Product Number of Business PartnerPRSHTEXT40CRM
NET_VALUECRMT_NET_VALUE_CUMCURR15(2) Total Net Value of Document in Document CurrencyWERTV8CRM
CURRENCYCRMT_CURRENCYCUKY5(0) *CurrencyWAERSFWSCRM
POSTING_DATE_HDCRMT_POSTING_DATEDATS8(0) Posting Date for a Business TransactionCRM
PATH_IDCRMT_TERRITORY_PATH_IDCHAR30(0) Territory Hierarchy IDCRM_TERRITORY_PATH_IDCRM
IR_EXISTSCRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
TEMPLATE_TYPE_IXCRMT_TEMPLATE_TYPE_DBCHAR1(0) Template Type of CRM TransactionCRM_TEMPLATE_TYPECRM
PFT_0CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_1CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_2CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_3CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_4CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_5CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_6CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_7CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_8CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_9CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_10CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_11CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_12CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_13CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_14CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_15CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_16CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_17CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_18CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_19CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_20CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_21CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_22CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_23CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_24CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_25CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_26CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_27CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_28CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_30CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_32CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_33CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_34CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_40CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM
PFT_41CRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEANCRM


View list of all tables