C_BusinessSolutionPortfolio

DDL: C_BUSINESSSOLUTIONPORTFOLIO Type: view_entity CONSUMPTION
31 Fields 1 Data Sources 1 OData Services

Projection: Business Solution Portfolio

C_BusinessSolutionPortfolio is a Consumption CDS View that provides data about "Projection: Business Solution Portfolio" in SAP S/4HANA. It reads from 1 data source (I_BusinessSolutionPortfolioTP) and exposes 31 fields with key field BusinessSolutionPortfolio. It is exposed through 1 OData service (C_BUSSOLUTIONPORTFOLIO_SRV).

Data Sources (1)

SourceAliasJoin Type
I_BusinessSolutionPortfolioTP I_BusinessSolutionPortfolioTP projection

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Projection: Business Solution Portfolio view

OData Services (1)

ServiceBindingVersionContractRelease
C_BUSSOLUTIONPORTFOLIO_SRV C_BUSSOLUTIONPORTFOLIO V2 C1 NOT_RELEASED

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionPortfolio BusinessSolutionPortfolio Transaction ID
BusSolnPrtfloReference BusSolnPrtfloReference Reference
BusSolnPrtfloDescription BusSolnPrtfloDescription Description
Currency Currency Valuation Crcy
BusSolnPrtfloNoteText BusSolnPrtfloNoteText Note
SoldToParty SoldToParty Sold-to Party
BusinessPartnerName _SoldToParty BusinessPartnerName Extracted Customer Name
FirstName _SoldToParty FirstName First Name
LastName _SoldToParty LastName Last Name
GroupBusinessPartnerName1 _SoldToParty GroupBusinessPartnerName1 Name 1
GroupBusinessPartnerName2 _SoldToParty GroupBusinessPartnerName2 Name 2
OrganizationBPName1 _SoldToParty OrganizationBPName1 Name 1
OrganizationBPName2 _SoldToParty OrganizationBPName2 Name 2
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
CreatedByUserDescription _CreatedByUser UserDescription Full Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangedByUserDescription _LastChangedByUser UserDescription Full Name
curr152
curr152
curr152
curr152
curr152
int8
int8
int8
int8
dats
dats
dats

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 C_BusinessSolutionPortfolio.
-- 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 C_BusinessSolutionPortfolio AS
SELECT
  BusinessSolutionPortfolio,
  BusSolnPrtfloReference,
  BusSolnPrtfloDescription,
  Currency,
  BusSolnPrtfloNoteText,
  SoldToParty,
  _SoldToParty.BusinessPartnerName AS BusinessPartnerName,
  _SoldToParty.FirstName AS FirstName,
  _SoldToParty.LastName AS LastName,
  _SoldToParty.GroupBusinessPartnerName1 AS GroupBusinessPartnerName1,
  _SoldToParty.GroupBusinessPartnerName2 AS GroupBusinessPartnerName2,
  _SoldToParty.OrganizationBPName1 AS OrganizationBPName1,
  _SoldToParty.OrganizationBPName2 AS OrganizationBPName2,
  CreationDateTime,
  CreatedByUser,
  _CreatedByUser.UserDescription AS CreatedByUserDescription,
  LastChangeDateTime,
  LastChangedByUser,
  _LastChangedByUser.UserDescription AS LastChangedByUserDescription,
  virtual BusSolutionPortfolioNetAmount : abap.curr( 15, 2 ) AS curr152,
  virtual NrOfBusSolnPrtfloSrvcContr : abap.int8 AS int8,
  virtual EarliestSrvcContrItmStartDate : abap.dats AS dats
FROM I_BusinessSolutionPortfolioTP
;

Learn More