I_VersionDetail

DDL: I_VERSIONDETAIL Type: view_entity COMPOSITE
6 Fields 2 Data Sources

Version Listing

I_VersionDetail is a Composite CDS View that provides data about "Version Listing" in SAP S/4HANA. It reads from 2 data sources (I_ExplicitAssortmentModule, I_ProductToAssortmentModule) and exposes 6 fields with key fields AssortmentModuleUUID, AssortmentModuleVersionUUID.

Data Sources (2)

SourceAliasJoin Type
I_ExplicitAssortmentModule module inner
I_ProductToAssortmentModule product_assignments inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Version Listing view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY AssortmentModuleUUID version AssortmentModuleUUID Recipe GUID
KEY AssortmentModuleVersionUUID version AssortmentModuleVersionUUID
AssortmentModuleName I_ExplicitAssortmentModule AssortmentModuleName Assortment Module
AssortmentModuleVersionName version AssortmentModuleName Assortment Module
ValidityStartDate version ValidityStartDate Validity Start Date
ValidityEndDate version ValidityEndDate ValidTo

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_VersionDetail.
-- 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_VersionDetail AS
SELECT
  version.AssortmentModuleUUID AS AssortmentModuleUUID,
  version.AssortmentModuleVersionUUID AS AssortmentModuleVersionUUID,
  module.AssortmentModuleName AS AssortmentModuleName,
  version.AssortmentModuleName AS AssortmentModuleVersionName,
  version.ValidityStartDate AS ValidityStartDate,
  version.ValidityEndDate AS ValidityEndDate
INNER JOIN I_ExplicitAssortmentModule AS module ON /* join condition not captured in parsed metadata */
INNER JOIN I_ProductToAssortmentModule AS product_assignments ON /* join condition not captured in parsed metadata */
;

Learn More