P_SPP_TrainingData05B1

DDL: P_SPP_TRAININGDATA05B1 SQL: PSDSPPTDA05B1 Type: view COMPOSITE Package: VDM_SD_PREDICTED_SALES

Training Data 05B1

P_SPP_TrainingData05B1 is a Composite CDS View that provides data about "Training Data 05B1" in SAP S/4HANA. It reads from 2 data sources (P_SPP_TrainingData04, P_SPP_TrainingDate02) and exposes 11 fields with key fields YearQuarter, PartOfQuarter, SalesOrganization, DistributionChannel, Division. Part of development package VDM_SD_PREDICTED_SALES.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
P_SPP_TrainingData04 Data04 left_outer
P_SPP_TrainingDate02 Date02 from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PSDSPPTDA05B1 view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY YearQuarter P_SPP_TrainingDate02 YearQuarter
KEY PartOfQuarter P_SPP_TrainingDate02 PartOfQuarter
KEY SalesOrganization SalesOrganization
KEY DistributionChannel DistributionChannel
KEY Division Division
KEY SoldToParty SoldToParty
KEY CustomerGroup CustomerGroup
KEY Material Material
KEY MaterialGroup MaterialGroup
KEY BillingDocumentType BillingDocumentType
Amount Amount 
@AbapCatalog.sqlViewName: 'PSDSPPTDA05B1'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE

define view P_SPP_TrainingData05B1
as select from P_SPP_TrainingDate02 as Date02
left outer join P_SPP_TrainingData04 as Data04
  on Date02.YearQuarter = Data04.YearQuarter
    and Date02.PartOfQuarter >= Data04.PartOfQuarter
{
  key Date02.YearQuarter,
  key Date02.PartOfQuarter,
  
  key SalesOrganization,
  key DistributionChannel,
  key Division,
  key SoldToParty,
  key CustomerGroup,
  key Material,
  key MaterialGroup,
  key BillingDocumentType,
  
  Amount
}

Learn More