P_EBPAO_ActualCostDebitWC

DDL: P_EBPAO_ACTUALCOSTDEBITWC Type: view COMPOSITE

P_EBPAO_ActualCostDebitWC is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_LedgerCompanyCodeCrcyRoles, P_EBPAO_ActualCostDebitWC1) and exposes 11 fields with key fields OrderID, CompanyCode, ControllingArea, Plant, ProfitCenter.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
I_LedgerCompanyCodeCrcyRoles CurrencyRoles inner
P_EBPAO_ActualCostDebitWC1 P_EBPAO_ActualCostDebitWC1 from

Parameters (4)

NameTypeDefault
P_Ledger fins_ledger
P_FromFiscalYearPeriod fins_fyearperiod
P_ToFiscalYearPeriod fins_fyearperiod
P_CurrencyRole fis_curtp

Annotations (11)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PEBPAOACTDBTWC 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 (11)

KeyFieldSource TableSource FieldDescription
KEY OrderID ActualCost OrderID
KEY CompanyCode ActualCost CompanyCode
KEY ControllingArea ActualCost ControllingArea
KEY Plant ActualCost Plant
KEY ProfitCenter ActualCost ProfitCenter
KEY OrderCategory ActualCost OrderCategory
KEY OrderType ActualCost OrderType
KEY StorageLocation ActualCost StorageLocation
KEY Product ActualCost Product
KEY ProductGroup ActualCost ProductGroup
WorkCenterInternalID ActualCost WorkCenterInternalID 
@AbapCatalog: {
  compiler.compareFilter: true,
  preserveKey: true,
  sqlViewName: 'PEBPAOACTDBTWC'
}
@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_ActualCostDebitWC
  with parameters
    P_Ledger               : fins_ledger,
    P_FromFiscalYearPeriod : fins_fyearperiod,
    P_ToFiscalYearPeriod   : fins_fyearperiod,
    P_CurrencyRole         : fis_curtp
  as select from P_EBPAO_ActualCostDebitWC1( 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.OrderID,
  key ActualCost.CompanyCode,
  key ActualCost.ControllingArea,
  key ActualCost.Plant,
  key ActualCost.ProfitCenter,
  key ActualCost.OrderCategory,
  key ActualCost.OrderType,
  key ActualCost.StorageLocation,
  key ActualCost.Product,
  key ActualCost.ProductGroup,

      ActualCost.WorkCenterInternalID,

      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 fis_dr_actlcost_in_dspcrcy preserving type) as AmountInDisplayCurrency
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LEDGERCOMPANYCODECRCYROLES",
"P_EBPAO_ACTUALCOSTDEBITWC1"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More