C_PhysInvtryDocItemMngCountTP

DDL: C_PHYSINVTRYDOCITEMMNGCOUNTTP Type: view_entity CONSUMPTION
82 Fields 1 Data Sources 1 OData Services

C_PhysInvtryDocItemMngCountTP is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (R_PhysInvtryDocumentItemTP) and exposes 82 fields with key fields FiscalYear, PhysicalInventoryDocument, PhysicalInventoryDocumentItem. It is exposed through 1 OData service (UI_PI_MANAGE_COUNT).

Data Sources (1)

SourceAliasJoin Type
R_PhysInvtryDocumentItemTP R_PhysInvtryDocumentItemTP projection

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

OData Services (1)

ServiceBindingVersionContractRelease
UI_PI_MANAGE_COUNT UI_PI_MANAGE_COUNT_V2 V2 C1 NOT_RELEASED

Fields (82)

KeyFieldSource TableSource FieldDescription
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY PhysicalInventoryDocument PhysicalInventoryDocument Physical Inventory Document
KEY PhysicalInventoryDocumentItem PhysicalInventoryDocumentItem Physical Inventory Document Item
Material Material Vehicle Model
ProductNameasProductNamelocalized
Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
StorageLocation StorageLocation StorageLocation
ValuationType ValuationType Valuation Type
StorageLocationName _StorageLocation StorageLocationName Storage Loc. Name
WarehouseStorageBin _ProductStorageLocation WarehouseStorageBin Storage Bin
Batch Batch Lot No.
InventorySpecialStockType InventorySpecialStockType Special Stock Type
PhysicalInventoryStockType PhysicalInventoryStockType Stock Type
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
ScheduleLine ScheduleLine Schedule Line
Supplier Supplier Supplier
SupplierName _Supplier SupplierName Supplier Name
Customer Customer Sold-to Party
CustomerName _Customer CustomerName Name of Customer
StockOwner StockOwner Owner of stock
LastChangedByUser LastChangedByUser User Name
LastChangedByUserDescription _LastChangedByUser UserDescription Full Name
LastChangeDate LastChangeDate Time Stamp
CountedByUser CountedByUser Counted By
CountedByUserDescription _CountedByUser UserDescription Full Name
PhysicalInventoryLastCountDate PhysicalInventoryLastCountDate Count Date
AdjustmentPostingMadeByUser AdjustmentPostingMadeByUser Adjustment Posting Made By
AdjmtPostingMadeByUserDesc _AdjustmentPostingMadeByUser UserDescription Full Name
PostingDate PostingDate Posting Date for GR
PhysicalInventoryItemIsCounted PhysicalInventoryItemIsCounted Is Counted
PhysInvtryDifferenceIsPosted PhysInvtryDifferenceIsPosted Is Difference Posted
PhysInvtryItemIsRecounted PhysInvtryItemIsRecounted Is Recounted
PhysInvtryItemIsDeleted PhysInvtryItemIsDeleted Is Deleted
IsHandledInAltvUnitOfMsr IsHandledInAltvUnitOfMsr Without Unit of Measure Proposal
PhysicalInventoryItemIsZero PhysicalInventoryItemIsZero Zero Counted
Quantity Quantity Value
MaterialBaseUnit MaterialBaseUnit Valuation Unit
QuantityInUnitOfEntry QuantityInUnitOfEntry Quantity in UnE
UnitOfEntry UnitOfEntry Unit of Entry
MaterialDocumentYear MaterialDocumentYear Material Document Year
MaterialDocument MaterialDocument Material Doc.
MaterialDocumentItem MaterialDocumentItem Material Document Item
PhysInvtryRecountDocument PhysInvtryRecountDocument Recount Doc.
Currency Currency Valuation Crcy
CycleCountType CycleCountType Cycle Count Type
WBSElementInternalID WBSElementInternalID WBS Element
WBSDescription _WBSElement WBSDescription WBS Element Name
PhysInvtryCtAmtInCoCodeCrcy PhysInvtryCtAmtInCoCodeCrcy Counted Quantity Value
ProductCategory ProductCategory Prod Category
ReasonForPhysInvtryDifference ReasonForPhysInvtryDifference Difference Reason
CrossPlantConfigurableMaterial CrossPlantConfigurableMaterial Cross-Plant Configurable Material
PhysInvtryDiffIsDistributed PhysInvtryDiffIsDistributed Difference Distributed
char16
virtualUICT_Batchboolean
_CrossPlantConfigurableMatl _CrossPlantConfigurableMatl
_CrossPlantConfigurableProd _CrossPlantConfigurableProd
_Currency _Currency
_Customer _Customer
_CustomerCompanyByPlant _CustomerCompanyByPlant
_InventorySpecialStockType _InventorySpecialStockType
_Material _Material
_MaterialBaseUnit _MaterialBaseUnit
_PhysicalInventoryStockType _PhysicalInventoryStockType
_PhysInvtryDocFiscalYear _PhysInvtryDocFiscalYear
_PhysInvtryDocHeader _PhysInvtryDocHeader
_PhysInvtryStatusT _PhysInvtryStatusT
_Plant _Plant
_Product _Product
_ProductCategory _ProductCategory
_SalesOrder _SalesOrder
_SalesOrderItem _SalesOrderItem
_SalesOrderScheduleLine _SalesOrderScheduleLine
_StorageLocation _StorageLocation
_Supplier _Supplier
_SupplierCompanyByPlant _SupplierCompanyByPlant
_UnitOfEntry _UnitOfEntry
_WBSElement _WBSElement
_ProductPlant _ProductPlant
_ProductPlantBasic _ProductPlantBasic
_Batch _Batch

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 C_PhysInvtryDocItemMngCountTP.
-- 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 C_PhysInvtryDocItemMngCountTP AS
SELECT
  FiscalYear,
  PhysicalInventoryDocument,
  PhysicalInventoryDocumentItem,
  Material,
  _Product._Text.ProductName as ProductName : localized AS ProductNameasProductNamelocalized,
  Plant,
  _Plant.PlantName AS PlantName,
  StorageLocation,
  ValuationType,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  _ProductStorageLocation.WarehouseStorageBin AS WarehouseStorageBin,
  Batch,
  InventorySpecialStockType,
  PhysicalInventoryStockType,
  SalesOrder,
  SalesOrderItem,
  ScheduleLine,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  Customer,
  _Customer.CustomerName AS CustomerName,
  StockOwner,
  LastChangedByUser,
  _LastChangedByUser.UserDescription AS LastChangedByUserDescription,
  LastChangeDate,
  CountedByUser,
  _CountedByUser.UserDescription AS CountedByUserDescription,
  PhysicalInventoryLastCountDate,
  AdjustmentPostingMadeByUser,
  _AdjustmentPostingMadeByUser.UserDescription AS AdjmtPostingMadeByUserDesc,
  PostingDate,
  PhysicalInventoryItemIsCounted,
  PhysInvtryDifferenceIsPosted,
  PhysInvtryItemIsRecounted,
  PhysInvtryItemIsDeleted,
  IsHandledInAltvUnitOfMsr,
  PhysicalInventoryItemIsZero,
  Quantity,
  MaterialBaseUnit,
  QuantityInUnitOfEntry,
  UnitOfEntry,
  MaterialDocumentYear,
  MaterialDocument,
  MaterialDocumentItem,
  PhysInvtryRecountDocument,
  Currency,
  CycleCountType,
  WBSElementInternalID,
  _WBSElement.WBSDescription AS WBSDescription,
  PhysInvtryCtAmtInCoCodeCrcy,
  ProductCategory,
  ReasonForPhysInvtryDifference,
  CrossPlantConfigurableMaterial,
  PhysInvtryDiffIsDistributed,
  virtual UICT_PhysInvtryDocFiscalYear : abap.char( 16 ) AS char16,
  virtual UICT_Batch : boolean AS virtualUICT_Batchboolean
FROM R_PhysInvtryDocumentItemTP
;

Learn More