R_EWM_PhysInventoryCntItemTP

DDL: R_EWM_PHYSINVENTORYCNTITEMTP Type: view_entity TRANSACTIONAL
53 Fields 1 Data Sources 1 Associations

Warehouse PInv. Count Item

R_EWM_PhysInventoryCntItemTP is a Transactional CDS View that provides data about "Warehouse PInv. Count Item" in SAP S/4HANA. It reads from 1 data source (P_EWM_PINVDOCCNTITEM02_2) and exposes 53 fields with key fields EWMWarehouse, PhysicalInventoryDocNumber, PhysicalInventoryDocYear, PhysicalInventoryItemNumber, LineIndexOfPInvItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_EWM_PINVDOCCNTITEM02_2 P_EWM_PINVDOCCNTITEM02_2 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_EWM_WhsePInvSerialNumberTP _WhsePhysicalInventorySrlNmbr

Annotations (9)

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

Fields (53)

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
_WhsePhysicalInventoryItem _WhsePhysicalInventoryItem
_WhsePhysicalInventorySrlNmbr _WhsePhysicalInventorySrlNmbr

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 R_EWM_PhysInventoryCntItemTP.
-- 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 R_EWM_PhysInventoryCntItemTP 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 P_EWM_PINVDOCCNTITEM02_2
LEFT OUTER JOIN R_EWM_WhsePInvSerialNumberTP AS _WhsePhysicalInventorySrlNmbr ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More