I_BusSolnOrderSrvcItmSitn

Solution Order Service Item Situation | view: ISOLOSRVITMSITN | TRAN | Extraction: Not supported | Component: S4CRM: Solution Order
Tables used: CRMS4D_SERV_I, CRMD_BRELVONAI, SCAPPTSEG, CRMS4D_ITEM_REL, SCAPTTXT
Column Name Description
BusinessSolutionOrder Transaction ID
BusinessSolutionOrderItem Shortened Item Number in Document
BusSolnOrdRelatedItem Shortened Item Number in Document
Column Name Description
Column Name Description
Column Name Description
PlannedServiceStartDate null
PlannedServiceEndDate null
ServiceContractItemStartDate null
Column Name Description
ServiceDocumentItemStatus Life Cycle Status Show values
Column Name Description Domain name
ServiceDocumentItemCharUUID 32 Character CRM Object GUID (Converted)
SuccessorReferenceDocument Transaction ID CRM_OBJECT_ID
BusSolnOrderItemCharUUID 32 Character CRM Object GUID (Converted)
ServiceDocumentItemUUID GUID of a CRM Order Object SYSUUID
PlannedServiceStartDateTime Service Planned From Date TZNTSTMPS
PlannedServiceEndDateTime Service Planned To Date TZNTSTMPS
LtstConfirmedDeliveryDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
BusSolnOrdReltdPlndStrtDteTme Service Planned From Date TZNTSTMPS
BusSolnOrdReltdPlndEndDteTme Service Planned To Date TZNTSTMPS
ServiceContrItemStartDateTime Contract Start date DEC15
SrvcDocApptEndDateTime Time Stamp (UTC) of Start Time of Appointment TZNTSTMPS
SrvcDocApptStartDateTime Time Stamp (UTC) of Start Time of Appointment TZNTSTMPS
BusSolnOrdItemIsTargetItem null
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
SalesOfficeOrgUnitID Sales Office HROBJEC_14
SalesOrganizationOrgUnitID Sales Organization ID HROBJEC_14
SalesGroupOrgUnitID Sales Group HROBJEC_14
ServiceOrganization Service Organization HROBJEC_14
Master Data Relations Join Conditions
CRM Item Object Type
  • CRM Item Object Type
  • CRM Item Object Type
  • I_BUSSOLNORDERSRVCITMSITN.BUSSOLNORDRELTDITMOBJECTTYPE == CRMC_SUBOB_CAT_I.SUBOBJ_CATEGORY
  • I_BUSSOLNORDERSRVCITMSITN.SERVICEDOCUMENTITEMOBJECTTYPE == CRMC_SUBOB_CAT_I.SUBOBJ_CATEGORY
Distribution Channel
  • Client
  • Distribution Channel
  • I_BUSSOLNORDERSRVCITMSITN.MANDT == TVTW.MANDT
  • I_BUSSOLNORDERSRVCITMSITN.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • I_BUSSOLNORDERSRVCITMSITN.MANDT == TSPA.MANDT
  • I_BUSSOLNORDERSRVCITMSITN.DIVISION == TSPA.SPART
Employee Responsible
  • Client
  • Employee Responsible
  • I_BUSSOLNORDERSRVCITMSITN.MANDT == BUT000.CLIENT
  • I_BUSSOLNORDERSRVCITMSITN.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
Business Trans. Cat.
  • Business Trans. Cat.
  • Business Trans. Cat.
  • I_BUSSOLNORDERSRVCITMSITN.SERVICEDOCSUCCESSORBUSOBJTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
  • I_BUSSOLNORDERSRVCITMSITN.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
CRM Item Object Type
  • CRM Item Object Type
  • CRM Item Object Type
  • I_BUSSOLNORDERSRVCITMSITN.BUSSOLNORDRELTDITMOBJECTTYPE == CRMC_SUBOB_CAT_I.SUBOBJ_CATEGORY
  • I_BUSSOLNORDERSRVCITMSITN.SERVICEDOCUMENTITEMOBJECTTYPE == CRMC_SUBOB_CAT_I.SUBOBJ_CATEGORY
Business Transaction Type
  • Client
  • Business Transaction Type
Executing Service Employee
  • Client
  • Executing Service Employee
  • I_BUSSOLNORDERSRVCITMSITN.MANDT == BUT000.CLIENT
  • I_BUSSOLNORDERSRVCITMSITN.SERVICEEMPLOYEE == BUT000.PARTNER
Business Trans. Cat.
  • Business Trans. Cat.
  • Business Trans. Cat.
  • I_BUSSOLNORDERSRVCITMSITN.SERVICEDOCSUCCESSORBUSOBJTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
  • I_BUSSOLNORDERSRVCITMSITN.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY