C_BusSolnOrdItmFinancialQ

Solution Order Item Financials - Query | view: CBSORDITMFINQRY | Extraction: Not supported | Component: S4CRM: Analytics
Tables used: SCAL_TT_DATE, CRMS4D_SERV_H, CRMS4D_SERV_I, PRTE, ACDOCA, MARA, FAAC_KFCSET_SPEC, FAAC_KFCT, BUT0ID, BUT000, TKA01, CRMS4C_ORGMAN, FINSC_LEDGER, MARA, PROJ, T000, HRRP_FSV_DIR, USR21, PRPS, PRPS, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_HRRP2SEMTA, HRRP_NODE, USR05, FAAC_KFC_SPEC, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_FISC_DATE
Column Name Description
ServiceObjectType FK Business Trans. Cat.
BusinessSolutionOrder Transaction ID
BusinessSolutionOrderItem Shortened Item Number in Document
Column Name Description
💲 null (DisplayCurrency):
TotBusSolnOrdItmNetAmtPerPerd null
BusSolnOrdRevnAmtInDC null
BusSolnOrdCostAmtInDC null
BusSolnOrdRecgdMargAmtInDC null
SlsItmNetAmount null
ServiceContractItemNetAmount null
ExpnItmNetAmount null
SbscrBilgItmNetAmount null
SrvcPrtItmNetAmount null
SrvcItmNetAmount null
Column Name Description
Column Name Description
PostingDate Posting Date for a Business Transaction
ServiceDocItemCreationDate Created On
Column Name Description
BusSolnOrdStatus Life Cycle Status Show values
BusSolnOrdItmStatus Life Cycle Status Show values
Column Name Description Domain name
BusSolnOrdDescription Transaction Description CRM_PROCESS_DESCRIPTION
BusSolnOrdItmDescription Product Description CRM_PRSHTEXT40_DB
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
Product Product Number MATNR
BusSolnOrdOpgMarginRatio Operating Margin Global Currency Percent FISD_PERCENT_2
NrOfOpenBusSolnOrders null
NrOfReldBusSolnOrders null
BusSolnOrdCreationQuarter Calendar Quarter NUM1
BusSolnOrdCreationMonth Calendar Month NUM2
BusSolnOrdCreationYear Calendar Year NUM4
Master Data Relations Join Conditions
Business Transaction Type
  • Business Transaction Type
  • Client
Country/Region
  • Client
  • Country/Region
  • C_BUSSOLNORDITMFINANCIALQ.MANDT == T005.MANDT
  • C_BUSSOLNORDITMFINANCIALQ.COUNTRY == T005.LAND1
Distribution Channel
  • Client
  • Distribution Channel
  • C_BUSSOLNORDITMFINANCIALQ.MANDT == TVTW.MANDT
  • C_BUSSOLNORDITMFINANCIALQ.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • C_BUSSOLNORDITMFINANCIALQ.MANDT == TSPA.MANDT
  • C_BUSSOLNORDITMFINANCIALQ.DIVISION == TSPA.SPART
Material Group
  • Client
  • Product Group
  • C_BUSSOLNORDITMFINANCIALQ.MANDT == T023.MANDT
  • C_BUSSOLNORDITMFINANCIALQ.PRODUCTGROUP == T023.MATKL
Region (State, Province, County)
  • Client
  • Country/Region
  • Region (State, Province, County)
  • C_BUSSOLNORDITMFINANCIALQ.MANDT == T005S.MANDT
  • C_BUSSOLNORDITMFINANCIALQ.COUNTRY == T005S.LAND1
  • C_BUSSOLNORDITMFINANCIALQ.REGION == T005S.BLAND
Item Category
  • Client
  • Item Category
CRM Item Object Type C_BUSSOLNORDITMFINANCIALQ.SERVICEDOCUMENTITEMOBJECTTYPE == CRMC_SUBOB_CAT_I.SUBOBJ_CATEGORY
Business Trans. Cat. C_BUSSOLNORDITMFINANCIALQ.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Sold-To Party
  • Sold-To Party
  • Client
  • C_BUSSOLNORDITMFINANCIALQ.SOLDTOPARTY == BUT000.PARTNER
  • C_BUSSOLNORDITMFINANCIALQ.MANDT == BUT000.CLIENT