I_PhysInventorySituation

DDL: I_PHYSINVENTORYSITUATION Type: view_entity COMPOSITE Package: ODATA_MM_IM_PI_OBJECT_PAGE
91 Fields 1 Data Sources

Phys Inventory Situation Anchor/Trigger

I_PhysInventorySituation is a Composite CDS View that provides data about "Phys Inventory Situation Anchor/Trigger" in SAP S/4HANA. It reads from 1 data source (P_PhysInventorySituation) and exposes 91 fields with key field PhysInvtrySitnID. Part of development package ODATA_MM_IM_PI_OBJECT_PAGE.

Data Sources (1)

SourceAliasJoin Type
P_PhysInventorySituation P_PhysInventorySituation from

Annotations (6)

NameValueLevelField
EndUserText.label Phys Inventory Situation Anchor/Trigger view
VDM.private false view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (91)

KeyFieldSource TableSource FieldDescription
KEY PhysInvtrySitnID PhysInvtrySitnID
FiscalYear FiscalYear G/L Fiscal Year
PhysicalInventoryDocument PhysicalInventoryDocument Physical Inventory Document
PhysicalInventoryDocumentItem PhysicalInventoryDocumentItem Physical Inventory Document Item
Material Material Vehicle Model
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
WarehouseStorageBin WarehouseStorageBin Storage Bin
Batch Batch Lot No.
InventorySpecialStockType InventorySpecialStockType Special Stock Type
GoodsMovementType GoodsMovementType Movement Type
PhysicalInventoryStockType PhysicalInventoryStockType Stock Type
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
ScheduleLine ScheduleLine Schedule Line
Supplier Supplier Supplier
StockOwner StockOwner Owner of stock
Customer Customer Sold-to Party
WBSElement WBSElement WBS Internal ID
ProductCategory ProductCategory Prod Category
LastChangeDate LastChangeDate Time Stamp
PhysicalInventoryLastCountDate PhysicalInventoryLastCountDate Count Date
PostingDate PostingDate Posting Date for GR
PhysInventoryPlannedCountDate PhysInventoryPlannedCountDate Plan.Count date
IsHandledInAltvUnitOfMsr IsHandledInAltvUnitOfMsr Without Unit of Measure Proposal
PhysicalInventoryItemIsZero PhysicalInventoryItemIsZero Zero Counted
PhysInvtryItemIsDeleted PhysInvtryItemIsDeleted Is Deleted
QuantityInUnitOfEntry QuantityInUnitOfEntry Quantity in UnE
Quantity Quantity Value
BookQtyBfrCountInMatlBaseUnit BookQtyBfrCountInMatlBaseUnit Book Quantity
DifferenceQuantityInBaseUnit DifferenceQuantityInBaseUnit
PhysInvtryDifferenceInPercent PhysInvtryDifferenceInPercent
MaterialBaseUnit MaterialBaseUnit Valuation Unit
UnitOfEntry UnitOfEntry Unit of Entry
Currency Currency Valuation Crcy
SlsPriceAmountInCoCodeCrcy SlsPriceAmountInCoCodeCrcy Sales Price Book Value
PhysInvtryCtAmtInCoCodeCrcy PhysInvtryCtAmtInCoCodeCrcy Counted Quantity Value
BookQtyAmountInCoCodeCrcy BookQtyAmountInCoCodeCrcy Book Value
DifferenceAmountInCoCodeCrcy DifferenceAmountInCoCodeCrcy Difference Val.
EnteredSlsAmtInCoCodeCrcy EnteredSlsAmtInCoCodeCrcy Sales Price Counted Value
IsValueOnlyMaterial IsValueOnlyMaterial Is Value-Only Material
MaterialDocument MaterialDocument Material Doc.
MaterialDocumentYear MaterialDocumentYear Material Document Year
MaterialDocumentItem MaterialDocumentItem Material Document Item
CycleCountType CycleCountType Cycle Count Type
NmbrOfPhysInvtryPerFiscalYear NmbrOfPhysInvtryPerFiscalYear
PhysInvtryIntvlForCycCounting PhysInvtryIntvlForCycCounting
PhysInvtryFloatTimeCycCounting PhysInvtryFloatTimeCycCounting
ReasonForPhysInvtryDifference ReasonForPhysInvtryDifference Difference Reason
CrossPlantConfigurableMaterial CrossPlantConfigurableMaterial Cross-Plant Configurable Material
PhysInvtryDiffIsDistributed PhysInvtryDiffIsDistributed Difference Distributed
PhysicalInventoryItemIsCounted PhysicalInventoryItemIsCounted Is Counted
PhysInvtryDifferenceIsPosted PhysInvtryDifferenceIsPosted Is Difference Posted
PhysInvtryItemIsRecounted PhysInvtryItemIsRecounted Is Recounted
PhysInvtryIsCreatedByRecount PhysInvtryIsCreatedByRecount
PhysicalInventoryNumber PhysicalInventoryNumber Physical Inventory Number
PhysInvtryDocHasQtySnapshot PhysInvtryDocHasQtySnapshot Book Inventory Freeze
SalesPriceValuationIsActive SalesPriceValuationIsActive Is Sales Price Valuation Active
SerialNumberProfile SerialNumberProfile SerialNoProfile
ProductType ProductType Product Type Group
ProductGroup ProductGroup Product Sold Group
SerialIdentifierAssgmtProfile SerialIdentifierAssgmtProfile Serial No. Prf.
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
NumberOfPhysInventoryCounts NumberOfPhysInventoryCounts
NumberOfPInvAdjustmentsPerYear NumberOfPInvAdjustmentsPerYear
PInvDiffQtyPerYearInBaseUnit PInvDiffQtyPerYearInBaseUnit
NmbrOfDaysSinceLastPInvCount NmbrOfDaysSinceLastPInvCount
PhysInvtryItemIsNeverCounted PhysInvtryItemIsNeverCounted
NrOfGdsRcptSinceLastPInvCount NrOfGdsRcptSinceLastPInvCount
GdsRcptQtySinceLastCtInBsUnt GdsRcptQtySinceLastCtInBsUnt
AvgStkQtySinceLastCountInBsUnt AvgStkQtySinceLastCountInBsUnt
InvtryTurnoverSinceLastCnt InvtryTurnoverSinceLastCnt
NrOfGoodsIssSinceLastPInvCount NrOfGoodsIssSinceLastPInvCount
GdsIssQtySinceLastCountInBsUnt GdsIssQtySinceLastCountInBsUnt
DiffCountedBookAmtInCoCodeCry DiffCountedBookAmtInCoCodeCry
_Customer _Customer
_CustomerCompanyByPlant _CustomerCompanyByPlant
_Supplier _Supplier
_SupplierCompanyByPlant _SupplierCompanyByPlant
_Material _Material
_CrossPlantConfigurableMatl _CrossPlantConfigurableMatl
_MaterialBaseUnit _MaterialBaseUnit
_Currency _Currency
_Plant _Plant
_StorageLocation _StorageLocation
_UnitOfEntry _UnitOfEntry
_PhysicalInventoryStockType _PhysicalInventoryStockType
_InventorySpecialStockType _InventorySpecialStockType
_PhysInvtryReasonCode _PhysInvtryReasonCode
_GoodsMovementType _GoodsMovementType
_ProductCategory _ProductCategory

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_PhysInventorySituation.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_PhysInventorySituation AS
SELECT
  PhysInvtrySitnID,
  FiscalYear,
  PhysicalInventoryDocument,
  PhysicalInventoryDocumentItem,
  Material,
  Plant,
  StorageLocation,
  WarehouseStorageBin,
  Batch,
  InventorySpecialStockType,
  GoodsMovementType,
  PhysicalInventoryStockType,
  SalesOrder,
  SalesOrderItem,
  ScheduleLine,
  Supplier,
  StockOwner,
  Customer,
  WBSElement,
  ProductCategory,
  LastChangeDate,
  PhysicalInventoryLastCountDate,
  PostingDate,
  PhysInventoryPlannedCountDate,
  IsHandledInAltvUnitOfMsr,
  PhysicalInventoryItemIsZero,
  PhysInvtryItemIsDeleted,
  QuantityInUnitOfEntry,
  Quantity,
  BookQtyBfrCountInMatlBaseUnit,
  DifferenceQuantityInBaseUnit,
  PhysInvtryDifferenceInPercent,
  MaterialBaseUnit,
  UnitOfEntry,
  Currency,
  SlsPriceAmountInCoCodeCrcy,
  PhysInvtryCtAmtInCoCodeCrcy,
  BookQtyAmountInCoCodeCrcy,
  DifferenceAmountInCoCodeCrcy,
  EnteredSlsAmtInCoCodeCrcy,
  IsValueOnlyMaterial,
  MaterialDocument,
  MaterialDocumentYear,
  MaterialDocumentItem,
  CycleCountType,
  NmbrOfPhysInvtryPerFiscalYear,
  PhysInvtryIntvlForCycCounting,
  PhysInvtryFloatTimeCycCounting,
  ReasonForPhysInvtryDifference,
  CrossPlantConfigurableMaterial,
  PhysInvtryDiffIsDistributed,
  PhysicalInventoryItemIsCounted,
  PhysInvtryDifferenceIsPosted,
  PhysInvtryItemIsRecounted,
  PhysInvtryIsCreatedByRecount,
  PhysicalInventoryNumber,
  PhysInvtryDocHasQtySnapshot,
  SalesPriceValuationIsActive,
  SerialNumberProfile,
  ProductType,
  ProductGroup,
  SerialIdentifierAssgmtProfile,
  IsMarkedForDeletion,
  NumberOfPhysInventoryCounts,
  NumberOfPInvAdjustmentsPerYear,
  PInvDiffQtyPerYearInBaseUnit,
  NmbrOfDaysSinceLastPInvCount,
  PhysInvtryItemIsNeverCounted,
  NrOfGdsRcptSinceLastPInvCount,
  GdsRcptQtySinceLastCtInBsUnt,
  AvgStkQtySinceLastCountInBsUnt,
  InvtryTurnoverSinceLastCnt,
  NrOfGoodsIssSinceLastPInvCount,
  GdsIssQtySinceLastCountInBsUnt,
  DiffCountedBookAmtInCoCodeCry
FROM P_PhysInventorySituation
;

Learn More