I_ExtProdGrp

DDL: I_EXTPRODGRP Type: view BASIC Package: VDM_MD_PRODUCT_DDIC
2 Fields 1 Data Sources 1 Associations 13 OData Services

External Product Group

I_ExtProdGrp (Basic)

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

External Product Group · Database & Data Management

I_ExtProdGrp is a Basic CDS View (Dimension) that provides data about "External Product Group" in SAP S/4HANA. It reads from 1 data source (twew) and exposes 2 fields with key field ExternalProductGroup. It has 1 association to related views. It is exposed through 13 OData services (ASQL_F2151, ASQL_F2152, ASQL_F2155, ...). Part of development package VDM_MD_PRODUCT_DDIC.

SAP Help Documentation

CategoryCDS Views for Product Master
Data CategoryDimension
StatusReleased
Data Extraction TypeFull (physical deletions are possible in source tables) Delta: Change Data Capture
Corresponding DataSourceNA
Purpose
This CDS view provides the consumer with a list of External Material Groups . Description: External Product Group

Prerequisites
These restriction types are edited in the Maintain Business Roles app. Users must also have authorization to access the Material Master Data for Plant.

Structure
Object types This view relates to the following SAP object types: Material Product

SAP Business Warehouse (SAP BW) Extraction
Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. In case you are interested in the details of the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Use SAP Library BI Content . For more information about data extraction, see Extracting Data Through CDS Views to SAP BW/4HANA .

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessDatabase & Data Management
Application ComponentLO-MD-MM-2CL
CapabilitiesData Source for Data Extraction,Data Source in SQL Select,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities,Data Source for Search,Data Provider for Value Help,Analytical Dimension
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageDatabase and Data Management for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the consumer with a list of External Material Groups .</p> <p>Description: External Product Group</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
twew twew from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ExtProdGrpText _Text $projection.ExternalProductGroup = _Text.ExternalProductGroup

Annotations (21)

NameValueLevelField
AbapCatalog.sqlViewName IEXTPRODGRP view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label External Product Group view
ObjectModel.representativeKey ExternalProductGroup view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
Consumption.ranked true view
ObjectModel.sapObjectNodeType.name ExternalProductGroup view

OData Services (13)

ServiceBindingVersionContractRelease
ASQL_F2151 ASQL_F2151 C2 NOT_RELEASED
ASQL_F2152 ASQL_F2152 C2 NOT_RELEASED
ASQL_F2155 ASQL_F2155 C2 NOT_RELEASED
ASQL_F2156 ASQL_F2156 C2 NOT_RELEASED
ASQL_F2390 ASQL_F2390 C2 NOT_RELEASED
ASQL_F2391 ASQL_F2391 C2 NOT_RELEASED
ASQL_F2612 ASQL_F2612 C2 NOT_RELEASED
ASQL_F2647 ASQL_F2647 C2 NOT_RELEASED
ASQL_F3025 ASQL_F3025 C2 NOT_RELEASED
ASQL_F3146 ASQL_F3146 C2 NOT_RELEASED
ASQL_F3147 ASQL_F3147 C2 NOT_RELEASED
ASQL_F8427 ASQL_F8427 C2 NOT_RELEASED
ASQL_F8428 ASQL_F8428 C2 NOT_RELEASED

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ExternalProductGroup External Product Group
_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_ExtProdGrp.
-- 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_ExtProdGrp AS
SELECT
  cast(extwg as externalproductgroup preserving type ) AS ExternalProductGroup
FROM twew
LEFT OUTER JOIN I_ExtProdGrpText AS _Text ON ExternalProductGroup = _Text.ExternalProductGroup  -- association [0..*]
;

Learn More