P_EBPAO_ActualCost

DDL: P_EBPAO_ACTUALCOST SQL: PEBPAOACTCOST Type: view COMPOSITE

P_EBPAO_ActualCost is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_LedgerCompanyCodeCrcyRoles, P_EBPAO_ActualCost1) and exposes 10 fields with key fields CompanyCode, OrderID, OrderType, OrderCategory, ControllingArea.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
I_LedgerCompanyCodeCrcyRoles CurrencyRoles inner
P_EBPAO_ActualCost1 P_EBPAO_ActualCost1 from

Parameters (4)

NameTypeDefault
P_Ledger fins_ledger
P_FromFiscalYearPeriod fins_fyearperiod
P_ToFiscalYearPeriod fins_fyearperiod
P_CurrencyRole fis_curtp

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PEBPAOACTCOST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode ActualCost CompanyCode
KEY OrderID ActualCost OrderID
KEY OrderType ActualCost OrderType
KEY OrderCategory ActualCost OrderCategory
KEY ControllingArea ActualCost ControllingArea
KEY Plant ActualCost Plant
KEY StorageLocation ActualCost StorageLocation
KEY ProfitCenter ActualCost ProfitCenter
KEY Product ActualCost Product
KEY ProductGroup ActualCost ProductGroup 
@AbapCatalog.sqlViewName: 'PEBPAOACTCOST'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #MIXED
}
@VDM: {
  private: true,
  viewType: #COMPOSITE
}
define view P_EBPAO_ActualCost
  with parameters
    P_Ledger               : fins_ledger,
    P_FromFiscalYearPeriod : fins_fyearperiod,
    P_ToFiscalYearPeriod   : fins_fyearperiod,
    P_CurrencyRole         : fis_curtp
  as select from P_EBPAO_ActualCost1( P_Ledger               : :P_Ledger,
                                      P_FromFiscalYearPeriod : :P_FromFiscalYearPeriod,
                                      P_ToFiscalYearPeriod   : :P_ToFiscalYearPeriod ) as ActualCost
    inner join   I_LedgerCompanyCodeCrcyRoles                                          as CurrencyRoles on  CurrencyRoles.CompanyCode = ActualCost.CompanyCode
                                                                                                        and CurrencyRoles.Ledger      = :P_Ledger
{
  key ActualCost.CompanyCode,
  key ActualCost.OrderID,
  key ActualCost.OrderType,
  key ActualCost.OrderCategory,
  key ActualCost.ControllingArea,
  key ActualCost.Plant,
  key ActualCost.StorageLocation,
  key ActualCost.ProfitCenter,
  key ActualCost.Product,
  key ActualCost.ProductGroup,

      cast(
        case :P_CurrencyRole
           when CurrencyRoles.CompanyCodeCurrencyRole  then ActualCost.AmountInCompanyCodeCurrency
           when CurrencyRoles.GlobalCurrencyRole       then ActualCost.AmountInGlobalCurrency
           when CurrencyRoles.FreeDefinedCurrency1Role then ActualCost.AmountInFreeDefinedCurrency1
           when CurrencyRoles.FreeDefinedCurrency2Role then ActualCost.AmountInFreeDefinedCurrency2
           when CurrencyRoles.FreeDefinedCurrency3Role then ActualCost.AmountInFreeDefinedCurrency3
           when CurrencyRoles.FreeDefinedCurrency4Role then ActualCost.AmountInFreeDefinedCurrency4
           when CurrencyRoles.FreeDefinedCurrency5Role then ActualCost.AmountInFreeDefinedCurrency5
           when CurrencyRoles.FreeDefinedCurrency6Role then ActualCost.AmountInFreeDefinedCurrency6
           when CurrencyRoles.FreeDefinedCurrency7Role then ActualCost.AmountInFreeDefinedCurrency7
           when CurrencyRoles.FreeDefinedCurrency8Role then ActualCost.AmountInFreeDefinedCurrency8
         else 0
      end as farp_amount_display_crcy) as AmountInDisplayCurrency
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LEDGERCOMPANYCODECRCYROLES",
"P_EBPAO_ACTUALCOST1"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More