C_ProdAssgblToStoreNarrowVH

DDL: C_PRODASSGBLTOSTORENARROWVH Type: view_entity CONSUMPTION Package: RFM_ASSORTMENT_MDL_APPS_COMMON
8 Fields 1 Data Sources 3 OData Services 1 Fiori Apps

Product Assignable to Store

C_ProdAssgblToStoreNarrowVH is a Consumption CDS View that provides data about "Product Assignable to Store" in SAP S/4HANA. It reads from 1 data source (C_ProdAssgblToStoreVH) and exposes 8 fields with key field Product. It is exposed through 3 OData services (JOULE_RFM_MNG_ASSTMT_MODULES, UI_RFM_MNG_ASSTMT_MODULES, UI_RFM_PROD_ASSIGN_EXPL_ASM). It is used in 1 Fiori application: Manage Assortment Modules. Part of development package RFM_ASSORTMENT_MDL_APPS_COMMON.

Data Sources (1)

SourceAliasJoin Type
C_ProdAssgblToStoreVH Product from

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Consumption.ranked true view
EndUserText.label Product Assignable to Store view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey Product view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
VDM.viewType #CONSUMPTION view

OData Services (3)

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
UI_RFM_PROD_ASSIGN_EXPL_ASM UI_RFM_PROD_ASSGN_EXPL_ASM 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 (8)

KeyFieldSource TableSource FieldDescription
KEY Product Product Product Sold
ProductName ProductName Description
AuthorizationGroup AuthorizationGroup AuthorizGroup
ProductType ProductType Product Type Group
_ProductType _ProductType
MerchandiseCategory MerchandiseCategory
_ProductGroup _ProductGroup
_ProductGroup_2 _ProductGroup_2

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_ProdAssgblToStoreNarrowVH.
-- 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_ProdAssgblToStoreNarrowVH AS
SELECT
  Product,
  ProductName,
  AuthorizationGroup,
  ProductType,
  MerchandiseCategory
FROM C_ProdAssgblToStoreVH AS Product
;

Learn More