C_AssortmentModuleTP

DDL: C_ASSORTMENTMODULETP Type: view_entity CONSUMPTION Package: RFM_MANAGE_ASSTMT_MODULES
11 Fields 1 Data Sources 1 OData Services 1 Fiori Apps

Assortment Module

C_AssortmentModuleTP is a Consumption CDS View that provides data about "Assortment Module" in SAP S/4HANA. It reads from 1 data source (I_ExplicitAssortmentModuleTP) and exposes 11 fields with key field AssortmentModuleUUID. It is exposed through 1 OData service (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 (1)

SourceAliasJoin Type
I_ExplicitAssortmentModuleTP I_ExplicitAssortmentModuleTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Assortment Module view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
ObjectModel.representativeKey AssortmentModuleUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
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 (11)

KeyFieldSource TableSource FieldDescription
KEY AssortmentModuleUUID AssortmentModuleUUID
AssortmentModuleName AssortmentModuleName
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUserName LastChangedByUserName User Name
VersionValidityStartDate _CurrentVersion ValidityStartDate Validity Start Date
VersionValidityEndDate _CurrentVersion ValidityEndDate ValidTo
ValidityEndDate _MaxVersionValidityEnd ValidityEndDate ValidTo
virtualUICT_CanBeTerminatedboolean
NumberOfFutureVersions _NrOfFutureVersions NumberOfFutureVersions
NumberOfUserAssignments _NrOfAssortmentUsers NumberOfUserAssignments
_User _User

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_AssortmentModuleTP.
-- 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_AssortmentModuleTP AS
SELECT
  AssortmentModuleUUID,
  AssortmentModuleName,
  LastChangeDateTime,
  LastChangedByUserName,
  _CurrentVersion.ValidityStartDate AS VersionValidityStartDate,
  _CurrentVersion.ValidityEndDate AS VersionValidityEndDate,
  _MaxVersionValidityEnd.ValidityEndDate AS ValidityEndDate,
  virtual UICT_CanBeTerminated : boolean AS virtualUICT_CanBeTerminatedboolean,
  _NrOfFutureVersions.NumberOfFutureVersions AS NumberOfFutureVersions,
  _NrOfAssortmentUsers.NumberOfUserAssignments AS NumberOfUserAssignments
FROM I_ExplicitAssortmentModuleTP
;

Learn More