I_ExplicitAssortmentModuleTTP

DDL: I_EXPLICITASSORTMENTMODULETTP Type: view_entity TRANSACTIONAL Package: RFM_ASSORTMENT_RAP_EXPLICIT
5 Fields 2 Data Sources

Assortment Module - Text

I_ExplicitAssortmentModuleTTP is a Transactional CDS View that provides data about "Assortment Module - Text" in SAP S/4HANA. It reads from 2 data sources (I_ExplicitAssortmentModule, I_AssortmentModuleText) and exposes 5 fields with key fields AssortmentModuleUUID, Language. Part of development package RFM_ASSORTMENT_RAP_EXPLICIT.

Data Sources (2)

SourceAliasJoin Type
I_ExplicitAssortmentModule ExplicitModule inner
I_AssortmentModuleText Text from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Assortment Module - Text view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey AssortmentModuleUUID view
ObjectModel.sapObjectNodeType.name AssortmentModuleDescription view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #META view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY AssortmentModuleUUID I_AssortmentModuleText AssortmentModuleUUID Recipe GUID
KEY Language I_AssortmentModuleText Language Report Text Language
AssortmentModuleObjectDesc I_AssortmentModuleText AssortmentModuleObjectDesc User Group
_ExplicitAssortmentModule _ExplicitAssortmentModule
_LanguageText I_AssortmentModuleText _LanguageText

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_ExplicitAssortmentModuleTTP.
-- 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_ExplicitAssortmentModuleTTP AS
SELECT
  Text.AssortmentModuleUUID AS AssortmentModuleUUID,
  Text.Language AS Language,
  Text.AssortmentModuleObjectDesc AS AssortmentModuleObjectDesc,
  Text._LanguageText AS _LanguageText
FROM I_AssortmentModuleText AS Text
INNER JOIN I_ExplicitAssortmentModule AS ExplicitModule ON /* join condition not captured in parsed metadata */
;

Learn More