C_PhysInvtryQuery

Physical Inventory Analysis | view: CPHYSINVTRYQUERY | TRAN | Extraction: Not supported | Component: VDM Physical Inventory

Tables used: IKPF, ISEG, T001K, T001W, T150

🔑 Keys
💰 Amounts (8)
∑ Quantities (4)
📅 Dates (5)
☰ Categorical (12)
Other (17)
🔗 Relations (16)

Column Name	Description

Column Name	Description
💲 Company Code Currency (Currency):
BookQtyAmountInCoCodeCrcy	Book Value
DifferenceAmountInCoCodeCrcy	Value of Difference
MaxAbsDiffAmountInCoCodeCrcy	Maximum Value of Difference
MinAbsDiffAmountInCoCodeCrcy	Minimum Value of Difference
PhysInvtryCtAmtInCoCodeCrcy	Counted Quantity Value
SlsPriceAmountInCoCodeCrcy	Sales Price Book Value
EnteredSlsAmtInCoCodeCrcy	Externally Entered Value Based on Sales Price
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
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
PhysicalInventoryGroupType	Type of Grouping Criterion	Show values
IsValueOnlyMaterial	Is Value-Only Material	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
FiscalYear	Fiscal Year	GJAHR
PhysicalInventoryDocument	Physical Inventory Document	BELNR
PhysicalInventoryDocumentItem	Physical Inventory Item Number	ZEILE
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 Plant Batch Number Client Material Number	`C_PHYSINVTRYQUERY.PLANT == MCHA.WERKS` `C_PHYSINVTRYQUERY.BATCH == MCHA.CHARG` `C_PHYSINVTRYQUERY.MANDT == MCHA.MANDT` `C_PHYSINVTRYQUERY.MATERIAL == MCHA.MATNR`
Cross-Plant Configurable Material Client Cross-Plant Configurable Material	`C_PHYSINVTRYQUERY.MANDT == MARA.MANDT` `C_PHYSINVTRYQUERY.CROSSPLANTCONFIGURABLEMATERIAL == MARA.MATNR`
Company Code Currency Company Code Currency Client	`C_PHYSINVTRYQUERY.CURRENCY == TCURC.WAERS` `C_PHYSINVTRYQUERY.MANDT == TCURC.MANDT`
Account number of customer Account number of customer Client	`C_PHYSINVTRYQUERY.CUSTOMER == KNA1.KUNNR` `C_PHYSINVTRYQUERY.MANDT == KNA1.MANDT`
Special Stock Type Special Stock Type Client	`C_PHYSINVTRYQUERY.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ` `C_PHYSINVTRYQUERY.MANDT == T148.MANDT`
Inventory Transaction Type	`C_PHYSINVTRYQUERY.INVENTORYTRANSACTIONTYPE == T158V.VGART`
Material Number Client Material Number	`C_PHYSINVTRYQUERY.MANDT == MARA.MANDT` `C_PHYSINVTRYQUERY.MATERIAL == MARA.MATNR`
Base Unit of Measure Base Unit of Measure Client	`C_PHYSINVTRYQUERY.MATERIALBASEUNIT == T006.MSEHI` `C_PHYSINVTRYQUERY.MANDT == T006.MANDT`
Plant Plant Client Material Number	`C_PHYSINVTRYQUERY.PLANT == MARC.WERKS` `C_PHYSINVTRYQUERY.MANDT == MARC.MANDT` `C_PHYSINVTRYQUERY.MATERIAL == MARC.MATNR`
Difference Reason Client Difference Reason ?	`C_PHYSINVTRYQUERY.MANDT == T157D.MANDT` `C_PHYSINVTRYQUERY.REASONFORPHYSINVTRYDIFFERENCE == T157D.GRUND` `C_PHYSINVTRYQUERY.[column in domain "BWART"] == T157D.BWART`
Storage location Plant Client Storage location Material Number	`C_PHYSINVTRYQUERY.PLANT == MARD.WERKS` `C_PHYSINVTRYQUERY.MANDT == MARD.MANDT` `C_PHYSINVTRYQUERY.STORAGELOCATION == MARD.LGORT` `C_PHYSINVTRYQUERY.MATERIAL == MARD.MATNR`
Vendor's account number Vendor's account number Client	`C_PHYSINVTRYQUERY.SUPPLIER == LFA1.LIFNR` `C_PHYSINVTRYQUERY.MANDT == LFA1.MANDT`
Entry Unit Client Entry Unit	`C_PHYSINVTRYQUERY.MANDT == T006.MANDT` `C_PHYSINVTRYQUERY.UNITOFENTRY == T006.MSEHI`

Other Relations \| to Master Data Relations ↑	Join Conditions
Cycle Count Type Plant Client Cycle Count Type	`C_PHYSINVTRYQUERY.PLANT == T159C.WERKS` `C_PHYSINVTRYQUERY.MANDT == T159C.MANDT` `C_PHYSINVTRYQUERY.CYCLECOUNTTYPE == T159C.ABCIN`