I_PhysInvtryIndBatchStorLoc

DDL: I_PHYSINVTRYINDBATCHSTORLOC Type: view BASIC

Physical Inventory Indicators of Batches on Storage Location

I_PhysInvtryIndBatchStorLoc is a Basic CDS View that provides data about "Physical Inventory Indicators of Batches on Storage Location" in SAP S/4HANA. It reads from 1 data source (mchb) and exposes 14 fields with key fields Material, Plant, StorageLocation, Batch.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
mchb mchb from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPHYSINDSTORLOC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Physical Inventory Indicators of Batches on Storage Location view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Material matnr
KEY Plant werks
KEY StorageLocation lgort
KEY Batch charg
InvtryCurrentYearStockInd kzicl
InvtryQualInspCurrentYrStkInd kzicq
InvtryRestrictedUseStockInd kzice
InventoryBlockStockInd kzics
InventoryStockPrevPeriod kzvcl
InvtryStockQltyInspPrevPeriod kzvcq
InvtryRestStockPrevPeriodInd kzvce
HasInvtryBlockStockPrevPeriod kzvcs
CreationDate ersda
IsMarkedForDeletion lvorm 
@AbapCatalog: {
                    sqlViewName: 'IPHYSINDSTORLOC',
                    compiler.compareFilter: true,
                    preserveKey: true
              }
@VDM: { 
          viewType: #BASIC,
          lifecycle.contract.type: #SAP_INTERNAL_API
      }     
@ObjectModel.usageType: { 
                             serviceQuality: #A,
                             sizeCategory : #L,
                             dataClass: #TRANSACTIONAL
                        } 
                        
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Physical Inventory Indicators of Batches on Storage Location'

define view I_PhysInvtryIndBatchStorLoc as select from mchb {

  key matnr as Material,
  key werks as Plant,
  key lgort as StorageLocation,
  key charg as Batch,
  
  kzicl as InvtryCurrentYearStockInd,
  kzicq as InvtryQualInspCurrentYrStkInd,
  kzice as InvtryRestrictedUseStockInd,
  kzics as InventoryBlockStockInd,
  kzvcl as InventoryStockPrevPeriod,
  kzvcq as InvtryStockQltyInspPrevPeriod,
  kzvce as InvtryRestStockPrevPeriodInd,
  kzvcs as HasInvtryBlockStockPrevPeriod,
  
  ersda as CreationDate,
  
  lvorm as IsMarkedForDeletion
    
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MCHB"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More