I_ProdToExplicitAsstmtMdlTP

DDL: I_PRODTOEXPLICITASSTMTMDLTP Type: view_entity TRANSACTIONAL
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.

Data Sources (1)

SourceAliasJoin Type
I_ProdToExplicitAsstmtModule I_ProdToExplicitAsstmtModule 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 AssortmentModuleUUID
KEY Product Product Product Sold
KEY AssortmentModuleName AssortmentModuleName
ProductIsMandatoryInAssortment ProductIsMandatoryInAssortment
RatioOfUsersWhoExcludedProdVal
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
LastChangeDate LastChangeDate Time Stamp
LastChangeDateTime LastChangeDateTime Timestamp
_ModuleVersion _ModuleVersion
_Text _Text
_Product _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
  AssortmentModuleUUID,
  Product,
  AssortmentModuleName,
  ProductIsMandatoryInAssortment,
  cast ( coalesce ( _ExclusionRatio.RatioOfUsersWhoExcludedProdVal, '0%' ) as rfm_asm_usr_prod_excl_percent preserving type ) AS RatioOfUsersWhoExcludedProdVal,
  ValidityStartDate,
  ValidityEndDate,
  LastChangeDate,
  LastChangeDateTime
FROM I_ProdToExplicitAsstmtModule
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