I_PHYSINVTRYDOCSRLNMBR

CDS View

Physical Inventory Doc Serial Number

I_PHYSINVTRYDOCSRLNMBR is a CDS View in S/4HANA. Physical Inventory Doc Serial Number. It contains 3 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 3 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_PhysInvtryDocSrlNmbrObjPage view from CONSUMPTION PI Document Serial Number Object Page
I_MaterialDocumentSerialNumber view_entity union COMPOSITE Seial Numbers for Material Document
P_SerialNmbrHistory view union CONSUMPTION Serial Numbers History

Fields (3)

KeyField CDS FieldsUsed in Views
KEY SerialNumber SerialNumber 1
Equipment Equipment 1
PhysicalInventoryDocumentItem PhysicalInventoryDocumentItem 1 
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'IPIDOCSN'
@EndUserText.label: 'Physical Inventory Doc Serial Number'

@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #COMPOSITE

define view I_PhysInvtryDocSrlNmbr
  as select from    P_PhysInvtryDocSrlNmbr as exp
    left outer join P_PhysInvtryDocSrlNmbr as act on  exp.PhysicalInventoryDocument     = act.PhysicalInventoryDocument
                                                  and exp.FiscalYear                    = act.FiscalYear
                                                  and exp.PhysicalInventoryDocumentItem = act.PhysicalInventoryDocumentItem
                                                  and exp.Equipment                     = act.Equipment
                                                  and act.PhysInvtrySerialNmbrListType  = '2' //Counted stock object list

{
  key exp.PhysicalInventoryDocument,
  key exp.FiscalYear,
  key exp.PhysicalInventoryDocumentItem,
  key exp.SerialNumber,
    
      exp.Equipment,
      exp.Material,
      exp.Plant,
      exp.DocumentDate,
      cast( 'I' as sn_history_doc_type preserving type )       as DocumentType, //Inventory Document

      
      'X'                                                      as SerialNumberIsInBooks,
      case when act.SerialNumber is null then ' ' else 'X' end as SerialNumberIsCounted
}
where exp.PhysInvtrySerialNmbrListType = '1' //Inventory balance object list


union select from P_PhysInvtryDocSrlNmbr as act
  left outer join P_PhysInvtryDocSrlNmbr as exp on  exp.PhysicalInventoryDocument     = act.PhysicalInventoryDocument
                                                and exp.FiscalYear                    = act.FiscalYear
                                                and exp.PhysicalInventoryDocumentItem = act.PhysicalInventoryDocumentItem
                                                and exp.Equipment                     = act.Equipment
                                                and exp.PhysInvtrySerialNmbrListType  = '1' //Inventory balance object list

{
  key act.PhysicalInventoryDocument,
  key act.FiscalYear,
  key act.PhysicalInventoryDocumentItem,
  key act.SerialNumber,

      act.Equipment,
      act.Material,
      act.Plant,
      act.DocumentDate,
      cast( 'I' as sn_history_doc_type preserving type )       as DocumentType, //Inventory Document

      
      case when exp.SerialNumber is null then ' ' else 'X' end as SerialNumberIsInBooks,
      'X'                                                      as SerialNumberIsCounted
}
where act.PhysInvtrySerialNmbrListType = '2' //Counted stock object list

Learn More