P_RTPC_REM_ORDER

CDS View

P_RTPC_REM_ORDER is a CDS View in S/4HANA. It contains 12 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 12 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_RTPC_REM_OrderPostedKPI view from COMPOSITE
P_RTPC_REM_OrderToBePostedKPI view from COMPOSITE

Fields (12)

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
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.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