Which tables does P_RealTimeMfgOrderToBePostdKPI use?

P_RealTimeMfgOrderToBePostdKPI reads from 2 data source(s): I_Ledger, P_AggregatedToBePostKPI.

How many fields does P_RealTimeMfgOrderToBePostdKPI have?

P_RealTimeMfgOrderToBePostdKPI has 46 fields. Key fields: CompanyCode, Ledger, OrderID.

P_RealTimeMfgOrderToBePostdKPI

DDL: P_REALTIMEMFGORDERTOBEPOSTDKPI SQL: PRTMOTBPKPI Type: view COMPOSITE

P_RealTimeMfgOrderToBePostdKPI is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_Ledger, P_AggregatedToBePostKPI) and exposes 46 fields with key fields CompanyCode, Ledger, OrderID.

Data Sources (2)

Source	Alias	Join Type
I_Ledger	ledger	inner
P_AggregatedToBePostKPI	P_AggregatedToBePostKPI	from

Parameters (2)

Name	Type	Default
P_FiscalPeriodStartDate	budat
P_FiscalPeriodEndDate	budat

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	PRTMOTBPKPI	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	#C	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
AbapCatalog.preserveKey	true	view

Fields (46)

Key	Field	Source Table	Source Field
KEY	CompanyCode	item	CompanyCode
KEY	Ledger	I_Ledger	Ledger
KEY	OrderID	item	OrderID
	OrderDescription	item	OrderDescription
	ControllingArea	item	ControllingArea
	OrderType	item	OrderType
	Plant	item	Plant
	OrderCategory	item	OrderCategory
	ProfitCenter	item	ProfitCenter
	Material	leadingOrderItem	Material
	LedgerName
	SimulationStatus	orderLog	SimulationStatus
	LogNumber	orderLog	LogNumber
	LogHandle	orderLog	LogHandle
	LogMessageText	orderLog	LogMessageText
	EventBasedProdnCostWlLogType	orderLog	EventBasedProdnCostWlLogType
	AmountInCompanyCodeCurrency	item	AmountInCompanyCodeCurrency
	AmountInGlobalCurrency	item	AmountInGlobalCurrency
	AmountInFreeDefinedCurrency1	item	AmountInFreeDefinedCurrency1
	AmountInFreeDefinedCurrency2	item	AmountInFreeDefinedCurrency2
	AmountInFreeDefinedCurrency3	item	AmountInFreeDefinedCurrency3
	AmountInFreeDefinedCurrency4	item	AmountInFreeDefinedCurrency4
	AmountInFreeDefinedCurrency5	item	AmountInFreeDefinedCurrency5
	AmountInFreeDefinedCurrency6	item	AmountInFreeDefinedCurrency6
	AmountInFreeDefinedCurrency7	item	AmountInFreeDefinedCurrency7
	AmountInFreeDefinedCurrency8	item	AmountInFreeDefinedCurrency8
	PeriodAmountInCompanyCodeCrcy	item	PeriodAmountInCompanyCodeCrcy
	PeriodAmountInGlobalCurrency	item	PeriodAmountInGlobalCurrency
	PeriodAmountInFreeDfndCrcy1	item	PeriodAmountInFreeDfndCrcy1
	PeriodAmountInFreeDfndCrcy2	item	PeriodAmountInFreeDfndCrcy2
	PeriodAmountInFreeDfndCrcy3	item	PeriodAmountInFreeDfndCrcy3
	PeriodAmountInFreeDfndCrcy4	item	PeriodAmountInFreeDfndCrcy4
	PeriodAmountInFreeDfndCrcy5	item	PeriodAmountInFreeDfndCrcy5
	PeriodAmountInFreeDfndCrcy6	item	PeriodAmountInFreeDfndCrcy6
	PeriodAmountInFreeDfndCrcy7	item	PeriodAmountInFreeDfndCrcy7
	PeriodAmountInFreeDfndCrcy8	item	PeriodAmountInFreeDfndCrcy8
	CompanyCodeCurrency	item	CompanyCodeCurrency
	GlobalCurrency	item	GlobalCurrency
	FreeDefinedCurrency1	item	FreeDefinedCurrency1
	FreeDefinedCurrency2	item	FreeDefinedCurrency2
	FreeDefinedCurrency3	item	FreeDefinedCurrency3
	FreeDefinedCurrency4	item	FreeDefinedCurrency4
	FreeDefinedCurrency5	item	FreeDefinedCurrency5
	FreeDefinedCurrency6	item	FreeDefinedCurrency6
	FreeDefinedCurrency7	item	FreeDefinedCurrency7
	FreeDefinedCurrency8	item	FreeDefinedCurrency8

@AbapCatalog.sqlViewName: 'PRTMOTBPKPI'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Event-based Order KPI'

@VDM.viewType: #COMPOSITE
@VDM.private:true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AbapCatalog.preserveKey:true

define view P_RealTimeMfgOrderToBePostdKPI
  with parameters
    P_FiscalPeriodStartDate : budat,
    P_FiscalPeriodEndDate   : budat
  as select from           P_AggregatedToBePostKPI(
                                       P_FiscalPeriodStartDate: $parameters.P_FiscalPeriodStartDate,
                                       P_FiscalPeriodEndDate: $parameters.P_FiscalPeriodEndDate) as item
    inner join             I_Ledger                                              as ledger           on  item.Ledger            = ledger.Ledger
                                                                                                     and ledger.LedgerType      = ''
                                                                                                     and ledger.ReferenceLedger = ''
    left outer to one join I_ProductCostCtrlgOrderItem                           as leadingOrderItem on  leadingOrderItem.OrderItem = '0001'
                                                                                                     and leadingOrderItem.OrderID   = item.OrderID
    left outer to one join R_EvtBsdProdnCostError                                as orderLog         on  item.OrderID                         =  orderLog.OrderID
                                                                                                     and item.Ledger                          =  orderLog.Ledger
                                                                                                     and item.CompanyCode                     =  orderLog.CompanyCode
                                                                                                     and orderLog.BusinessTransactionCategory <> 'KZPR'                                                                                                  
{
  key item.CompanyCode,
  key ledger.Ledger,
//      item.ControllingObject,

  key item.OrderID,
      item.OrderDescription,
      item.ControllingArea,
      item.OrderType,
      item.Plant,
      item.OrderCategory,
      item.ProfitCenter,
      //item.StatusCode,

      leadingOrderItem.Material,
      ledger._Text[1: Language = $session.system_language].LedgerName,

      orderLog.SimulationStatus,

      orderLog.LogNumber,
      orderLog.LogHandle,
      orderLog.LogMessageText,
      //Severity,

      orderLog.EventBasedProdnCostWlLogType,

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

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      item.PeriodAmountInCompanyCodeCrcy,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      item.PeriodAmountInGlobalCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
      item.PeriodAmountInFreeDfndCrcy1,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
      item.PeriodAmountInFreeDfndCrcy2,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
      item.PeriodAmountInFreeDfndCrcy3,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
      item.PeriodAmountInFreeDfndCrcy4,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
      item.PeriodAmountInFreeDfndCrcy5,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
      item.PeriodAmountInFreeDfndCrcy6,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
      item.PeriodAmountInFreeDfndCrcy7,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
      item.PeriodAmountInFreeDfndCrcy8,

      item.CompanyCodeCurrency,
      item.GlobalCurrency,
      item.FreeDefinedCurrency1,
      item.FreeDefinedCurrency2,
      item.FreeDefinedCurrency3,
      item.FreeDefinedCurrency4,
      item.FreeDefinedCurrency5,
      item.FreeDefinedCurrency6,
      item.FreeDefinedCurrency7,
      item.FreeDefinedCurrency8
}
  

//@AbapCatalog.sqlViewName: 'PRTMOTBPKPI'

//@AbapCatalog.compiler.compareFilter: true

//@AccessControl.authorizationCheck: #NOT_REQUIRED

//@ClientHandling.algorithm: #SESSION_VARIABLE

////@EndUserText.label: 'Event-based Order KPI'

//@VDM.viewType: #COMPOSITE

//@VDM.private:true

//@ObjectModel.usageType.serviceQuality: #C

//@ObjectModel.usageType.sizeCategory: #XXL

//@ObjectModel.usageType.dataClass: #TRANSACTIONAL

//@AbapCatalog.preserveKey:true

//

//define view P_RealTimeMfgOrderToBePostdKPI

//  with parameters

//    P_FiscalPeriodStartDate : budat,

//    P_FiscalPeriodEndDate   : budat

//  as select from           P_ToBePostEventBasedEntries(

//                                       P_FiscalPeriodStartDate: $parameters.P_FiscalPeriodStartDate,

//                                       P_FiscalPeriodEndDate: $parameters.P_FiscalPeriodEndDate) as item

//    inner join             I_Ledger                                              as ledger           on  item.Ledger            = ledger.Ledger

//                                                                                                     and ledger.LedgerType      = ''

//                                                                                                     and ledger.ReferenceLedger = ''

//    left outer to one join I_ProductCostCtrlgOrderItem                           as leadingOrderItem on  leadingOrderItem.OrderItem = '0001'

//                                                                                                     and leadingOrderItem.OrderID   = item.OrderID

//    left outer to one join R_EvtBsdProdnCostError                                as orderLog         on  item.OrderID                         =  orderLog.OrderID

//                                                                                                     and item.Ledger                          =  orderLog.Ledger

//                                                                                                     and item.CompanyCode                     =  orderLog.CompanyCode

//                                                                                                     and orderLog.BusinessTransactionCategory <> 'KZPR'                                                                                                  

//{

//  key item.CompanyCode,

//  key ledger.Ledger,

//  key item.AccountingDocument,

//  key item.LedgerGLLineItem,

//  key item.FiscalYear,

//      item.ControllingObject,

//      item.ReferenceDocumentType,

//      item.ReferenceDocumentContext,

//      item.ReferenceDocument,

//      item.OrderID,

//      item.OrderItem,

//      item.OrderDescription,

//      item.ControllingArea,

//      item.OrderType,

//      item.Plant,

//      item.OrderCategory,

//      item.ProfitCenter,

//      item.StatusCode,

//      leadingOrderItem.Material,

//      ledger._Text[1: Language = $session.system_language].LedgerName,

//

//      orderLog.SimulationStatus,

//

//      orderLog.LogNumber,

//      orderLog.LogHandle,

//      orderLog.LogMessageText,

//      //Severity,

//      orderLog.EventBasedProdnCostWlLogType,

//

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }

//      item.AmountInCompanyCodeCurrency,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }

//      item.AmountInGlobalCurrency,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }

//      item.AmountInFreeDefinedCurrency1,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }

//      item.AmountInFreeDefinedCurrency2,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }

//      item.AmountInFreeDefinedCurrency3,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }

//      item.AmountInFreeDefinedCurrency4,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }

//      item.AmountInFreeDefinedCurrency5,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }

//      item.AmountInFreeDefinedCurrency6,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }

//      item.AmountInFreeDefinedCurrency7,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }

//      item.AmountInFreeDefinedCurrency8,

//

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }

//      item.PeriodAmountInCompanyCodeCrcy,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }

//      item.PeriodAmountInGlobalCurrency,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }

//      item.PeriodAmountInFreeDfndCrcy1,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }

//      item.PeriodAmountInFreeDfndCrcy2,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }

//      item.PeriodAmountInFreeDfndCrcy3,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }

//      item.PeriodAmountInFreeDfndCrcy4,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }

//      item.PeriodAmountInFreeDfndCrcy5,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }

//      item.PeriodAmountInFreeDfndCrcy6,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }

//      item.PeriodAmountInFreeDfndCrcy7,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }

//      item.PeriodAmountInFreeDfndCrcy8,

//

//      item.CompanyCodeCurrency,

//      item.GlobalCurrency,

//      item.FreeDefinedCurrency1,

//      item.FreeDefinedCurrency2,

//      item.FreeDefinedCurrency3,

//      item.FreeDefinedCurrency4,

//      item.FreeDefinedCurrency5,

//      item.FreeDefinedCurrency6,

//      item.FreeDefinedCurrency7,

//      item.FreeDefinedCurrency8

//}

//

Depth:

P_RealTimeMfgOrderToBePostdKPI view

P_AggregatedToBePostKPI view_entity
I_Ledger view

I_RealTimeMfgOrderToBePostdKPI view