C_SiteProductGroupTP

DDL: C_SITEPRODUCTGROUPTP Type: view_entity CONSUMPTION Package: RFM_SITE_MAINTAIN
14 Fields 1 Data Sources 2 OData Services 1 Fiori Apps

Site Product Groups

C_SiteProductGroupTP is a Consumption CDS View that provides data about "Site Product Groups" in SAP S/4HANA. It reads from 1 data source (R_SiteProductGroupTP) and exposes 14 fields with key fields Site, SiteCustomer, ProductGroup, ProductGroupDraftUUID. It is exposed through 2 OData services (ASQL_F5375, UI_RFM_SITE_MAINTAIN). It is used in 1 Fiori application: Maintain Retail Site. Part of development package RFM_SITE_MAINTAIN.

Data Sources (1)

SourceAliasJoin Type
R_SiteProductGroupTP R_SiteProductGroupTP projection

Annotations (12)

NameValueLevelField
EndUserText.label Site Product Groups view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
Metadata.allowExtensions true view
ObjectModel.representativeKey ProductGroup view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix SMC view
AbapCatalog.extensibility.quota.maximumFields 1000 view
AbapCatalog.extensibility.quota.maximumBytes 100000 view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F5375 ASQL_F5375 C2 NOT_RELEASED
UI_RFM_SITE_MAINTAIN UI_RFM_SITE_MAINTAIN V2 C1 NOT_TO_BE_RELEASED_STABLE

Fiori Apps (1)

App IDApp NameTypeDescription
F5375 Maintain Retail Site Transactional An application to maintain relevant information for a retail distribution center or a retail store and facilitate making it functional for business use.

Maintain Retail Site

Business Role: Master Data Specialist - Location Data (Retail)

With this app, as a Master Data Specialist - Location Data Retail you can maintain retail site master data and enable it for functional use such as assigning business partner to the site, profit center assignment to the site, so on. If the site is already functional, then you can review the attributes of the site including the assigned business partner and profit center.

Key Features: Make a site functional by creating a site business partner and establishing the link between site and business partner Assign an already created business partner for the site Create a business partner by navigating to Manage Business Partner app Use copy master data functionality. It is possible as well to copy master data. the business partner ID is created with the same ID as the site ID so on. Assign profit center for site and the assortment is created automatically when business partner assignment to site is saved Add merchandise categories Add supplying sites Define block reason for blocked sites Maintain opening and closing date and time Use copy master data functionality to make multiple sites functional

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Site Site Plant
KEY SiteCustomer SiteCustomer
KEY ProductGroup ProductGroup Product Sold Group
KEY ProductGroupDraftUUID ProductGroupDraftUUID
ProductGroupForEdit ProductGroupForEdit Product Sold Group
ProdReplnmtRqmtGroup ProdReplnmtRqmtGroup
StoreProcurementProfile StoreProcurementProfile
RevaluationProfile RevaluationProfile
PriceIsIncludingSalesTax PriceIsIncludingSalesTax
PriceListType PriceListType Price List Tp.
MaterialGroupName
SiteName _SiteMaster SiteName
CustomerName _SiteMaster CustomerName Name of Customer
_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 C_SiteProductGroupTP.
-- 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_SiteProductGroupTP AS
SELECT
  Site,
  SiteCustomer,
  ProductGroup,
  ProductGroupDraftUUID,
  ProductGroupForEdit,
  ProdReplnmtRqmtGroup,
  StoreProcurementProfile,
  RevaluationProfile,
  PriceIsIncludingSalesTax,
  PriceListType,
  _ProductGroup._Text[1: Language=$session.system_language].MaterialGroupName AS MaterialGroupName,
  _SiteMaster.SiteName AS SiteName,
  _SiteMaster.CustomerName AS CustomerName
FROM R_SiteProductGroupTP
;

Learn More