SAP TABLES | Customer Relationship Management | Business Transactions(CRM-BTX) SAP CRM

CRMD_ORDER_INDEX SAP Index table for one-order document Table








CRMD_ORDER_INDEX is a standard SAP Table which is used to store Index table for one-order document information. This is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about Table CRMD_ORDER_INDEX and the data within it using relevant SAP transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories


Dictionary fields for SAP Table CRMD_ORDER_INDEX




FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
.INCLUDECRMT_ORDER_INDEX_KEY Key fields for index table for product
CLIENTMANDTCLNT3
*
Client
GUIDCRMT_OBJECT_GUIDRAW16 GUID of a CRM Order Object
.INCLUDECRMT_ORDER_INDEX_LOG_KEY Logical key for index table for product
HEADERCRMT_OBJECT_GUIDRAW16 GUID of a CRM Order Object
ITEMCRMT_OBJECT_GUIDRAW16 GUID of a CRM Order Object
.INCLUDECRMT_ORDER_INDEX_DATA CRM Index: Data
OBJECT_TYPECRMT_SUBOBJECT_CATEGORYCHAR10 CRMC_SUBOB_CATBusiness Transaction Category
PROCESS_TYPE_IXCRMT_PROCESS_TYPECHAR4 Business Transaction Type
CURR_PHASECRMT_CURR_PHASECHAR3 Phase
IMPORTANCECRMT_IMPORTANCECHAR1
*
Opportunity/Lead Priority
PARTNER_NOCRMT_PARTNER_NOCHAR32 Partner Number
SALES_ORGCRMT_SALES_ORGCHAR14 Sales Organization
DIS_CHANNELCRMT_DISTRIBUTION_CHANNELCHAR2 Distribution Channel
DIVISIONCRMT_DIVISIONCHAR2 Division
SERVICE_ORGCRMT_SERVICE_ORGCHAR14 Service Organization
SALES_OFFICECRMT_SALES_OFFICECHAR14 Sales Office
SALES_GROUPCRMT_SALES_GROUPCHAR14 Sales Group
PURCH_ORGCRMT_PURCH_ORGCHAR14 Purchasing Organization
PO_NUMBER_UCCRMT_PO_NUMBER_UCCHAR35 Sold-to Party's External Reference No. (in Capital Letters)
STAT_OPENCRMT_STATUS_OPENCHAR1 Transaction is Still Open
STAT_PROCESSCRMT_STATUS_PROCESSCHAR1 Postprocessing Required
STAT_RELEASEDCRMT_STATUS_RELEASEDCHAR1 Status: Released
STAT_BILLCRMT_STATUS_TO_BE_BILLEDCHAR1 Select for Billing Document
STAT_SERVICE_DWPCRMT_STATUS_SERVICE_DWPCHAR1 Selection Control Station
STAT_PLANNEDCRMT_STATUS_PLANNEDCHAR1 Status: Planned
STAT_QUOTCRMT_BOOLEANCHAR1 Logical Variable
PRIVATE_FLAG_IXCRMT_PRIVATCHAR1 Indicator: Task is Private
STAT_INQCRMT_BOOLEANCHAR1 Logical Variable
STAT_CREDITCRMT_STATUS_CREDCHAR1 Credit Block on Transaction
INVCR_DATECRMT_INVCR_DATEDEC15 Billing Document Creation DateTSTPS
DATE_1CRMT_VALID_FROMDEC15 Time Dependency: Validity Start DateTSTPS
DATE_2CRMT_VALID_TODEC15 Time Dependency: Validity End DateTSTPS
DATE_3CRMT_CONTACT_FROMDEC15 Time Stamp: Start of Customer ContactTSTPS
DATE_4CRMT_CONTACT_TODEC15 Time Stamp: End of Customer ContactTSTPS
NO_APPTCRMT_BOOLEANCHAR1 Logical Variable
PRODUCT_IDCRMT_ORDERED_PRODCHAR54 Product Name Entered
CATEGORY_IDCOMT_CATEGORY_IDCHAR20 Category ID
CATALOG_IDCRMT_CATALOGCHAR20 Catalog ID from which the line was selected
CATALOG_ITEMCRMT_CATALOGITEMCHAR40 Catalog Item (Unique Key)

DESCRIPT_PARTNERCRMT_ITEM_DESCR_PARTNERCHAR40 Product Number of Business Partner
NET_VALUECRMT_NET_VALUE_CUMCURR15(2) Total Net Value of Document in Document Currency
CURRENCYCRMT_CURRENCYCUKY5
*
Currency
POSTING_DATE_HDCRMT_POSTING_DATEDATS8 Posting Date for a Business Transaction
PATH_IDCRMT_TERRITORY_PATH_IDCHAR30 Territory Hierarchy ID
IR_EXISTSCRMT_BOOLEANCHAR1 Logical Variable
TEMPLATE_TYPE_IXCRMT_TEMPLATE_TYPE_DBCHAR1 Template Type of CRM Transaction
.INCLUDECRMT_ORDER_INDEX_PFT Partner Function Categories in Index
PFT_0CRMT_BOOLEANCHAR1 Logical Variable
PFT_1CRMT_BOOLEANCHAR1 Logical Variable
PFT_2CRMT_BOOLEANCHAR1 Logical Variable
PFT_3CRMT_BOOLEANCHAR1 Logical Variable
PFT_4CRMT_BOOLEANCHAR1 Logical Variable
PFT_5CRMT_BOOLEANCHAR1 Logical Variable
PFT_6CRMT_BOOLEANCHAR1 Logical Variable
PFT_7CRMT_BOOLEANCHAR1 Logical Variable
PFT_8CRMT_BOOLEANCHAR1 Logical Variable
PFT_9CRMT_BOOLEANCHAR1 Logical Variable
PFT_10CRMT_BOOLEANCHAR1 Logical Variable
PFT_11CRMT_BOOLEANCHAR1 Logical Variable
PFT_12CRMT_BOOLEANCHAR1 Logical Variable
PFT_13CRMT_BOOLEANCHAR1 Logical Variable
PFT_14CRMT_BOOLEANCHAR1 Logical Variable
PFT_15CRMT_BOOLEANCHAR1 Logical Variable
PFT_16CRMT_BOOLEANCHAR1 Logical Variable
PFT_17CRMT_BOOLEANCHAR1 Logical Variable
PFT_18CRMT_BOOLEANCHAR1 Logical Variable
PFT_19CRMT_BOOLEANCHAR1 Logical Variable
PFT_20CRMT_BOOLEANCHAR1 Logical Variable
PFT_21CRMT_BOOLEANCHAR1 Logical Variable
PFT_22CRMT_BOOLEANCHAR1 Logical Variable
PFT_23CRMT_BOOLEANCHAR1 Logical Variable
PFT_24CRMT_BOOLEANCHAR1 Logical Variable
PFT_25CRMT_BOOLEANCHAR1 Logical Variable
PFT_26CRMT_BOOLEANCHAR1 Logical Variable
PFT_27CRMT_BOOLEANCHAR1 Logical Variable
PFT_28CRMT_BOOLEANCHAR1 Logical Variable
PFT_30CRMT_BOOLEANCHAR1 Logical Variable
PFT_32CRMT_BOOLEANCHAR1 Logical Variable
PFT_33CRMT_BOOLEANCHAR1 Logical Variable

PFT_34CRMT_BOOLEANCHAR1 Logical Variable
PFT_40CRMT_BOOLEANCHAR1 Logical Variable
PFT_41CRMT_BOOLEANCHAR1 Logical Variable


Key field
Non-key field