P_PhysInvtryNotPosted_L2

DDL: P_PHYSINVTRYNOTPOSTED_L2 Type: view_entity COMPOSITE Package: ODATA_MM_IM_PI_MASS_CREATE

Not posted master data

P_PhysInvtryNotPosted_L2 is a Composite CDS View that provides data about "Not posted master data" in SAP S/4HANA. It reads from 3 data sources (P_PhysInvtryNotPosted_L1, I_Product, P_ProductPlantBasic) and exposes 19 fields with key fields Material, Plant, StorageLocation, Batch, Supplier. Part of development package ODATA_MM_IM_PI_MASS_CREATE.

3 data source(s) 19 fields

Data Sources (3)

SourceAliasJoin Type
P_PhysInvtryNotPosted_L1 NotPosted from
I_Product Product inner
P_ProductPlantBasic ProductPlant inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Not posted master data view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY Material P_PhysInvtryNotPosted_L1 Material
KEY Plant P_PhysInvtryNotPosted_L1 Plant
KEY StorageLocation P_PhysInvtryNotPosted_L1 StorageLocation
KEY Batch P_PhysInvtryNotPosted_L1 Batch
KEY Supplier P_PhysInvtryNotPosted_L1 Supplier
KEY SalesOrder P_PhysInvtryNotPosted_L1 SalesOrder
KEY SalesOrderItem P_PhysInvtryNotPosted_L1 SalesOrderItem
KEY WBSElementInternalID P_PhysInvtryNotPosted_L1 WBSElementInternalID
KEY Customer P_PhysInvtryNotPosted_L1 Customer
KEY StockOwner P_PhysInvtryNotPosted_L1 StockOwner
KEY InventoryStockType P_PhysInvtryNotPosted_L1 InventoryStockType
KEY InventorySpecialStockType
BaseUnit I_Product BaseUnit
ValuationCategory P_ProductPlantBasic ValuationCategory
IsBatchManagementRequired P_ProductPlantBasic IsBatchManagementRequired
InventoryForCycleCountInd P_ProductPlantBasic InventoryForCycleCountInd
SerialNumberProfile P_ProductPlantBasic SerialNumberProfile
InventoryValuationType BatchPlant InventoryValuationType
MatlBatchIsInRstrcdUseStock BatchPlant MatlBatchIsInRstrcdUseStock 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Not posted master data'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #X,
    sizeCategory: #S,
    dataClass: #MIXED
}
@VDM:{
       private: true,
       viewType: #COMPOSITE
     }
define view entity P_PhysInvtryNotPosted_L2
as select from P_PhysInvtryNotPosted_L1 as NotPosted
inner join I_Product                as Product      on Product.Product = NotPosted.Material
inner join P_ProductPlantBasic      as ProductPlant on ProductPlant.Product  = NotPosted.Material
                                                   and ProductPlant.Plant = NotPosted.Plant
left outer to one join I_BatchPlant as BatchPlant   on BatchPlant.Material  = NotPosted.Material
                                                   and BatchPlant.Plant = NotPosted.Plant
                                                   and BatchPlant.Batch = NotPosted.Batch  
{
  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 cast('' as sobkz) as InventorySpecialStockType,
      Product.BaseUnit,
      ProductPlant.ValuationCategory,
      ProductPlant.IsBatchManagementRequired,
      ProductPlant.InventoryForCycleCountInd,
      ProductPlant.SerialNumberProfile,
      BatchPlant.InventoryValuationType,
      BatchPlant.MatlBatchIsInRstrcdUseStock
}
where ( ProductPlant.IsInternalBatchManaged = '' and ( NotPosted.Batch = '' or NotPosted.Batch is null ) ) 
or ( ProductPlant.IsInternalBatchManaged <> '' and ( NotPosted.Batch <> '' or NotPosted.Batch is not null ) )

Learn More