- Accounting - General (AC)
- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Business intelligence solutions (BI)
- Collaborative Cross Applications (XAP)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Basic Functions (CRM-BF)
- Business Transactions (CRM-BTX)
- Activity Management (CRM-BTX-ACT)
- Basic Functions for Business Transactions (CRM-BTX-BF)
- Contracts (CRM-BTX-CTR)
- Controlling Integration (CRM-BTX-COI)
- Knowledge Article (CRM-BTX-KA)
- Lead Management (CRM-BTX-LEA)
- Operative Reporting and BW Analyses (CRM-BTX-ANA)
- Opportunities (CRM-BTX-OPP)
- Provider Transactions (CRM-BTX-PRV)
- Sales Transaction (CRM-BTX-SLO)
- Service Order (CRM-BTX-SVO)
- Service Request (CRM-BTX-SRQ)
- CRM Cross-Application Components (CRM-CA)
- CRM Integration for ERP Billing in Current Account (CRM-FCA)
- Integration Industry Solutions (CRM-IS)
- Interaction Center WebClient (CRM-IC)
- Interaction Center WinClient (CRM-CIC)
- Master Data (CRM-MD)
- Public Sector (CRM-IPS)
- Resource Planning for Personnel Resources (CRM-RPL)
- SAP S/4HANA Service (CRM-S4)
- Telecommunications (CRM-IT)
- Utilities Industry (CRM-IU)
- Waste Management (CRM-WA)
- Customer Service (CS)
- Discrete Industries (DI)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise Performance Management (EPM)
- Enterprise Portal (EP)
- Enterprise Portal (EP)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Financials (FIN)
- Global Trade Services (SLL)
- Governance, Risk and Compliance (GRC)
- Incentive and Commission Management (ICM) (ICM)
- Investment Management (IM)
- Knowledge Management (KM)
- LOD Components (LOD)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Obsolete Product: mySAP.com Workplace (WP)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Personnel Time Management (PT)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP HANA (HAN)
- SAP NetWeaver Master Data Management (MDM)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Training and Event Management (PE)
- Transportation Management (TM)
- Treasury (TR)
- Web Channel (WEC)
CRMD_ORDER_INDEX
Index table for one-order document
|
#index
|
Component: Business Transactions
- 🔑 Keys (2)
- 💰 Amounts (1)
- ∑ Quantities
- 📅 Dates (1)
- ☰ Categorical (65)
- Other (27)
- 🔗 Relations (1)
| Column Name | Description | |
|---|---|---|
| CLIENT | Client | |
| GUID | GUID of a CRM Order Object |
| Column Name | Description | |
|---|---|---|
| NET_VALUE | Total Net Value of Document in Document Currency |
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| POSTING_DATE_HD | Posting Date for a Business Transaction |
| Column Name | Description | |
|---|---|---|
| STAT_OPEN | Transaction is Still Open | Show values |
| STAT_PROCESS | Postprocessing Required | Show values |
| STAT_RELEASED | Status: Released | Show values |
| STAT_BILL | Select for Billing Document | Show values |
| STAT_SERVICE_DWP | Selection Control Station | Show values |
| STAT_PLANNED | Status: Planned | Show values |
| STAT_QUOT | Logical Variable | Show values |
| PRIVATE_FLAG_IX | Indicator: Task is Private | Show values |
| STAT_INQ | Logical Variable | Show values |
| NO_APPT | Logical Variable | Show values |
| IR_EXISTS | Logical Variable | Show values |
| TEMPLATE_TYPE_IX | Template Type of CRM Transaction | Show values |
| HEAD | Logical Variable | Show values |
| PFT_0 | Logical Variable | Show values |
| PFT_1 | Logical Variable | Show values |
| PFT_2 | Logical Variable | Show values |
| PFT_3 | Logical Variable | Show values |
| PFT_4 | Logical Variable | Show values |
| PFT_5 | Logical Variable | Show values |
| PFT_6 | Logical Variable | Show values |
| PFT_7 | Logical Variable | Show values |
| PFT_8 | Logical Variable | Show values |
| PFT_9 | Logical Variable | Show values |
| PFT_10 | Logical Variable | Show values |
| PFT_11 | Logical Variable | Show values |
| PFT_12 | Logical Variable | Show values |
| PFT_13 | Logical Variable | Show values |
| PFT_14 | Logical Variable | Show values |
| PFT_15 | Logical Variable | Show values |
| PFT_16 | Logical Variable | Show values |
| PFT_17 | Logical Variable | Show values |
| PFT_18 | Logical Variable | Show values |
| PFT_19 | Logical Variable | Show values |
| PFT_20 | Logical Variable | Show values |
| PFT_21 | Logical Variable | Show values |
| PFT_22 | Logical Variable | Show values |
| PFT_23 | Logical Variable | Show values |
| PFT_24 | Logical Variable | Show values |
| PFT_25 | Logical Variable | Show values |
| PFT_26 | Logical Variable | Show values |
| PFT_27 | Logical Variable | Show values |
| PFT_28 | Logical Variable | Show values |
| PFT_30 | Logical Variable | Show values |
| PFT_32 | Logical Variable | Show values |
| PFT_33 | Logical Variable | Show values |
| PFT_34 | Logical Variable | Show values |
| PFT_40 | Logical Variable | Show values |
| PFT_41 | Logical Variable | Show values |
| PFT_49 | Logical Variable | Show values |
| PFT_50 | Logical Variable | Show values |
| PFT_51 | Logical Variable | Show values |
| PFT_52 | Logical Variable | Show values |
| PFT_54 | Logical Variable | Show values |
| PFT_55 | Logical Variable | Show values |
| PFT_56 | Logical Variable | Show values |
| PFT_57 | Logical Variable | Show values |
| PFT_58 | Logical Variable | Show values |
| PFT_37 | Logical Variable | Show values |
| PFT_59 | Logical Variable | Show values |
| PFT_62 | Logical Variable | Show values |
| PFT_68 | Logical Variable | Show values |
| PFT_69 | Logical Variable | Show values |
| PFT_70 | Logical Variable | Show values |
| MAINPARTNER | Main Partner (For Ambiguous Partner Functions) | Show values |
| PFT_46 | Logical Variable | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| HEADER | GUID of a CRM Order Object | SYSUUID | |
| ITEM | GUID of a CRM Order Object | SYSUUID | |
| PROCESS_TYPE_IX | Business Transaction Type | CRM_PROCESS_TYPE | |
| CURR_PHASE | Sales Stage | CRM_PHASE | |
| IMPORTANCE | Opportunity/Lead Priority | CRM_IMPORTANCE | |
| PARTNER_NO | Partner Number | CRM_PARTNER_NO | |
| SALES_ORG | Sales Organization ID | HROBJEC_14 | |
| DIS_CHANNEL | Distribution Channel | VTWEG | |
| DIVISION | Division | SPART | |
| SERVICE_ORG | Service Organization | HROBJEC_14 | |
| SALES_OFFICE | Sales Office | HROBJEC_14 | |
| SALES_GROUP | Sales Group | HROBJEC_14 | |
| PURCH_ORG | Purchasing Organization | HROBJEC_14 | |
| PO_NUMBER_UC | Sold-to Party's External Reference No. (in Capital Letters) | CHAR35 | |
| STAT_CREDIT | Credit Block on Transaction | CRMT_STATUS_CRED | |
| INVCR_DATE | Billing Document Creation Date | BCOS_TSTMP | |
| DATE_1 | Time Dependency: Validity Start Date | BCOS_TSTMP | |
| DATE_2 | Time Dependency: Validity End Date | BCOS_TSTMP | |
| DATE_3 | Time Stamp: Start of Customer Contact | BCOS_TSTMP | |
| DATE_4 | Time Stamp: End of Customer Contact | BCOS_TSTMP | |
| PRODUCT_ID | Product Name Entered | CRM_ORDERED_PROD | |
| CATEGORY_ID | Category ID | COM_CATEGORY_ID | |
| CATALOG_ID | Catalog ID from which the line was selected | CRM_CATALOGID | |
| CATALOG_ITEM | Catalog Item (Unique Key) | CRM_CATALOGITEM | |
| DESCRIPT_PARTNER | Product Number of Business Partner | PRSHTEXT40 | |
| PATH_ID | Territory Hierarchy ID | CRM_TERRITORY_PATH_ID | |
| OBJECT_TYPE_HDIX | Business Transaction Category | CRM_OJ_NAME_PROCESS |
| Master Data Relations | Join Conditions |
|---|---|
| Business Transaction Category | CRMD_ORDER_INDEX.OBJECT_TYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY |