I_DifferentiationPortfolioText

DDL: I_DIFFERENTIATIONPORTFOLIOTEXT Type: view_entity BASIC Package: FTR_GENERAL_CORE

Differentiation Portfolio Name

I_DifferentiationPortfolioText is a Basic CDS View that provides data about "Differentiation Portfolio Name" in SAP S/4HANA. It reads from 1 data source (twpob_t) and exposes 7 fields with key fields CompanyCode, DifferentiationPortfolio, Language. It has 2 associations to related views. It is exposed through 1 OData service (ASQL_F3966). Part of development package FTR_GENERAL_CORE.

Data Sources (1)

SourceAliasJoin Type
twpob_t DifferentiationPortfolioText from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_DifferentiationPortfolio _DifferentiationPortfolio $projection.DifferentiationPortfolio = _DifferentiationPortfolio.DifferentiationPortfolio and $projection.CompanyCode = _DifferentiationPortfolio.CompanyCode
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (10)

NameValueLevelField
AbapCatalog.entityBuffer.definitionAllowed false view
ObjectModel.dataCategory #TEXT view
Analytics.technicalName IDIFFPORTFTXT view
ObjectModel.representativeKey DifferentiationPortfolio view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Differentiation Portfolio Name view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F3966 ASQL_F3966 C2 NOT_RELEASED

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode twpob_t bukrs Value
KEY DifferentiationPortfolio
KEY Language twpob_t spras Off. Language
DifferentiationPortfolioName
_DifferentiationPortfolio _DifferentiationPortfolio
_Language _Language
_CompanyCode _CompanyCode

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_DifferentiationPortfolioText.
-- 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_DifferentiationPortfolioText AS
SELECT
  DifferentiationPortfolioText.bukrs AS CompanyCode,
  cast(DifferentiationPortfolioText.rportb as ftr_gen_portfolio_diff preserving type) AS DifferentiationPortfolio,
  DifferentiationPortfolioText.spras AS Language,
  cast(DifferentiationPortfolioText.xportb as ftr_gen_portfolio_diff_name preserving type) AS DifferentiationPortfolioName
FROM twpob_t AS DifferentiationPortfolioText
LEFT OUTER JOIN I_DifferentiationPortfolio AS _DifferentiationPortfolio ON DifferentiationPortfolio = _DifferentiationPortfolio.DifferentiationPortfolio AND CompanyCode = _DifferentiationPortfolio.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;