P_SrvcContrSettlmtBillgReqDets

Service Contract Item Billing Document Request Details | view: PSCITMBDRDT | 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
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
BillgDocReqBillgSts Billing Document Request Status Show values
ServiceContractItemStatus Life Cycle Status Show values
Column Name Description Domain name
ServiceContractDescription Transaction Description CRM_PROCESS_DESCRIPTION
ServiceContractItemProduct Product Number MATNR
SrvcContrItemBillgBlockReason Business Partner: Billing Block Reason FAKSP
ServiceContractItemIsCanceled null
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
Master Data Relations Join Conditions
Distribution Channel
  • Distribution Channel
  • Client
  • P_SRVCCONTRSETTLMTBILLGREQDETS.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • P_SRVCCONTRSETTLMTBILLGREQDETS.MANDT == TVTW.MANDT
Division
  • Client
  • Division
  • P_SRVCCONTRSETTLMTBILLGREQDETS.MANDT == TSPA.MANDT
  • P_SRVCCONTRSETTLMTBILLGREQDETS.DIVISION == TSPA.SPART
Employee Responsible
  • Employee Responsible
  • Client
  • P_SRVCCONTRSETTLMTBILLGREQDETS.RESPEMPLOYEEBUSINESSPARTNERID == BUT000.PARTNER
  • P_SRVCCONTRSETTLMTBILLGREQDETS.MANDT == BUT000.CLIENT
Business Transaction Type
  • Client
  • Business Transaction Type
  • P_SRVCCONTRSETTLMTBILLGREQDETS.MANDT == CRMC_PROC_TYPE.CLIENT
  • P_SRVCCONTRSETTLMTBILLGREQDETS.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
  • P_SRVCCONTRSETTLMTBILLGREQDETS.SERVICECONTRITEMQUANTITYUNIT == T006.MSEHI
  • P_SRVCCONTRSETTLMTBILLGREQDETS.MANDT == T006.MANDT
Business Trans. Cat. P_SRVCCONTRSETTLMTBILLGREQDETS.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Sold-To Party
  • Sold-To Party
  • Client
  • P_SRVCCONTRSETTLMTBILLGREQDETS.SOLDTOPARTY == BUT000.PARTNER
  • P_SRVCCONTRSETTLMTBILLGREQDETS.MANDT == BUT000.CLIENT
Currency
  • Currency
  • Client
  • P_SRVCCONTRSETTLMTBILLGREQDETS.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_SRVCCONTRSETTLMTBILLGREQDETS.MANDT == TCURC.MANDT