I_SerialNumberPurchaseOrder

DDL: I_SERIALNUMBERPURCHASEORDER Type: view_entity COMPOSITE

Serial Number in Purchase Order

I_SerialNumberPurchaseOrder is a Composite CDS View that provides data about "Serial Number in Purchase Order" in SAP S/4HANA. It reads from 2 data sources (I_MaintenanceObjectListItem, I_MaintObjListPurchaseOrder) and exposes 9 fields with key fields Equipment, PurchaseOrder, PurchaseOrderItem.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_MaintenanceObjectListItem _MaintenanceObjectListItem inner
I_MaintObjListPurchaseOrder _MaintObjListPurchaseOrder from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
EndUserText.label Serial Number in Purchase Order view
Metadata.ignorePropagatedAnnotations true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Equipment I_MaintenanceObjectListItem Equipment
KEY PurchaseOrder I_MaintObjListPurchaseOrder PurchaseOrder
KEY PurchaseOrderItem I_MaintObjListPurchaseOrder PurchaseOrderItem
Material I_MaintenanceObjectListItem Material
SerialNumber I_MaintenanceObjectListItem SerialNumber
_Equipment I_MaintenanceObjectListItem _Equipment
_PurchaseOrder I_MaintObjListPurchaseOrder _PurchaseOrder
_PurchaseOrderItem I_MaintObjListPurchaseOrder _PurchaseOrderItem
_Product I_MaintenanceObjectListItem _Product 
@AccessControl: { authorizationCheck: #CHECK,
                  personalData.blocking: #NOT_REQUIRED }

@VDM.viewType: #COMPOSITE

@ObjectModel: {
                usageType: {
                            serviceQuality: #A,
                            sizeCategory:   #XL,
                            dataClass:      #TRANSACTIONAL
                           },
                 supportedCapabilities: [
                            #SQL_DATA_SOURCE,
                            #CDS_MODELING_DATA_SOURCE,
                            #CDS_MODELING_ASSOCIATION_TARGET
                                        ],
                 modelingPattern: #ANALYTICAL_DIMENSION                                  
              }

@EndUserText.label: 'Serial Number in Purchase Order'
@Metadata.ignorePropagatedAnnotations:true
define view entity I_SerialNumberPurchaseOrder
  as select from I_MaintObjListPurchaseOrder as _MaintObjListPurchaseOrder
  -- data source association to list item cannot be used due to current CDS restrictions
  -- (could be done implicitly in field list by _A._B[inner].C, but non-maskable warnings ensue)
  -- ... join needs foreign key relationship to be defined again
    inner join I_MaintenanceObjectListItem as _MaintenanceObjectListItem
      on _MaintObjListPurchaseOrder.MaintenanceObjectList = _MaintenanceObjectListItem.MaintenanceObjectList
{
  @ObjectModel.foreignKey.association: '_Equipment'
  key _MaintenanceObjectListItem.Equipment,

  @ObjectModel.foreignKey.association: '_PurchaseOrder'
  key _MaintObjListPurchaseOrder.PurchaseOrder,
  @ObjectModel.foreignKey.association: '_PurchaseOrderItem'
  key _MaintObjListPurchaseOrder.PurchaseOrderItem,

  @ObjectModel.foreignKey.association: '_Product'
  _MaintenanceObjectListItem.Material,
  _MaintenanceObjectListItem.SerialNumber,

  _MaintenanceObjectListItem._Equipment,
  _MaintObjListPurchaseOrder._PurchaseOrder,
  _MaintObjListPurchaseOrder._PurchaseOrderItem,
  _MaintenanceObjectListItem._Product
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCEOBJECTLISTITEM",
"I_MAINTOBJLISTPURCHASEORDER"
],
"ASSOCIATED":
[
"I_EQUIPMENT",
"I_PRODUCT",
"I_PURCHASEORDER",
"I_PURCHASEORDERITEM"
],
"BASE":
[
"I_MAINTENANCEOBJECTLISTITEM",
"I_MAINTOBJLISTPURCHASEORDER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More