P_SrvcContrItmSettlmtInvcDets

Service Contract Item Invoice Details | view: PSCITMINVDT | 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
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
BillingDocumentDate Billing Date
SettlementStartDate Created On
SettlementEndDate Created On
BillgReqItemBillingDate Created On
ServiceContractItemStartDate null
ServiceContractItemEndDate null
ServiceDocItemCreationDate Created On
Column Name Description
OverallBillingStatus SD Billing Status Show values
ServiceContrItemBillingStatus Billing Status Show values
BillgReqItemBillingStatus Settlement Status of Billing Request Line Show values
BillgDocReqBillgSts Billing Document Request Status Show values
ServiceContractItemStatus Life Cycle Status Show values
SDDocumentCategory SD Document Category Show values
ReferenceSDDocumentCategory Reference Document Category Show values
Column Name Description Domain name
BillingDocumentItem Billing Item POSNR
ServiceContractDescription Transaction Description CRM_PROCESS_DESCRIPTION
ServiceContractItemProduct Product Number MATNR
ServiceContractItemIsCanceled null
SrvcContrItemBillgBlockReason Business Partner: Billing Block Reason FAKSP
BillingDocumentRequestItem Billing Document Request Item POSNR
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
BillingDocumentItemText Short text for sales order item TEXT40
ReferenceSDDocument Document number of the reference document VBELN
Master Data Relations Join Conditions
Billing Type
  • Client
  • Billing Type
  • P_SRVCCONTRITMSETTLMTINVCDETS.MANDT == TVFK.MANDT
  • P_SRVCCONTRITMSETTLMTINVCDETS.BILLINGDOCUMENTTYPE == TVFK.FKART
Distribution Channel
  • Client
  • Distribution Channel
  • P_SRVCCONTRITMSETTLMTINVCDETS.MANDT == TVTW.MANDT
  • P_SRVCCONTRITMSETTLMTINVCDETS.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • P_SRVCCONTRITMSETTLMTINVCDETS.MANDT == TSPA.MANDT
  • P_SRVCCONTRITMSETTLMTINVCDETS.DIVISION == TSPA.SPART
Employee Responsible
  • Client
  • Employee Responsible
  • P_SRVCCONTRITMSETTLMTINVCDETS.MANDT == BUT000.CLIENT
  • P_SRVCCONTRITMSETTLMTINVCDETS.RESPEMPLOYEEBUSINESSPARTNERID == BUT000.PARTNER
Business Transaction Type
  • Client
  • Business Transaction Type
  • P_SRVCCONTRITMSETTLMTINVCDETS.MANDT == CRMC_PROC_TYPE.CLIENT
  • P_SRVCCONTRITMSETTLMTINVCDETS.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_SRVCCONTRITMSETTLMTINVCDETS.MANDT == T006.MANDT
  • P_SRVCCONTRITMSETTLMTINVCDETS.SERVICECONTRITEMQUANTITYUNIT == T006.MSEHI
Business Trans. Cat. P_SRVCCONTRITMSETTLMTINVCDETS.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Sold-To Party
  • Client
  • Sold-To Party
  • P_SRVCCONTRITMSETTLMTINVCDETS.MANDT == BUT000.CLIENT
  • P_SRVCCONTRITMSETTLMTINVCDETS.SOLDTOPARTY == BUT000.PARTNER
Currency
  • Client
  • Currency
  • P_SRVCCONTRITMSETTLMTINVCDETS.MANDT == TCURC.MANDT
  • P_SRVCCONTRITMSETTLMTINVCDETS.TRANSACTIONCURRENCY == TCURC.WAERS