C_ProdStoreToExplctAsstmtMdl

DDL: C_PRODSTORETOEXPLCTASSTMTMDL Type: view_entity CONSUMPTION Package: RFM_ASSIGN_ASM_USR_TO_EXPL_ASM
10 Fields 1 Data Sources 1 OData Services

Product-Store Assignment via Assortment Module

C_ProdStoreToExplctAsstmtMdl is a Consumption CDS View that provides data about "Product-Store Assignment via Assortment Module" in SAP S/4HANA. It reads from 1 data source (R_ProdStoreToExplctAsstmtMdlTP) and exposes 10 fields with key fields AssortmentModuleUUID, Product, AssortmentModuleUser, AssignmentValidityStartDate. It is exposed through 1 OData service (UI_RFM_USER_ASSIGN_EXPL_ASM). Part of development package RFM_ASSIGN_ASM_USR_TO_EXPL_ASM.

Data Sources (1)

SourceAliasJoin Type
R_ProdStoreToExplctAsstmtMdlTP R_ProdStoreToExplctAsstmtMdlTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Product-Store Assignment via Assortment Module view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.sapObjectNodeType.name ListingCondition view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_RFM_USER_ASSIGN_EXPL_ASM UI_RFM_USR_ASSIGN_EXPL_ASM V2 C1 NOT_RELEASED

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY AssortmentModuleUUID AssortmentModuleUUID
KEY Product Product Sold
KEY AssortmentModuleUser AssortmentModuleUser
KEY AssignmentValidityStartDate AssignmentValidityStartDate Validity Start Date
ProductIsMandatoryInAssortment ProductIsMandatoryInAssortment
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
SalesOrganization SalesOrganization Sales Organization
ProductNamelocalized

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_ProdStoreToExplctAsstmtMdl.
-- 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_ProdStoreToExplctAsstmtMdl AS
SELECT
  AssortmentModuleUUID,
  cast ( Product as productnumber preserving type ) AS Product,
  AssortmentModuleUser,
  AssignmentValidityStartDate,
  ProductIsMandatoryInAssortment,
  ValidityStartDate,
  ValidityEndDate,
  DistributionChannel,
  SalesOrganization,
  _Product._Text.ProductName : localized AS ProductNamelocalized
FROM R_ProdStoreToExplctAsstmtMdlTP
;

Learn More