P_PhysInvtryDocSrlNmbr

DDL: P_PHYSINVTRYDOCSRLNMBR SQL: PPIDOCSN Type: view COMPOSITE

P_PhysInvtryDocSrlNmbr is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_MaintenanceItemObject, I_SerialNmbrPhysicalInvtry) and exposes 9 fields with key fields PhysicalInventoryDocument, FiscalYear, PhysicalInventoryDocumentItem, PhysInvtrySerialNmbrListType, Equipment.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_MaintenanceItemObject I_MaintenanceItemObject inner
I_SerialNmbrPhysicalInvtry I_SerialNmbrPhysicalInvtry from

Annotations (10)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName PPIDOCSN view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PhysicalInventoryDocument PhysicalInventoryDocument
KEY FiscalYear FiscalYear
KEY PhysicalInventoryDocumentItem PhysicalInventoryDocumentItem
KEY PhysInvtrySerialNmbrListType PhysInvtrySerialNmbrListType
KEY Equipment I_MaintenanceItemObject Equipment
Plant Plant
Material I_MaintenanceItemObject Material
SerialNumber I_MaintenanceItemObject SerialNumber
DocumentDate I_SerialNmbrPhysicalInvtry DocumentDate 
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'PPIDOCSN'

@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.private: true
@VDM.viewType: #COMPOSITE

define view P_PhysInvtryDocSrlNmbr
  as select from I_SerialNmbrPhysicalInvtry 
    inner join   I_MaintenanceItemObject on I_SerialNmbrPhysicalInvtry.MaintenanceItemObjectList = I_MaintenanceItemObject.MaintenanceItemObjectList
{

  key PhysicalInventoryDocument,
  key FiscalYear,
  key PhysicalInventoryDocumentItem,
  key PhysInvtrySerialNmbrListType,
  key I_MaintenanceItemObject.Equipment,

      Plant,
      I_MaintenanceItemObject.Material,
      I_MaintenanceItemObject.SerialNumber,
      I_SerialNmbrPhysicalInvtry.DocumentDate
}

Learn More