P_EBPCC_ActualCost4Info

DDL: P_EBPCC_ACTUALCOST4INFO SQL: PEBPCCACTCOST Type: view COMPOSITE

P_EBPCC_ActualCost4Info is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_LedgerCompanyCodeCrcyRoles, P_EBPCC_ActualCost4Info1) and exposes 1 field with key field OrderID.

2 data source(s) 1 fields

Data Sources (2)

SourceAliasJoin Type
I_LedgerCompanyCodeCrcyRoles LedgerCompanyCodeCrcyRole inner
P_EBPCC_ActualCost4Info1 P_EBPCC_ActualCost4Info1 from

Parameters (6)

NameTypeDefault
P_OrderID fis_order_number
P_CompanyCode fis_bukrs
P_FromFiscalYearPeriod fis_jahrper
P_ToFiscalYearPeriod fis_jahrper
P_Ledger fins_ledger
P_CurrencyRole fac_crcyrole

Annotations (7)

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

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY OrderID OrderID 
@AbapCatalog.sqlViewName: 'PEBPCCACTCOST'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

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

define view P_EBPCC_ActualCost4Info
  with parameters
    P_OrderID              : fis_order_number,
    P_CompanyCode          : fis_bukrs,
    P_FromFiscalYearPeriod : fis_jahrper,
    P_ToFiscalYearPeriod   : fis_jahrper,
    P_Ledger               : fins_ledger,
    P_CurrencyRole         : fac_crcyrole
  as select from P_EBPCC_ActualCost4Info1( P_OrderID              : :P_OrderID,
                                           P_FromFiscalYearPeriod : :P_FromFiscalYearPeriod,
                                           P_ToFiscalYearPeriod   : :P_ToFiscalYearPeriod,
                                           P_Ledger               : :P_Ledger )
    inner join   I_LedgerCompanyCodeCrcyRoles as LedgerCompanyCodeCrcyRole on  LedgerCompanyCodeCrcyRole.CompanyCode = :P_CompanyCode
                                                                           and LedgerCompanyCodeCrcyRole.Ledger      = :P_Ledger
{
  key OrderID,

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

Learn More