P_PhysInvtryDocSrlNmbr

DDL: P_PHYSINVTRYDOCSRLNMBR Type: view_entity COMPOSITE Package: MM_IM_VDM_PI

Physical Inventory Doc Serial Number

P_PhysInvtryDocSrlNmbr is a Composite CDS View that provides data about "Physical Inventory Doc Serial Number" 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. Part of development package MM_IM_VDM_PI.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_MaintenanceItemObject I_MaintenanceItemObject inner
I_SerialNmbrPhysicalInvtry I_SerialNmbrPhysicalInvtry from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PhysicalInventoryDocument I_SerialNmbrPhysicalInvtry PhysicalInventoryDocument
KEY FiscalYear I_SerialNmbrPhysicalInvtry FiscalYear
KEY PhysicalInventoryDocumentItem I_SerialNmbrPhysicalInvtry PhysicalInventoryDocumentItem
KEY PhysInvtrySerialNmbrListType I_SerialNmbrPhysicalInvtry PhysInvtrySerialNmbrListType
KEY Equipment I_MaintenanceItemObject Equipment
Plant I_SerialNmbrPhysicalInvtry Plant
Material I_MaintenanceItemObject Material
SerialNumber I_MaintenanceItemObject SerialNumber
DocumentDate I_SerialNmbrPhysicalInvtry DocumentDate 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.private: true
@VDM.viewType: #COMPOSITE

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

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

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

Learn More