P_EBPAO_TR_VarianceByType3

DDL: P_EBPAO_TR_VARIANCEBYTYPE3 SQL: PEBPAOTRVRCBT3 Type: view COMPOSITE

P_EBPAO_TR_VarianceByType3 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_EBPAO_OrderContextForHdrOnly, P_EBPAO_TR_VarianceByType2) and exposes 11 fields with key fields CompanyCode, OrderID, OrderType, OrderCategory, ControllingArea.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
P_EBPAO_OrderContextForHdrOnly OrderContext from
P_EBPAO_TR_VarianceByType2 P_EBPAO_TR_VarianceByType2 inner

Parameters (5)

NameTypeDefault
P_Ledger fins_ledger
P_FromFiscalYearPeriod fins_fyearperiod
P_ToFiscalYearPeriod fins_fyearperiod
P_CurrencyRole fac_crcyrole
P_SubLedgerAcctLineItemType slalittype

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PEBPAOTRVRCBT3 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_EBPAO_OrderContextForHdrOnly CompanyCode
KEY OrderID P_EBPAO_OrderContextForHdrOnly OrderID
KEY OrderType P_EBPAO_OrderContextForHdrOnly OrderType
KEY OrderCategory P_EBPAO_OrderContextForHdrOnly OrderCategory
KEY ControllingArea P_EBPAO_OrderContextForHdrOnly ControllingArea
KEY Plant P_EBPAO_OrderContextForHdrOnly Plant
KEY StorageLocation P_EBPAO_OrderContextForHdrOnly StorageLocation
KEY ProfitCenter P_EBPAO_OrderContextForHdrOnly ProfitCenter
KEY Product P_EBPAO_OrderContextForHdrOnly Product
KEY ProductGroup P_EBPAO_OrderContextForHdrOnly ProductGroup
AmountInDisplayCurrency 
@AbapCatalog.sqlViewName: 'PEBPAOTRVRCBT3'

@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM.private: true
@VDM.viewType: #COMPOSITE

define view P_EBPAO_TR_VarianceByType3
  with parameters
    P_Ledger                    : fins_ledger,
    P_FromFiscalYearPeriod      : fins_fyearperiod,
    P_ToFiscalYearPeriod        : fins_fyearperiod,
    P_CurrencyRole              : fac_crcyrole,
    P_SubLedgerAcctLineItemType : slalittype
  as select from P_EBPAO_OrderContextForHdrOnly                                                           as OrderContext
    inner join   P_EBPAO_TR_VarianceByType2( P_Ledger                    : :P_Ledger,
                                             P_FromFiscalYearPeriod      : :P_FromFiscalYearPeriod,
                                             P_ToFiscalYearPeriod        : :P_ToFiscalYearPeriod,
                                             P_CurrencyRole              : :P_CurrencyRole,
                                             P_SubLedgerAcctLineItemType : :P_SubLedgerAcctLineItemType ) as VarianceCost on  OrderContext.CompanyCode = VarianceCost.CompanyCode
                                                                                                                          and OrderContext.OrderID     = VarianceCost.OrderID
{
  key OrderContext.CompanyCode,
  key OrderContext.OrderID,
  key OrderContext.OrderType,
  key OrderContext.OrderCategory,
  key OrderContext.ControllingArea,
  key OrderContext.Plant,
  key OrderContext.StorageLocation,
  key OrderContext.ProfitCenter,
  key OrderContext.Product,
  key OrderContext.ProductGroup,

      sum(VarianceCost.AmountInDisplayCurrency) as AmountInDisplayCurrency
}
group by
  OrderContext.CompanyCode,
  OrderContext.OrderID,
  OrderContext.OrderType,
  OrderContext.OrderCategory,
  OrderContext.ControllingArea,
  OrderContext.Plant,
  OrderContext.StorageLocation,
  OrderContext.ProfitCenter,
  OrderContext.Product,
  OrderContext.ProductGroup
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_EBPAO_ORDERCONTEXTFORHDRONLY",
"P_EBPAO_TR_VARIANCEBYTYPE2"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More