I_EWM_PInvDocBusKeyParent

DDL: I_EWM_PINVDOCBUSKEYPARENT SQL: IEWMPIPARBIZ Type: view BASIC
24 Fields 1 Data Sources

Business Keys of Whse PInv Item Parent

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

Data Sources (1)

SourceAliasJoin Type
/lime/pi_par_biz /lime/pi_par_biz from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IEWMPIPARBIZ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
EndUserText.label Business Keys of Whse PInv Item Parent view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view

Fields (24)

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
LocationPlant werks Receiving Plant
StorageLocation lgort Sublocation
GlobalLocationNumber gln GLN
WarehouseLocationUUID locid Single-Character Flag
WarehouseLocation apo_locno APO Location
BusinessPartner partner With Partner
WarehouseLocationRole partner_role Partner Role
MeansOfTransport motid Mns of Trans.ID
EWMMeansOfTransport Mns of Trans.ID
StorageType lgtyp Storage Type
EWMStorageType lgtyp Storage Type
StorageBin lgpla Storage Bin
EWMStorageBin lgpla Storage Bin
SourceResource rsrc Resource
TranspUnitInternalNumber tu_num Internal TU No.
WarehouseViewForGlobalStocks lgnum_view View
SerialShippingContainerCode sscc SSCC
HandlingUnitNumber huident HU ID
HandlingUnitIndicator vhi Virtual HU

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_PInvDocBusKeyParent.
-- 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: IEWMPIPARBIZ

CREATE VIEW I_EWM_PInvDocBusKeyParent AS
SELECT
  guid_doc AS PhysicalInventoryDocumentUUID,
  item_no AS PhysicalInventoryItemNumber,
  line_idx AS LineIndexOfPInvItem,
  change_seq AS PhysicalInventoryChangeVersion,
  item_type AS PInvDocumentItemType,
  werks AS LocationPlant,
  lgort AS StorageLocation,
  gln AS GlobalLocationNumber,
  locid AS WarehouseLocationUUID,
  apo_locno AS WarehouseLocation,
  partner AS BusinessPartner,
  partner_role AS WarehouseLocationRole,
  motid AS MeansOfTransport,
  cast(motid as /scdl/dl_transmeans_id ) AS EWMMeansOfTransport,
  lgtyp AS StorageType,
  lgtyp AS EWMStorageType,
  lgpla AS StorageBin,
  lgpla AS EWMStorageBin,
  rsrc AS SourceResource,
  tu_num AS TranspUnitInternalNumber,
  lgnum_view AS WarehouseViewForGlobalStocks,
  sscc AS SerialShippingContainerCode,
  huident AS HandlingUnitNumber,
  vhi AS HandlingUnitIndicator
FROM /lime/pi_par_biz
;

Learn More