A_WhsePhysInventoryCntItem

DDL: A_WHSEPHYSINVENTORYCNTITEM Type: view_entity COMPOSITE
47 Fields 1 Data Sources 1 OData Services

Warehouse Physical Inventory Count Item

A_WhsePhysInventoryCntItem is a Composite CDS View that provides data about "Warehouse Physical Inventory Count Item" in SAP S/4HANA. It reads from 1 data source (P_EWM_PINVDOCCNTITEM02) and exposes 47 fields with key fields PhysicalInventoryDocumentUUID, PhysicalInventoryItemNumber, LineIndexOfPInvItem, PInvQuantitySequence. It is exposed through 1 OData service (API_WHSE_PHYSINVENTORYITEM).

Data Sources (1)

SourceAliasJoin Type
P_EWM_PINVDOCCNTITEM02 P_EWM_PINVDOCCNTITEM02 from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Warehouse Physical Inventory Count Item view

OData Services (1)

ServiceBindingVersionContractRelease
API_WHSE_PHYSINVENTORYITEM API_WHSE_PHYSINVENTORYITEM V2 C2 Deprecated

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY PhysicalInventoryDocumentUUID PhysicalInventoryDocumentUUID
KEY PhysicalInventoryItemNumber PhysicalInventoryItemNumber
KEY LineIndexOfPInvItem LineIndexOfPInvItem
KEY PInvQuantitySequence PInvQuantitySequence
PhysicalInventoryItemLevel PhysicalInventoryItemLevel
PInvItemParentType PInvItemParentType Parent Item Type
StorageBin StorageBin Storage Bin
StorageType StorageType Storage Type
ParentHandlingUnitNumber ParentHandlingUnitNumber Parent Handling Unit
PhysicalInventoryItemType PhysicalInventoryItemType
HandlingUnitNumber HandlingUnitNumber
Product Product Product Sold
ProductUUID ProductUUID UUID
BatchUUID BatchUUID Target Grp GUID
Batch Batch Batch Number
SerialNumberRequiredLevel SerialNumberRequiredLevel Serial No. Reqm
StockType StockType Stock Type
StockOwner StockOwner Owner of stock
StockOwnerPartnerRole StockOwnerPartnerRole
StockUsage StockUsage
EntitledToDisposeParty EntitledToDisposeParty Disposal Party
EntitledToDisposePartnerRole EntitledToDisposePartnerRole
StockDocumentCategory StockDocumentCategory Special Reference Stock Type
StockDocumentNumber StockDocumentNumber
StockItemNumber StockItemNumber
WBSElementExternalID WBSElementExternalID WBS Element External ID
DocumentReltdStockDocCat DocumentReltdStockDocCat
WhseQualityInspectionType WhseQualityInspectionType
QualityInspectionDocUUID QualityInspectionDocUUID
StockIdentificationNumber StockIdentificationNumber
DocumentReltdStockDocUUID DocumentReltdStockDocUUID
DocumentReltdStockDocItemUUID DocumentReltdStockDocItemUUID
WhseTaskGoodsReceiptDateTime WhseTaskGoodsReceiptDateTime
ShelfLifeExpirationDate ShelfLifeExpirationDate SLED/BBD
CountryOfOrigin CountryOfOrigin Country or Region of Origin
MatlBatchIsInRstrcdUseStock MatlBatchIsInRstrcdUseStock Batch restr.
HndlgUnitItemCountedIsComplete HndlgUnitItemCountedIsComplete
HndlgUnitItemCountedIsEmpty HndlgUnitItemCountedIsEmpty
HndlgUnitItemCountedIsNotExist HndlgUnitItemCountedIsNotExist
PackagingMaterial PackagingMaterial Packaging Materials
HandlingUnitType HandlingUnitType HUTyp
StorageBinIsEmpty StorageBinIsEmpty
PInvIsZeroCount PInvIsZeroCount
RequestedQuantityUnit RequestedQuantityUnit Requested Quantity Unit
RequestedQuantity RequestedQuantity Requested Quantity
PInvItemChgUTCDateTime PInvItemChgUTCDateTime
_WhsePhysicalInventoryItem _WhsePhysicalInventoryItem

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 A_WhsePhysInventoryCntItem.
-- 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.

CREATE VIEW A_WhsePhysInventoryCntItem AS
SELECT
  PhysicalInventoryDocumentUUID,
  PhysicalInventoryItemNumber,
  LineIndexOfPInvItem,
  PInvQuantitySequence,
  PhysicalInventoryItemLevel,
  PInvItemParentType,
  StorageBin,
  StorageType,
  ParentHandlingUnitNumber,
  PhysicalInventoryItemType,
  HandlingUnitNumber,
  Product,
  ProductUUID,
  BatchUUID,
  Batch,
  SerialNumberRequiredLevel,
  StockType,
  StockOwner,
  StockOwnerPartnerRole,
  StockUsage,
  EntitledToDisposeParty,
  EntitledToDisposePartnerRole,
  StockDocumentCategory,
  StockDocumentNumber,
  StockItemNumber,
  WBSElementExternalID,
  DocumentReltdStockDocCat,
  WhseQualityInspectionType,
  QualityInspectionDocUUID,
  StockIdentificationNumber,
  DocumentReltdStockDocUUID,
  DocumentReltdStockDocItemUUID,
  WhseTaskGoodsReceiptDateTime,
  ShelfLifeExpirationDate,
  CountryOfOrigin,
  MatlBatchIsInRstrcdUseStock,
  HndlgUnitItemCountedIsComplete,
  HndlgUnitItemCountedIsEmpty,
  HndlgUnitItemCountedIsNotExist,
  PackagingMaterial,
  HandlingUnitType,
  StorageBinIsEmpty,
  PInvIsZeroCount,
  RequestedQuantityUnit,
  RequestedQuantity,
  PInvItemChgUTCDateTime
FROM P_EWM_PINVDOCCNTITEM02
;

Learn More