I_BusSolnOrdItmBasicFinancial

Solution Order Item for Fin Reporting | view: IBUSSOLORDITMFR | ATTR | Extraction: Not supported | Component: S4CRM: Analytics
Tables used: CRMS4D_SERV_I
Column Name Description
BusinessSolutionOrder Transaction ID
BusinessSolutionOrderItem Shortened Item Number in Document
Column Name Description
💲 Currency (TransactionCurrency):
ServiceDocumentItemNetAmount Net Value
ServiceDocumentItemTaxAmount Tax amount in document currency
ServiceDocItemGrossAmount Gross Order Value in PO Currency
Column Name Description
📏 Unit of Measure in Which the Product Is Sold (ServiceDocItemQuantityUnit):
ServiceDocumentItemQuantity CRM: Order Quantity
Column Name Description
PostingDate Posting Date for a Business Transaction
Column Name Description
ServiceDocumentItemStatus Life Cycle Status Show values
Column Name Description Domain name
ServiceDocumentDescription Transaction Description CRM_PROCESS_DESCRIPTION
BusinessSolutionOrderItemUUID GUID of a CRM Order Object SYSUUID
BusinessSolutionOrderUUID GUID of a CRM Order Object SYSUUID
ParentServiceDocumentItemUUID GUID of a CRM Order Object SYSUUID
ServiceDocumentItemDescription Product Description CRM_PRSHTEXT40_DB
Language Short Text Language for an Item SYLANGU
OriginallyRequestedProduct Product Name Entered CRM_ORDERED_PROD
ProfitCenter Profit Center PRCTR
ControllingArea Controlling Area CACCD
RequestedServiceStartDateTime Service Request Start Date TZNTSTMPS
RequestedServiceEndDateTime Service Request Due Date TZNTSTMPS
ServiceContrItemStartDateTime Contract Start date DEC15
ServiceContrItemEndDateTime Contract End Date DEC15
SalesOrganizationOrgUnitID Sales Organization ID HROBJEC_14
SalesOfficeOrgUnitID Sales Office HROBJEC_14
SalesGroupOrgUnitID Sales Group HROBJEC_14
ServiceOrganization Service Organization HROBJEC_14
ResponsibleServiceOrganization Organizational Unit (Service) HROBJEC_14
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
Master Data Relations Join Conditions
Distribution Channel
  • Distribution Channel
  • Client
  • I_BUSSOLNORDITMBASICFINANCIAL.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_BUSSOLNORDITMBASICFINANCIAL.MANDT == TVTW.MANDT
Division
  • Client
  • Division
  • I_BUSSOLNORDITMBASICFINANCIAL.MANDT == TSPA.MANDT
  • I_BUSSOLNORDITMBASICFINANCIAL.DIVISION == TSPA.SPART
Employee Responsible
  • Employee Responsible
  • Client
  • I_BUSSOLNORDITMBASICFINANCIAL.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
  • I_BUSSOLNORDITMBASICFINANCIAL.MANDT == BUT000.CLIENT
Item Category
  • Client
  • Item Category
  • I_BUSSOLNORDITMBASICFINANCIAL.MANDT == CRMC_ITEM_TYPE.CLIENT
  • I_BUSSOLNORDITMBASICFINANCIAL.SERVICEDOCITEMCATEGORY == CRMC_ITEM_TYPE.ITM_TYPE
Unit of Measure in Which the Product Is Sold
  • Unit of Measure in Which the Product Is Sold
  • Client
  • I_BUSSOLNORDITMBASICFINANCIAL.SERVICEDOCITEMQUANTITYUNIT == T006.MSEHI
  • I_BUSSOLNORDITMBASICFINANCIAL.MANDT == T006.MANDT
CRM Item Object Type I_BUSSOLNORDITMBASICFINANCIAL.SERVICEDOCUMENTITEMOBJECTTYPE == CRMC_SUBOB_CAT_I.SUBOBJ_CATEGORY
Business Transaction Type
  • Business Transaction Type
  • Client
  • I_BUSSOLNORDITMBASICFINANCIAL.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • I_BUSSOLNORDITMBASICFINANCIAL.MANDT == CRMC_PROC_TYPE.CLIENT
Business Trans. Cat. I_BUSSOLNORDITMBASICFINANCIAL.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Sold-To Party
  • Sold-To Party
  • Client
  • I_BUSSOLNORDITMBASICFINANCIAL.SOLDTOPARTY == BUT000.PARTNER
  • I_BUSSOLNORDITMBASICFINANCIAL.MANDT == BUT000.CLIENT
Country/Region
  • Country/Region
  • Client
  • I_BUSSOLNORDITMBASICFINANCIAL.SOLDTOPARTYCOUNTRY == T005.LAND1
  • I_BUSSOLNORDITMBASICFINANCIAL.MANDT == T005.MANDT
Region (State, Province, County)
  • Country/Region
  • Region (State, Province, County)
  • Client
  • I_BUSSOLNORDITMBASICFINANCIAL.SOLDTOPARTYCOUNTRY == T005S.LAND1
  • I_BUSSOLNORDITMBASICFINANCIAL.SOLDTOPARTYREGION == T005S.BLAND
  • I_BUSSOLNORDITMBASICFINANCIAL.MANDT == T005S.MANDT
Currency
  • Client
  • Currency
  • I_BUSSOLNORDITMBASICFINANCIAL.MANDT == TCURC.MANDT
  • I_BUSSOLNORDITMBASICFINANCIAL.TRANSACTIONCURRENCY == TCURC.WAERS