I_PhysInvtryDocumentItemTP

Purpose
This CDS view provides the prerequisites for answering the following business questions: Which materials in a storage location were counted when, and with which differences? Who performed the count? Who approved the counted differences? How large was the book quantity in the system before the count? If the inventory count of this item had to be re-done, which physical inventory document was used? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role that includes authorization based on at least one of the business catalogs listed above. In this role, the following restriction type must be set to read access: Physical Inventory: Physical Inventory Document in Plant ( M_ISEG_WIB ) These restriction types are edited in the Maintain Business Roles app. Configuration

Structure
Parameters The view does not have any parameters. Fields used for filtering The main filters are as follows: FiscalYear / PhysicalInventoryDocument / PhysicalInventoryDocumentItem used to filter for one specific physical inventory document item Material used to filter for all items of one material PhysicalInventoryItemIsCounted used to find all uncounted items Further important fields Important fields in this view include the following: Field Name Description Comment FiscalYear Fiscal year of the Physical Inventory Document The combination of the fields FiscalYear , PhysicalInventoryDocument and, PhysicalInventoryDocumentItem uniquely identifies a physical inventory document item. PhysicalInventoryDocument Number of the Physical Inventory Document The combination of the fields FiscalYear , PhysicalInventoryDocument and, PhysicalInventoryDocumentItem uniquely identifies a physical inventory document item. PhysicalInventoryDocumentItem Item Number The combination of the fields FiscalYear , PhysicalInventoryDocument and, PhysicalInventoryDocumentItem uniquely identifies a physical inventory document item. Material Material Plant Plant StorageLocation Storage Location Batch Batch Number InventorySpecialStockType Special Stock Indicator Allowed values: B - Customer Stock C - SC Customer Stock E - Orders on Hand F - SC Customer Order Stock I - SC RTP J - SC Vendor Consignment K - Supplier Consignment M - Ret.Trans.Pkg Vendor O - Subcontracting Stock Q - Project Stock R - SC Project Stock V - Ret. Pkg W. Customer W - Customer Consignment Y - Shipping Unit (Warehouse) Not allowed values: P - Pipeline Material T - Stock in Transit PhysicalInventoryStockType Stock Type (Physical Inventory) Allowed values: 1 - (Un)restricted 2 - Quality Inspection 4 - Blocked SalesOrder Sales Order Number SalesOrderItem Item Number in Sales Order ScheduleLine Delivery Schedule for Sales Order Supplier Vendor Account Number Customer Account Number of Customer StockOwner Owner of Stock LastChangedByUser User Name Name of the user who last changed this physical inventory item. LastChangeDate Last Change Timestamp CountedByUser User Name Name of the user who last entered the count results for this physical inventory item. PhysicalInventoryLastCountDate Date of Last Count Specifies the date of the last physical inventory count. AdjustmentPostingMadeByUser Adjustment Posting Made By Name of the user who made the adjustment posting. PostingDate Posting Date PhysInventoryReferenceNumber Reference Number for Physical Inventory PhysicalInventoryItemIsCounted Item has been counted PhysInvtryDifferenceIsPosted Difference has been posted PhysInvtryItemIsRecounted Item will be recounted PhysInvtryItemIsDeleted Item is Deleted