I_SERIALNMBRPHYSICALINVTRY

CDS View

Serial Number Phys Invtry doc

I_SERIALNMBRPHYSICALINVTRY is a CDS View in S/4HANA. Serial Number Phys Invtry doc. It contains 6 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 6 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PhysInvtryDocSrlNmbr view_entity from COMPOSITE Physical Inventory Doc Serial Number

Fields (6)

KeyField CDS FieldsUsed in Views
KEY FiscalYear FiscalYear 1
KEY PhysicalInventoryDocument PhysicalInventoryDocument 1
KEY PhysicalInventoryDocumentItem PhysicalInventoryDocumentItem 1
KEY PhysInvtrySerialNmbrListType PhysInvtrySerialNmbrListType 1
DocumentDate DocumentDate 1
Plant Plant 1 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY // never expose this view directly, only via associations

@EndUserText.label: 'Serial Number Phys Invtry doc'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L

@VDM.viewType: #BASIC
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'I_MaintObjListPhysInventoryDoc'

define view entity I_SerialNmbrPhysicalInvtry
  as select from ser07

  association [1..1] to I_PhysInvtryDocHeader as _PhysInvtryDocHeader on  $projection.PhysicalInventoryDocument     = _PhysInvtryDocHeader.PhysicalInventoryDocument
                                                                      and $projection.FiscalYear                    = _PhysInvtryDocHeader.FiscalYear
  association [0..1] to I_PhysInvtryDocItem as _PhysInvtryDocItem     on  $projection.PhysicalInventoryDocument     = _PhysInvtryDocItem.PhysicalInventoryDocument
                                                                      and $projection.PhysicalInventoryDocumentItem = _PhysInvtryDocItem.PhysicalInventoryDocumentItem
                                                                      and $projection.FiscalYear                    = _PhysInvtryDocItem.FiscalYear
{
  key obknr as MaintenanceItemObjectList,
     
      iblnr as PhysicalInventoryDocument,
      zeili as PhysicalInventoryDocumentItem,
      mjahr as FiscalYear,

      oltpi as PhysInvtrySerialNmbrListType,
      datum as DocumentDate,
      werk  as Plant,
      
      _PhysInvtryDocHeader,
      _PhysInvtryDocItem
}

Learn More