C_ServiceOrderItemDEX

Data Extraction for Service Order | view: CSRVCORDITMDEX | TRAN | Extraction: Full or Incremental | Component: S4CRM: BI Data Exchange
Tables used: CRMS4D_SERV_H, CRMS4D_SERV_I, CRMD_BRELVONAI, CRMD_BRELVONAE, CRMS4D_REFOBJ
Column Name Description
ServiceObjectType FK Business Trans. Cat.
ServiceDocument Transaction ID
ServiceDocumentItem Shortened Item Number in Document
Column Name Description
💲 Currency (TransactionCurrency):
ServiceDocNetAmount Total Net Value of Document in Document Currency
InvoiceAmountInInvoiceDocCrcy Invoice Value
SrvcDocItmReldAmtInTransCrcy Released Value
ServiceDocumentItemNetAmount Net Value
ServiceDocItemGrossAmount Gross Order Value in PO Currency
Column Name Description
📏 Unit of Measure in Which the Product Is Sold (ServiceDocItemQuantityUnit):
SrvcDocItmRequestedQuantity Ordered Quantity
InvoiceQuantity Invoiced Quantity
SrvcDocItmDeliveredQuantity Delivered Quantity
SrvcDocItmReleasedQuantity Released Quantity
ServiceDocumentItemQuantity CRM: Order Quantity
📏 Base Unit of Measure of Product (SrvcDocItemBaseQuantityUnit):
ServiceDuration Duration
Column Name Description
RequestedServiceStartDate Created On
RequestedServiceEndDate Changed On
PostingDate Posting Date for a Business Transaction
ProfitCenterDeterminationDate Date
ExchangeRateDate Exchange Rate Date
Column Name Description
ServiceDocumentStatus Life Cycle Status Show values
ServiceDocumentIsReleased Release Status Show values
ServiceDocumentIsQuotation Quotation Status Show values
ServiceDocumentHasError Error Status Show values
ServiceDocIsReleasedForBilling Release Status for Cumulated Billing Show values
ServiceDocumentIsRejected Cancellation Status Show values
ServiceDocBillingStatus Billing Status Show values
ServiceDocumentIsOpen Status "Open" Show values
ServiceEscalationLevel Escalation Show values
SrvcOrderConfirmationRelevance Relevant for Confirmation Show values
ServiceDocumentItemStatus Life Cycle Status Show values
ServiceDocumentItemIsReleased Release Status Show values
ServiceDocumentItemIsQuotation Quotation Status Show values
ServiceDocumentItemHasError Error Status Show values
SrvcDocItmDeliveryStatus Delivery Status Show values
SrvcDocItmGoodsIssueStatus Goods Issue Status Show values
ServiceDocItemBillingStatus Billing Status Show values
SrvcDocItmIsReleasedForBilling Billing Release Status Show values
ServiceDocumentItemIsRejected Cancellation Status Show values
ServiceDocumentItemIsOpen Status "Open" Show values
QuotationIsAccepted Acceptance Status Show values
ServiceReferenceObjectType Object Type for Reference Object in Subject Set Show values
SrvcRefObjIsMainObject Main Reference Object Show values
Column Name Description Domain name
ServiceDocumentUUID GUID of a CRM Order Object SYSUUID
ServiceDocumentCharUUID 32 Character CRM Object GUID (Converted)
ServiceDocumentDescription Transaction Description CRM_PROCESS_DESCRIPTION
PurchaseOrderByCustomer Sold-To Party's External Reference Number TEXT35
ServiceDocChangedDateTime Changed At TZNTSTMPS
ServiceDocCreationDateTime Created At TZNTSTMPS
ServiceDocumentItemUUID GUID of a CRM Order Object SYSUUID
ServiceDocumentItemCharUUID 32 Character CRM Object GUID (Converted)
ParentServiceDocumentItemUUID GUID of a CRM Order Object SYSUUID
ProfitCenter Profit Center PRCTR
ControllingArea Controlling Area CACCD
OriginallyRequestedProduct Product Name Entered CRM_ORDERED_PROD
Product Product Number MATNR
PlannedServiceStartDateTime Service Planned From Date TZNTSTMPS
PlannedServiceEndDateTime Service Planned To Date TZNTSTMPS
SrvcDocItmOrdToBaseQtyNmrtr Numerator (factor) for conversion trans. quantity in BME CRM_PROCESS_QTY_NUM
SrvcDocItmOrdToBaseQtyDnmntr Denominator (factor) for conversion trans. quantity in BME CRM_PROCESS_QTY_DEN
OrderToBaseQuantityExponent 10 Exponent for Quantity Conversion CRM_EXPONENT10
AccountingExchangeRate Exchange Rate CRM_EXCHG_RATE
SalesOrganizationOrgUnitID Sales Organization ID HROBJEC_14
SalesOfficeOrgUnitID Sales Office HROBJEC_14
SalesGroupOrgUnitID Sales Group HROBJEC_14
ServiceOrganization Service Organization HROBJEC_14
ResponsibleSalesOrganization Organizational Unit (Sales) HROBJEC_14
ResponsibleServiceOrganization Organizational Unit (Service) HROBJEC_14
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
ProductHierarchy Product Category COM_CATEGORY_ID
ServiceRefObjectSequenceNumber Reference Object Counter NUMC8
ServiceReferenceObjectUUID GUID of a CRM Order Object SYSUUID
ProductUUID Internal Key for Product SYSUUID
SerialNumber Serial Number GERNR
FunctionalLocation Functional Location TPLNR
ServiceDocumentRelationUUID Object Relationship Service : GUID binary link SYSUUID_22
ServiceDocRltnSequenceNumber Sequential Number of Segment in IDoc Type NUM4
ServiceDocumentPredecessorUUID GUID of a CRM Order Object SYSUUID
ServiceDocPrdcssrBusObjType Object Type OJ_NAME
SrvcContrPredecessorUUID GUID of a CRM Order Object SYSUUID
SrvcContrPrdcssrBusObjType Object Type OJ_NAME
ServiceDocumentItmRelationUUID Object Relationship Service : GUID binary link SYSUUID_22
ServiceDocItmRltnSqncNumber Sequential Number of Segment in IDoc Type NUM4
ServiceDocItmPrdcssrCharUUID 32 Character CRM Object GUID SYSUUID_C
SrvcContrItmPrdcssrCharUUID 32 Character CRM Object GUID SYSUUID_C
Master Data Relations Join Conditions
Customer Group 1
  • Client
  • Customer Group 1
  • C_SERVICEORDERITEMDEX.MANDT == TVV1.MANDT
  • C_SERVICEORDERITEMDEX.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
Customer Group 2
  • Client
  • Customer Group 2
  • C_SERVICEORDERITEMDEX.MANDT == TVV2.MANDT
  • C_SERVICEORDERITEMDEX.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
Customer Group 3
  • Client
  • Customer Group 3
  • C_SERVICEORDERITEMDEX.MANDT == TVV3.MANDT
  • C_SERVICEORDERITEMDEX.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
Customer Group 4
  • Client
  • Customer Group 4
  • C_SERVICEORDERITEMDEX.MANDT == TVV4.MANDT
  • C_SERVICEORDERITEMDEX.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
Customer Group 5
  • Client
  • Customer Group 5
  • C_SERVICEORDERITEMDEX.MANDT == TVV5.MANDT
  • C_SERVICEORDERITEMDEX.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
Accounting Indicator
  • Client
  • Accounting Indicator
  • C_SERVICEORDERITEMDEX.MANDT == TBMOT.MANDT
  • C_SERVICEORDERITEMDEX.BILLABLECONTROL == TBMOT.BEMOT
Business Partner: Billing Block Reason
  • Client
  • Business Partner: Billing Block Reason
  • C_SERVICEORDERITEMDEX.MANDT == TVFS.MANDT
  • C_SERVICEORDERITEMDEX.BILLINGBLOCKREASON == TVFS.FAKSP
Activity Category (Communication Type)
  • Client
  • Activity Category (Communication Type)
Customer Contact Person
  • Client
  • Customer Contact Person
  • C_SERVICEORDERITEMDEX.MANDT == BUT000.CLIENT
  • C_SERVICEORDERITEMDEX.CONTACTPERSON == BUT000.PARTNER
Customer Group
  • Client
  • Customer Group
  • C_SERVICEORDERITEMDEX.MANDT == T151.MANDT
  • C_SERVICEORDERITEMDEX.CUSTOMERGROUP == T151.KDGRP
Distribution Channel
  • Client
  • Distribution Channel
  • C_SERVICEORDERITEMDEX.MANDT == TVTW.MANDT
  • C_SERVICEORDERITEMDEX.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Division
  • Client
  • C_SERVICEORDERITEMDEX.DIVISION == TSPA.SPART
  • C_SERVICEORDERITEMDEX.MANDT == TSPA.MANDT
Equipment Number
  • Client
  • Equipment Number
  • C_SERVICEORDERITEMDEX.MANDT == EQUI.MANDT
  • C_SERVICEORDERITEMDEX.EQUIPMENT == EQUI.EQUNR
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • C_SERVICEORDERITEMDEX.MANDT == TCURV.MANDT
  • C_SERVICEORDERITEMDEX.EXCHANGERATETYPE == TCURV.KURST
Material Price Group
  • Material Price Group
  • Material Price Group
  • Client
  • C_SERVICEORDERITEMDEX.PRODUCTGROUP == T178.KONDM
  • C_SERVICEORDERITEMDEX.SRVCMATERIALPRICINGGROUP == T178.KONDM
  • C_SERVICEORDERITEMDEX.MANDT == T178.MANDT
Material Group 1
  • Client
  • Material Group 1
  • C_SERVICEORDERITEMDEX.MANDT == TVM1.MANDT
  • C_SERVICEORDERITEMDEX.PRODUCTGROUP1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • C_SERVICEORDERITEMDEX.MANDT == TVM2.MANDT
  • C_SERVICEORDERITEMDEX.PRODUCTGROUP2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • C_SERVICEORDERITEMDEX.MANDT == TVM3.MANDT
  • C_SERVICEORDERITEMDEX.PRODUCTGROUP3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • C_SERVICEORDERITEMDEX.MANDT == TVM4.MANDT
  • C_SERVICEORDERITEMDEX.PRODUCTGROUP4 == TVM4.MVGR4
Material Group 5
  • Material Group 5
  • Client
  • C_SERVICEORDERITEMDEX.PRODUCTGROUP5 == TVM5.MVGR5
  • C_SERVICEORDERITEMDEX.MANDT == TVM5.MANDT
Material Number
  • Client
  • Product Number
  • Material Number
  • C_SERVICEORDERITEMDEX.MANDT == MARA.MANDT
  • C_SERVICEORDERITEMDEX.PRODUCT == MARA.MATNR
  • C_SERVICEORDERITEMDEX.PRODUCTID == MARA.MATNR
Recommended Priority
  • Client
  • Recommended Priority
  • C_SERVICEORDERITEMDEX.MANDT == SCPRIO.CLIENT
  • C_SERVICEORDERITEMDEX.RECOMMENDEDSERVICEPRIORITY == SCPRIO.PRIORITY
Employee Responsible
  • Client
  • Employee Responsible
  • C_SERVICEORDERITEMDEX.MANDT == BUT000.CLIENT
  • C_SERVICEORDERITEMDEX.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
Item Category
  • Client
  • Item Category
Unit of Measure in Which the Product Is Sold
  • Unit of Measure in Which the Product Is Sold
  • Client
  • C_SERVICEORDERITEMDEX.SERVICEDOCITEMQUANTITYUNIT == T006.MSEHI
  • C_SERVICEORDERITEMDEX.MANDT == T006.MANDT
Impact
  • Client
  • Impact
CRM Item Object Type C_SERVICEORDERITEMDEX.SERVICEDOCUMENTITEMOBJECTTYPE == CRMC_SUBOB_CAT_I.SUBOBJ_CATEGORY
Activity Priority
  • Client
  • Activity Priority
  • C_SERVICEORDERITEMDEX.MANDT == SCPRIO.CLIENT
  • C_SERVICEORDERITEMDEX.SERVICEDOCUMENTITEMPRIORITY == SCPRIO.PRIORITY
Problem Category
  • Client
  • Problem Category
Business Transaction Type
  • Business Transaction Type
  • Client
Urgency
  • Client
  • Urgency
Business Trans. Cat. C_SERVICEORDERITEMDEX.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Risk
  • Client
  • Risk
Service Team
  • Client
  • Service Team
  • C_SERVICEORDERITEMDEX.MANDT == BUT000.CLIENT
  • C_SERVICEORDERITEMDEX.SERVICETEAM == BUT000.PARTNER
Sold-To Party
  • Client
  • Sold-To Party
  • C_SERVICEORDERITEMDEX.MANDT == BUT000.CLIENT
  • C_SERVICEORDERITEMDEX.SOLDTOPARTY == BUT000.PARTNER
Country/Region
  • Client
  • Country/Region
  • C_SERVICEORDERITEMDEX.MANDT == T005.MANDT
  • C_SERVICEORDERITEMDEX.SOLDTOPARTYCOUNTRY == T005.LAND1
Region (State, Province, County)
  • Region (State, Province, County)
  • Client
  • Country/Region
  • C_SERVICEORDERITEMDEX.SOLDTOPARTYREGION == T005S.BLAND
  • C_SERVICEORDERITEMDEX.MANDT == T005S.MANDT
  • C_SERVICEORDERITEMDEX.SOLDTOPARTYCOUNTRY == T005S.LAND1
Base Unit of Measure of Product
  • Base Unit of Measure of Product
  • Client
  • C_SERVICEORDERITEMDEX.SRVCDOCITEMBASEQUANTITYUNIT == T006.MSEHI
  • C_SERVICEORDERITEMDEX.MANDT == T006.MANDT
Material Price Group
  • Material Price Group
  • Material Price Group
  • Client
  • C_SERVICEORDERITEMDEX.PRODUCTGROUP == T178.KONDM
  • C_SERVICEORDERITEMDEX.SRVCMATERIALPRICINGGROUP == T178.KONDM
  • C_SERVICEORDERITEMDEX.MANDT == T178.MANDT
Reference Currency
  • Client
  • Reference Currency
  • C_SERVICEORDERITEMDEX.MANDT == TCURC.MANDT
  • C_SERVICEORDERITEMDEX.STATISTICSCURRENCY == TCURC.WAERS
Currency
  • Client
  • Currency
  • C_SERVICEORDERITEMDEX.MANDT == TCURC.MANDT
  • C_SERVICEORDERITEMDEX.TRANSACTIONCURRENCY == TCURC.WAERS