P_SrvcContrItmSettlmtDetails

Service Contract Item Settlement Details | view: PSCITMSETLDT | 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):
ServiceContractItemNetAmount Net Value
BillgReqItemNetAmount Net Value
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
BillgReqItemBillingDate Created On
ServiceContractItemStartDate null
ServiceContractItemEndDate null
ServiceDocItemCreationDate Created On
Column Name Description
ServiceContrItemBillingStatus Billing Status Show values
BillgReqItemBillingStatus Settlement Status of Billing Request Line Show values
ServiceContractItemStatus Life Cycle Status Show values
Column Name Description Domain name
ServiceContractDescription Transaction Description CRM_PROCESS_DESCRIPTION
ServiceContractItemProduct Product Number MATNR
ServiceContractItemCanclnDate Contract End Date DEC15
SrvcContrItemBillgBlockReason Business Partner: Billing Block Reason FAKSP
ServiceContractItemIsActive null
SrvcContrItemHasBillingBlock null
PurchaseOrderByCustomer Sold-To Party's External Reference Number TEXT35
ProfitCenter Profit Center PRCTR
ControllingArea Controlling Area CACCD
RefBusinessSolutionOrder Reference Solution Order ID CRM_OBJECT_ID
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
ServiceDocumentItemDescription Product Description CRM_PRSHTEXT40_DB
Master Data Relations Join Conditions
Distribution Channel
  • Client
  • Distribution Channel
  • P_SRVCCONTRITMSETTLMTDETAILS.MANDT == TVTW.MANDT
  • P_SRVCCONTRITMSETTLMTDETAILS.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • P_SRVCCONTRITMSETTLMTDETAILS.MANDT == TSPA.MANDT
  • P_SRVCCONTRITMSETTLMTDETAILS.DIVISION == TSPA.SPART
Employee Responsible
  • Client
  • Employee Responsible
  • P_SRVCCONTRITMSETTLMTDETAILS.MANDT == BUT000.CLIENT
  • P_SRVCCONTRITMSETTLMTDETAILS.RESPEMPLOYEEBUSINESSPARTNERID == BUT000.PARTNER
Business Transaction Type
  • Client
  • Business Transaction Type
  • P_SRVCCONTRITMSETTLMTDETAILS.MANDT == CRMC_PROC_TYPE.CLIENT
  • P_SRVCCONTRITMSETTLMTDETAILS.SERVICECONTRACTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
Unit of Measure in Which the Product Is Sold
  • Client
  • Unit of Measure in Which the Product Is Sold
  • P_SRVCCONTRITMSETTLMTDETAILS.MANDT == T006.MANDT
  • P_SRVCCONTRITMSETTLMTDETAILS.SERVICECONTRITEMQUANTITYUNIT == T006.MSEHI
CRM Service : Reason for Cancellation
  • Client
  • CRM Service : Reason for Cancellation
  • P_SRVCCONTRITMSETTLMTDETAILS.MANDT == CRMC_CANCREASON.CLIENT
  • P_SRVCCONTRITMSETTLMTDETAILS.SERVICEDOCUMENTITMCANCLNREASON == CRMC_CANCREASON.CANC_REASON
Business Trans. Cat. P_SRVCCONTRITMSETTLMTDETAILS.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Sold-To Party
  • Client
  • Sold-To Party
  • P_SRVCCONTRITMSETTLMTDETAILS.MANDT == BUT000.CLIENT
  • P_SRVCCONTRITMSETTLMTDETAILS.SOLDTOPARTY == BUT000.PARTNER
Currency
  • Client
  • Currency
  • P_SRVCCONTRITMSETTLMTDETAILS.MANDT == TCURC.MANDT
  • P_SRVCCONTRITMSETTLMTDETAILS.TRANSACTIONCURRENCY == TCURC.WAERS