P_PHYSINVTRYNOTPOSTED_L3

CDS View

Not posted master data

P_PHYSINVTRYNOTPOSTED_L3 is a CDS View in S/4HANA. Not posted master data. It contains 14 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 14 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PhysInvtryProposal_L1 view_entity union_all COMPOSITE Inventory proposal level 1

Fields (14)

KeyField CDS FieldsUsed in Views
KEY BaseUnit MaterialBaseUnit 1
KEY Batch Batch 1
KEY Customer Customer 1
KEY InventorySpecialStockType InventorySpecialStockType 1
KEY InventoryStockType InventoryStockType 1
KEY Plant Plant 1
KEY SalesOrder SalesOrder 1
KEY StockOwner StockOwner 1
KEY StorageLocation StorageLocation 1
KEY Supplier Supplier 1
KEY WBSElementInternalID WBSElementInternalID 1
InventoryValuationType InventoryValuationType 1
MatlBatchIsInRstrcdUseStock MatlBatchIsInRstrcdUseStock 1
SerialNumberProfile SerialIdentifierAssgmtProfile 1 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Not posted master data'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #D,
    sizeCategory: #XL,
    dataClass: #MASTER
}
@VDM:{
       private: true,
       viewType: #COMPOSITE
     }
define view entity P_PhysInvtryNotPosted_L3
as select from P_PhysInvtryNotPosted_L2 as NotPosted
  left outer to one join I_ValuationArea           as ValArea        on NotPosted.Plant                      = ValArea.ValuationArea
  left outer to one join P_PhysIntryCurrentPeriod  as _CurrentPeriod on _CurrentPeriod.CompanyCode           = ValArea.CompanyCode
  left outer to many join P_MappedPhysInvtryItem   as PiItem         on  NotPosted.Material                  = PiItem.Material
                                                                     and NotPosted.Plant                     = PiItem.Plant
                                                                     and NotPosted.StorageLocation           = PiItem.StorageLocation
                                                                     and ( NotPosted.Batch                   = PiItem.Batch or NotPosted.Batch is null )
                                                                     and ( NotPosted.InventoryStockType      = PiItem.InventoryStockType or( NotPosted.InventoryStockType = '08' and PiItem.InventoryStockType = '01' ) )
                                                                     and NotPosted.BaseUnit                  = PiItem.MaterialBaseUnit
                                                                     and _CurrentPeriod.FiscalYear           = PiItem.FiscalYear
                                                                     and PiItem.PhysInvtryItemIsRecounted    = ''
                                                                     and PiItem.PhysInvtryDifferenceIsPosted = ''
                                                                     and PiItem.PhysInvtryItemIsDeleted      = '' // Filtering out closed inventory counts


{
  key NotPosted.Material,
  key NotPosted.Plant,
  key NotPosted.StorageLocation,
  key NotPosted.Batch,
  key NotPosted.Supplier,
  key NotPosted.SalesOrder,
  key NotPosted.SalesOrderItem,
  key NotPosted.WBSElementInternalID,
  key NotPosted.Customer,
  key NotPosted.StockOwner,
  key NotPosted.InventoryStockType,
  key NotPosted.InventorySpecialStockType,
      NotPosted.BaseUnit,
      NotPosted.ValuationCategory,
      NotPosted.IsBatchManagementRequired,
      NotPosted.InventoryForCycleCountInd,
      NotPosted.SerialNumberProfile,
      NotPosted.InventoryValuationType,
      NotPosted.MatlBatchIsInRstrcdUseStock
    
}
group by
  NotPosted.Material,
  NotPosted.Plant,
  NotPosted.StorageLocation,
  NotPosted.Batch,
  NotPosted.Supplier,
  NotPosted.SalesOrder,
  NotPosted.SalesOrderItem,
  NotPosted.WBSElementInternalID,
  NotPosted.Customer,
  NotPosted.StockOwner,
  NotPosted.InventoryStockType,
  NotPosted.InventorySpecialStockType,
  NotPosted.BaseUnit,
  NotPosted.ValuationCategory,
  NotPosted.IsBatchManagementRequired,
  NotPosted.InventoryForCycleCountInd,
  NotPosted.SerialNumberProfile,
  NotPosted.InventoryValuationType,
  NotPosted.MatlBatchIsInRstrcdUseStock,
  PiItem.PhysicalInventoryDocument
having
  PiItem.PhysicalInventoryDocument is null

Learn More