I_BusSolnPortfolioAllItemTP

Transact. Process.: All Items | view: IBSPALLITEMTP | TRAN | Extraction: Not supported | Component: S4CRM: Business Solution Portfolio
Tables used: VBAPVBAKVBKDVEDACRMS4D_SERV_HCRMS4D_SERV_I
Column Name Description
BusinessSolutionPortfolio Transaction ID
BusSolnPrtfloAssgdObjectType Values for Domains: Single Value/Lower Limit
BusSolnPrtfloAssignedDocument Transaction ID
BusSolnPrtfloAssignedDocItem Shortened Item Number in Document
Column Name Description
💲 Currency (TransactionCurrency):
ItemNetAmount Net Value
💲 Currency (Currency):
BusSolnPrtfloAssgdDocItmNetAmt null
Column Name Description
📏 Unit of Measure in Which the Product Is Sold (ServiceDocItemQuantityUnit):
ServiceDocumentItemQuantity Requested Quantity
Column Name Description
Column Name Description
Column Name Description Domain name
BusSolnPrtfloAssgdObjTypeName Short Text for Fixed Values DDTEXT
ServiceObjectType Business Trans. Cat. CRM_OJ_NAME_PROCESS
SalesOrderType Business Transaction Type CRM_PROCESS_TYPE
ServiceDocumentType Business Transaction Type CRM_PROCESS_TYPE
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
Division Division SPART
OrganizationDivision Division SPART
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
ServiceDocumentUUID 32 Character CRM Object GUID (Converted)
ServiceDocumentItemUUID 32 Character CRM Object GUID (Converted)
ServiceContractUUID 32 Character CRM Object GUID (Converted)
ServiceOrderUUID 32 Character CRM Object GUID (Converted)
ServiceDocumentDescription Transaction Description CRM_PROCESS_DESCRIPTION
Product Product Name Entered CRM_ORDERED_PROD
ProductName Product Description CRM_PRSHTEXT40_DB
CreationDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
CreatedByUser User Name SYCHAR12
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
LastChangedByUser User Name SYCHAR12
BusSolnPrtfloLastChgDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
SalesOrganizationOrgUnitID Sales Organization ID HROBJEC_14
SalesOfficeOrgUnitID Sales Office HROBJEC_14
SalesGroupOrgUnitID Sales Group HROBJEC_14
ServiceOrganization Service Organization HROBJEC_14
ResponsibleEmployee Employee Responsible BU_PARTNER
Master Data Relations Join Conditions
Unit of Measure in Which the Product Is Sold
  • Client
  • Unit of Measure in Which the Product Is Sold
  • I_BUSSOLNPORTFOLIOALLITEMTP.MANDT == T006.MANDT
  • I_BUSSOLNPORTFOLIOALLITEMTP.SERVICEDOCITEMQUANTITYUNIT == T006.MSEHI
Currency
  • Client
  • Currency
  • Currency
  • I_BUSSOLNPORTFOLIOALLITEMTP.MANDT == TCURC.MANDT
  • I_BUSSOLNPORTFOLIOALLITEMTP.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_BUSSOLNPORTFOLIOALLITEMTP.CURRENCY == TCURC.WAERS