I_ProdToExplicitAsstmtMdlTP

DDL: I_PRODTOEXPLICITASSTMTMDLTP Type: view_entity TRANSACTIONAL Package: RFM_ASSORTMENT_RAP_EXPLICIT
14 Fields 1 Data Sources 2 Associations

Product Assignment to Assortment Module

I_ProdToExplicitAsstmtMdlTP is a Transactional CDS View that provides data about "Product Assignment to Assortment Module" in SAP S/4HANA. It reads from 1 data source (I_ProdToExplicitAsstmtModule) and exposes 14 fields with key fields AssortmentModuleUUID, Product, AssortmentModuleName. It has 2 associations to related views. Part of development package RFM_ASSORTMENT_RAP_EXPLICIT.

Data Sources (1)

SourceAliasJoin Type
I_ProdToExplicitAsstmtModule AssortmentModule from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ProdAssgblToExplctModuleTP _AssignableProduct $projection.Product = _AssignableProduct.Product
[1..*] I_ProdToExplctAsstmtMdlVersTP _ProdToExplctMdlVers

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Product Assignment to Assortment Module view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.sapObjectNodeType.name AssortmentModuleProductAssgmt view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY AssortmentModuleUUID I_ProdToExplicitAsstmtModule AssortmentModuleUUID
KEY Product I_ProdToExplicitAsstmtModule Product Product Sold
KEY AssortmentModuleName I_ProdToExplicitAsstmtModule AssortmentModuleName
ProductIsMandatoryInAssortment I_ProdToExplicitAsstmtModule ProductIsMandatoryInAssortment
RatioOfUsersWhoExcludedProdVal
ValidityStartDate I_ProdToExplicitAsstmtModule ValidityStartDate Validity Start Date
ValidityEndDate I_ProdToExplicitAsstmtModule ValidityEndDate ValidTo
LastChangeDate I_ProdToExplicitAsstmtModule LastChangeDate Time Stamp
LastChangeDateTime I_ProdToExplicitAsstmtModule LastChangeDateTime Timestamp
_ModuleVersion I_ProdToExplicitAsstmtModule _ModuleVersion
_Text I_ProdToExplicitAsstmtModule _Text
_Product I_ProdToExplicitAsstmtModule _Product
_AssignableProduct _AssignableProduct
_ProdToExplctMdlVers _ProdToExplctMdlVers

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_ProdToExplicitAsstmtMdlTP.
-- 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_ProdToExplicitAsstmtMdlTP AS
SELECT
  AssortmentModule.AssortmentModuleUUID AS AssortmentModuleUUID,
  AssortmentModule.Product AS Product,
  AssortmentModule.AssortmentModuleName AS AssortmentModuleName,
  AssortmentModule.ProductIsMandatoryInAssortment AS ProductIsMandatoryInAssortment,
  cast ( coalesce ( AssortmentModule._ExclusionRatio.RatioOfUsersWhoExcludedProdVal, '0%' ) as rfm_asm_usr_prod_excl_percent preserving type ) AS RatioOfUsersWhoExcludedProdVal,
  AssortmentModule.ValidityStartDate AS ValidityStartDate,
  AssortmentModule.ValidityEndDate AS ValidityEndDate,
  AssortmentModule.LastChangeDate AS LastChangeDate,
  AssortmentModule.LastChangeDateTime AS LastChangeDateTime,
  AssortmentModule._ModuleVersion AS _ModuleVersion,
  AssortmentModule._Text AS _Text,
  AssortmentModule._Product AS _Product
FROM I_ProdToExplicitAsstmtModule AS AssortmentModule
LEFT OUTER JOIN I_ProdAssgblToExplctModuleTP AS _AssignableProduct ON Product = _AssignableProduct.Product  -- association [1..1]
LEFT OUTER JOIN I_ProdToExplctAsstmtMdlVersTP AS _ProdToExplctMdlVers ON /* condition not available in parsed metadata */  -- association [1..*]
;

Learn More