I_ExplctAsstmtMdlExclsnRatio

DDL: I_EXPLCTASSTMTMDLEXCLSNRATIO Type: view_entity COMPOSITE
3 Fields 3 Data Sources

I_ExplctAsstmtMdlExclsnRatio is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_ExplicitAsstmtModuleVersion, I_ProductToAssortmentModule, P_MaximumSiteValidityStartDate) and exposes 3 fields with key fields AssortmentModuleGroupUUID, Product.

Data Sources (3)

SourceAliasJoin Type
I_ExplicitAsstmtModuleVersion ModuleGroups from
I_ProductToAssortmentModule ProductAssignments inner
P_MaximumSiteValidityStartDate UserAssignments inner

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY AssortmentModuleGroupUUID I_ExplicitAsstmtModuleVersion AssortmentModuleUUID Recipe GUID
KEY Product I_ProductToAssortmentModule Product Product Sold
char18asRatioOfUsersWhoExcludedProdVal

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_ExplctAsstmtMdlExclsnRatio.
-- 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_ExplctAsstmtMdlExclsnRatio AS
SELECT
  ModuleGroups.AssortmentModuleUUID AS AssortmentModuleGroupUUID,
  ProductAssignments.Product AS Product,
  concat( cast( division( cast( count( distinct Exclusions.AssortmentModuleUser )*100 as abap.dec( 13, 3 )), cast ( count( distinct UserAssignments.AssortmentModuleUser )*1 as abap.dec( 13, 3 ) ), 3 ) as abap.char(18) ), '%') as RatioOfUsersWhoExcludedProdVal AS char18asRatioOfUsersWhoExcludedProdVal
FROM I_ExplicitAsstmtModuleVersion AS ModuleGroups
INNER JOIN I_ProductToAssortmentModule AS ProductAssignments ON /* join condition not captured in parsed metadata */
INNER JOIN P_MaximumSiteValidityStartDate AS UserAssignments ON /* join condition not captured in parsed metadata */
;

Learn More