I_SiteProductGroup

DDL: I_SITEPRODUCTGROUP Type: view BASIC
14 Fields 1 Data Sources 4 Associations

Product Group Assignment to Site

I_SiteProductGroup (Basic)

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

RetailSiteMerchandiseCategory · Cross Applications

I_SiteProductGroup is a Basic CDS View (Dimension) that provides data about "Product Group Assignment to Site" in SAP S/4HANA. It reads from 1 data source (wrf6) and exposes 14 fields with key fields SiteCustomer, ProductGroup. It has 4 associations to related views.

SAP Help Documentation

CategorySites for Retail
Data CategoryDimension
Purpose
This CDS view helps to retrieve assignments of product groups to retail sites. Note In the retail context, the term product group is often used synonymously with merchandise category . This CDS view provides the data to answer the following business questions: Which product group is operated in a certain retail site? How is a certain product group configured in a certain store with respect to replenishment, POS outbound, price lists, and others? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: W_BETR_USR ( Authorization Check Users/Sites )

Structure
Important Fields Important fields in this view include the following: Field Name Description SiteCustomer Customer number of retail site Note This is a key field. ProductGroup Product group Note This is a key field. ContactPersonStdDepartment Department number AssortmentGrade Assortment grade ProdGroupIsExcldFrmPOSOutbound Indicates whether the product group is excluded from POS outbound processing ProdReplnmtRqmtGroup Requirement group for replenishment StoreProcurementProfile Store procurement profile for store order and replenishment PriceListType Defines the price list type that the system uses to determine a price at item level RevaluationProfile Retail revaluation profile PriceIsIncludingSalesTax Price including sales tax

Data Extraction
Data Extraction Type Full (physical deletions are possible in source tables) Delta (change data capture)

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentLO-RFM-MD-SIT
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source for Data Extraction
PackageCross Applications for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view helps to retrieve assignments of product groups to retail sites.</p> This CDS view provides the data to answer the following business questions:<ul> <li><p>Which product group is operated in a certain retail site?</p></li> <li><p>How is a certain product group configured in a certain store with respect to replenishment, POS outbound, price lists, and others?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
wrf6 wrf6 from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_MaterialGroup _ProductGroup $projection.ProductGroup = _ProductGroup.MaterialGroup
[0..1] I_ContactPersonStdDepartment _ContactPersonStdDepartment $projection.ContactPersonStdDepartment = _ContactPersonStdDepartment.ContactPersonStdDepartment
[1..1] I_Site _Site $projection.SiteCustomer = _Site.SiteCustomer
[1..1] I_Customer _Customer $projection.SiteCustomer = _Customer.Customer

Annotations (18)

NameValueLevelField
EndUserText.label Product Group Assignment to Site view
AbapCatalog.sqlViewName ISTEPRODUCTGROUP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey ProductGroup view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.sapObjectNodeType.name RetailSiteMerchandiseCategory view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY SiteCustomer locnr CustomerNoPlant
KEY ProductGroup Product Sold Group
ContactPersonStdDepartment abtnr Department number
AssortmentGrade sstuf Assortment grade
ProdGroupIsExcldFrmPOSOutbound wdaus Exclude material group from POS outbound processing
ProdReplnmtRqmtGroup rqgrp Replenishment: requirement group
StoreProcurementProfile fbpro Store procurement profile for store order, replenishment
PriceListType pltyp_p Price determination: Item-based price list type
RevaluationProfile uprof Retail revalution profile
PriceIsIncludingSalesTax primw Price including sales tax
_ProductGroup _ProductGroup
_ContactPersonStdDepartment _ContactPersonStdDepartment
_Site _Site
_Customer _Customer

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_SiteProductGroup.
-- 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_SiteProductGroup AS
SELECT
  locnr AS SiteCustomer,
  cast(matkl as productgroup preserving type) AS ProductGroup,
  abtnr AS ContactPersonStdDepartment,
  sstuf AS AssortmentGrade,
  wdaus AS ProdGroupIsExcldFrmPOSOutbound,
  rqgrp AS ProdReplnmtRqmtGroup,
  fbpro AS StoreProcurementProfile,
  pltyp_p AS PriceListType,
  uprof AS RevaluationProfile,
  primw AS PriceIsIncludingSalesTax
FROM wrf6
LEFT OUTER JOIN I_MaterialGroup AS _ProductGroup ON ProductGroup = _ProductGroup.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN I_ContactPersonStdDepartment AS _ContactPersonStdDepartment ON ContactPersonStdDepartment = _ContactPersonStdDepartment.ContactPersonStdDepartment  -- association [0..1]
LEFT OUTER JOIN I_Site AS _Site ON SiteCustomer = _Site.SiteCustomer  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON SiteCustomer = _Customer.Customer  -- association [1..1]
;

Learn More