A_SeasonSalesPeriod

DDL: A_SEASONSALESPERIOD Type: view COMPOSITE
29 Fields 2 Data Sources

API view for season sd periods

A_SeasonSalesPeriod is a Composite CDS View that provides data about "API view for season sd periods" in SAP S/4HANA. It reads from 2 data sources (I_Customer, I_SeasonSalesPeriod) and exposes 29 fields with key field ConditionRecord.

Data Sources (2)

SourceAliasJoin Type
I_Customer I_Customer left_outer
I_SeasonSalesPeriod I_SeasonSalesPeriod from

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName ASEASONSDPERIODS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label API view for season sd 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 (29)

KeyFieldSource TableSource FieldDescription
KEY ConditionRecord ConditionRecord Cond.Record No.
ProductSeasonYear ProductSeasonYear Season Year
ProductSeason ProductSeason Season
ProductCollection ProductCollection Collection
ProductTheme ProductTheme Theme
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Country I_SeasonSalesPeriod Country Venue: Ctry/Reg
Region I_SeasonSalesPeriod Region Venue Region
CustomerGroup CustomerGroup Customer Group
SoldToParty SoldToParty Sold-to Party
SalesDistrict SalesDistrict Sales District
PartnerFunction PartnerFunction Partner Functn
DeliveryStartDate DeliveryStartDate Deliv.Date From
DeliveryEndDate DeliveryEndDate Deliv. Date To
OrderStartDate OrderStartDate Order Date From
OrderEndDate OrderEndDate Order Date To
StoreSaleStartDate StoreSaleStartDate sale from (str)
StoreSaleEndDate StoreSaleEndDate sale till (str)
DeliveryDateIsProposed DeliveryDateIsProposed Del. Date Check
ProposedDeliveryDate ProposedDeliveryDate Proposed Delivery Date
ATPCheckStartDate ATPCheckStartDate Start Date ATP
PreferredDeliveryDate PreferredDeliveryDate Prfrd Deliv Date
CreatedByUser I_SeasonSalesPeriod CreatedByUser User Name
CreationDate I_SeasonSalesPeriod CreationDate Time Stamp
CreationTime I_SeasonSalesPeriod 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_SeasonSalesPeriod.
-- 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_SeasonSalesPeriod AS
SELECT
  ConditionRecord,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  SalesOrganization,
  DistributionChannel,
  I_SeasonSalesPeriod.Country AS Country,
  I_SeasonSalesPeriod.Region AS Region,
  CustomerGroup,
  SoldToParty,
  SalesDistrict,
  PartnerFunction,
  DeliveryStartDate,
  DeliveryEndDate,
  OrderStartDate,
  OrderEndDate,
  StoreSaleStartDate,
  StoreSaleEndDate,
  DeliveryDateIsProposed,
  ProposedDeliveryDate,
  ATPCheckStartDate,
  PreferredDeliveryDate,
  I_SeasonSalesPeriod.CreatedByUser AS CreatedByUser,
  I_SeasonSalesPeriod.CreationDate AS CreationDate,
  I_SeasonSalesPeriod.CreationTime AS CreationTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime
FROM I_SeasonSalesPeriod
LEFT OUTER JOIN I_Customer ON /* join condition not captured in parsed metadata */
;

Learn More