P_SPP_TrainingData06

DDL: P_SPP_TRAININGDATA06 SQL: PSDSPPTDA06 Type: view COMPOSITE

P_SPP_TrainingData06 is a Composite CDS View in SAP S/4HANA. It reads from 5 data sources (I_Customer, P_SPP_TrainingData05A2, P_SPP_TrainingDate02, I_Product, I_SalesOrganization) and exposes 30 fields with key fields YearMonth, PartOfMonth, SalesOrganization, DistributionChannel, Division.

5 data source(s) 30 fields

Data Sources (5)

SourceAliasJoin Type
I_Customer C left_outer
P_SPP_TrainingData05A2 Data05A2 from
P_SPP_TrainingDate02 Date02 left_outer
I_Product P left_outer
I_SalesOrganization SO left_outer

Annotations (6)

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

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY YearMonth P_SPP_TrainingData05A2 YearMonth
KEY PartOfMonth P_SPP_TrainingData05A2 PartOfMonth
KEY SalesOrganization P_SPP_TrainingData05A2 SalesOrganization
KEY DistributionChannel P_SPP_TrainingData05A2 DistributionChannel
KEY Division P_SPP_TrainingData05A2 Division
KEY SoldToParty P_SPP_TrainingData05A2 SoldToParty
KEY CustomerGroup P_SPP_TrainingData05A2 CustomerGroup
KEY Material P_SPP_TrainingData05A2 Material
KEY MaterialGroup P_SPP_TrainingData05A2 MaterialGroup
KEY BillingDocumentType P_SPP_TrainingData05A2 BillingDocumentType
YearQuarter YearQuarter
PartOfQuarter PartOfQuarter
CalendarWeek CalendarWeek
CalendarMonth CalendarMonth
CalendarQuarter CalendarQuarter
Previous1YearMonth Previous1YearMonth
Previous1YearQuarter Previous1YearQuarter
CustomerClassification CustomerClassification
CustomerAccountGroup CustomerAccountGroup
IsOneTimeAccount IsOneTimeAccount
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
Industry Industry
Country Country
CityName CityName
ProductType ProductType
CompanyCode CompanyCode
CntByPOM CntByPOM
SumAmtByPOM SumAmtByPOM
MaxAmtByPOM MaxAmtByPOM
MinAmtByPOM MinAmtByPOM 
@AbapCatalog.sqlViewName: 'PSDSPPTDA06'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE

define view P_SPP_TrainingData06
as select from P_SPP_TrainingData05A2 as Data05A2
left outer join P_SPP_TrainingDate02 as Date02
  on Data05A2.YearMonth = Date02.YearMonth
    and Data05A2.PartOfMonth = Date02.PartOfMonth
left outer join I_Customer as C
  on Data05A2.SoldToParty = C.Customer
left outer join I_Product as P
  on Data05A2.Material = P.Product
left outer join I_SalesOrganization as SO
  on Data05A2.SalesOrganization = SO.SalesOrganization
{
  key Data05A2.YearMonth,
  key Data05A2.PartOfMonth,
  key Data05A2.SalesOrganization,
  key Data05A2.DistributionChannel,
  key Data05A2.Division,
  key Data05A2.SoldToParty,
  key Data05A2.CustomerGroup,
  key Data05A2.Material,
  key Data05A2.MaterialGroup,
  key Data05A2.BillingDocumentType,
  
  YearQuarter,
  PartOfQuarter,
  
  CalendarWeek,
  CalendarMonth,
  CalendarQuarter,
  
  Previous1YearMonth,
  Previous1YearQuarter,
 
  CustomerClassification,
  CustomerAccountGroup,
  IsOneTimeAccount,
  IsBusinessPurposeCompleted,
  Industry,
  Country,
  CityName,
  ProductType,
  CompanyCode,
  
  CntByPOM,
  SumAmtByPOM,
  MaxAmtByPOM,
  MinAmtByPOM
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMER",
"I_PRODUCT",
"I_SALESORGANIZATION",
"P_SPP_TRAININGDATA05A2",
"P_SPP_TRAININGDATE02"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More