P_RTPC_REM_OrderToBePostedKPI

DDL: P_RTPC_REM_ORDERTOBEPOSTEDKPI SQL: PRTPCREMOTBPK Type: view COMPOSITE

P_RTPC_REM_OrderToBePostedKPI is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_RTPC_REM_Order) and exposes 33 fields with key fields OrderID, Ledger.

1 data source(s) 33 fields

Data Sources (1)

SourceAliasJoin Type
P_RTPC_REM_Order _Order from

Parameters (2)

NameTypeDefault
P_FiscalPeriodStartDate budat
P_FiscalPeriodEndDate budat

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PRTPCREMOTBPK view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY OrderID P_RTPC_REM_Order OrderID
KEY Ledger _Doc Ledger
OrderDescription P_RTPC_REM_Order OrderDescription
ControllingObject P_RTPC_REM_Order ControllingObject
ControllingArea P_RTPC_REM_Order ControllingArea
CompanyCode P_RTPC_REM_Order CompanyCode
OrderType P_RTPC_REM_Order OrderType
Material P_RTPC_REM_Order Material
Plant P_RTPC_REM_Order Plant
OrderCategory P_RTPC_REM_Order OrderCategory
ProfitCenter P_RTPC_REM_Order ProfitCenter
StatusCode
ProductionVersion P_RTPC_REM_Order ProductionVersion
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency
AmountInGlobalCurrency AmountInGlobalCurrency
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1
AmountInFreeDefinedCurrency2 AmountInFreeDefinedCurrency2
AmountInFreeDefinedCurrency3 AmountInFreeDefinedCurrency3
AmountInFreeDefinedCurrency4 AmountInFreeDefinedCurrency4
AmountInFreeDefinedCurrency5 AmountInFreeDefinedCurrency5
AmountInFreeDefinedCurrency6 AmountInFreeDefinedCurrency6
AmountInFreeDefinedCurrency7 AmountInFreeDefinedCurrency7
AmountInFreeDefinedCurrency8 AmountInFreeDefinedCurrency8
CompanyCodeCurrency CompanyCodeCurrency
GlobalCurrency GlobalCurrency
FreeDefinedCurrency1 FreeDefinedCurrency1
FreeDefinedCurrency2 FreeDefinedCurrency2
FreeDefinedCurrency3 FreeDefinedCurrency3
FreeDefinedCurrency4 FreeDefinedCurrency4
FreeDefinedCurrency5 FreeDefinedCurrency5
FreeDefinedCurrency6 FreeDefinedCurrency6
FreeDefinedCurrency7 FreeDefinedCurrency7
FreeDefinedCurrency8 FreeDefinedCurrency8 
@AbapCatalog.sqlViewName: 'PRTPCREMOTBPK'
@AbapCatalog.compiler.compareFilter: true
//@AbapCatalog.preserveKey:true

@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'To be posted Event-Based REM orders KPI'

@VDM.viewType: #COMPOSITE
@VDM.private:true
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
define view P_RTPC_REM_OrderToBePostedKPI
  with parameters
    P_FiscalPeriodStartDate : budat,
    P_FiscalPeriodEndDate   : budat
  as select from           P_RTPC_REM_Order                 as _Order
    left outer to one join P_RTPC_REM_UnsettledActualCost(P_FiscalPeriodStartDate   : $parameters.P_FiscalPeriodStartDate,
                                                          P_FiscalPeriodEndDate     : $parameters.P_FiscalPeriodEndDate
                                                          ) as _Doc on _Doc.OrderID = _Order.OrderID
{
  key _Order.OrderID           as OrderID,
  key _Doc.Ledger              as Ledger,
      _Order.OrderDescription  as OrderDescription,
      _Order.ControllingObject as ControllingObject,
      _Order.ControllingArea   as ControllingArea,
      _Order.CompanyCode       as CompanyCode,
      _Order.OrderType         as OrderType,
      _Order.Material          as Material,
      _Order.Plant             as Plant,
      _Order.OrderCategory     as OrderCategory,
      _Order.ProfitCenter      as ProfitCenter,
      'I0002'                  as StatusCode,
      _Order.ProductionVersion as ProductionVersion,

      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      AmountInCompanyCodeCurrency,
      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      AmountInGlobalCurrency,
      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
      AmountInFreeDefinedCurrency1,
      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
      AmountInFreeDefinedCurrency2,
      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
      AmountInFreeDefinedCurrency3,
      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
      AmountInFreeDefinedCurrency4,
      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
      AmountInFreeDefinedCurrency5,
      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
      AmountInFreeDefinedCurrency6,
      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
      AmountInFreeDefinedCurrency7,
      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
      AmountInFreeDefinedCurrency8,

      CompanyCodeCurrency,
      GlobalCurrency,
      FreeDefinedCurrency1,
      FreeDefinedCurrency2,
      FreeDefinedCurrency3,
      FreeDefinedCurrency4,
      FreeDefinedCurrency5,
      FreeDefinedCurrency6,
      FreeDefinedCurrency7,
      FreeDefinedCurrency8
}
where
       AmountInCompanyCodeCurrency != 0
    or AmountInGlobalCurrency != 0
    or AmountInFreeDefinedCurrency1 != 0
    or AmountInFreeDefinedCurrency2 != 0
    or AmountInFreeDefinedCurrency3 != 0
    or AmountInFreeDefinedCurrency4 != 0
    or AmountInFreeDefinedCurrency5 != 0
    or AmountInFreeDefinedCurrency6 != 0
    or AmountInFreeDefinedCurrency7 != 0
    or AmountInFreeDefinedCurrency8 != 0

Learn More