A_WhsePhysInventoryCntItem_2

DDL: A_WHSEPHYSINVENTORYCNTITEM_2 Type: view_entity COMPOSITE Package: WME_ODATA_API
51 Fields 1 Data Sources 2 OData Services

Warehouse Physical Inventory Count Item

A_WhsePhysInventoryCntItem_2 is a Composite CDS View that provides data about "Warehouse Physical Inventory Count Item" in SAP S/4HANA. It reads from 1 data source (R_EWM_PhysInventoryCntItemTP) and exposes 51 fields with key fields EWMWarehouse, PhysicalInventoryDocNumber, PhysicalInventoryDocYear, PhysicalInventoryItemNumber, LineIndexOfPInvItem. It is exposed through 2 OData services (API_WHSE_PHYSINVTRYITEM_2, ASQL_F6274). Part of development package WME_ODATA_API.

Data Sources (1)

SourceAliasJoin Type
R_EWM_PhysInventoryCntItemTP R_EWM_PhysInventoryCntItemTP projection

Annotations (10)

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 #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Warehouse Physical Inventory Count Item view
ObjectModel.sapObjectNodeType.name WhsePhysicalInventoryCountItem view

OData Services (2)

ServiceBindingVersionContractRelease
API_WHSE_PHYSINVTRYITEM_2 API_WHSE_PHYSINVTRYITEM_2 V4 C2 C1
ASQL_F6274 ASQL_F6274 C2 NOT_RELEASED

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY EWMWarehouse EWMWarehouse Warehouse No.
KEY PhysicalInventoryDocNumber PhysicalInventoryDocNumber
KEY PhysicalInventoryDocYear PhysicalInventoryDocYear
KEY PhysicalInventoryItemNumber PhysicalInventoryItemNumber
KEY LineIndexOfPInvItem LineIndexOfPInvItem
KEY PInvQuantitySequence PInvQuantitySequence
PhysicalInventoryItemLevel PhysicalInventoryItemLevel
PInvItemParentType PInvItemParentType Parent Item Type
EWMStorageBin EWMStorageBin Storage Bin
EWMStorageType EWMStorageType 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
EWMStockType EWMStockType Stock Type
EWMStockOwner EWMStockOwner Character Field with Length 10
StockOwnerPartnerRole StockOwnerPartnerRole
EWMStockUsage EWMStockUsage Usage
EntitledToDisposeParty EntitledToDisposeParty Disposal Party
EntitledToDisposePartnerRole EntitledToDisposePartnerRole
StockDocumentCategory StockDocumentCategory Special Reference Stock Type
StockDocumentNumber StockDocumentNumber
StockItemNumber StockItemNumber
WBSElementExternalID WBSElementExternalID WBS Element External ID
WBSElementInternalID WBSElementInternalID WBS Internal ID
SpecialStockIdfgSalesOrder SpecialStockIdfgSalesOrder Stock Ident Header
SpecialStockIdfgSalesOrderItem SpecialStockIdfgSalesOrderItem Stock Ident Item
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
EWMStorageBinIsEmpty EWMStorageBinIsEmpty
PInvIsZeroCount PInvIsZeroCount
RequestedQuantityUnit RequestedQuantityUnit Requested Quantity Unit
RequestedQuantity RequestedQuantity Requested Quantity
PInvItemChgUTCDateTime PInvItemChgUTCDateTime

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_2.
-- 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_2 AS
SELECT
  EWMWarehouse,
  PhysicalInventoryDocNumber,
  PhysicalInventoryDocYear,
  PhysicalInventoryItemNumber,
  LineIndexOfPInvItem,
  PInvQuantitySequence,
  PhysicalInventoryItemLevel,
  PInvItemParentType,
  EWMStorageBin,
  EWMStorageType,
  ParentHandlingUnitNumber,
  PhysicalInventoryItemType,
  HandlingUnitNumber,
  Product,
  ProductUUID,
  BatchUUID,
  Batch,
  SerialNumberRequiredLevel,
  EWMStockType,
  EWMStockOwner,
  StockOwnerPartnerRole,
  EWMStockUsage,
  EntitledToDisposeParty,
  EntitledToDisposePartnerRole,
  StockDocumentCategory,
  StockDocumentNumber,
  StockItemNumber,
  WBSElementExternalID,
  WBSElementInternalID,
  SpecialStockIdfgSalesOrder,
  SpecialStockIdfgSalesOrderItem,
  DocumentReltdStockDocCat,
  WhseQualityInspectionType,
  QualityInspectionDocUUID,
  StockIdentificationNumber,
  DocumentReltdStockDocUUID,
  DocumentReltdStockDocItemUUID,
  WhseTaskGoodsReceiptDateTime,
  ShelfLifeExpirationDate,
  CountryOfOrigin,
  MatlBatchIsInRstrcdUseStock,
  HndlgUnitItemCountedIsComplete,
  HndlgUnitItemCountedIsEmpty,
  HndlgUnitItemCountedIsNotExist,
  PackagingMaterial,
  HandlingUnitType,
  EWMStorageBinIsEmpty,
  PInvIsZeroCount,
  RequestedQuantityUnit,
  RequestedQuantity,
  PInvItemChgUTCDateTime
FROM R_EWM_PhysInventoryCntItemTP
;

Learn More