R_ProdnOrderItemSerialNumberTP

DDL: R_PRODNORDERITEMSERIALNUMBERTP Type: view_entity TRANSACTIONAL Package: PP_PRODUCTIONORDER_RAP

Production Order Item Serial Number - TP

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

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderItemSerialNumber SerialNumber from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_ProductionOrderTP _ProductionOrder $projection.ProductionOrder = _ProductionOrder.ProductionOrder

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 Production Order Item Serial Number - TP view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ProductionOrder I_MfgOrderItemSerialNumber ManufacturingOrder
KEY ProductionOrderItem I_MfgOrderItemSerialNumber ManufacturingOrderItem
KEY SerialNumber I_MfgOrderItemSerialNumber SerialNumber
Product I_MfgOrderItemSerialNumber Product
ProductionPlant I_MfgOrderItemSerialNumber ProductionPlant
ManufacturingOrderCategory I_MfgOrderItemSerialNumber ManufacturingOrderCategory
ProductionOrderType I_MfgOrderItemSerialNumber ManufacturingOrderType
SerialNumberProfile I_MfgOrderItemSerialNumber SerialNumberProfile
_ProductionOrderItem _ProductionOrderItem
_ProductionOrder _ProductionOrder 
@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: 'Production Order Item Serial Number - TP'

define view entity R_ProdnOrderItemSerialNumberTP
  as select from I_MfgOrderItemSerialNumber as SerialNumber

  // BO relation

  association        to parent R_ProductionOrderItemTP as _ProductionOrderItem on  $projection.ProductionOrder     = _ProductionOrderItem.ProductionOrder
                                                                               and $projection.ProductionOrderItem = _ProductionOrderItem.ProductionOrderItem
  association [1..1] to R_ProductionOrderTP            as _ProductionOrder     on  $projection.ProductionOrder = _ProductionOrder.ProductionOrder

{
      // Key

  key SerialNumber.ManufacturingOrder     as ProductionOrder,
  key SerialNumber.ManufacturingOrderItem as ProductionOrderItem,
  key SerialNumber.SerialNumber,

//      Equipment_2                         as Equipment,

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


      // Associations

      _ProductionOrderItem,
      _ProductionOrder

}
where
  ManufacturingOrderCategory = '10'

Learn More