I_BusSolnOrdItmFinancialCube

Solution Order Item Financials - Cube | view: IBSOLNITNFINCUBE | TRAN | 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
💲 Currency (TransactionCurrency):
TotBusSolnOrdItmNetAmtPerPerd Net Value
SlsItmNetAmount Net Value
ServiceContractItemNetAmount Net Value
ExpnItmNetAmount Net Value
SbscrBilgItmNetAmount Net Value
SrvcPrtItmNetAmount Net Value
SrvcItmNetAmount Net Value
💲 Company Code Currency (CompanyCodeCurrency):
RevenueAmountInCompanyCodeCrcy null
CostAmountInCompanyCodeCrcy null
RecognizedMarginAmtInCCCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date for a Business Transaction
ServiceDocItemCreationDate Created On
Column Name Description
Column Name Description Domain name
BusSolnOrdDescription Transaction Description
BusSolnOrdItmDescription Product Description CRM_PRSHTEXT40_DB
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
BusSolnOrdItmStatus Life Cycle Status
BusSolnOrdStatus Life Cycle Status
Product Product Number MATNR
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
  • I_BUSSOLNORDITMFINANCIALCUBE.MANDT == T005.MANDT
  • I_BUSSOLNORDITMFINANCIALCUBE.COUNTRY == T005.LAND1
Distribution Channel
  • Client
  • Distribution Channel
  • I_BUSSOLNORDITMFINANCIALCUBE.MANDT == TVTW.MANDT
  • I_BUSSOLNORDITMFINANCIALCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • I_BUSSOLNORDITMFINANCIALCUBE.MANDT == TSPA.MANDT
  • I_BUSSOLNORDITMFINANCIALCUBE.DIVISION == TSPA.SPART
Material Group
  • Product Group
  • Client
  • I_BUSSOLNORDITMFINANCIALCUBE.PRODUCTGROUP == T023.MATKL
  • I_BUSSOLNORDITMFINANCIALCUBE.MANDT == T023.MANDT
Region (State, Province, County)
  • Region (State, Province, County)
  • Client
  • Country/Region
  • I_BUSSOLNORDITMFINANCIALCUBE.REGION == T005S.BLAND
  • I_BUSSOLNORDITMFINANCIALCUBE.MANDT == T005S.MANDT
  • I_BUSSOLNORDITMFINANCIALCUBE.COUNTRY == T005S.LAND1
Item Category
  • Client
  • Item Category
CRM Item Object Type I_BUSSOLNORDITMFINANCIALCUBE.SERVICEDOCUMENTITEMOBJECTTYPE == CRMC_SUBOB_CAT_I.SUBOBJ_CATEGORY
Business Trans. Cat. I_BUSSOLNORDITMFINANCIALCUBE.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Sold-To Party
  • Client
  • Sold-To Party
  • I_BUSSOLNORDITMFINANCIALCUBE.MANDT == BUT000.CLIENT
  • I_BUSSOLNORDITMFINANCIALCUBE.SOLDTOPARTY == BUT000.PARTNER
Currency
  • Client
  • Currency
  • I_BUSSOLNORDITMFINANCIALCUBE.MANDT == TCURC.MANDT
  • I_BUSSOLNORDITMFINANCIALCUBE.TRANSACTIONCURRENCY == TCURC.WAERS