I_PhysInventorySituation

Phys Inventory Situation Anchor/Trigger | view: IPHYSINVSITN | TRAN | Extraction: Not supported | Component: VDM Physical Inventory
Tables used: MATDOC, IKPF, ISEG, VBAP, PRTE, MATDOC_EXTRACT, MATDOC_EXTRACT, MATDOC_EXTRACT, MARA, MCHA, T001, TKA02, T001K, T001W, T001W, MARA, PROJ, PRPS, PRPS, /SAPSLL/CLSNR, /SAPSLL/MARITC, /SAPSLL/NOSCA, MARC, T001W, MARD, MARV, T001K, MARV, MARC, T150, T159C, /SAPSLL/TUNOS, FINSC_FISC_DATE
Column Name Description
PhysInvtrySitnID Physical Inventory Situation ID
Column Name Description
💲 Company Code Currency (Currency):
SlsPriceAmountInCoCodeCrcy Sales Price Book Value
PhysInvtryCtAmtInCoCodeCrcy Counted Quantity Value
BookQtyAmountInCoCodeCrcy Book Value
DifferenceAmountInCoCodeCrcy Value of Difference
EnteredSlsAmtInCoCodeCrcy Externally Entered Value Based on Sales Price
DiffCountedBookAmtInCoCodeCry Difference Value based on Count Entry
Column Name Description
📏 Entry Unit (UnitOfEntry):
QuantityInUnitOfEntry Counted Quantity in Entry Unit
📏 Base Unit of Measure (MaterialBaseUnit):
Quantity Counted Quantity
BookQtyBfrCountInMatlBaseUnit Book Quantity Immediately Prior to Count
DifferenceQuantityInBaseUnit Physical Inventory Item Difference Quantity in Base Unit
PInvDiffQtyPerYearInBaseUnit Adjusted Quantity Last 12 Months
GdsRcptQtySinceLastCtInBsUnt Received Quantity Since Last Count
AvgStkQtySinceLastCountInBsUnt Average Book Quantity
GdsIssQtySinceLastCountInBsUnt Issued Quantity Since Last Count
Column Name Description
LastChangeDate Last Changed On
PhysicalInventoryLastCountDate Date of Last Count
PostingDate Posting Date in the Document
PhysInventoryPlannedCountDate Planned Date of Inventory Count
Column Name Description
ProductCategory Material Category Show values
IsHandledInAltvUnitOfMsr Without Unit of Measure Proposal Show values
PhysicalInventoryItemIsZero Is Zero Count Show values
PhysInvtryItemIsDeleted Item is Deleted Show values
IsValueOnlyMaterial Is Value-Only Material Show values
PhysInvtryDiffIsDistributed Is Difference Distributed Show values
PhysicalInventoryItemIsCounted Item is Counted Show values
PhysInvtryDifferenceIsPosted Difference of Item is Posted Show values
PhysInvtryItemIsRecounted Item is Recounted Show values
PhysInvtryIsCreatedByRecount Physical Inventory Document Created by Recount Show values
PhysInvtryDocHasQtySnapshot Book Inventory Freeze Show values
SalesPriceValuationIsActive Is Sales Price Valuation Active Show values
IsMarkedForDeletion Deletion Indicator Show values
PhysInvtryItemIsNeverCounted Stock was never counted Show values
Column Name Description Domain name
FiscalYear Fiscal Year GJAHR
PhysicalInventoryDocument Physical Inventory Document BELNR
PhysicalInventoryDocumentItem Physical Inventory Item Number ZEILE
WarehouseStorageBin Storage Bin CHAR10
GoodsMovementType Movement Type for Adjustment BWART
SalesOrder Sales Order Number VBELN
SalesOrderItem Sales Order Item NUM06
ScheduleLine Delivery Schedule for Sales Order NUM04
StockOwner Owner of stock LIFNR
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
PhysInvtryDifferenceInPercent Physical Inventory Difference in Percent
MaterialDocument Number of Material Document BELNR
MaterialDocumentYear Material Document Year GJAHR
MaterialDocumentItem Material Document Item MBLPO
NmbrOfPhysInvtryPerFiscalYear No. of Phys. Inventories per Fiscal Year for Cycle Counting NUM3
PhysInvtryIntvlForCycCounting Physical Inventory Interval (in Workdays) for Cycle Counting NUM3
PhysInvtryFloatTimeCycCounting Float Time (in Workdays) for Cycle Counting NUM2
PhysicalInventoryNumber Physical Inventory Number XBLNR1
SerialNumberProfile Serial Number Profile SERAIL
ProductType Product Type COM_PRODUCT_TYPE
ProductGroup Product Group MATKL
NumberOfPhysInventoryCounts Number of PI Counts in the current Fiscal Year
NumberOfPInvAdjustmentsPerYear Count Adjustments Last 12 Months
NmbrOfDaysSinceLastPInvCount Days Since Last Count
NrOfGdsRcptSinceLastPInvCount Goods Receipts Since Last Count
InvtryTurnoverSinceLastCnt Turnover Since Last Count
NrOfGoodsIssSinceLastPInvCount Goods Issues Since Last Count
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Client
  • Material Number
  • Plant
  • I_PHYSINVENTORYSITUATION.BATCH == MCHA.CHARG
  • I_PHYSINVENTORYSITUATION.MANDT == MCHA.MANDT
  • I_PHYSINVENTORYSITUATION.MATERIAL == MCHA.MATNR
  • I_PHYSINVENTORYSITUATION.PLANT == MCHA.WERKS
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • I_PHYSINVENTORYSITUATION.CROSSPLANTCONFIGURABLEMATERIAL == MARA.MATNR
  • I_PHYSINVENTORYSITUATION.MANDT == MARA.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • I_PHYSINVENTORYSITUATION.CURRENCY == TCURC.WAERS
  • I_PHYSINVENTORYSITUATION.MANDT == TCURC.MANDT
Customer Number
  • Customer Number
  • Client
  • I_PHYSINVENTORYSITUATION.CUSTOMER == KNA1.KUNNR
  • I_PHYSINVENTORYSITUATION.MANDT == KNA1.MANDT
Special Stock Type
  • Client
  • Special Stock Type
  • I_PHYSINVENTORYSITUATION.MANDT == T148.MANDT
  • I_PHYSINVENTORYSITUATION.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
Material Number
  • Client
  • Material Number
  • I_PHYSINVENTORYSITUATION.MANDT == MARA.MANDT
  • I_PHYSINVENTORYSITUATION.MATERIAL == MARA.MATNR
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_PHYSINVENTORYSITUATION.MATERIALBASEUNIT == T006.MSEHI
  • I_PHYSINVENTORYSITUATION.MANDT == T006.MANDT
Plant
  • Client
  • Material Number
  • Plant
  • I_PHYSINVENTORYSITUATION.MANDT == MARC.MANDT
  • I_PHYSINVENTORYSITUATION.MATERIAL == MARC.MATNR
  • I_PHYSINVENTORYSITUATION.PLANT == MARC.WERKS
Difference Reason
  • ?
  • Difference Reason
  • Client
  • I_PHYSINVENTORYSITUATION.[column in domain "BWART"] == T157D.BWART
  • I_PHYSINVENTORYSITUATION.REASONFORPHYSINVTRYDIFFERENCE == T157D.GRUND
  • I_PHYSINVENTORYSITUATION.MANDT == T157D.MANDT
Serial Number Profile
  • Serial Number Profile
  • Client
  • I_PHYSINVENTORYSITUATION.SERIALIDENTIFIERASSGMTPROFILE == TSERIAL.SERIAL
  • I_PHYSINVENTORYSITUATION.MANDT == TSERIAL.MANDT
Storage location
  • Storage location
  • Client
  • Material Number
  • Plant
  • I_PHYSINVENTORYSITUATION.STORAGELOCATION == MARD.LGORT
  • I_PHYSINVENTORYSITUATION.MANDT == MARD.MANDT
  • I_PHYSINVENTORYSITUATION.MATERIAL == MARD.MATNR
  • I_PHYSINVENTORYSITUATION.PLANT == MARD.WERKS
Vendor's account number
  • Vendor's account number
  • Client
  • I_PHYSINVENTORYSITUATION.SUPPLIER == LFA1.LIFNR
  • I_PHYSINVENTORYSITUATION.MANDT == LFA1.MANDT
Entry Unit
  • Entry Unit
  • Client
  • I_PHYSINVENTORYSITUATION.UNITOFENTRY == T006.MSEHI
  • I_PHYSINVENTORYSITUATION.MANDT == T006.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Cycle Count Type
  • Cycle Count Type
  • Client
  • Plant
  • I_PHYSINVENTORYSITUATION.CYCLECOUNTTYPE == T159C.ABCIN
  • I_PHYSINVENTORYSITUATION.MANDT == T159C.MANDT
  • I_PHYSINVENTORYSITUATION.PLANT == T159C.WERKS