I_EWM_PInvDocBusItemQty

DDL: I_EWM_PINVDOCBUSITEMQTY SQL: IEWMPIDOCTB Type: view BASIC
14 Fields 1 Data Sources

Business Item Quantity of Whse PInv

I_EWM_PInvDocBusItemQty is a Basic CDS View that provides data about "Business Item Quantity of Whse PInv" in SAP S/4HANA. It reads from 1 data source (/lime/pi_doc_tb) and exposes 14 fields with key fields PhysicalInventoryDocumentUUID, PhysicalInventoryItemNumber, LineIndexOfPInvItem, PhysicalInventoryChangeVersion, PInvDocumentItemType.

Data Sources (1)

SourceAliasJoin Type
/lime/pi_doc_tb /lime/pi_doc_tb from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IEWMPIDOCTB view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
EndUserText.label Business Item Quantity of Whse PInv view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY PhysicalInventoryDocumentUUID guid_doc GUID
KEY PhysicalInventoryItemNumber item_no Sort No.
KEY LineIndexOfPInvItem line_idx Table Row
KEY PhysicalInventoryChangeVersion change_seq Version
KEY PInvDocumentItemType item_type Type
KEY PInvQuantityDocStatus qan_doc_status Quantity Status
KEY PInvQuantitySequence quan_seq Table Row
KEY UnitOfMeasure unit UoM
QuantityOfPInvItemInBaseUoM quantity Value
EnteredQuantityOfPInvItem entered_quantity Qty Entered
EnteredUoMOfPInv entered_unit UoM Entered
PInvIsZeroCount ind_zero_count Zero Count
PInvIsNotCount ind_not_count Do Not Enter
_UnitOfMeasure _UnitOfMeasure

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_PInvDocBusItemQty.
-- 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: IEWMPIDOCTB

CREATE VIEW I_EWM_PInvDocBusItemQty AS
SELECT
  guid_doc AS PhysicalInventoryDocumentUUID,
  item_no AS PhysicalInventoryItemNumber,
  line_idx AS LineIndexOfPInvItem,
  change_seq AS PhysicalInventoryChangeVersion,
  item_type AS PInvDocumentItemType,
  qan_doc_status AS PInvQuantityDocStatus,
  quan_seq AS PInvQuantitySequence,
  unit AS UnitOfMeasure,
  quantity AS QuantityOfPInvItemInBaseUoM,
  entered_quantity AS EnteredQuantityOfPInvItem,
  entered_unit AS EnteredUoMOfPInv,
  ind_zero_count AS PInvIsZeroCount,
  ind_not_count AS PInvIsNotCount
FROM /lime/pi_doc_tb
;

Learn More