C_ServiceContractItemDEX

Data Extraction for Service Contract | view: CSRVCCONTRITMDEX | TRAN | Extraction: Full or Incremental | Component: S4CRM: BI Data Exchange
Tables used: CRMS4D_SERV_H, CRMS4D_SERV_I, CRMD_BRELVONAI, 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
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
ServiceDocumentItemStatus Life Cycle Status Show values
ServiceDocumentItemIsReleased Release 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
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
SrvcDocItmPostingDateTime Posting Date TZNTSTMPS
SrvcDocItmValdtyStartDateTime Time Dependency: Validity Start Date TZNTSTMPS
SrvcDocItmValdtyEndDateTime Time Dependency: Validity End Date TZNTSTMPS
ProfitCenter Profit Center PRCTR
ControllingArea Controlling Area CACCD
OriginallyRequestedProduct Product Name Entered CRM_ORDERED_PROD
Product Product Number MATNR
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
ServiceContrItemStartDateTime Contract Start date DEC15
ServiceContrItemEndDateTime Contract End Date DEC15
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
SrvcQtanPredecessorUUID GUID of a CRM Order Object SYSUUID
ServiceDocumentItmRelationUUID Object Relationship Service : GUID binary link SYSUUID_22
ServiceDocItmRltnSqncNumber Sequential Number of Segment in IDoc Type NUM4
SrvcQtanItmPrdcssrCharUUID 32 Character CRM Object GUID SYSUUID_C
Master Data Relations Join Conditions
Customer Group 1
  • Client
  • Customer Group 1
  • C_SERVICECONTRACTITEMDEX.MANDT == TVV1.MANDT
  • C_SERVICECONTRACTITEMDEX.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
Customer Group 2
  • Customer Group 2
  • Client
  • C_SERVICECONTRACTITEMDEX.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • C_SERVICECONTRACTITEMDEX.MANDT == TVV2.MANDT
Customer Group 3
  • Client
  • Customer Group 3
  • C_SERVICECONTRACTITEMDEX.MANDT == TVV3.MANDT
  • C_SERVICECONTRACTITEMDEX.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
Customer Group 4
  • Customer Group 4
  • Client
  • C_SERVICECONTRACTITEMDEX.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
  • C_SERVICECONTRACTITEMDEX.MANDT == TVV4.MANDT
Customer Group 5
  • Customer Group 5
  • Client
  • C_SERVICECONTRACTITEMDEX.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
  • C_SERVICECONTRACTITEMDEX.MANDT == TVV5.MANDT
Accounting Indicator
  • Accounting Indicator
  • Client
  • C_SERVICECONTRACTITEMDEX.BILLABLECONTROL == TBMOT.BEMOT
  • C_SERVICECONTRACTITEMDEX.MANDT == TBMOT.MANDT
Business Partner: Billing Block Reason
  • Business Partner: Billing Block Reason
  • Client
  • C_SERVICECONTRACTITEMDEX.BILLINGBLOCKREASON == TVFS.FAKSP
  • C_SERVICECONTRACTITEMDEX.MANDT == TVFS.MANDT
Bill-To Party
  • Bill-To Party
  • Client
  • C_SERVICECONTRACTITEMDEX.BILLTOPARTY == BUT000.PARTNER
  • C_SERVICECONTRACTITEMDEX.MANDT == BUT000.CLIENT
Activity Category (Communication Type)
  • Activity Category (Communication Type)
  • Client
Customer Contact Person
  • Client
  • Customer Contact Person
  • C_SERVICECONTRACTITEMDEX.MANDT == BUT000.CLIENT
  • C_SERVICECONTRACTITEMDEX.CONTACTPERSON == BUT000.PARTNER
Customer Group
  • Customer Group
  • Client
  • C_SERVICECONTRACTITEMDEX.CUSTOMERGROUP == T151.KDGRP
  • C_SERVICECONTRACTITEMDEX.MANDT == T151.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • C_SERVICECONTRACTITEMDEX.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_SERVICECONTRACTITEMDEX.MANDT == TVTW.MANDT
Division
  • Division
  • Client
  • C_SERVICECONTRACTITEMDEX.DIVISION == TSPA.SPART
  • C_SERVICECONTRACTITEMDEX.MANDT == TSPA.MANDT
Equipment Number
  • Equipment Number
  • Client
  • C_SERVICECONTRACTITEMDEX.EQUIPMENT == EQUI.EQUNR
  • C_SERVICECONTRACTITEMDEX.MANDT == EQUI.MANDT
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • C_SERVICECONTRACTITEMDEX.MANDT == TCURV.MANDT
  • C_SERVICECONTRACTITEMDEX.EXCHANGERATETYPE == TCURV.KURST
Payer
  • Payer
  • Client
  • C_SERVICECONTRACTITEMDEX.PAYERPARTY == BUT000.PARTNER
  • C_SERVICECONTRACTITEMDEX.MANDT == BUT000.CLIENT
Terms of Payment
  • Terms of Payment
  • ?
  • Client
  • C_SERVICECONTRACTITEMDEX.PAYMENTTERMS == T052.ZTERM
  • C_SERVICECONTRACTITEMDEX.[column in domain "DZTAGG_052"] == T052.ZTAGG
  • C_SERVICECONTRACTITEMDEX.MANDT == T052.MANDT
Material Group 1
  • Material Group 1
  • Client
  • C_SERVICECONTRACTITEMDEX.PRODUCTGROUP1 == TVM1.MVGR1
  • C_SERVICECONTRACTITEMDEX.MANDT == TVM1.MANDT
Material Group 2
  • Client
  • Material Group 2
  • C_SERVICECONTRACTITEMDEX.MANDT == TVM2.MANDT
  • C_SERVICECONTRACTITEMDEX.PRODUCTGROUP2 == TVM2.MVGR2
Material Group 3
  • Material Group 3
  • Client
  • C_SERVICECONTRACTITEMDEX.PRODUCTGROUP3 == TVM3.MVGR3
  • C_SERVICECONTRACTITEMDEX.MANDT == TVM3.MANDT
Material Group 4
  • Material Group 4
  • Client
  • C_SERVICECONTRACTITEMDEX.PRODUCTGROUP4 == TVM4.MVGR4
  • C_SERVICECONTRACTITEMDEX.MANDT == TVM4.MANDT
Material Group 5
  • Client
  • Material Group 5
  • C_SERVICECONTRACTITEMDEX.MANDT == TVM5.MANDT
  • C_SERVICECONTRACTITEMDEX.PRODUCTGROUP5 == TVM5.MVGR5
Material Number
  • Client
  • Product Number
  • Material Number
  • C_SERVICECONTRACTITEMDEX.MANDT == MARA.MANDT
  • C_SERVICECONTRACTITEMDEX.PRODUCT == MARA.MATNR
  • C_SERVICECONTRACTITEMDEX.PRODUCTID == MARA.MATNR
Recommended Priority
  • Client
  • Recommended Priority
  • C_SERVICECONTRACTITEMDEX.MANDT == SCPRIO.CLIENT
  • C_SERVICECONTRACTITEMDEX.RECOMMENDEDSERVICEPRIORITY == SCPRIO.PRIORITY
Employee Responsible
  • Employee Responsible
  • Client
  • C_SERVICECONTRACTITEMDEX.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
  • C_SERVICECONTRACTITEMDEX.MANDT == BUT000.CLIENT
Item Category
  • Item Category
  • Client
Unit of Measure in Which the Product Is Sold
  • Unit of Measure in Which the Product Is Sold
  • Client
  • C_SERVICECONTRACTITEMDEX.SERVICEDOCITEMQUANTITYUNIT == T006.MSEHI
  • C_SERVICECONTRACTITEMDEX.MANDT == T006.MANDT
Cancellation Reason Code
  • Cancellation Reason Code
  • Client
  • C_SERVICECONTRACTITEMDEX.SERVICEDOCITEMREJECTIONREASON == TVAG.ABGRU
  • C_SERVICECONTRACTITEMDEX.MANDT == TVAG.MANDT
Cancelling Party
  • Cancelling Party
  • Client
  • C_SERVICECONTRACTITEMDEX.SERVICEDOCUMENTITEMCANCLNPARTY == CRMC_PARTY.CANC_PARTY
  • C_SERVICECONTRACTITEMDEX.MANDT == CRMC_PARTY.CLIENT
CRM Item Object Type C_SERVICECONTRACTITEMDEX.SERVICEDOCUMENTITEMOBJECTTYPE == CRMC_SUBOB_CAT_I.SUBOBJ_CATEGORY
Activity Priority
  • Activity Priority
  • Client
  • C_SERVICECONTRACTITEMDEX.SERVICEDOCUMENTITEMPRIORITY == SCPRIO.PRIORITY
  • C_SERVICECONTRACTITEMDEX.MANDT == SCPRIO.CLIENT
CRM Service : Reason for Cancellation
  • CRM Service : Reason for Cancellation
  • Client
Business Transaction Type
  • Business Transaction Type
  • Client
Executing Service Employee
  • Client
  • Executing Service Employee
  • C_SERVICECONTRACTITEMDEX.MANDT == BUT000.CLIENT
  • C_SERVICECONTRACTITEMDEX.SERVICEEMPLOYEE == BUT000.PARTNER
Business Trans. Cat.
  • Business Trans. Cat.
  • Business Trans. Cat.
  • C_SERVICECONTRACTITEMDEX.SRVCQTANPRDCSSRBUSOBJTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
  • C_SERVICECONTRACTITEMDEX.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Service Team
  • Service Team
  • Client
  • C_SERVICECONTRACTITEMDEX.SERVICETEAM == BUT000.PARTNER
  • C_SERVICECONTRACTITEMDEX.MANDT == BUT000.CLIENT
Ship-To Party
  • Ship-To Party
  • Client
  • C_SERVICECONTRACTITEMDEX.SHIPTOPARTY == BUT000.PARTNER
  • C_SERVICECONTRACTITEMDEX.MANDT == BUT000.CLIENT
Sold-To Party
  • Sold-To Party
  • Client
  • C_SERVICECONTRACTITEMDEX.SOLDTOPARTY == BUT000.PARTNER
  • C_SERVICECONTRACTITEMDEX.MANDT == BUT000.CLIENT
Country/Region
  • Country/Region
  • Client
  • C_SERVICECONTRACTITEMDEX.SOLDTOPARTYCOUNTRY == T005.LAND1
  • C_SERVICECONTRACTITEMDEX.MANDT == T005.MANDT
Region (State, Province, County)
  • Country/Region
  • Client
  • Region (State, Province, County)
  • C_SERVICECONTRACTITEMDEX.SOLDTOPARTYCOUNTRY == T005S.LAND1
  • C_SERVICECONTRACTITEMDEX.MANDT == T005S.MANDT
  • C_SERVICECONTRACTITEMDEX.SOLDTOPARTYREGION == T005S.BLAND
Base Unit of Measure of Product
  • Base Unit of Measure of Product
  • Client
  • C_SERVICECONTRACTITEMDEX.SRVCDOCITEMBASEQUANTITYUNIT == T006.MSEHI
  • C_SERVICECONTRACTITEMDEX.MANDT == T006.MANDT
Cancellation Procedure
  • Cancellation Procedure
  • Client
  • C_SERVICECONTRACTITEMDEX.SRVCDOCITMCANCLNPROCEDURE == CRMC_CANCPROC.CANCPROC
  • C_SERVICECONTRACTITEMDEX.MANDT == CRMC_CANCPROC.CLIENT
Material Price Group
  • Material Price Group
  • Client
  • C_SERVICECONTRACTITEMDEX.SRVCMATERIALPRICINGGROUP == T178.KONDM
  • C_SERVICECONTRACTITEMDEX.MANDT == T178.MANDT
Business Trans. Cat.
  • Business Trans. Cat.
  • Business Trans. Cat.
  • C_SERVICECONTRACTITEMDEX.SRVCQTANPRDCSSRBUSOBJTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
  • C_SERVICECONTRACTITEMDEX.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Reference Currency
  • Reference Currency
  • Client
  • C_SERVICECONTRACTITEMDEX.STATISTICSCURRENCY == TCURC.WAERS
  • C_SERVICECONTRACTITEMDEX.MANDT == TCURC.MANDT
Currency
  • Currency
  • Client
  • C_SERVICECONTRACTITEMDEX.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_SERVICECONTRACTITEMDEX.MANDT == TCURC.MANDT