C_AssortmentModuleUserVH

DDL: C_ASSORTMENTMODULEUSERVH Type: view_entity CONSUMPTION Package: RFM_MANAGE_ASSTMT_MODULES
7 Fields 2 Data Sources 2 OData Services 1 Fiori Apps

Assortment User

C_AssortmentModuleUserVH is a Consumption CDS View that provides data about "Assortment User" in SAP S/4HANA. It reads from 2 data sources (I_Site, I_SiteOpeningHours) and exposes 7 fields with key field Site. It is exposed through 2 OData services (JOULE_RFM_MNG_ASSTMT_MODULES, UI_RFM_MNG_ASSTMT_MODULES). It is used in 1 Fiori application: Manage Assortment Modules. Part of development package RFM_MANAGE_ASSTMT_MODULES.

Data Sources (2)

SourceAliasJoin Type
I_Site Site from
I_SiteOpeningHours SiteOpeningHours inner

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Assortment User view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
VDM.viewType #CONSUMPTION view

OData Services (2)

ServiceBindingVersionContractRelease
JOULE_RFM_MNG_ASSTMT_MODULES JOULE_RFM_MNG_ASSTMT_MDL V2 C1 NOT_TO_BE_RELEASED_STABLE
UI_RFM_MNG_ASSTMT_MODULES UI_RFM_MNG_ASSTMT_MODULES V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F4892 Manage Assortment Modules Transactional An application to manage assortment modules.

Manage Assortment Modules

Business Role: Assortment Specialist - Retail

With this feature, you can select up to 1,000 products at a time to assign them to an assortment module version, including its follow-on versions.

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Site I_Site Site Plant
SiteCustomer I_Site SiteCustomer CustomerNoPlant
SiteName I_Site SiteName
SalesOrganization I_Site SalesOrganization Sales Organization
SalesOrganizationName
DistributionChannel I_Site DistributionChannel RefDistCh-Cust/Mat.
DistributionChannelName

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_AssortmentModuleUserVH.
-- 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_AssortmentModuleUserVH AS
SELECT
  Site.Site AS Site,
  Site.SiteCustomer AS SiteCustomer,
  Site.SiteName AS SiteName,
  Site.SalesOrganization AS SalesOrganization,
  Site._SalesOrganization._Text[1: Language=$session.system_language].SalesOrganizationName AS SalesOrganizationName,
  Site.DistributionChannel AS DistributionChannel,
  Site._DistributionChannel._Text[1: Language=$session.system_language].DistributionChannelName AS DistributionChannelName
FROM I_Site AS Site
INNER JOIN I_SiteOpeningHours AS SiteOpeningHours ON /* join condition not captured in parsed metadata */
;

Learn More