A_SeasonPurchasePeriod

DDL: A_SEASONPURCHASEPERIOD Type: view COMPOSITE
18 Fields 2 Data Sources

API view for season mm periods

A_SeasonPurchasePeriod is a Composite CDS View that provides data about "API view for season mm periods" in SAP S/4HANA. It reads from 2 data sources (I_SeasonPurchasePeriod, I_Supplier) and exposes 18 fields with key field ConditionRecord.

Data Sources (2)

SourceAliasJoin Type
I_SeasonPurchasePeriod I_SeasonPurchasePeriod from
I_Supplier I_Supplier left_outer

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName ASEASONMMPERIOD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label API view for season mm periods view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.representativeKey ConditionRecord view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ConditionRecord ConditionRecord Cond.Record No.
ProductSeasonYear ProductSeasonYear Season Year
ProductSeason ProductSeason Season
ProductCollection ProductCollection Collection
ProductTheme ProductTheme Theme
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
Supplier I_SeasonPurchasePeriod Supplier Supplier
DeliveryStartDate DeliveryStartDate Deliv.Date From
DeliveryEndDate DeliveryEndDate Deliv. Date To
OrderStartDate OrderStartDate Order Date From
OrderEndDate OrderEndDate Order Date To
CreatedByUser I_SeasonPurchasePeriod CreatedByUser User Name
CreationDate I_SeasonPurchasePeriod CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed

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 A_SeasonPurchasePeriod.
-- 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 A_SeasonPurchasePeriod AS
SELECT
  ConditionRecord,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  PurchasingOrganization,
  PurchasingGroup,
  I_SeasonPurchasePeriod.Supplier AS Supplier,
  DeliveryStartDate,
  DeliveryEndDate,
  OrderStartDate,
  OrderEndDate,
  I_SeasonPurchasePeriod.CreatedByUser AS CreatedByUser,
  I_SeasonPurchasePeriod.CreationDate AS CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime
FROM I_SeasonPurchasePeriod
LEFT OUTER JOIN I_Supplier ON /* join condition not captured in parsed metadata */
;

Learn More