ESH_N_PHYSINVTRY

Anchor view -PHYSINVTRY | view: ESH_L_PHYSINVTRY | TRAN | Extraction: Not supported | Component: Basic Functions
Tables used: IKPFISEGKNA1T148T148TT158VT158WMARAT023T023TMAKTT001KT001WT001WT001LLFA1USR21
Column Name Description
FISCALYEAR Fiscal Year
PHYSICALINVENTORYDOCUMENT Physical Inventory Document
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 MONAT
INVENTORYSPECIALSTOCKTYPENAME Description of special stock TEXT20
INVENTORYTRANSACTIONTYPETEXT Long Text TEXT40
MATERIALGROUP Product Group MATKL
MATERIALGROUPNAME Product Group Description TEXT20
MATERIALNAME Material Description TEXT40
SUPPLIERNAME Name 1 NAME
CUSTOMERNAME Name 1 NAME
PHYSICALINVENTORYCOUNTSTATUS Count Status ZSTAT
PHYSICALINVENTORYCOUNTSTSTXT Short Text for Fixed Values DDTEXT
PHYSINVTRYADJMTPOSTGSTSTXT Short Text for Fixed Values DDTEXT
PHYSINVTRYADJUSTMENTPOSTINGSTS Status of Adjustment Posting (Inventory Differences) DSTAT
PLANTNAME Plant Name TEXT30
STORAGELOCATIONNAME Storage Location Name TEXT16
USERDESCRIPTION User Description SUIDTECHDESC
Master Data Relations Join Conditions
Account number of customer
  • Account number of customer
  • Client
  • ESH_N_PHYSINVTRY.CUSTOMER == KNA1.KUNNR
  • ESH_N_PHYSINVTRY.MANDT == KNA1.MANDT
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • ESH_N_PHYSINVTRY.MANDT == T148.MANDT
  • ESH_N_PHYSINVTRY.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
Inventory Transaction Type ESH_N_PHYSINVTRY.INVENTORYTRANSACTIONTYPE == T158V.VGART
Material Number
  • Client
  • Material Number
  • ESH_N_PHYSINVTRY.MANDT == MARA.MANDT
  • ESH_N_PHYSINVTRY.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • ESH_N_PHYSINVTRY.MANDT == T001W.MANDT
  • ESH_N_PHYSINVTRY.PLANT == T001W.WERKS
Storage location
  • Storage location
  • Client
  • Plant
  • ESH_N_PHYSINVTRY.STORAGELOCATION == T001L.LGORT
  • ESH_N_PHYSINVTRY.MANDT == T001L.MANDT
  • ESH_N_PHYSINVTRY.PLANT == T001L.WERKS
Vendor's account number
  • Client
  • Vendor's account number
  • ESH_N_PHYSINVTRY.MANDT == LFA1.MANDT
  • ESH_N_PHYSINVTRY.SUPPLIER == LFA1.LIFNR