I_SrvcOrdItemProductDets

Retrieves Items of Serv. Order for Serv. Conf. creation | view: ISRVORDITMPRODET | TRAN | Extraction: Not supported | Component: S4CRM: Service Order Fiori-UI
Tables used: CRMS4D_SERV_I, MARA, MARA, MVKE
Column Name Description
ServiceDocument Transaction ID
ServiceDocumentItem Shortened Item Number in Document
Column Name Description
Column Name Description
📏 Unit of Measure in Which the Product Is Sold (ServiceDocItemQuantityUnit):
ServiceDocumentItemQuantity CRM: Order Quantity
ParSrvcDocItemQuantity CRM: Order Quantity
Column Name Description
Column Name Description
ServiceDocumentItemIsQuotation Quotation Status Show values
SrvcOrderConfirmationRelevance Relevant for Confirmation Show values
Column Name Description Domain name
Product Product Name Entered CRM_ORDERED_PROD
ServiceDocumentItemDescription Product Description CRM_PRSHTEXT40_DB
ParentServiceDocumentItemUUID GUID of a CRM Order Object SYSUUID
ParentServiceDocumentItem Shortened Item Number in Document CRMS4_NUMBER_INT
SrvcProductListProduct Product Name Entered CRM_ORDERED_PROD
SrvcProductListProductName Product Description CRM_PRSHTEXT40_DB
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
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
Accounting Indicator
  • Accounting Indicator
  • Client
  • I_SRVCORDITEMPRODUCTDETS.BILLABLECONTROL == TBMOT.BEMOT
  • I_SRVCORDITEMPRODUCTDETS.MANDT == TBMOT.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • I_SRVCORDITEMPRODUCTDETS.MANDT == TVTW.MANDT
  • I_SRVCORDITEMPRODUCTDETS.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Division
  • Client
  • I_SRVCORDITEMPRODUCTDETS.DIVISION == TSPA.SPART
  • I_SRVCORDITEMPRODUCTDETS.MANDT == TSPA.MANDT
Item category group
  • Client
  • Item Category Group from Material Master
  • I_SRVCORDITEMPRODUCTDETS.MANDT == TPTM.MANDT
  • I_SRVCORDITEMPRODUCTDETS.ITEMCATEGORYGROUP == TPTM.MTPOS
Employee Responsible
  • Employee Responsible
  • Client
  • I_SRVCORDITEMPRODUCTDETS.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
  • I_SRVCORDITEMPRODUCTDETS.MANDT == BUT000.CLIENT
Item Category
  • Client
  • Item Category
Unit of Measure in Which the Product Is Sold
  • Client
  • Unit of Measure in Which the Product Is Sold
  • I_SRVCORDITEMPRODUCTDETS.MANDT == T006.MANDT
  • I_SRVCORDITEMPRODUCTDETS.SERVICEDOCITEMQUANTITYUNIT == T006.MSEHI
Business Transaction Type
  • Client
  • Business Transaction Type
Business Trans. Cat. I_SRVCORDITEMPRODUCTDETS.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY