P_BusSolnOrdHdrData

Business Solution Order Header Data | view: PBUSSOLNORDDATA | Extraction: Not supported | Component: S4CRM: Analytics
Column Name Description
ServiceObjectType FK Business Trans. Cat.
BusinessSolutionOrder Transaction ID
Column Name Description
💲 Currency (TransactionCurrency):
ServiceDocNetAmount Total Net Value of Document in Document Currency
Column Name Description
Column Name Description
ServiceDocumentCreationDate Created On
Column Name Description
BusSolnOrdStatus Life Cycle Status Show values
Column Name Description Domain name
BusSolnOrdDescription Transaction Description CRM_PROCESS_DESCRIPTION
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
NrOfOpenBusSolnOrders null
NrOfReldBusSolnOrders null
NrOfCrtedBusSolnOrders null
BusSolnOrdCreationQuarter Calendar Quarter NUM1
BusSolnOrdCreationMonth Calendar Month NUM2
BusSolnOrdCreationYear Calendar Year NUM4
Master Data Relations Join Conditions
Business Transaction Type
  • Client
  • Business Transaction Type
Distribution Channel
  • Client
  • Distribution Channel
  • P_BUSSOLNORDHDRDATA.MANDT == TVTW.MANDT
  • P_BUSSOLNORDHDRDATA.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • P_BUSSOLNORDHDRDATA.MANDT == TSPA.MANDT
  • P_BUSSOLNORDHDRDATA.DIVISION == TSPA.SPART
Business Trans. Cat. P_BUSSOLNORDHDRDATA.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Sold-To Party
  • Client
  • Sold-To Party
  • P_BUSSOLNORDHDRDATA.MANDT == BUT000.CLIENT
  • P_BUSSOLNORDHDRDATA.SOLDTOPARTY == BUT000.PARTNER
Country/Region
  • Client
  • Country/Region
  • P_BUSSOLNORDHDRDATA.MANDT == T005.MANDT
  • P_BUSSOLNORDHDRDATA.SOLDTOPARTYCOUNTRY == T005.LAND1
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • Country/Region
  • P_BUSSOLNORDHDRDATA.MANDT == T005S.MANDT
  • P_BUSSOLNORDHDRDATA.SOLDTOPARTYREGION == T005S.BLAND
  • P_BUSSOLNORDHDRDATA.SOLDTOPARTYCOUNTRY == T005S.LAND1
Currency
  • Client
  • Currency
  • P_BUSSOLNORDHDRDATA.MANDT == TCURC.MANDT
  • P_BUSSOLNORDHDRDATA.TRANSACTIONCURRENCY == TCURC.WAERS