ESH_S_PHYSINVTRY

Search view -PHYSINVTRY | view: ESH_U_PHYSINVTRY | TRAN | Extraction: Not supported | Component: Basic Functions
Tables used: IKPFISEGKNA1T148T148TT158VT158WMARAT023T023TMAKTT001KT001WT001WT001LLFA1USR21
Column Name Description
Column Name Description
Column Name Description
Column Name Description
DOCUMENTDATE Document Date in Document
PHYSICALINVENTORYLASTCOUNTDATE Date of Last Count
PHYSINVENTORYPLANNEDCOUNTDATE Planned Date of Inventory Count
POSTINGDATE Posting Date in the Document
Column Name Description
Column Name Description Domain name
CREATEDBYUSERNAME Physical Inventory Created by User USNAM
FISCALPERIOD Posting Period
FISCALYEAR Fiscal Year GJAHR
INVENTORYSPECIALSTOCKTYPENAME Description of special stock TEXT20
INVENTORYTRANSACTIONTYPETEXT Long Text TEXT40
MATERIALGROUP Product Group MATKL
MATERIALGROUPNAME Product Group Description
MATERIALNAME Material Description TEXT40
SUPPLIERNAME Name 1 NAME
CUSTOMERNAME Name 1 NAME
PHYSICALINVENTORYCOUNTSTATUS Count Status ZSTAT
PHYSICALINVENTORYCOUNTSTSTXT Short Text for Fixed Values DDTEXT
PHYSICALINVENTORYDOCUMENT Physical Inventory Document BELNR
PHYSINVTRYADJMTPOSTGSTSTXT Short Text for Fixed Values DDTEXT
PHYSINVTRYADJUSTMENTPOSTINGSTS Status of Adjustment Posting (Inventory Differences) DSTAT
PLANTNAME Plant Name
STORAGELOCATIONNAME Storage Location Name TEXT16
USERDESCRIPTION User Description
Master Data Relations Join Conditions
Account number of customer
  • Client
  • Account number of customer
  • ESH_S_PHYSINVTRY.MANDT == KNA1.MANDT
  • ESH_S_PHYSINVTRY.CUSTOMER == KNA1.KUNNR
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • ESH_S_PHYSINVTRY.MANDT == T148.MANDT
  • ESH_S_PHYSINVTRY.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
Inventory Transaction Type ESH_S_PHYSINVTRY.INVENTORYTRANSACTIONTYPE == T158V.VGART
Material Number
  • Client
  • Material Number
  • ESH_S_PHYSINVTRY.MANDT == MARA.MANDT
  • ESH_S_PHYSINVTRY.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • ESH_S_PHYSINVTRY.MANDT == T001W.MANDT
  • ESH_S_PHYSINVTRY.PLANT == T001W.WERKS
Storage location
  • Storage location
  • Client
  • Plant
  • ESH_S_PHYSINVTRY.STORAGELOCATION == T001L.LGORT
  • ESH_S_PHYSINVTRY.MANDT == T001L.MANDT
  • ESH_S_PHYSINVTRY.PLANT == T001L.WERKS
Vendor's account number
  • Client
  • Vendor's account number
  • ESH_S_PHYSINVTRY.MANDT == LFA1.MANDT
  • ESH_S_PHYSINVTRY.SUPPLIER == LFA1.LIFNR