A_SeasonSalesPeriod

DDL: A_SEASONSALESPERIOD Type: view COMPOSITE Package: VDM_RFM_SEASON

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. Part of development package VDM_RFM_SEASON.

2 data source(s) 29 fields

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
ProductSeasonYear ProductSeasonYear
ProductSeason ProductSeason
ProductCollection ProductCollection
ProductTheme ProductTheme
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
Country I_SeasonSalesPeriod Country
Region I_SeasonSalesPeriod Region
CustomerGroup CustomerGroup
SoldToParty SoldToParty
SalesDistrict SalesDistrict
PartnerFunction PartnerFunction
DeliveryStartDate DeliveryStartDate
DeliveryEndDate DeliveryEndDate
OrderStartDate OrderStartDate
OrderEndDate OrderEndDate
StoreSaleStartDate StoreSaleStartDate
StoreSaleEndDate StoreSaleEndDate
DeliveryDateIsProposed DeliveryDateIsProposed
ProposedDeliveryDate ProposedDeliveryDate
ATPCheckStartDate ATPCheckStartDate
PreferredDeliveryDate PreferredDeliveryDate
CreatedByUser I_SeasonSalesPeriod CreatedByUser
CreationDate I_SeasonSalesPeriod CreationDate
CreationTime I_SeasonSalesPeriod CreationTime
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
LastChangeTime LastChangeTime 
@AbapCatalog: {
  sqlViewName: 'ASEASONSDPERIODS',
  compiler.compareFilter: true,
  preserveKey: true
}
@EndUserText.label: 'API view for season sd periods'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
   viewType: #COMPOSITE,
   lifecycle.contract.type: #PUBLIC_REMOTE_API
   }
@ObjectModel: {
   representativeKey: 'ConditionRecord',
   createEnabled: true,
   deleteEnabled: true,
   updateEnabled: true,
   usageType: {
     dataClass:      #MASTER,
     serviceQuality: #C,
     sizeCategory:   #M
   },
   semanticKey: ['ConditionRecord', 'ProductSeasonYear', 'ProductSeason', 'ProductCollection', 'ProductTheme']
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #BLOCKED_DATA_EXCLUDED
}
@Metadata.ignorePropagatedAnnotations: true


define view A_SeasonSalesPeriod
  as select from    I_SeasonSalesPeriod
    left outer join I_Customer on I_SeasonSalesPeriod.SoldToParty = I_Customer.Customer
{
      //I_SEASONSALESPERIOD

  key 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,
      @ObjectModel.readOnly: true
      I_SeasonSalesPeriod.CreatedByUser as CreatedByUser,
      @ObjectModel.readOnly: true
      I_SeasonSalesPeriod.CreationDate  as CreationDate,
      @ObjectModel.readOnly: true
      I_SeasonSalesPeriod.CreationTime  as CreationTime,
      @ObjectModel.readOnly: true
      LastChangedByUser,
      @ObjectModel.readOnly: true
      LastChangeDate,
      @ObjectModel.readOnly: true
      LastChangeTime
}
where
     I_Customer.IsBusinessPurposeCompleted = ''
  or I_SeasonSalesPeriod.SoldToParty       = '';

Learn More