I_EWM_PhysicalInventoryArea

DDL: I_EWM_PHYSICALINVENTORYAREA SQL: IEWMPICUSTARE Type: view BASIC Package: VDM_EWM_CORE
14 Fields 1 Data Sources

Warehouse Physical Inventory Area

I_EWM_PhysicalInventoryArea is a Basic CDS View that provides data about "Warehouse Physical Inventory Area" in SAP S/4HANA. It reads from 1 data source (/lime/picust_are) and exposes 14 fields with key field PhysicalInventoryArea. Part of development package VDM_EWM_CORE.

Data Sources (1)

SourceAliasJoin Type
/lime/picust_are /lime/picust_are from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IEWMPICUSTARE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Warehouse Physical Inventory Area view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY PhysicalInventoryArea pi_aread Phys. Inv. Area
PhysicalInventoryAreaUUID pi_area Phys. Inv. Area
PhysicalInventoryIsPutAway place_inv Putaway PI
LowStockCheckIsWithPInv lowchk_inv LSPI
LowStockCheckIsWithoutPInv lowcheck LS Check
PostgAftCtEntryIsSimultaneous book_after_count PstgAfterCount
BookQuantityIsDspd display_location Dsplay Quantity
PInvItemObjectsIsDspd display_object Display Objects
PInvHndlgUnitCompleteIsAllowed hu_comp_allowed HU Complete
PInvHndlgUnitCountingMethod hu_cnt_mode HU Counting Method
ItemObjectsInPInvDocIsPrinted print_object Print Obj.
ThresholdOfPInvQuantity quantity_limit Quantity
PInvCompletenessCheckIsOffline compl_offline Completeness Check
SerialNumberInPInvIsDspd display_serid Serial No.

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_EWM_PhysicalInventoryArea.
-- 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: IEWMPICUSTARE

CREATE VIEW I_EWM_PhysicalInventoryArea AS
SELECT
  pi_aread AS PhysicalInventoryArea,
  pi_area AS PhysicalInventoryAreaUUID,
  place_inv AS PhysicalInventoryIsPutAway,
  lowchk_inv AS LowStockCheckIsWithPInv,
  lowcheck AS LowStockCheckIsWithoutPInv,
  book_after_count AS PostgAftCtEntryIsSimultaneous,
  display_location AS BookQuantityIsDspd,
  display_object AS PInvItemObjectsIsDspd,
  hu_comp_allowed AS PInvHndlgUnitCompleteIsAllowed,
  hu_cnt_mode AS PInvHndlgUnitCountingMethod,
  print_object AS ItemObjectsInPInvDocIsPrinted,
  quantity_limit AS ThresholdOfPInvQuantity,
  compl_offline AS PInvCompletenessCheckIsOffline,
  display_serid AS SerialNumberInPInvIsDspd
FROM /lime/picust_are
;

Learn More