I_MAINTOBJLISTPURCHASEORDER

CDS View

Maint Object List in Purchase Order

I_MAINTOBJLISTPURCHASEORDER is a CDS View in S/4HANA. Maint Object List in Purchase Order. It contains 4 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MaintObjectListCollection view_entity union_all COMPOSITE Maintenance Object List Collection
I_SerialNumberPurchaseOrder view_entity from COMPOSITE Serial Number in Purchase Order

Fields (4)

KeyField CDS FieldsUsed in Views
KEY PurchaseOrder PurchaseOrder 1
KEY PurchaseOrderItem PurchaseOrderItem 1
_PurchaseOrder _PurchaseOrder 1
_PurchaseOrderItem _PurchaseOrderItem 1
@AccessControl: { authorizationCheck: #CHECK,
                  personalData.blocking: #NOT_REQUIRED }

@VDM.viewType: #BASIC

@ObjectModel.usageType: {
        dataClass:      #TRANSACTIONAL,
        serviceQuality: #A,
        sizeCategory:   #L }
@ObjectModel.supportedCapabilities: [
  #SQL_DATA_SOURCE,
  #CDS_MODELING_DATA_SOURCE,
  #CDS_MODELING_ASSOCIATION_TARGET
]

@EndUserText.label: 'Maint Object List in Purchase Order'
define view entity I_MaintObjListPurchaseOrder
  as select from ser08

  association [1..*] to I_MaintenanceObjectListItem as _MaintenanceObjectListItem
    on $projection.MaintenanceObjectList = _MaintenanceObjectListItem.MaintenanceObjectList
  association [0..1] to I_PurchaseOrderAPI01 as _PurchaseOrder
    on $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
  association [0..1] to I_PurchaseOrderItemAPI01 as _PurchaseOrderItem
    on $projection.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder
    and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem
{
  key obknr as MaintenanceObjectList,

  @ObjectModel.foreignKey.association: '_PurchaseOrder'
  ebeln as PurchaseOrder,
  @ObjectModel.foreignKey.association: '_PurchaseOrderItem'
  ebelp as PurchaseOrderItem,
  
  bstyp as PurchasingDocumentCategory,
  bsart as PurchasingDocumentType,
  pstyp as PurchasingDocumentItemCategory,
  werk  as Plant,
  anzsn as NumberOfSerialNumbers,
  datum as SerialNumberAssignmentDate,
  uzeit as SerialNumberAssignmentTime,

  _MaintenanceObjectListItem,
  _PurchaseOrder,
  _PurchaseOrderItem
}