P_RTPC_REM_ORDER

CDS View

Event-Based REM orders

P_RTPC_REM_ORDER is a CDS View in S/4HANA. Event-Based REM orders. It contains 13 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 13 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_RTPC_REM_OrderPostedKPI view from COMPOSITE Posted Event-Based REM Orders KPI
P_RTPC_REM_OrderToBePostedKPI view from COMPOSITE To be posted Event-Based REM orders KPI

Fields (13)

KeyField CDS FieldsUsed in Views
KEY OrderID OrderID 2
CompanyCode CompanyCode 2
ControllingArea ControllingArea 2
ControllingObject ControllingObject 2
Material Material 2
OrderCategory OrderCategory 2
OrderDescription OrderDescription 2
OrderSettlementTriggerType OrderSettlementTriggerType 1
OrderType OrderType 2
Plant Plant 2
ProductionVersion ProductionVersion 2
ProfitCenter ProfitCenter 2
ResultsAnalysisKey ResultsAnalysisKey 1 
@AbapCatalog.sqlViewName: 'PRTPCREMORD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Event-Based REM orders'

@VDM.viewType: #COMPOSITE
@VDM.private:true
@ObjectModel.representativeKey: 'OrderID'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
define view P_RTPC_REM_Order
  as select from           I_ProductCostCtrlgOrder     as _Order
    left outer to one join I_ProductCostCtrlgOrderItem as _LeadingOrderItem on  _LeadingOrderItem.OrderID   = _Order.OrderID
                                                                            and _LeadingOrderItem.OrderItem = '0001'
{
  key _Order.OrderID                      as OrderID,
      _Order.OrderDescription             as OrderDescription,
      _Order.ObjectInternalID             as ControllingObject,
      _Order.OrderType                    as OrderType,
      _Order.OrderCategory                as OrderCategory,
      _Order.ControllingArea              as ControllingArea,
      _Order.CompanyCode                  as CompanyCode,

      _Order.Plant                        as Plant,
      _Order.ProfitCenter                 as ProfitCenter,
      _Order.ResultAnalysisInternalID     as ResultsAnalysisKey,
      _Order.OrderSettlementTriggerType   as OrderSettlementTriggerType,

      _Order.TechnicalCompletionDate      as TechCompDate,
//      _Order.MfgOrderHasMultipleItems,


      _LeadingOrderItem.Material          as Material,
      _LeadingOrderItem.ProductionVersion as ProductionVersion
}
where
      _Order.OrderIsEventBasedPosting = 'X'
  and _Order.IsMarkedForDeletion      = ''
  and _Order.OrderCategory            = '05'

Learn More