I_MAINTOBJLISTPHYSINVENTORYDOC

CDS View

Maint Object List in Phys Inventory Doc

I_MAINTOBJLISTPHYSINVENTORYDOC is a CDS View in S/4HANA. Maint Object List in Phys Inventory Doc. It contains 7 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 7 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SerialNumberPhysInventoryDoc view_entity from COMPOSITE Serial Number in Physical Inventory Doc

Fields (7)

KeyField CDS FieldsUsed in Views
KEY FiscalYear FiscalYear 1
KEY PhysicalInventoryDocument PhysicalInventoryDocument 1
KEY PhysicalInventoryDocumentItem PhysicalInventoryDocumentItem 1
KEY SerialNumberPhysicalInvtryType SerialNumberPhysicalInvtryType 1
_PhysicalInventoryDocument _PhysicalInventoryDocument 1
_PhysicalInventoryDocumentItem _PhysicalInventoryDocumentItem 1
_PhysicalInvtryDocFiscalYear _PhysicalInvtryDocFiscalYear 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 Phys Inventory Doc'
define view entity I_MaintObjListPhysInventoryDoc
  as select from ser07

  association [1..*] to I_MaintenanceObjectListItem as _MaintenanceObjectListItem
    on $projection.MaintenanceObjectList = _MaintenanceObjectListItem.MaintenanceObjectList
  association [0..1] to I_PhysInvtryDocFiscalYear as _PhysicalInvtryDocFiscalYear
    on $projection.FiscalYear = _PhysicalInvtryDocFiscalYear.FiscalYear
  association [0..1] to I_PhysInvtryDocHeader as _PhysicalInventoryDocument
    on $projection.PhysicalInventoryDocument = _PhysicalInventoryDocument.PhysicalInventoryDocument
    and $projection.FiscalYear = _PhysicalInventoryDocument.FiscalYear
  association [0..1] to I_PhysInvtryDocItem as _PhysicalInventoryDocumentItem
    on $projection.PhysicalInventoryDocument = _PhysicalInventoryDocumentItem.PhysicalInventoryDocument
    and $projection.PhysicalInventoryDocumentItem = _PhysicalInventoryDocumentItem.PhysicalInventoryDocumentItem
    and $projection.FiscalYear = _PhysicalInventoryDocumentItem.FiscalYear
{
  key obknr as MaintenanceObjectList,

  @ObjectModel.foreignKey.association: '_PhysicalInvtryDocFiscalYear'
  mjahr as FiscalYear,
  @ObjectModel.foreignKey.association: '_PhysicalInventoryDocument'
  iblnr as PhysicalInventoryDocument,
  @ObjectModel.foreignKey.association: '_PhysicalInventoryDocumentItem'
  zeili as PhysicalInventoryDocumentItem,

  cast( oltpi as losn_srl_nmbr_phys_invtry_type preserving type ) as SerialNumberPhysicalInvtryType,
  
  werk      as Plant,
  lagerort  as StorageLocation,
  charge    as Batch,
  bstar     as PhysicalInventoryStockType,
  anzsn     as NumberOfSerialNumbers,
  datum     as SerialNumberAssignmentDate,
    
  _MaintenanceObjectListItem,
  _PhysicalInvtryDocFiscalYear,
  _PhysicalInventoryDocument,
  _PhysicalInventoryDocumentItem
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SER07"
],
"ASSOCIATED":
[
"I_MAINTENANCEOBJECTLISTITEM",
"I_PHYSINVTRYDOCFISCALYEAR",
"I_PHYSINVTRYDOCHEADER",
"I_PHYSINVTRYDOCITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More