I_BusSolnOrdBasicFinancial

Solution Order for Financial Reporting | view: IBUSSOLORDFR | ATTR | Extraction: Not supported | Component: S4CRM: Analytics
Tables used: CRMS4D_SERV_H
Column Name Description
BusinessSolutionOrder Transaction ID
Column Name Description
💲 Currency (TransactionCurrency):
ServiceDocNetAmount Total Net Value of Document in Document Currency
ServiceDocGrossAmount Total Gross Value of Document in Document Currency
ServiceDocTaxAmount Total Tax Amount in Document Currency
Column Name Description
Column Name Description
PostingDate Posting Date for a Business Transaction
Column Name Description
ServiceDocumentStatus Life Cycle Status Show values
Column Name Description Domain name
BusinessSolutionOrderUUID GUID of a CRM Order Object SYSUUID
ServiceDocumentDescription Transaction Description CRM_PROCESS_DESCRIPTION
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
  • Client
  • Distribution Channel
  • I_BUSSOLNORDBASICFINANCIAL.MANDT == TVTW.MANDT
  • I_BUSSOLNORDBASICFINANCIAL.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • I_BUSSOLNORDBASICFINANCIAL.MANDT == TSPA.MANDT
  • I_BUSSOLNORDBASICFINANCIAL.DIVISION == TSPA.SPART
Language Key of Description I_BUSSOLNORDBASICFINANCIAL.LANGUAGE == T002.SPRAS
Employee Responsible
  • Client
  • Employee Responsible
  • I_BUSSOLNORDBASICFINANCIAL.MANDT == BUT000.CLIENT
  • I_BUSSOLNORDBASICFINANCIAL.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
Business Transaction Type
  • Client
  • Business Transaction Type
Business Trans. Cat. I_BUSSOLNORDBASICFINANCIAL.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Sold-To Party
  • Client
  • Sold-To Party
  • I_BUSSOLNORDBASICFINANCIAL.MANDT == BUT000.CLIENT
  • I_BUSSOLNORDBASICFINANCIAL.SOLDTOPARTY == BUT000.PARTNER
Country/Region
  • Client
  • Country/Region
  • I_BUSSOLNORDBASICFINANCIAL.MANDT == T005.MANDT
  • I_BUSSOLNORDBASICFINANCIAL.SOLDTOPARTYCOUNTRY == T005.LAND1
Region (State, Province, County)
  • Client
  • Country/Region
  • Region (State, Province, County)
  • I_BUSSOLNORDBASICFINANCIAL.MANDT == T005S.MANDT
  • I_BUSSOLNORDBASICFINANCIAL.SOLDTOPARTYCOUNTRY == T005S.LAND1
  • I_BUSSOLNORDBASICFINANCIAL.SOLDTOPARTYREGION == T005S.BLAND
Currency
  • Client
  • Currency
  • I_BUSSOLNORDBASICFINANCIAL.MANDT == TCURC.MANDT
  • I_BUSSOLNORDBASICFINANCIAL.TRANSACTIONCURRENCY == TCURC.WAERS