P_BusSolnOrdItmFinData

Business Solution Order Item Financial Data | view: PBSOLNORDITMFNDT | Extraction: Not supported | Component: S4CRM: Analytics
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
💲 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
BusSolnOrdItmStatus Life Cycle Status Show values
BusSolnOrdStatus 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
BusSolnOrdCreationQuarter Calendar Quarter NUM1
BusSolnOrdCreationMonth Calendar Month NUM2
BusSolnOrdCreationYear Calendar Year NUM4
NrOfOpenBusSolnOrders null
NrOfReldBusSolnOrders null
Master Data Relations Join Conditions
Business Transaction Type
  • Business Transaction Type
  • Client
Country/Region
  • Country/Region
  • Client
  • P_BUSSOLNORDITMFINDATA.COUNTRY == T005.LAND1
  • P_BUSSOLNORDITMFINDATA.MANDT == T005.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • P_BUSSOLNORDITMFINDATA.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • P_BUSSOLNORDITMFINDATA.MANDT == TVTW.MANDT
Division
  • Division
  • Client
  • P_BUSSOLNORDITMFINDATA.DIVISION == TSPA.SPART
  • P_BUSSOLNORDITMFINDATA.MANDT == TSPA.MANDT
Region (State, Province, County)
  • Country/Region
  • Client
  • Region (State, Province, County)
  • P_BUSSOLNORDITMFINDATA.COUNTRY == T005S.LAND1
  • P_BUSSOLNORDITMFINDATA.MANDT == T005S.MANDT
  • P_BUSSOLNORDITMFINDATA.REGION == T005S.BLAND
Item Category
  • Client
  • Item Category
CRM Item Object Type P_BUSSOLNORDITMFINDATA.SERVICEDOCUMENTITEMOBJECTTYPE == CRMC_SUBOB_CAT_I.SUBOBJ_CATEGORY
Business Trans. Cat. P_BUSSOLNORDITMFINDATA.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Sold-To Party
  • Sold-To Party
  • Client
  • P_BUSSOLNORDITMFINDATA.SOLDTOPARTY == BUT000.PARTNER
  • P_BUSSOLNORDITMFINDATA.MANDT == BUT000.CLIENT
Currency
  • Currency
  • Client
  • P_BUSSOLNORDITMFINDATA.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_BUSSOLNORDITMFINDATA.MANDT == TCURC.MANDT