I_PhysInvtryCube

Physical Inventory - Cube | view: IPHYINVTRYCUBE | 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):
DiffSlsPrcAmtInCoCodeCrcy Value of Difference Based on Sales Price
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
Column Name Description
📏 Base Unit of Measure (MaterialBaseUnit):
BookQtyBfrCountInMatlBaseUnit Book Quantity Immediately Prior to Count
Quantity Counted Quantity
DifferenceQuantityInBaseUnit Physical Inventory Item Difference Quantity in Base Unit
📏 Entry Unit (UnitOfEntry):
QuantityInUnitOfEntry Counted Quantity in Entry Unit
Column Name Description
PhysicalInventoryLastCountDate Date of Last Count
PostingDate Posting Date in the Document
DocumentDate Document Date in Document
LastChangeDate Last Changed On
PhysInventoryPlannedCountDate Planned Date of Inventory Count
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
PhysicalInventoryType Physical Inventory Type Show values
PostingIsBlockedForPhysInvtry Posting Block Due to Physical Inventory Show values
PhysInvtryDocHasQtySnapshot Book Inventory Freeze Show values
PhysInvtryDiffIsDistributed Is Difference Distributed Show values
PhysicalInventoryGroupType Type of Grouping Criterion Show values
IsValueOnlyMaterial Is Value-Only Material Show values
IsHandledInAltvUnitOfMsr Without Unit of Measure Proposal Show values
ProductCategory Material Category Show values
SalesPriceValuationIsActive Is Sales Price Valuation Active 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
FiscalPeriod Posting Period MONAT
PhysicalInventoryGroup Grouping Criterion of Physical Inventory Document Item CHAR10
PhysicalInventoryNumber Physical Inventory Number XBLNR1
PhysicalInventoryDocumentDesc Description of Physical Inventory Document TEXT40
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
  • Material Number
  • Plant
  • Batch Number
  • Client
  • I_PHYSINVTRYCUBE.MATERIAL == MCHA.MATNR
  • I_PHYSINVTRYCUBE.PLANT == MCHA.WERKS
  • I_PHYSINVTRYCUBE.BATCH == MCHA.CHARG
  • I_PHYSINVTRYCUBE.MANDT == MCHA.MANDT
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • I_PHYSINVTRYCUBE.MANDT == MARA.MANDT
  • I_PHYSINVTRYCUBE.CROSSPLANTCONFIGURABLEMATERIAL == MARA.MATNR
Company Code Currency
  • Client
  • Company Code Currency
  • I_PHYSINVTRYCUBE.MANDT == TCURC.MANDT
  • I_PHYSINVTRYCUBE.CURRENCY == TCURC.WAERS
Account number of customer
  • Account number of customer
  • Client
  • I_PHYSINVTRYCUBE.CUSTOMER == KNA1.KUNNR
  • I_PHYSINVTRYCUBE.MANDT == KNA1.MANDT
Special Stock Type
  • Client
  • Special Stock Type
  • I_PHYSINVTRYCUBE.MANDT == T148.MANDT
  • I_PHYSINVTRYCUBE.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
Inventory Transaction Type I_PHYSINVTRYCUBE.INVENTORYTRANSACTIONTYPE == T158V.VGART
Material Number
  • Material Number
  • Client
  • I_PHYSINVTRYCUBE.MATERIAL == MARA.MATNR
  • I_PHYSINVTRYCUBE.MANDT == MARA.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_PHYSINVTRYCUBE.MATERIALBASEUNIT == T006.MSEHI
  • I_PHYSINVTRYCUBE.MANDT == T006.MANDT
Plant
  • Material Number
  • Plant
  • Client
  • I_PHYSINVTRYCUBE.MATERIAL == MARC.MATNR
  • I_PHYSINVTRYCUBE.PLANT == MARC.WERKS
  • I_PHYSINVTRYCUBE.MANDT == MARC.MANDT
Difference Reason
  • Difference Reason
  • ?
  • Client
  • I_PHYSINVTRYCUBE.REASONFORPHYSINVTRYDIFFERENCE == T157D.GRUND
  • I_PHYSINVTRYCUBE.[column in domain "BWART"] == T157D.BWART
  • I_PHYSINVTRYCUBE.MANDT == T157D.MANDT
Storage location
  • Material Number
  • Storage location
  • Plant
  • Client
  • I_PHYSINVTRYCUBE.MATERIAL == MARD.MATNR
  • I_PHYSINVTRYCUBE.STORAGELOCATION == MARD.LGORT
  • I_PHYSINVTRYCUBE.PLANT == MARD.WERKS
  • I_PHYSINVTRYCUBE.MANDT == MARD.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • I_PHYSINVTRYCUBE.SUPPLIER == LFA1.LIFNR
  • I_PHYSINVTRYCUBE.MANDT == LFA1.MANDT
Entry Unit
  • Entry Unit
  • Client
  • I_PHYSINVTRYCUBE.UNITOFENTRY == T006.MSEHI
  • I_PHYSINVTRYCUBE.MANDT == T006.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Cycle Count Type
  • Plant
  • Cycle Count Type
  • Client
  • I_PHYSINVTRYCUBE.PLANT == T159C.WERKS
  • I_PHYSINVTRYCUBE.CYCLECOUNTTYPE == T159C.ABCIN
  • I_PHYSINVTRYCUBE.MANDT == T159C.MANDT