I_CurrentlyValdAsstmtMdlVers

DDL: I_CURRENTLYVALDASSTMTMDLVERS Type: view_entity BASIC
8 Fields 1 Data Sources

Currently Valid Asstmt Module Version

I_CurrentlyValdAsstmtMdlVers is a Basic CDS View that provides data about "Currently Valid Asstmt Module Version" in SAP S/4HANA. It reads from 1 data source (I_ExplicitAsstmtModuleVersion) and exposes 8 fields with key field AssortmentModuleVersionUUID.

Data Sources (1)

SourceAliasJoin Type
I_ExplicitAsstmtModuleVersion I_ExplicitAsstmtModuleVersion from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Currently Valid Asstmt Module Version view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY AssortmentModuleVersionUUID AssortmentModuleVersionUUID
AssortmentModuleName AssortmentModuleName Assortment Module
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
AssortmentModuleUUID AssortmentModuleUUID Assortment UUID
LastChangeDate LastChangeDate Time Stamp
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUserName LastChangedByUserName User Name

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_CurrentlyValdAsstmtMdlVers.
-- 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_CurrentlyValdAsstmtMdlVers AS
SELECT
  AssortmentModuleVersionUUID,
  AssortmentModuleName,
  ValidityStartDate,
  ValidityEndDate,
  AssortmentModuleUUID,
  LastChangeDate,
  LastChangeDateTime,
  LastChangedByUserName
FROM I_ExplicitAsstmtModuleVersion
;

Learn More