I_SrvcOrdBillgDelayedSituation

Service Order not invoiced situation | view: ISRVCINVSO | Extraction: Not supported | Component: S4CRM: Analytics
Tables used: VBRK, VBRP, CRMS4D_SERV_H, CRMS4D_SERV_I
Column Name Description
ServiceObjectType FK Business Trans. Cat.
ServiceOrder Transaction ID
ServiceDocumentItem Shortened Item Number in Document
ServiceDocumentItemUUID GUID of a CRM Order Object
BillingDocument Billing Document
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value in Document Currency
Column Name Description
Column Name Description
Column Name Description
BillingIssueType Billing Issue Type Show values
AccountingPostingStatus Posting Status of Billing Document Show values
InvoiceClearingStatus Clearing Status of Billing Document Show values
OverallBillingStatus SD Billing Status Show values
BillingDocumentIsTemporary IsDraft Indicator Show values
Column Name Description Domain name
BillingDocumentItem Billing Item POSNR
ServiceDocumentUUID GUID of a CRM Order Object SYSUUID
SrvcOrdItmBillgDocItmCmbndID Concatenation of Billing Document ID and Service Ord Itm No.
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
ResponsibleEmployeeUserID User ID XUBNAME
ServiceDocumentCreatedByUser User that Created the Transaction UNAME
NrOfDaysAfterCreationDate Number of Days After Billing Document Creation
SalesOrganizationOrgUnitID Sales Organization ID HROBJEC_14
SalesOfficeOrgUnitID Sales Office HROBJEC_14
SalesGroupOrgUnitID Sales Group HROBJEC_14
ServiceOrganization Service Organization HROBJEC_14
Master Data Relations Join Conditions
Billing Type
  • Client
  • Billing Type
  • I_SRVCORDBILLGDELAYEDSITUATION.MANDT == TVFK.MANDT
  • I_SRVCORDBILLGDELAYEDSITUATION.BILLINGDOCUMENTTYPE == TVFK.FKART
Distribution Channel
  • Client
  • Distribution Channel
  • I_SRVCORDBILLGDELAYEDSITUATION.MANDT == TVTW.MANDT
  • I_SRVCORDBILLGDELAYEDSITUATION.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • I_SRVCORDBILLGDELAYEDSITUATION.MANDT == TSPA.MANDT
  • I_SRVCORDBILLGDELAYEDSITUATION.DIVISION == TSPA.SPART
Employee Responsible
  • Client
  • Employee Responsible
  • I_SRVCORDBILLGDELAYEDSITUATION.MANDT == BUT000.CLIENT
  • I_SRVCORDBILLGDELAYEDSITUATION.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
Item Category
  • Client
  • Item Category
  • I_SRVCORDBILLGDELAYEDSITUATION.MANDT == CRMC_ITEM_TYPE.CLIENT
  • I_SRVCORDBILLGDELAYEDSITUATION.SERVICEDOCITEMCATEGORY == CRMC_ITEM_TYPE.ITM_TYPE
Business Transaction Type
  • Client
  • Business Transaction Type
  • I_SRVCORDBILLGDELAYEDSITUATION.MANDT == CRMC_PROC_TYPE.CLIENT
  • I_SRVCORDBILLGDELAYEDSITUATION.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
Business Trans. Cat. I_SRVCORDBILLGDELAYEDSITUATION.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Sold-To Party
  • Client
  • Sold-To Party
  • I_SRVCORDBILLGDELAYEDSITUATION.MANDT == BUT000.CLIENT
  • I_SRVCORDBILLGDELAYEDSITUATION.SOLDTOPARTY == BUT000.PARTNER
SD Document Currency
  • Client
  • SD Document Currency
  • I_SRVCORDBILLGDELAYEDSITUATION.MANDT == TCURC.MANDT
  • I_SRVCORDBILLGDELAYEDSITUATION.TRANSACTIONCURRENCY == TCURC.WAERS