C_PhysInvtryQuery

DDL: C_PHYSINVTRYQUERY SQL: CPHYSINVTRYQUERY Type: view CONSUMPTION
63 Fields 1 Data Sources

Physical Inventory Analysis

C_PhysInvtryQuery is a Consumption CDS View that provides data about "Physical Inventory Analysis" in SAP S/4HANA. It reads from 1 data source (I_PhysInvtryCube) and exposes 63 fields.

Data Sources (1)

SourceAliasJoin Type
I_PhysInvtryCube PhysicalInventoryCube from

Annotations (13)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName CPHYSINVTRYQUERY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Physical Inventory Analysis view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
OData.publish true view
VDM.private false view
VDM.viewType #CONSUMPTION view
Analytics.query true view

Fields (63)

KeyFieldSource TableSource FieldDescription
FiscalYear FiscalYear G/L Fiscal Year
PhysicalInventoryDocument PhysicalInventoryDocument Physical Inventory Document
PhysicalInventoryDocumentItem PhysicalInventoryDocumentItem Physical Inventory Document Item
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
Material Material Vehicle Model
Batch RealProductBatch
ValuationType ValuationType Valuation Type
InventorySpecialStockType InventorySpecialStockType Special Stock Type
PhysicalInventoryStockType PhysicalInventoryStockType Stock Type
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
ScheduleLine ScheduleLine Schedule Line
Supplier Supplier Supplier
Customer Customer Sold-to Party
WBSElementInternalID WBSElementInternalID WBS Internal ID
PhysicalInventoryItemIsCounted PhysicalInventoryItemIsCounted Is Counted
PhysInvtryDifferenceIsPosted PhysInvtryDifferenceIsPosted Is Difference Posted
PhysInvtryItemIsRecounted PhysInvtryItemIsRecounted Is Recounted
PhysInvtryItemIsDeleted PhysInvtryItemIsDeleted Is Deleted
CycleCountType CycleCountType Cycle Count Type
PhysicalInventoryType PhysicalInventoryType
InventoryTransactionType InventoryTransactionType Trans. Ev. Type
GoodsMovementType GoodsMovementType Movement Type
PostingIsBlockedForPhysInvtry PostingIsBlockedForPhysInvtry Posting Block
PhysInvtryDocHasQtySnapshot PhysInvtryDocHasQtySnapshot Book Inventory Freeze
PhysicalInventoryLastCountDate PhysicalInventoryLastCountDate Count Date
PostingDate PostingDate Posting Date for GR
ReasonForPhysInvtryDifference ReasonForPhysInvtryDifference Difference Reason
DocumentDate DocumentDate Journal Entry Date
LastChangeDate LastChangeDate Time Stamp
PhysInventoryPlannedCountDate PhysInventoryPlannedCountDate Plan.Count date
FiscalPeriod FiscalPeriod Tax period
Currency Currency Valuation Crcy
PhysicalInventoryGroupType PhysicalInventoryGroupType Grouping Type
PhysicalInventoryGroup PhysicalInventoryGroup Grpg Crit.
PhysicalInventoryNumber PhysicalInventoryNumber Physical Inventory Number
PhysicalInventoryDocumentDesc PhysicalInventoryDocumentDesc Description
PhysInventoryReferenceNumber PhysInventoryReferenceNumber Physical Inventory Reference
MaterialDocumentYear MaterialDocumentYear Material Document Year
MaterialDocument MaterialDocument Material Doc.
MaterialDocumentItem MaterialDocumentItem Material Document Item
PhysInvtryRecountDocument PhysInvtryRecountDocument Recount Doc.
IsValueOnlyMaterial IsValueOnlyMaterial Is Value-Only Material
ProductCategory ProductCategory Prod Category
CrossPlantConfigurableMaterial CrossPlantConfigurableMaterial Cross-Plant Configurable Material
SalesPriceValuationIsActive SalesPriceValuationIsActive Is Sales Price Valuation Active
PhysicalInventoryItemIsZero PhysicalInventoryItemIsZero Zero Counted
MaterialBaseUnit MaterialBaseUnit Valuation Unit
UnitOfEntry UnitOfEntry Unit of Entry
BookQtyAmountInCoCodeCrcy BookQtyAmountInCoCodeCrcy Book Value
DifferenceAmountInCoCodeCrcy DifferenceAmountInCoCodeCrcy Difference Val.
NumberOfPhysInvtryItems NumberOfPhysInvtryItems
MaxAbsDiffAmountInCoCodeCrcy MaxAbsDiffAmountInCoCodeCrcy
MinAbsDiffAmountInCoCodeCrcy MinAbsDiffAmountInCoCodeCrcy
PhysInvtryCtAmtInCoCodeCrcy PhysInvtryCtAmtInCoCodeCrcy Counted Quantity Value
BookQtyBfrCountInMatlBaseUnit BookQtyBfrCountInMatlBaseUnit Book Quantity
Quantity Quantity Value
QuantityInUnitOfEntry QuantityInUnitOfEntry Quantity in UnE
DifferenceQuantityInBaseUnit DifferenceQuantityInBaseUnit
SlsPriceAmountInCoCodeCrcy SlsPriceAmountInCoCodeCrcy Sales Price Book Value
EnteredSlsAmtInCoCodeCrcy EnteredSlsAmtInCoCodeCrcy Sales Price Counted Value
DiffSlsPrcAmtInCoCodeCrcy DiffSlsPrcAmtInCoCodeCrcy

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_PhysInvtryQuery.
-- 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: CPHYSINVTRYQUERY

CREATE VIEW C_PhysInvtryQuery AS
SELECT
  FiscalYear,
  PhysicalInventoryDocument,
  PhysicalInventoryDocumentItem,
  Plant,
  StorageLocation,
  Material,
  RealProductBatch AS Batch,
  ValuationType,
  InventorySpecialStockType,
  PhysicalInventoryStockType,
  SalesOrder,
  SalesOrderItem,
  ScheduleLine,
  Supplier,
  Customer,
  WBSElementInternalID,
  PhysicalInventoryItemIsCounted,
  PhysInvtryDifferenceIsPosted,
  PhysInvtryItemIsRecounted,
  PhysInvtryItemIsDeleted,
  CycleCountType,
  PhysicalInventoryType,
  InventoryTransactionType,
  GoodsMovementType,
  PostingIsBlockedForPhysInvtry,
  PhysInvtryDocHasQtySnapshot,
  PhysicalInventoryLastCountDate,
  PostingDate,
  ReasonForPhysInvtryDifference,
  DocumentDate,
  LastChangeDate,
  PhysInventoryPlannedCountDate,
  FiscalPeriod,
  Currency,
  PhysicalInventoryGroupType,
  PhysicalInventoryGroup,
  PhysicalInventoryNumber,
  PhysicalInventoryDocumentDesc,
  PhysInventoryReferenceNumber,
  MaterialDocumentYear,
  MaterialDocument,
  MaterialDocumentItem,
  PhysInvtryRecountDocument,
  IsValueOnlyMaterial,
  ProductCategory,
  CrossPlantConfigurableMaterial,
  SalesPriceValuationIsActive,
  PhysicalInventoryItemIsZero,
  MaterialBaseUnit,
  UnitOfEntry,
  BookQtyAmountInCoCodeCrcy,
  DifferenceAmountInCoCodeCrcy,
  NumberOfPhysInvtryItems,
  MaxAbsDiffAmountInCoCodeCrcy,
  MinAbsDiffAmountInCoCodeCrcy,
  PhysInvtryCtAmtInCoCodeCrcy,
  BookQtyBfrCountInMatlBaseUnit,
  Quantity,
  QuantityInUnitOfEntry,
  DifferenceQuantityInBaseUnit,
  SlsPriceAmountInCoCodeCrcy,
  EnteredSlsAmtInCoCodeCrcy,
  DiffSlsPrcAmtInCoCodeCrcy
FROM I_PhysInvtryCube AS PhysicalInventoryCube
;

Learn More