- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- SAP S/4HANA Service (CRM-S4)
- S4CRM: Analytics (CRM-S4-ANA)
- S4CRM: Basic Functions (CRM-S4-BF)
- S4CRM: Business Transaction Framework (CRM-S4-BTX)
- S4CRM: Case Management (CRM-S4-CM)
- S4CRM: Complaints (CRM-S4-COM)
- S4CRM: In-House Repair (CRM-S4-IHR)
- S4CRM: Master Data (CRM-S4-MD)
- S4CRM: Pre-Sales & Sales (CRM-S4-SLS)
- S4CRM: Public Services Industry (CRM-S4-IPS)
- S4CRM: Reporting (CRM-S4-REP)
- S4CRM: Service Management (CRM-S4-SRV)
- S4CRM: Solution (CRM-S4-SOL)
- S4CRM: Subscription Order Management (CRM-S4-SOM)
- S4CRM: Utilities Industry (CRM-S4-IU)
- SAP S/4HANA Service (CRM-S4)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- 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 Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
P_ServiceOrderItemDataCube
Helper view for Service Order Item Cube
| view: PSRVORDIEMDTCB
| Extraction:
Not supported
| Component: S4CRM: Analytics
Tables used:
SCAL_TT_DATE, CRMS4D_SERV_H, CRMS4D_SERV_I, CRMS4D_REFOBJ, MARA, EQUI, EQKT, EQUZ, IFLOT, IFLOTX, T002, MARA, MAKT
| Column Name | Description | |
|---|---|---|
| ServiceObjectType FK | Business Trans. Cat. | |
| ServiceDocument | Transaction ID | |
| ServiceDocumentItem | Shortened Item Number in Document |
| Column Name | Description | |
|---|---|---|
| 💲 Currency (TransactionCurrency): | ||
| ServiceDocumentItemNetAmount | Net Value | |
| Column Name | Description | |
|---|---|---|
| 📏 Unit of Measure in Which the Product Is Sold (ServiceDocItemQuantityUnit): | ||
| ServiceDocumentItemQuantity | CRM: Order Quantity | |
| Column Name | Description | |
|---|---|---|
| PostingDate | Posting Date for a Business Transaction | |
| RequestedServiceStartDate | null | |
| RequestedServiceEndDate | null | |
| ServiceFirstResponseByDate | null | |
| SrvcDocItemSLADueByDate | null | |
| PlannedServiceStartDate | null | |
| PlannedServiceEndDate | null | |
| ServiceDocumentCreationDate | Created On | |
| ServiceDocItemCreationDate | Created On |
| Column Name | Description | |
|---|---|---|
| ServiceDocumentStatus | Life Cycle Status | Show values |
| ServiceDocumentIsOpen | Status "Open" | Show values |
| ServiceReferenceObjectType | Object Type for Reference Object in Subject Set | Show values |
| ServiceDocumentItemStatus | Life Cycle Status | Show values |
| ServiceDocumentItemHasError | Error Status | Show values |
| ServiceDocumentItemIsOpen | Status "Open" | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| ServiceDocumentDescription | Transaction Description | CRM_PROCESS_DESCRIPTION | |
| ServiceDocumentItemDescription | Product Description | CRM_PRSHTEXT40_DB | |
| ParentServiceDocumentItemUUID | GUID of a CRM Order Object | SYSUUID | |
| SrvcOrdItmByReqdStrtWkNmbr | null | ||
| SrvcOrdItmByReqdEndWkNmbr | null | ||
| SrvcOrdItmByPlndStrtWkNmbr | null | ||
| SrvcOrdItmByPlndEndWkNmbr | null | ||
| SrvcOrdItmBy1stRspWkNmbr | null | ||
| SrvcOrdItmByToDoWkNmbr | null | ||
| ReferenceObjectID | Material Number | MATNR | |
| SrvcRefObjName | Description of technical object | TEXT40 | |
| RefBusinessSolutionOrder | Reference Solution Order ID | CRM_OBJECT_ID | |
| OriginallyRequestedProduct | Product Name Entered | CRM_ORDERED_PROD | |
| RequestedServiceStartDateTime | Service Request Start Date | TZNTSTMPS | |
| RequestedServiceEndDateTime | Service Request Due Date | TZNTSTMPS | |
| NmbrOfIncompleteServiceOrders | null | ||
| NmbrOfServiceOrderItems | null | ||
| NumberOfOverdueServiceOrders | null | ||
| SalesOrganization | Sales Organization | VKORG | |
| SalesOffice | Sales office | VKBUR | |
| SalesGroup | Sales group | VKGRP | |
| ServiceOrganization | Service Organization | HROBJEC_14 | |
| SalesOrganizationOrgUnitID | Sales Organization ID | HROBJEC_14 | |
| SalesOfficeOrgUnitID | Sales Office | HROBJEC_14 | |
| SalesGroupOrgUnitID | Sales Group | HROBJEC_14 |
| Master Data Relations | Join Conditions |
|---|---|
Customer Contact Person
| |
Distribution Channel
| |
Division
| |
Equipment Number
| |
Employee Responsible
| |
Item Category
|
|
Unit of Measure in Which the Product Is Sold
| |
| CRM Item Object Type | P_SERVICEORDERITEMDATACUBE.SERVICEDOCUMENTITEMOBJECTTYPE == CRMC_SUBOB_CAT_I.SUBOBJ_CATEGORY |
Activity Priority
| |
Activity Priority
| |
Business Transaction Type
|
|
Executing Service Employee
| |
| Business Trans. Cat. | P_SERVICEORDERITEMDATACUBE.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY |
Service Team
| |
Ship-To Party
| |
Sold-To Party
| |
Currency
|