C_SrvcContrItmSettlmtPerdQ

Service Contracts - Flexible Analysis | view: CSRVCCONTRSETL | Extraction: Not supported | Component: S4CRM: Analytics
Column Name Description
ServiceContract Transaction ID
ServiceContractItem Shortened Item Number in Document
BillingRequestItem Billing Request Item No
Column Name Description
💲 null (DisplayCurrency):
BillgReqItemNetAmount null
SrvcContrItmSettlmtPerdBlldAmt null
BillgDocReqItemNetAmount null
Column Name Description
Column Name Description
BillingDocumentDate Billing Date
SettlementStartDate Created On
SettlementEndDate Created On
Column Name Description
ServiceContractItemIsCanceled Cancellation Status Show values
ServiceContrItemBillingStatus Billing Status Show values
ServiceContractItemStatus Life Cycle Status Show values
BillgDocReqBillgSts Billing Document Request Status Show values
OverallBillingStatus SD Billing Status Show values
BillgReqItemBillingStatus Settlement Status of Billing Request Line Show values
Column Name Description Domain name
ServiceDocumentItemDescription Product Description CRM_PRSHTEXT40_DB
SrvcContrItmHasInvoiceDue null
ServiceContractItemProduct Product Number MATNR
RefBusinessSolutionOrder Reference Solution Order ID CRM_OBJECT_ID
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
SalesOrganization Sales Organization VKORG
NrOfBillgReqItmsWithInvoiceDue null
BillingDocumentRequestItem Billing Document Request Item POSNR
BillingDocumentItem Billing Item POSNR
SrvcContrItemBillgBlockReason Business Partner: Billing Block Reason FAKSP
SrvcContrItemHasBillingBlock null
ProfitCenter Profit Center PRCTR
PurchaseOrderByCustomer Sold-To Party's External Reference Number TEXT35
ControllingArea Controlling Area CACCD
Master Data Relations Join Conditions
Distribution Channel
  • Client
  • Distribution Channel
  • C_SRVCCONTRITMSETTLMTPERDQ.MANDT == TVTW.MANDT
  • C_SRVCCONTRITMSETTLMTPERDQ.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • C_SRVCCONTRITMSETTLMTPERDQ.MANDT == TSPA.MANDT
  • C_SRVCCONTRITMSETTLMTPERDQ.DIVISION == TSPA.SPART
Employee Responsible
  • Client
  • Employee Responsible
  • C_SRVCCONTRITMSETTLMTPERDQ.MANDT == BUT000.CLIENT
  • C_SRVCCONTRITMSETTLMTPERDQ.RESPEMPLOYEEBUSINESSPARTNERID == BUT000.PARTNER
Sold-To Party
  • Client
  • Sold-To Party
  • C_SRVCCONTRITMSETTLMTPERDQ.MANDT == BUT000.CLIENT
  • C_SRVCCONTRITMSETTLMTPERDQ.SOLDTOPARTY == BUT000.PARTNER