P_PhysInvtryKeyFiguresBaseSitn

DDL: P_PHYSINVTRYKEYFIGURESBASESITN Type: view_entity COMPOSITE Package: ODATA_MM_IM_PI_OBJECT_PAGE
16 Fields 5 Data Sources

Basis for calc. of PI Key Figur. for Stck Sep. Comb. Situat.

P_PhysInvtryKeyFiguresBaseSitn is a Composite CDS View that provides data about "Basis for calc. of PI Key Figur. for Stck Sep. Comb. Situat." in SAP S/4HANA. It reads from 5 data sources (I_CompanyCode, I_CompanyCodePeriod, I_Plant, P_PhysIntryValuationArea, P_MappedPhysInvtryItem) and exposes 16 fields with key fields Material, Plant, StorageLocation, Batch, Supplier. Part of development package ODATA_MM_IM_PI_OBJECT_PAGE.

Data Sources (5)

SourceAliasJoin Type
I_CompanyCode _CompanyCode inner
I_CompanyCodePeriod _CurrentPeriod inner
I_Plant _Plant inner
P_PhysIntryValuationArea _ValuationArea inner
P_MappedPhysInvtryItem item from

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_ALLOWED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY Material P_MappedPhysInvtryItem Material Vehicle Model
KEY Plant P_MappedPhysInvtryItem Plant Valuation Area
KEY StorageLocation P_MappedPhysInvtryItem StorageLocation StorageLocation
KEY Batch P_MappedPhysInvtryItem Batch Lot No.
KEY Supplier P_MappedPhysInvtryItem Supplier Supplier
KEY SalesOrder P_MappedPhysInvtryItem SalesOrder SD Document
KEY SalesOrderItem P_MappedPhysInvtryItem SalesOrderItem Sales Order Item
KEY WBSElementInternalID P_MappedPhysInvtryItem WBSElementInternalID WBS Internal ID
KEY Customer P_MappedPhysInvtryItem Customer Sold-to Party
KEY StockOwner P_MappedPhysInvtryItem StockOwner Owner of stock
KEY InventoryStockType P_MappedPhysInvtryItem InventoryStockType Stock Type
KEY InventorySpecialStockType P_MappedPhysInvtryItem InventorySpecialStockType Special Stock Type
KEY MaterialBaseUnit P_MappedPhysInvtryItem MaterialBaseUnit Valuation Unit
PhysicalInventoryLastCountDate
NumberOfPhysInventoryCounts
CurrentDate

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 P_PhysInvtryKeyFiguresBaseSitn.
-- 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 P_PhysInvtryKeyFiguresBaseSitn AS
SELECT
  item.Material AS Material,
  item.Plant AS Plant,
  item.StorageLocation AS StorageLocation,
  item.Batch AS Batch,
  item.Supplier AS Supplier,
  item.SalesOrder AS SalesOrder,
  item.SalesOrderItem AS SalesOrderItem,
  item.WBSElementInternalID AS WBSElementInternalID,
  item.Customer AS Customer,
  item.StockOwner AS StockOwner,
  item.InventoryStockType AS InventoryStockType,
  item.InventorySpecialStockType AS InventorySpecialStockType,
  item.MaterialBaseUnit AS MaterialBaseUnit,
  max(item.PhysicalInventoryLastCountDate) AS PhysicalInventoryLastCountDate,
  sum( case when ( _CurrentPeriod.ProductCurrentFiscalYear = item.FiscalYear and item.PhysicalInventoryItemIsCounted = 'X' ) then 1 else 0 end ) AS NumberOfPhysInventoryCounts,
  $session.system_date AS CurrentDate
FROM P_MappedPhysInvtryItem AS item
INNER JOIN I_Plant AS _Plant ON /* join condition not captured in parsed metadata */
INNER JOIN P_PhysIntryValuationArea AS _ValuationArea ON /* join condition not captured in parsed metadata */
INNER JOIN I_CompanyCode AS _CompanyCode ON /* join condition not captured in parsed metadata */
INNER JOIN I_CompanyCodePeriod AS _CurrentPeriod ON /* join condition not captured in parsed metadata */
;

Learn More