A_SeasonPurchasePeriod

DDL: A_SEASONPURCHASEPERIOD Type: view COMPOSITE

Season Purchase Period

A_SeasonPurchasePeriod is a Composite CDS View that provides data about "Season Purchase Period" 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 Season Purchase Period 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
ProductSeasonYear ProductSeasonYear
ProductSeason ProductSeason
ProductCollection ProductCollection
ProductTheme ProductTheme
PurchasingOrganization PurchasingOrganization
PurchasingGroup PurchasingGroup
Supplier I_SeasonPurchasePeriod Supplier
DeliveryStartDate DeliveryStartDate
DeliveryEndDate DeliveryEndDate
OrderStartDate OrderStartDate
OrderEndDate OrderEndDate
CreatedByUser I_SeasonPurchasePeriod CreatedByUser
CreationDate I_SeasonPurchasePeriod CreationDate
CreationTime CreationTime
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
LastChangeTime LastChangeTime
@AbapCatalog: {
  sqlViewName: 'ASEASONMMPERIOD',
  compiler.compareFilter: true,
  preserveKey: true
}
@EndUserText.label: 'Season Purchase Period'
@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: {
  //privilegedAssociations: ['_CreatedByUser', '_ChangedByUser'],

  authorizationCheck: #CHECK  ,
  personalData.blocking: #BLOCKED_DATA_EXCLUDED
}
@Metadata.ignorePropagatedAnnotations: true

define view A_SeasonPurchasePeriod
  as select from    I_SeasonPurchasePeriod
    left outer join I_Supplier on I_SeasonPurchasePeriod.Supplier = I_Supplier.Supplier
{
      //I_SEASONPURCHASEPERIOD

  key ConditionRecord,
      ProductSeasonYear,
      ProductSeason,
      ProductCollection,
      ProductTheme,
      PurchasingOrganization,
      PurchasingGroup,
      I_SeasonPurchasePeriod.Supplier      as Supplier,
      DeliveryStartDate,
      DeliveryEndDate,
      OrderStartDate,
      OrderEndDate,
      @ObjectModel.readOnly: true
      I_SeasonPurchasePeriod.CreatedByUser as CreatedByUser,
      @ObjectModel.readOnly: true
      I_SeasonPurchasePeriod.CreationDate  as CreationDate,
      @ObjectModel.readOnly: true
      CreationTime,
      @ObjectModel.readOnly: true
      LastChangedByUser,
      @ObjectModel.readOnly: true
      LastChangeDate,
      @ObjectModel.readOnly: true
      LastChangeTime
}
where
     I_Supplier.IsBusinessPurposeCompleted = ''
  or I_SeasonPurchasePeriod.Supplier       = '';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SEASONPURCHASEPERIOD",
"I_SUPPLIER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/