P_SPP_TrainingData05A1

DDL: P_SPP_TRAININGDATA05A1 SQL: PSDSPPTDA05A1 Type: view COMPOSITE

P_SPP_TrainingData05A1 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_SPP_TrainingData04, P_SPP_TrainingDate02) and exposes 11 fields with key fields YearMonth, PartOfMonth, SalesOrganization, DistributionChannel, Division.

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 PSDSPPTDA05A1 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 YearMonth P_SPP_TrainingDate02 YearMonth
KEY PartOfMonth P_SPP_TrainingDate02 PartOfMonth
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: 'PSDSPPTDA05A1'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE

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

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_SPP_TRAININGDATA04",
"P_SPP_TRAININGDATE02"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More