Which tables does P_RTPC_REM_OrderToBePostedKPI use?

P_RTPC_REM_OrderToBePostedKPI reads from 1 data source(s): P_RTPC_REM_Order.

How many fields does P_RTPC_REM_OrderToBePostedKPI have?

P_RTPC_REM_OrderToBePostedKPI has 34 fields. Key fields: OrderID, Ledger.

P_RTPC_REM_OrderToBePostedKPI

DDL: P_RTPC_REM_ORDERTOBEPOSTEDKPI SQL: PRTPCREMOTBPK Type: view COMPOSITE Package: FINS_PCC_RTPC_REM

To be posted Event-Based REM orders KPI

P_RTPC_REM_OrderToBePostedKPI is a Composite CDS View that provides data about "To be posted Event-Based REM orders KPI" in SAP S/4HANA. It reads from 1 data source (P_RTPC_REM_Order) and exposes 34 fields with key fields OrderID, Ledger. Part of development package FINS_PCC_RTPC_REM.

Data Sources (1)

Source	Alias	Join Type
P_RTPC_REM_Order	_Order	from

Parameters (2)

Name	Type	Default
P_FiscalPeriodStartDate	budat
P_FiscalPeriodEndDate	budat

Annotations (9)

Name	Value	Level
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 (34)

Key	Field	Source Table	Source Field
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
	OrderSettlementTriggerType	P_RTPC_REM_Order	OrderSettlementTriggerType
	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,
      _Order.OrderSettlementTriggerType as OrderSettlementTriggerType,

      @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

Depth:

P_RTPC_REM_OrderToBePostedKPI view

P_RTPC_REM_Order view

P_RTPC_PCC_OrderToBePosted view