C_ServiceConfirmationItemDEX

Data Extraction for Service Confirmation | view: CSRVCCONFITMDEX | 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
ServiceDocumentItemNetAmount Net Value
ServiceDocItemGrossAmount Gross Order Value in PO Currency
Column Name Description
📏 Time Unit for Confirmed Duration (ActualServiceDurationUnit):
ActualServiceDuration Confirmed Duration
📏 Unit of Measure in Which the Product Is Sold (ServiceDocItemQuantityUnit):
SrvcDocItmRequestedQuantity Ordered Quantity
InvoiceQuantity Invoiced Quantity
SrvcDocItmDeliveredQuantity Delivered Quantity
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
ServiceDocumentHasError Error Status Show values
ServiceDocIsReleasedForBilling Release Status for Cumulated Billing Show values
ServiceDocBillingStatus Billing Status Show values
ServiceDocumentIsOpen Status "Open" Show values
ServiceDocumentItemStatus Life Cycle Status Show values
ServiceDocumentItemHasError Error Status Show values
ServiceDocItemBillingStatus Billing Status Show values
SrvcDocItmIsReleasedForBilling Billing Release Status Show values
ServiceDocumentItemIsRejected Cancellation Status Show values
ServiceDocumentItemIsOpen Status "Open" 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
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
ActualServiceStartDateTime Service Actual Start Date TZNTSTMPS
ActualServiceEndDateTime Service Actual End Date TZNTSTMPS
TimeSheetOvertimeCategory Overtime Category CATS_OVERTIME_CATEGORY
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
SrvcOrdPredecessorUUID GUID of a CRM Order Object SYSUUID
SrvcOrdPrdcssrBusObjType Object Type OJ_NAME
ServiceDocumentItmRelationUUID Object Relationship Service : GUID binary link SYSUUID_22
ServiceDocItmRltnSqncNumber Sequential Number of Segment in IDoc Type NUM4
SrvcOrdItmPrdcssrCharUUID 32 Character CRM Object GUID SYSUUID_C
Master Data Relations Join Conditions
Customer Group 1
  • Client
  • Customer Group 1
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == TVV1.MANDT
  • C_SERVICECONFIRMATIONITEMDEX.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
Customer Group 2
  • Client
  • Customer Group 2
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == TVV2.MANDT
  • C_SERVICECONFIRMATIONITEMDEX.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
Customer Group 3
  • Client
  • Customer Group 3
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == TVV3.MANDT
  • C_SERVICECONFIRMATIONITEMDEX.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
Customer Group 4
  • Client
  • Customer Group 4
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == TVV4.MANDT
  • C_SERVICECONFIRMATIONITEMDEX.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
Customer Group 5
  • Client
  • Customer Group 5
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == TVV5.MANDT
  • C_SERVICECONFIRMATIONITEMDEX.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
Accounting Indicator
  • Client
  • Accounting Indicator
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == TBMOT.MANDT
  • C_SERVICECONFIRMATIONITEMDEX.BILLABLECONTROL == TBMOT.BEMOT
Business Partner: Billing Block Reason
  • Client
  • Business Partner: Billing Block Reason
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == TVFS.MANDT
  • C_SERVICECONFIRMATIONITEMDEX.BILLINGBLOCKREASON == TVFS.FAKSP
Activity Category (Communication Type)
  • Client
  • Activity Category (Communication Type)
Customer Contact Person
  • Client
  • Customer Contact Person
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == BUT000.CLIENT
  • C_SERVICECONFIRMATIONITEMDEX.CONTACTPERSON == BUT000.PARTNER
Customer Group
  • Client
  • Customer Group
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == T151.MANDT
  • C_SERVICECONFIRMATIONITEMDEX.CUSTOMERGROUP == T151.KDGRP
Distribution Channel
  • Client
  • Distribution Channel
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == TVTW.MANDT
  • C_SERVICECONFIRMATIONITEMDEX.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == TSPA.MANDT
  • C_SERVICECONFIRMATIONITEMDEX.DIVISION == TSPA.SPART
Equipment Number
  • Client
  • Equipment Number
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == EQUI.MANDT
  • C_SERVICECONFIRMATIONITEMDEX.EQUIPMENT == EQUI.EQUNR
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == TCURV.MANDT
  • C_SERVICECONFIRMATIONITEMDEX.EXCHANGERATETYPE == TCURV.KURST
Material Price Group
  • Client
  • Material Price Group
  • Material Price Group
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == T178.MANDT
  • C_SERVICECONFIRMATIONITEMDEX.PRODUCTGROUP == T178.KONDM
  • C_SERVICECONFIRMATIONITEMDEX.SRVCMATERIALPRICINGGROUP == T178.KONDM
Material Group 1
  • Client
  • Material Group 1
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == TVM1.MANDT
  • C_SERVICECONFIRMATIONITEMDEX.PRODUCTGROUP1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == TVM2.MANDT
  • C_SERVICECONFIRMATIONITEMDEX.PRODUCTGROUP2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == TVM3.MANDT
  • C_SERVICECONFIRMATIONITEMDEX.PRODUCTGROUP3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == TVM4.MANDT
  • C_SERVICECONFIRMATIONITEMDEX.PRODUCTGROUP4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == TVM5.MANDT
  • C_SERVICECONFIRMATIONITEMDEX.PRODUCTGROUP5 == TVM5.MVGR5
Material Number
  • Client
  • Product Number
  • Material Number
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == MARA.MANDT
  • C_SERVICECONFIRMATIONITEMDEX.PRODUCT == MARA.MATNR
  • C_SERVICECONFIRMATIONITEMDEX.PRODUCTID == MARA.MATNR
Employee Responsible
  • Client
  • Employee Responsible
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == BUT000.CLIENT
  • C_SERVICECONFIRMATIONITEMDEX.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
Item Category
  • Client
  • Item Category
Unit of Measure in Which the Product Is Sold
  • Client
  • Unit of Measure in Which the Product Is Sold
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == T006.MANDT
  • C_SERVICECONFIRMATIONITEMDEX.SERVICEDOCITEMQUANTITYUNIT == T006.MSEHI
CRM Item Object Type C_SERVICECONFIRMATIONITEMDEX.SERVICEDOCUMENTITEMOBJECTTYPE == CRMC_SUBOB_CAT_I.SUBOBJ_CATEGORY
Activity Priority
  • Client
  • Activity Priority
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == SCPRIO.CLIENT
  • C_SERVICECONFIRMATIONITEMDEX.SERVICEDOCUMENTITEMPRIORITY == SCPRIO.PRIORITY
Business Transaction Type
  • Client
  • Business Transaction Type
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == CRMC_PROC_TYPE.CLIENT
  • C_SERVICECONFIRMATIONITEMDEX.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
Business Trans. Cat. C_SERVICECONFIRMATIONITEMDEX.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Service Team
  • Client
  • Service Team
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == BUT000.CLIENT
  • C_SERVICECONFIRMATIONITEMDEX.SERVICETEAM == BUT000.PARTNER
Sold-To Party
  • Client
  • Sold-To Party
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == BUT000.CLIENT
  • C_SERVICECONFIRMATIONITEMDEX.SOLDTOPARTY == BUT000.PARTNER
Country/Region
  • Client
  • Country/Region
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == T005.MANDT
  • C_SERVICECONFIRMATIONITEMDEX.SOLDTOPARTYCOUNTRY == T005.LAND1
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • Country/Region
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == T005S.MANDT
  • C_SERVICECONFIRMATIONITEMDEX.SOLDTOPARTYREGION == T005S.BLAND
  • C_SERVICECONFIRMATIONITEMDEX.SOLDTOPARTYCOUNTRY == T005S.LAND1
Base Unit of Measure of Product
  • Base Unit of Measure of Product
  • Client
  • C_SERVICECONFIRMATIONITEMDEX.SRVCDOCITEMBASEQUANTITYUNIT == T006.MSEHI
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == T006.MANDT
Material Price Group
  • Client
  • Material Price Group
  • Material Price Group
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == T178.MANDT
  • C_SERVICECONFIRMATIONITEMDEX.PRODUCTGROUP == T178.KONDM
  • C_SERVICECONFIRMATIONITEMDEX.SRVCMATERIALPRICINGGROUP == T178.KONDM
Reference Currency
  • Client
  • Reference Currency
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == TCURC.MANDT
  • C_SERVICECONFIRMATIONITEMDEX.STATISTICSCURRENCY == TCURC.WAERS
Currency
  • Client
  • Currency
  • C_SERVICECONFIRMATIONITEMDEX.MANDT == TCURC.MANDT
  • C_SERVICECONFIRMATIONITEMDEX.TRANSACTIONCURRENCY == TCURC.WAERS