P_SrvcOrdItmWthSrvcContrDets

Srvc Ord Itm With Srvc Contr Details | view: PSOITMWTHCONTRDT | Extraction: Not supported | Component: S4CRM: Analytics
Tables used: SCAL_TT_DATE, CRMS4D_SERV_H, CRMS4D_SERV_I, CRMD_BRELVONAI, CRMS4D_REFOBJ, EQUI, EQUZ, IFLOT
Column Name Description
ServiceObjectType FK Business Trans. Cat.
ServiceOrder Transaction ID
ServiceDocumentItem Shortened Item Number in Document
Column Name Description
💲 Currency (TransactionCurrency):
ServiceContractItemNetAmount Net Value
SrvcOrdItmWthContrRefNetAmt Net Value
SrvcOrdItmWthoutContrRefNetAmt Net Value
InvoiceAmountInInvoiceDocCrcy Invoice Value
Column Name Description
📏 Unit of Measure in Which the Product Is Sold (ServiceOrderItemQuantityUnit):
ServiceOrderItemQuantity CRM: Order Quantity
Column Name Description
ServiceDocItemCreationDate Created On
ServiceContractItemStartDate null
ServiceContractItemEndDate null
Column Name Description
ServiceOrderItemStatus Life Cycle Status Show values
ServiceDocumentItemIsOpen Status "Open" Show values
ServiceContrItemBillingStatus Billing Status Show values
ServiceReferenceObjectType Object Type for Reference Object in Subject Set Show values
Column Name Description Domain name
ServiceOrderDescription Transaction Description CRM_PROCESS_DESCRIPTION
ServiceOrderItemCharUUID 32 Character CRM Object GUID (Converted)
ServiceOrderItemProduct Product Number MATNR
ServiceDocItemCreationDateTime Created At TZNTSTMPS
ServiceContract Transaction ID CRM_OBJECT_ID
ServiceContractDescription Transaction Description CRM_PROCESS_DESCRIPTION
ServiceContractItem Shortened Item Number in Document CRMS4_NUMBER_INT
ServiceContractItemProduct Product Number MATNR
ProfitCenter Profit Center PRCTR
ControllingArea Controlling Area CACCD
PurchaseOrderByCustomer Sold-To Party's External Reference Number TEXT35
NmbrOfFUPServiceOrderItems null
NrOfSrvcOrdItmsWthoutContrRef null
ServiceContractItemIsActive null
FunctionalLocation Functional Location TPLNR
SrvcOrdCreationQuarter Calendar Quarter NUM1
SrvcOrdCreationMonth Calendar Month NUM2
SrvcOrdCreationYear Calendar Year NUM4
CreationDateYearQuarter Year Quarter NUM5
CreationDateYearMonth Year Month NUM6
RefBusinessSolutionOrder Reference Solution Order ID CRM_OBJECT_ID
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
Master Data Relations Join Conditions
Construction type material of the object
  • Construction type material of the object
  • Client
  • P_SRVCORDITMWTHSRVCCONTRDETS.CONSTRUCTIONMATERIAL == MARA.MATNR
  • P_SRVCORDITMWTHSRVCCONTRDETS.MANDT == MARA.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • P_SRVCORDITMWTHSRVCCONTRDETS.MANDT == TVTW.MANDT
  • P_SRVCORDITMWTHSRVCCONTRDETS.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • P_SRVCORDITMWTHSRVCCONTRDETS.MANDT == TSPA.MANDT
  • P_SRVCORDITMWTHSRVCCONTRDETS.DIVISION == TSPA.SPART
Equipment Number
  • Client
  • Equipment Number
  • P_SRVCORDITMWTHSRVCCONTRDETS.MANDT == EQUI.MANDT
  • P_SRVCORDITMWTHSRVCCONTRDETS.EQUIPMENT == EQUI.EQUNR
Equipment category
  • Equipment category
  • Client
  • P_SRVCORDITMWTHSRVCCONTRDETS.EQUIPMENTCATEGORY == T370T.EQTYP
  • P_SRVCORDITMWTHSRVCCONTRDETS.MANDT == T370T.MANDT
Functional location category
  • Functional location category
  • Client
  • P_SRVCORDITMWTHSRVCCONTRDETS.FUNCTIONALLOCATIONCATEGORY == T370F.FLTYP
  • P_SRVCORDITMWTHSRVCCONTRDETS.MANDT == T370F.MANDT
Industry Sector
  • Client
  • Industry Sector
  • P_SRVCORDITMWTHSRVCCONTRDETS.MANDT == T016.MANDT
  • P_SRVCORDITMWTHSRVCCONTRDETS.INDUSTRY == T016.BRSCH
Material Number
  • Material Number
  • Client
  • P_SRVCORDITMWTHSRVCCONTRDETS.MATERIAL == MARA.MATNR
  • P_SRVCORDITMWTHSRVCCONTRDETS.MANDT == MARA.MANDT
Employee Responsible
  • Employee Responsible
  • Client
  • P_SRVCORDITMWTHSRVCCONTRDETS.RESPEMPLOYEEBUSINESSPARTNERID == BUT000.PARTNER
  • P_SRVCORDITMWTHSRVCCONTRDETS.MANDT == BUT000.CLIENT
Business Trans. Cat. P_SRVCORDITMWTHSRVCCONTRDETS.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Unit of Measure in Which the Product Is Sold
  • Unit of Measure in Which the Product Is Sold
  • Client
  • P_SRVCORDITMWTHSRVCCONTRDETS.SERVICEORDERITEMQUANTITYUNIT == T006.MSEHI
  • P_SRVCORDITMWTHSRVCCONTRDETS.MANDT == T006.MANDT
Business Transaction Type
  • Client
  • Business Transaction Type
Sold-To Party
  • Sold-To Party
  • Client
  • P_SRVCORDITMWTHSRVCCONTRDETS.SOLDTOPARTY == BUT000.PARTNER
  • P_SRVCORDITMWTHSRVCCONTRDETS.MANDT == BUT000.CLIENT
Country/Region
  • Country/Region
  • Client
  • P_SRVCORDITMWTHSRVCCONTRDETS.SOLDTOPARTYCOUNTRY == T005.LAND1
  • P_SRVCORDITMWTHSRVCCONTRDETS.MANDT == T005.MANDT
Region (State, Province, County)
  • Country/Region
  • Client
  • Region (State, Province, County)
  • P_SRVCORDITMWTHSRVCCONTRDETS.SOLDTOPARTYCOUNTRY == T005S.LAND1
  • P_SRVCORDITMWTHSRVCCONTRDETS.MANDT == T005S.MANDT
  • P_SRVCORDITMWTHSRVCCONTRDETS.SOLDTOPARTYREGION == T005S.BLAND
Type of Technical Object
  • Type of Technical Object
  • Client
  • P_SRVCORDITMWTHSRVCCONTRDETS.TECHNICALOBJECTTYPE == T370K.EQART
  • P_SRVCORDITMWTHSRVCCONTRDETS.MANDT == T370K.MANDT
Currency
  • Client
  • Currency
  • P_SRVCORDITMWTHSRVCCONTRDETS.MANDT == TCURC.MANDT
  • P_SRVCORDITMWTHSRVCCONTRDETS.TRANSACTIONCURRENCY == TCURC.WAERS