C_PhysInventorySituation

DDL: C_PHYSINVENTORYSITUATION SQL: CPHYSINVSITN Type: view CONSUMPTION
91 Fields 1 Data Sources

Phys Inventory Situation Anchor/Trigger

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

Data Sources (1)

SourceAliasJoin Type
I_PhysInventorySituation I_PhysInventorySituation from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CPHYSINVSITN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Phys Inventory Situation Anchor/Trigger view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private false view
VDM.viewType #CONSUMPTION view
ObjectModel.uniqueIdField PhysInvtrySitnID 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.
DiffCountedBookAmtInCoCodeCry DiffCountedBookAmtInCoCodeCry
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
_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 C_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.
-- SQL view name: CPHYSINVSITN

CREATE VIEW C_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,
  DiffCountedBookAmtInCoCodeCry,
  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
FROM I_PhysInventorySituation
;

Learn More