I_BusinessSolutionPortfolioTP

DDL: I_BUSINESSSOLUTIONPORTFOLIOTP Type: view_entity TRANSACTIONAL
19 Fields 1 Data Sources 9 Associations

Transact. Processing: BSP

I_BusinessSolutionPortfolioTP is a Transactional CDS View that provides data about "Transact. Processing: BSP" in SAP S/4HANA. It reads from 1 data source (I_BusinessSolutionPortfolio) and exposes 19 fields with key field BusinessSolutionPortfolio. It has 9 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BusinessSolutionPortfolio I_BusinessSolutionPortfolio from

Associations (9)

CardinalityTargetAliasCondition
[0..*] I_BusSolnPortfolioAllItemTP _BusSolnPrtfloAllItems $projection.BusinessSolutionPortfolio = _BusSolnPrtfloAllItems.BusinessSolutionPortfolio
[0..1] I_BusinessPartner _SoldToParty $projection.SoldToParty = _SoldToParty.BusinessPartner
[0..1] I_User _CreatedByUser $projection.CreatedByUser = _CreatedByUser.UserID
[0..1] I_User _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.UserID
[0..1] I_BusSolPrtfloSoldToPtyQuickVw _SoldToPartyQuickView $projection.SoldToParty = _SoldToPartyQuickView.BusinessPartner
[0..*] I_BusSolnPrtfloSrvcContrItmTP _BusSolnPrtfloSrvcContrItm
[0..*] I_BuSoPrtfloSubscrpnContrItmTP _BuSoPrtfloSubscrpnContrItm
[0..*] I_BusSolnPrtfloSrvcOrderItmTP _BusSolnPrtfloSrvcOrderItm
[0..*] I_BusSolnPrtfloSlsOrderItmTP _BusSolnPrtfloSlsOrderItm

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Transact. Processing: BSP view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionPortfolio BusinessSolutionPortfolio Transaction ID
BusSolnPrtfloReference BusSolnPrtfloReference Reference
BusSolnPrtfloDescription BusSolnPrtfloDescription Description
Currency Currency Valuation Crcy
SoldToParty SoldToParty Sold-to Party
BusSolnPrtfloNoteText BusSolnPrtfloNoteText Note
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_BusSolnPrtfloSrvcContrItm _BusSolnPrtfloSrvcContrItm
_BuSoPrtfloSubscrpnContrItm _BuSoPrtfloSubscrpnContrItm
_BusSolnPrtfloSrvcOrderItm _BusSolnPrtfloSrvcOrderItm
_BusSolnPrtfloSlsOrderItm _BusSolnPrtfloSlsOrderItm
_BusSolnPrtfloAllItems _BusSolnPrtfloAllItems
_SoldToParty _SoldToParty
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_SoldToPartyQuickView _SoldToPartyQuickView

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_BusinessSolutionPortfolioTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_BusinessSolutionPortfolioTP AS
SELECT
  BusinessSolutionPortfolio,
  BusSolnPrtfloReference,
  BusSolnPrtfloDescription,
  Currency,
  SoldToParty,
  BusSolnPrtfloNoteText,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM I_BusinessSolutionPortfolio
LEFT OUTER JOIN I_BusSolnPortfolioAllItemTP AS _BusSolnPrtfloAllItems ON BusinessSolutionPortfolio = _BusSolnPrtfloAllItems.BusinessSolutionPortfolio  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartner AS _SoldToParty ON SoldToParty = _SoldToParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_BusSolPrtfloSoldToPtyQuickVw AS _SoldToPartyQuickView ON SoldToParty = _SoldToPartyQuickView.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusSolnPrtfloSrvcContrItmTP AS _BusSolnPrtfloSrvcContrItm ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BuSoPrtfloSubscrpnContrItmTP AS _BuSoPrtfloSubscrpnContrItm ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BusSolnPrtfloSrvcOrderItmTP AS _BusSolnPrtfloSrvcOrderItm ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BusSolnPrtfloSlsOrderItmTP AS _BusSolnPrtfloSlsOrderItm ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More