I_EWM_PInvDocBusKeyItem

DDL: I_EWM_PINVDOCBUSKEYITEM SQL: IEWMPIITBIZ Type: view BASIC Package: VDM_EWM_CORE
51 Fields 1 Data Sources

Bus Keys of Whse Physical Inventory Item

I_EWM_PInvDocBusKeyItem is a Basic CDS View that provides data about "Bus Keys of Whse Physical Inventory Item" in SAP S/4HANA. It reads from 1 data source (/lime/pi_it_biz) and exposes 51 fields with key fields PhysicalInventoryDocumentUUID, PhysicalInventoryItemNumber, LineIndexOfPInvItem, PhysicalInventoryChangeVersion, PInvDocumentItemType. Part of development package VDM_EWM_CORE.

Data Sources (1)

SourceAliasJoin Type
/lime/pi_it_biz /lime/pi_it_biz from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IEWMPIITBIZ 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 Bus Keys of Whse Physical Inventory Item view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view

Fields (51)

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
ProductBatch charg Chargeable Proc.
Batch charg Chargeable Proc.
EWMStockOwner owner Vehicle Owner
StockOwner owner Vehicle Owner
StockOwnerPartnerRole owner_role Partner Role
GlobalTradeItemNumber gtin GTIN
GlobalTradeItemNumberVariant gtin_variant Variant
StockType cat TAL Category
EWMStockType cat TAL Category
EWMStockUsage stock_usage Usage
StockUsage stock_usage Usage
SpecialStockIdfgSalesOrder sales_ord_stock Sales Order
SpecialStockIdfgSalesOrderItem s_ord_item_stock Sales Order Item
InventorySpclStockWBSElement wbs_stock WBS Element
PlanningVersionUUID vrsioid Plng Version
ProducedMaterial apo_matnr APO NaterialNo.
ProductUUID Product ID
BatchUUID batchid Batch
StockDocumentCategory stock_doccat Type
StockDocumentNumber stock_docno Stk Ref. Doc.
StockItemNumber stock_itmno Ref. Doc. Itm
DocumentReltdStockDocCat doccat Document Cat.
EntitledToDisposeParty entitled Party Ent. to Disp.
EntitledToDisposePartnerRole entitled_role Partner Role
CounterForStockSeparation stock_cnt Counter
SerialShippingContainerCode sscc SSCC
HandlingUnitNumber huident HU ID
HandlingUnitIndicator vhi Virtual HU
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
PackagingMaterial hu_pmat Pack. Material
HandlingUnitType hu_type HUTyp

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_PInvDocBusKeyItem.
-- 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: IEWMPIITBIZ

CREATE VIEW I_EWM_PInvDocBusKeyItem AS
SELECT
  guid_doc AS PhysicalInventoryDocumentUUID,
  item_no AS PhysicalInventoryItemNumber,
  line_idx AS LineIndexOfPInvItem,
  change_seq AS PhysicalInventoryChangeVersion,
  item_type AS PInvDocumentItemType,
  charg AS ProductBatch,
  charg AS Batch,
  owner AS EWMStockOwner,
  owner AS StockOwner,
  owner_role AS StockOwnerPartnerRole,
  gtin AS GlobalTradeItemNumber,
  gtin_variant AS GlobalTradeItemNumberVariant,
  cat AS StockType,
  cat AS EWMStockType,
  stock_usage AS EWMStockUsage,
  stock_usage AS StockUsage,
  sales_ord_stock AS SpecialStockIdfgSalesOrder,
  s_ord_item_stock AS SpecialStockIdfgSalesOrderItem,
  wbs_stock AS InventorySpclStockWBSElement,
  vrsioid AS PlanningVersionUUID,
  apo_matnr AS ProducedMaterial,
  cast( matid as matid_no_conv preserving type ) AS ProductUUID,
  batchid AS BatchUUID,
  stock_doccat AS StockDocumentCategory,
  stock_docno AS StockDocumentNumber,
  stock_itmno AS StockItemNumber,
  doccat AS DocumentReltdStockDocCat,
  entitled AS EntitledToDisposeParty,
  entitled_role AS EntitledToDisposePartnerRole,
  stock_cnt AS CounterForStockSeparation,
  sscc AS SerialShippingContainerCode,
  huident AS HandlingUnitNumber,
  vhi AS HandlingUnitIndicator,
  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,
  hu_pmat AS PackagingMaterial,
  hu_type AS HandlingUnitType
FROM /lime/pi_it_biz
;

Learn More