I_SrvcContrItmSettlmtPerdCube

SrvcContr Itm with Setl Period – Cube | view: ISRVCCONTRSETL | TRAN | Extraction: Not supported | Component: S4CRM: Analytics
Column Name Description
ServiceContract Transaction ID
ServiceContractItem Shortened Item Number in Document
ServiceObjectType FK Business Trans. Cat.
BillingRequestItem Billing Request Item No
Column Name Description
💲 Currency (TransactionCurrency):
BillgReqItemNetAmount Net Value
SrvcContrItmSettlmtPerdBlldAmt Net Value
BillgDocReqItemNetAmount Net Value of Billing item in Document Currency
Column Name Description
📏 Unit of Measure in Which the Product Is Sold (ServiceContrItemQuantityUnit):
ServiceContractItemQuantity CRM: Order Quantity
Column Name Description
SettlementStartDate Created On
SettlementEndDate Created On
BillingDocumentDate Billing Date
ServiceContractItemEndDate null
ServiceDocItemCreationDate Created On
Column Name Description
Column Name Description Domain name
ServiceContractItemProduct Product Number
ServiceContractItemIsCanceled Cancellation Status
ServiceContrItemBillingStatus Billing Status
SrvcContrItemBillgBlockReason Business Partner: Billing Block Reason
SrvcContrItemHasBillingBlock null
BillgReqItemBillingStatus Settlement Status of Billing Request Line
SrvcContrItmHasInvoiceDue null
NrOfBillgReqItmsWithInvoiceDue null
BillingDocumentRequestItem Billing Document Request Item
BillgDocReqBillgSts Billing Document Request Status
BillingDocumentItem Billing Item
BillingDocumentItemText Short text for sales order item TEXT40
OverallBillingStatus SD Billing Status
ProfitCenter Profit Center
ControllingArea Controlling Area CACCD
PurchaseOrderByCustomer Sold-To Party's External Reference Number
ServiceDocumentItemDescription Product Description CRM_PRSHTEXT40_DB
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
RefBusinessSolutionOrder Reference Solution Order ID
ServiceContractItemStatus Life Cycle Status
Master Data Relations Join Conditions
Distribution Channel
  • Client
  • Distribution Channel
  • I_SRVCCONTRITMSETTLMTPERDCUBE.MANDT == TVTW.MANDT
  • I_SRVCCONTRITMSETTLMTPERDCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • I_SRVCCONTRITMSETTLMTPERDCUBE.MANDT == TSPA.MANDT
  • I_SRVCCONTRITMSETTLMTPERDCUBE.DIVISION == TSPA.SPART
Employee Responsible
  • Client
  • Employee Responsible
  • I_SRVCCONTRITMSETTLMTPERDCUBE.MANDT == BUT000.CLIENT
  • I_SRVCCONTRITMSETTLMTPERDCUBE.RESPEMPLOYEEBUSINESSPARTNERID == BUT000.PARTNER
Business Transaction Type
  • Client
  • Business Transaction Type
  • I_SRVCCONTRITMSETTLMTPERDCUBE.MANDT == CRMC_PROC_TYPE.CLIENT
  • I_SRVCCONTRITMSETTLMTPERDCUBE.SERVICECONTRACTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
Unit of Measure in Which the Product Is Sold
  • Unit of Measure in Which the Product Is Sold
  • Client
  • I_SRVCCONTRITMSETTLMTPERDCUBE.SERVICECONTRITEMQUANTITYUNIT == T006.MSEHI
  • I_SRVCCONTRITMSETTLMTPERDCUBE.MANDT == T006.MANDT
Business Trans. Cat. I_SRVCCONTRITMSETTLMTPERDCUBE.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Sold-To Party
  • Client
  • Sold-To Party
  • I_SRVCCONTRITMSETTLMTPERDCUBE.MANDT == BUT000.CLIENT
  • I_SRVCCONTRITMSETTLMTPERDCUBE.SOLDTOPARTY == BUT000.PARTNER
Currency
  • Client
  • Currency
  • I_SRVCCONTRITMSETTLMTPERDCUBE.MANDT == TCURC.MANDT
  • I_SRVCCONTRITMSETTLMTPERDCUBE.TRANSACTIONCURRENCY == TCURC.WAERS