I_PRAProduct

DDL: I_PRAPRODUCT SQL: IPVPRODUCT Type: view BASIC Package: OIU_VDM_CDS
4 Fields 1 Data Sources 3 Associations 2 OData Services

PRA Product

I_PRAProduct (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Production Revenue Accounting Product · Cross Applications

I_PRAProduct is a Basic CDS View (Dimension) that provides data about "PRA Product" in SAP S/4HANA. It reads from 1 data source (I_MinorProduct) and exposes 4 fields with key field Product. It has 3 associations to related views. It is exposed through 2 OData services (UI_INTERESTDETAILSDATAMANAGE, UI_INTRSTOWNRDETSDATAMANAGE). Part of development package OIU_VDM_CDS.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessCross Applications
Application ComponentIS-OIL-PRA
CapabilitiesData Source for Data Extraction,Data Source in SQL Select,Analytical Dimension,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageCross Applications for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_MinorProduct I_MinorProduct from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_MajorProduct _MajorProduct $projection.MajorProduct = _MajorProduct.MajorProduct
[0..1] I_MinorProduct _MinorProduct $projection.MajorProduct = _MinorProduct.MajorProduct and $projection.MinorProduct = _MinorProduct.MinorProduct
[1..*] I_PRAProductText _Text $projection.Product = _Text.Product

Annotations (15)

NameValueLevelField
EndUserText.label PRA Product view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IPVPRODUCT view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey Product view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.sapObjectNodeType.name PRAProduct view
Search.searchable false view

OData Services (2)

ServiceBindingVersionContractRelease
UI_INTERESTDETAILSDATAMANAGE UI_INTRSTDETAILSDATAMANAGE V2 C1 NOT_RELEASED
UI_INTRSTOWNRDETSDATAMANAGE UI_INTRSTOWNRDETSMANAGE V2 C1 NOT_RELEASED

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Product Full three char. product code (Major and Detail Products)
MajorProduct MajorProduct Major product code
MinorProduct MinorProduct Minor Product Code
_Text _Text

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_PRAProduct.
-- 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.
-- SQL view name: IPVPRODUCT

CREATE VIEW I_PRAProduct AS
SELECT
  cast(concat(MajorProduct, MinorProduct) as oiu_full_pd_cd ) AS Product,
  MajorProduct,
  MinorProduct
FROM I_MinorProduct
LEFT OUTER JOIN I_MajorProduct AS _MajorProduct ON MajorProduct = _MajorProduct.MajorProduct  -- association [0..1]
LEFT OUTER JOIN I_MinorProduct AS _MinorProduct ON MajorProduct = _MinorProduct.MajorProduct AND MinorProduct = _MinorProduct.MinorProduct  -- association [0..1]
LEFT OUTER JOIN I_PRAProductText AS _Text ON Product = _Text.Product  -- association [1..*]
;

Learn More