C_AsstmtMdlUserToAsstmtMdlTP

DDL: C_ASSTMTMDLUSERTOASSTMTMDLTP Type: view_entity CONSUMPTION
21 Fields 1 Data Sources

Assortment User Assignment to Assortment Module

C_AsstmtMdlUserToAsstmtMdlTP is a Consumption CDS View that provides data about "Assortment User Assignment to Assortment Module" in SAP S/4HANA. It reads from 1 data source (I_AssMdlUserToExplctAssMdlTP_2) and exposes 21 fields with key fields AssortmentModuleUUID, AssortmentModuleUser, ValidityStartDate.

Data Sources (1)

SourceAliasJoin Type
I_AssMdlUserToExplctAssMdlTP_2 I_AssMdlUserToExplctAssMdlTP_2 projection

Annotations (8)

NameValueLevelField
EndUserText.label Assortment User Assignment to Assortment Module view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
ObjectModel.representativeKey AssortmentModuleUser view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY AssortmentModuleUUID AssortmentModuleUUID
KEY AssortmentModuleUser AssortmentModuleUser
KEY ValidityStartDate ValidityStartDate Validity Start Date
AssortmentModuleName AssortmentModuleName
ValidityEndDate ValidityEndDate ValidTo
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUserName LastChangedByUserName User Name
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Country
CountryNameasCountryNamelocalized
CityName
SiteName _Site SiteName
SalesOrganizationNamelocalized
DistributionChannelNamelocalized
AsstmtMdlProdExclusionPercent _ExclusionRatio AsstmtMdlProdExclusionPercent
_Exclusions _Exclusions
_ExplicitAssortmentModule _ExplicitAssortmentModule
_Products _Products
_Text _Text
_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_AsstmtMdlUserToAsstmtMdlTP.
-- 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_AsstmtMdlUserToAsstmtMdlTP AS
SELECT
  AssortmentModuleUUID,
  AssortmentModuleUser,
  ValidityStartDate,
  AssortmentModuleName,
  ValidityEndDate,
  LastChangeDateTime,
  LastChangedByUserName,
  SalesOrganization,
  DistributionChannel,
  cast( _Site._Address._Country.Country as rfm_asm_country preserving type) AS Country,
  _Site._Address._Country._Text.CountryName as CountryName : localized AS CountryNameasCountryNamelocalized,
  _Site._Address.CityName AS CityName,
  _Site.SiteName AS SiteName,
  _Site._SalesOrganization._Text.SalesOrganizationName : localized AS SalesOrganizationNamelocalized,
  _Site._DistributionChannel._Text.DistributionChannelName : localized AS DistributionChannelNamelocalized,
  _ExclusionRatio.AsstmtMdlProdExclusionPercent AS AsstmtMdlProdExclusionPercent
FROM I_AssMdlUserToExplctAssMdlTP_2
;

Learn More