I_EWM_PInvDocItemLogHist

DDL: I_EWM_PINVDOCITEMLOGHIST SQL: IEWMPILOGITEMH Type: view BASIC
10 Fields 1 Data Sources

Log History of Whse Phys Inventory Item

I_EWM_PInvDocItemLogHist is a Basic CDS View that provides data about "Log History of Whse Phys Inventory Item" in SAP S/4HANA. It reads from 1 data source (/lime/pi_loghist) and exposes 10 fields with key fields PhysicalInventoryDocumentUUID, PhysicalInventoryItemNumber, PhysicalInventoryLogType, PhysicalInventoryLogSequence.

Data Sources (1)

SourceAliasJoin Type
/lime/pi_loghist /lime/pi_loghist from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IEWMPILOGITEMH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Log History of Whse Phys Inventory Item view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
AbapCatalog.preserveKey true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PhysicalInventoryDocumentUUID guid_doc GUID
KEY PhysicalInventoryItemNumber item_no Sort No.
KEY PhysicalInventoryLogType log_type Log Entry Cat.
KEY PhysicalInventoryLogSequence log_seq Table Row
PInvLogItemTimeStamp timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
PhysicalInventoryLogByUserName userid User Name
PhysicalInventoryProcessType process_type Type of Data
PhysicalInventoryRefDocNumber ref_doc_id Document No.
PhysicalInventoryRefDocType ref_doc_type Ref. procedure
PInvRefDocLogSystem ref_doc_logsys Logical system

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_PInvDocItemLogHist.
-- 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: IEWMPILOGITEMH

CREATE VIEW I_EWM_PInvDocItemLogHist AS
SELECT
  guid_doc AS PhysicalInventoryDocumentUUID,
  item_no AS PhysicalInventoryItemNumber,
  log_type AS PhysicalInventoryLogType,
  log_seq AS PhysicalInventoryLogSequence,
  timestamp AS PInvLogItemTimeStamp,
  userid AS PhysicalInventoryLogByUserName,
  process_type AS PhysicalInventoryProcessType,
  ref_doc_id AS PhysicalInventoryRefDocNumber,
  ref_doc_type AS PhysicalInventoryRefDocType,
  ref_doc_logsys AS PInvRefDocLogSystem
FROM /lime/pi_loghist
;

Learn More