I_AugmentedPhysInvtryDocItem

Augmented Physical Inventory Doc Item | view: IAUPIDOCITEM | TRAN | Extraction: Not supported | Component: VDM Physical Inventory
Tables used: IKPF, ISEG, T001K, T001W, T150
Column Name Description
FiscalYear Fiscal Year
PhysicalInventoryDocument Physical Inventory Document
PhysicalInventoryDocumentItem Physical Inventory Item Number
Column Name Description
💲 Company Code Currency (Currency):
EnteredSlsAmtInCoCodeCrcy Externally Entered Value Based on Sales Price
SlsPriceAmountInCoCodeCrcy Sales Price Book Value
PhysInvtryCtAmtInCoCodeCrcy Counted Quantity Value
BookQtyAmountInCoCodeCrcy Book Value
DifferenceAmountInCoCodeCrcy Value of Difference
MaxAbsDiffAmountInCoCodeCrcy Maximum Value of Difference
MinAbsDiffAmountInCoCodeCrcy Minimum Value of Difference
DiffSlsPrcAmtInCoCodeCrcy Value of Difference Based on Sales Price
Column Name Description
📏 Base Unit of Measure (MaterialBaseUnit):
BookQtyBfrCountInMatlBaseUnit Book Quantity Immediately Prior to Count
Quantity Counted Quantity
📏 Entry Unit (UnitOfEntry):
QuantityInUnitOfEntry Counted Quantity in Entry Unit
DifferenceQuantityInBaseUnit Physical Inventory Item Difference Quantity in Base Unit
Column Name Description
PhysicalInventoryLastCountDate Date of Last Count
PostingDate Posting Date in the Document
LastChangeDate Last Changed On
Column Name Description
PhysicalInventoryItemIsCounted Item is Counted Show values
PhysInvtryDifferenceIsPosted Difference of Item is Posted Show values
PhysInvtryItemIsRecounted Item is Recounted Show values
PhysInvtryItemIsDeleted Item is Deleted Show values
PhysInvtryDiffIsDistributed Is Difference Distributed Show values
IsValueOnlyMaterial Is Value-Only Material Show values
IsHandledInAltvUnitOfMsr Without Unit of Measure Proposal Show values
ProductCategory Material Category Show values
PhysicalInventoryItemIsZero Is Zero Count Show values
Column Name Description Domain name
SalesOrder Sales Order Number VBELN
SalesOrderItem Item Number in Sales Order NUM06
ScheduleLine Delivery Schedule for Sales Order NUM04
GoodsMovementType Movement Type for Adjustment BWART
PhysInventoryReferenceNumber Physical Inventory Reference XBLNR1
MaterialDocumentYear Material Document Year GJAHR
MaterialDocument Number of Material Document BELNR
MaterialDocumentItem Material Document Item MBLPO
PhysInvtryRecountDocument Number of Recount Document BELNR
NumberOfPhysInvtryItems Number of Physical Inventory Items
Master Data Relations Join Conditions
Batch Number
  • Plant
  • Material Number
  • Batch Number
  • Client
  • I_AUGMENTEDPHYSINVTRYDOCITEM.PLANT == MCHA.WERKS
  • I_AUGMENTEDPHYSINVTRYDOCITEM.MATERIAL == MCHA.MATNR
  • I_AUGMENTEDPHYSINVTRYDOCITEM.BATCH == MCHA.CHARG
  • I_AUGMENTEDPHYSINVTRYDOCITEM.MANDT == MCHA.MANDT
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • I_AUGMENTEDPHYSINVTRYDOCITEM.MANDT == MARA.MANDT
  • I_AUGMENTEDPHYSINVTRYDOCITEM.CROSSPLANTCONFIGURABLEMATERIAL == MARA.MATNR
Company Code Currency
  • Company Code Currency
  • Client
  • I_AUGMENTEDPHYSINVTRYDOCITEM.CURRENCY == TCURC.WAERS
  • I_AUGMENTEDPHYSINVTRYDOCITEM.MANDT == TCURC.MANDT
Account number of customer
  • Account number of customer
  • Client
  • I_AUGMENTEDPHYSINVTRYDOCITEM.CUSTOMER == KNA1.KUNNR
  • I_AUGMENTEDPHYSINVTRYDOCITEM.MANDT == KNA1.MANDT
Special Stock Type
  • Special Stock Type
  • Client
  • I_AUGMENTEDPHYSINVTRYDOCITEM.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
  • I_AUGMENTEDPHYSINVTRYDOCITEM.MANDT == T148.MANDT
Material Number
  • Material Number
  • Client
  • I_AUGMENTEDPHYSINVTRYDOCITEM.MATERIAL == MARA.MATNR
  • I_AUGMENTEDPHYSINVTRYDOCITEM.MANDT == MARA.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_AUGMENTEDPHYSINVTRYDOCITEM.MATERIALBASEUNIT == T006.MSEHI
  • I_AUGMENTEDPHYSINVTRYDOCITEM.MANDT == T006.MANDT
Plant
  • Plant
  • Material Number
  • Client
  • I_AUGMENTEDPHYSINVTRYDOCITEM.PLANT == MARC.WERKS
  • I_AUGMENTEDPHYSINVTRYDOCITEM.MATERIAL == MARC.MATNR
  • I_AUGMENTEDPHYSINVTRYDOCITEM.MANDT == MARC.MANDT
Difference Reason
  • Difference Reason
  • ?
  • Client
  • I_AUGMENTEDPHYSINVTRYDOCITEM.REASONFORPHYSINVTRYDIFFERENCE == T157D.GRUND
  • I_AUGMENTEDPHYSINVTRYDOCITEM.[column in domain "BWART"] == T157D.BWART
  • I_AUGMENTEDPHYSINVTRYDOCITEM.MANDT == T157D.MANDT
Storage location
  • Plant
  • Storage location
  • Material Number
  • Client
  • I_AUGMENTEDPHYSINVTRYDOCITEM.PLANT == MARD.WERKS
  • I_AUGMENTEDPHYSINVTRYDOCITEM.STORAGELOCATION == MARD.LGORT
  • I_AUGMENTEDPHYSINVTRYDOCITEM.MATERIAL == MARD.MATNR
  • I_AUGMENTEDPHYSINVTRYDOCITEM.MANDT == MARD.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • I_AUGMENTEDPHYSINVTRYDOCITEM.SUPPLIER == LFA1.LIFNR
  • I_AUGMENTEDPHYSINVTRYDOCITEM.MANDT == LFA1.MANDT
Entry Unit
  • Entry Unit
  • Client
  • I_AUGMENTEDPHYSINVTRYDOCITEM.UNITOFENTRY == T006.MSEHI
  • I_AUGMENTEDPHYSINVTRYDOCITEM.MANDT == T006.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Cycle Count Type
  • Plant
  • Cycle Count Type
  • Client
  • I_AUGMENTEDPHYSINVTRYDOCITEM.PLANT == T159C.WERKS
  • I_AUGMENTEDPHYSINVTRYDOCITEM.CYCLECOUNTTYPE == T159C.ABCIN
  • I_AUGMENTEDPHYSINVTRYDOCITEM.MANDT == T159C.MANDT