R_ProcOrderItemSerialNumberTP

DDL: R_PROCORDERITEMSERIALNUMBERTP Type: view_entity TRANSACTIONAL Package: PP_PROCESSORDER_RAP

Process Order Item Serial Number - TP

R_ProcOrderItemSerialNumberTP is a Transactional CDS View that provides data about "Process Order Item Serial Number - TP" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderItemSerialNumber) and exposes 10 fields with key fields ProcessOrder, ProcessOrderItem, SerialNumber. It has 1 association to related views. Part of development package PP_PROCESSORDER_RAP.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderItemSerialNumber SerialNumber from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_ProcessOrderTP _Order $projection.ProcessOrder = _Order.ProcessOrder

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Process Order Item Serial Number - TP view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ProcessOrder I_MfgOrderItemSerialNumber ManufacturingOrder
KEY ProcessOrderItem I_MfgOrderItemSerialNumber ManufacturingOrderItem
KEY SerialNumber I_MfgOrderItemSerialNumber SerialNumber
Product I_MfgOrderItemSerialNumber Product
ProductionPlant I_MfgOrderItemSerialNumber ProductionPlant
ManufacturingOrderCategory I_MfgOrderItemSerialNumber ManufacturingOrderCategory
ProcessOrderType I_MfgOrderItemSerialNumber ManufacturingOrderType
SerialNumberProfile I_MfgOrderItemSerialNumber SerialNumberProfile
_Item _Item
_Order _Order 
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.modelingPattern: #NONE
@ObjectModel.supportedCapabilities: [#TRANSACTIONAL_PROVIDER]
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
@EndUserText.label: 'Process Order Item Serial Number - TP'

define view entity R_ProcOrderItemSerialNumberTP
  as select from I_MfgOrderItemSerialNumber as SerialNumber

  // BO relation

  association        to parent R_ProcessOrderItemTP as _Item  on  $projection.ProcessOrder     = _Item.ProcessOrder
                                                              and $projection.ProcessOrderItem = _Item.ProcessOrderItem
  association [1..1] to R_ProcessOrderTP            as _Order on  $projection.ProcessOrder = _Order.ProcessOrder

{
      // Key

  key SerialNumber.ManufacturingOrder     as ProcessOrder,
  key SerialNumber.ManufacturingOrderItem as ProcessOrderItem,
  key SerialNumber.SerialNumber,

      //      Equipment_2                         as Equipment,

      SerialNumber.Product,
      SerialNumber.ProductionPlant,
      SerialNumber.ManufacturingOrderCategory,
      SerialNumber.ManufacturingOrderType as ProcessOrderType,
      SerialNumber.SerialNumberProfile,
      //      SerialNumber.DocumentDate           as SerialNumberAssignmentDate,


      // Associations

      _Item,
      _Order

}
where
  ManufacturingOrderCategory = '40'

Learn More