C_BusSolnOrdItemRelationships

Solution Order Item Relationship | view: CSOLOITEMREL | TRAN | Extraction: Not supported | Component: S4CRM: Solution Order

Tables used: CRMS4D_SERV_I, SIT_INST, SIT_INST_QUEUE, SIT_INST_QUEUE, SCAPPTSEG, CRMS4D_ITEM_REL, CRMC_ITEM_TYPE, CRMC_ITEM_TYPE_T, SIT_DEF, SIT_T_DEF, SCAPTTXT, CRMS4S_ITEM_REL, CRMS4S_ITEM_RELT, CRMC_SALES_ITEM

🔑 Keys (4)
💰 Amounts (1)
∑ Quantities (1)
📅 Dates
☰ Categorical (1)
Other (15)
🔗 Relations (9)

Column Name	Description
BusinessSolutionOrder	Transaction ID
BusinessSolutionOrderItem	Shortened Item Number in Document
BusSolnOrdRelatedItem	Shortened Item Number in Document
BusSolnOrdItemIsTargetItem	null

Column Name	Description
💲 Currency (TransactionCurrency):
ServiceDocumentItemNetAmount	Net Value

Column Name	Description
📏 Unit of Measure in Which the Product Is Sold (ServiceDocItemQuantityUnit):
ServiceDocumentItemQuantity	CRM: Order Quantity

Column Name	Description

Column Name	Description
ServiceDocumentItemStatus	Life Cycle Status	Show values

Column Name	Description	Domain name
BusSolnOrderItemCharUUID	32 Character CRM Object GUID (Converted)
ServiceDocumentItemStatusName	Short Text for Fixed Values	DDTEXT
SrvcItemRelshpType	Item Relationship Type	CRMS4_ITEM_RELATIONSHIP_TYPE
BusSolnOrdItemRelshpTypeName	Name of Item Relationship (Forward)	TEXT50
ServiceDocumentItemDescription	Product Description	CRM_PRSHTEXT40_DB
ServiceDocItemCategoryName	Item Category Text	TEXT40
OriginallyRequestedProduct	Product Name Entered
SitnNumberOfInstances	Number of Situations	INT4
SalesOfficeOrgUnitID	Sales Office	HROBJEC_14
SalesOrganizationOrgUnitID	Sales Organization ID	HROBJEC_14
SalesGroupOrgUnitID	Sales Group	HROBJEC_14
SalesGroup	Sales group	VKGRP
SalesOffice	Sales office	VKBUR
SalesOrganization	Sales Organization	VKORG
ServiceOrganization	Service Organization	HROBJEC_14

Master Data Relations	Join Conditions
Distribution Channel Client Distribution Channel	`C_BUSSOLNORDITEMRELATIONSHIPS.MANDT == TVTW.MANDT` `C_BUSSOLNORDITEMRELATIONSHIPS.DISTRIBUTIONCHANNEL == TVTW.VTWEG`
Division Division Client	`C_BUSSOLNORDITEMRELATIONSHIPS.DIVISION == TSPA.SPART` `C_BUSSOLNORDITEMRELATIONSHIPS.MANDT == TSPA.MANDT`
Employee Responsible Client Employee Responsible	`C_BUSSOLNORDITEMRELATIONSHIPS.MANDT == BUT000.CLIENT` `C_BUSSOLNORDITEMRELATIONSHIPS.RESPONSIBLEEMPLOYEE == BUT000.PARTNER`
Item Category Item Category Client	`C_BUSSOLNORDITEMRELATIONSHIPS.SERVICEDOCITEMCATEGORY == CRMC_ITEM_TYPE.ITM_TYPE` `C_BUSSOLNORDITEMRELATIONSHIPS.MANDT == CRMC_ITEM_TYPE.CLIENT`
Unit of Measure in Which the Product Is Sold Unit of Measure in Which the Product Is Sold Client	`C_BUSSOLNORDITEMRELATIONSHIPS.SERVICEDOCITEMQUANTITYUNIT == T006.MSEHI` `C_BUSSOLNORDITEMRELATIONSHIPS.MANDT == T006.MANDT`
CRM Item Object Type	`C_BUSSOLNORDITEMRELATIONSHIPS.SERVICEDOCUMENTITEMOBJECTTYPE == CRMC_SUBOB_CAT_I.SUBOBJ_CATEGORY`
Business Transaction Type Client Business Transaction Type	`C_BUSSOLNORDITEMRELATIONSHIPS.MANDT == CRMC_PROC_TYPE.CLIENT` `C_BUSSOLNORDITEMRELATIONSHIPS.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE`
Business Trans. Cat.	`C_BUSSOLNORDITEMRELATIONSHIPS.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY`
Currency Client Currency	`C_BUSSOLNORDITEMRELATIONSHIPS.MANDT == TCURC.MANDT` `C_BUSSOLNORDITEMRELATIONSHIPS.TRANSACTIONCURRENCY == TCURC.WAERS`