I_PHYSINVTRYINDBATCHSTORLOC

CDS View

Physical Inventory Indicators of Batches on Storage Location

I_PHYSINVTRYINDBATCHSTORLOC is a CDS View in S/4HANA. Physical Inventory Indicators of Batches on Storage Location. It contains 4 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 4 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_ProductBatchByInvStockType view_entity from COMPOSITE
P_ProductBatchByInvStockType view_entity union COMPOSITE

Fields (4)

KeyField CDS FieldsUsed in Views
KEY Batch Batch 1
KEY Material Material 1
KEY Plant Plant 1
KEY StorageLocation StorageLocation 1 
@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