I_BusSolnOrdItemRelationships

Solution Order Item Relationships | view: ISOLOITEMRELSHPS | TRAN | Extraction: Not supported | Component: S4CRM: Solution Order
Tables used: CRMS4D_SERV_I, 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
Column Name Description
ServiceDocumentItemStatus Life Cycle Status Show values
SrvcDocItmDeliveryStatus Delivery Status Show values
Column Name Description Domain name
ServiceDocumentItemCharUUID 32 Character CRM Object GUID (Converted)
BusSolnOrdItemIsTargetItem null
BusSolnOrderItemCharUUID 32 Character CRM Object GUID (Converted)
ServiceDocumentItemUUID GUID of a CRM Order Object SYSUUID
SrvcItemRelshpType Item Relationship Type CRMS4_ITEM_RELATIONSHIP_TYPE
PlannedServiceStartDateTime Service Planned From Date TZNTSTMPS
PlannedServiceEndDateTime Service Planned To Date TZNTSTMPS
LtstConfirmedDeliveryDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
SrvcDocApptStartDateTime Time Stamp (UTC) of Start Time of Appointment TZNTSTMPS
SrvcDocApptEndDateTime Time Stamp (UTC) of Start Time of Appointment TZNTSTMPS
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
Distribution Channel
  • Client
  • Distribution Channel
  • I_BUSSOLNORDITEMRELATIONSHIPS.MANDT == TVTW.MANDT
  • I_BUSSOLNORDITEMRELATIONSHIPS.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • I_BUSSOLNORDITEMRELATIONSHIPS.MANDT == TSPA.MANDT
  • I_BUSSOLNORDITEMRELATIONSHIPS.DIVISION == TSPA.SPART
Employee Responsible
  • Employee Responsible
  • Client
  • I_BUSSOLNORDITEMRELATIONSHIPS.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
  • I_BUSSOLNORDITEMRELATIONSHIPS.MANDT == BUT000.CLIENT
CRM Item Object Type I_BUSSOLNORDITEMRELATIONSHIPS.SERVICEDOCUMENTITEMOBJECTTYPE == CRMC_SUBOB_CAT_I.SUBOBJ_CATEGORY
Business Transaction Type
  • Client
  • Business Transaction Type
  • I_BUSSOLNORDITEMRELATIONSHIPS.MANDT == CRMC_PROC_TYPE.CLIENT
  • I_BUSSOLNORDITEMRELATIONSHIPS.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
Executing Service Employee
  • Executing Service Employee
  • Client
  • I_BUSSOLNORDITEMRELATIONSHIPS.SERVICEEMPLOYEE == BUT000.PARTNER
  • I_BUSSOLNORDITEMRELATIONSHIPS.MANDT == BUT000.CLIENT
Business Trans. Cat. I_BUSSOLNORDITEMRELATIONSHIPS.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY