- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
P_PhysInvtryProposal
Proposals for new PI documents
| view: P_PIPROPOSAL
| Extraction:
Not supported
| Component: Physical Inventory
Tables used:
MATDOC, ISEG, VBAP, PRTE, MATDOC_EXTRACT, FMLT_PRICE, CKMLCR, MARA, MCHA, T001, TKA02, FINSC_LEDGER, FINSC_LEDGER_T, MAKT, CKMLHD, T001K, MCHB, T001W, PROJ, PRPS, /SAPSLL/CLSNR, /SAPSLL/MARITC, /SAPSLL/NOSCA, MARC, MARD, FINSC_CURTYPE, CKMLPR, FINSC_CURTYPET, MARV, FINSC_VALSUBTYPT, FINSC_VALUTYPT, T150, T159C, FINSC_ACTVE_APPL, /SAPSLL/TUNOS, FINSC_FISC_DATE, FMLC_TOGGLE, FMLT_CURTP_ML
| Column Name | Description | |
|---|---|---|
| Plant | Plant | |
| StorageLocation | Storage Location | |
| Material | Material Number | |
| Batch | Batch Number | |
| Supplier | Vendor's account number | |
| SalesOrder | Sales Order Number | |
| SalesOrderItem | Item Number in Sales Order | |
| WBSElement | Work Breakdown Structure Element (WBS Element) | |
| Customer | Account number of customer | |
| StockOwner | Owner of Stock | |
| InventoryStockType | Stock Type of Goods Movement (Stock Identifier) | Show values |
| InventorySpecialStockType | Special Stock Type | |
| MaterialBaseUnit | Base Unit of Measure |
| Column Name | Description | |
|---|---|---|
| 💲 Currency Key (CompanyCodeCurrency): | ||
| InventoryPrice | Physical Inventory Inventory Price | |
| Column Name | Description | |
|---|---|---|
| 📏 Base Unit of Measure (MaterialBaseUnit): | ||
| MatlWrhsStkQtyInMatlBaseUnit | Current Book Quantity | |
| PInvDiffQtyPerYearInBaseUnit | Adjusted Quantity Last 12 Months | |
| GdsRcptQtySinceLastCtInBsUnt | Received Quantity Since Last Count | |
| AvgStkQtySinceLastCountInBsUnt | Average Book Quantity | |
| GdsIssQtySinceLastCountInBsUnt | Issued Quantity Since Last Count | |
| Column Name | Description | |
|---|---|---|
| CreationDateMaterial | Created On | |
| CreationDateBatch | Created On | |
| PhysicalInventoryLastCountDate | Physical Inventory Last Count Date |
| Column Name | Description | |
|---|---|---|
| InventoryStockType | Stock Type of Goods Movement (Stock Identifier) | Show values |
| IsBatchManagementRequired | Batch Management Requirement Indicator for Plant | Show values |
| IsMarkedForDeletion | Flag Material for Deletion at Plant Level | Show values |
| PhysicalInventoryItemIsCounted | Item has been counted | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| CycleCountType | Physical Inventory Indicator for Cycle Counting | ABCIN | |
| NmbrOfPhysInvtryPerFiscalYear | No. of Phys. Inventories per Fiscal Year for Cycle Counting | NUM3 | |
| PhysInvtryIntvlForCycCounting | Physical Inventory Interval (in Workdays) for Cycle Counting | NUM3 | |
| PhysInvtryFloatTimeCycCounting | Float Time (in Workdays) for Cycle Counting | NUM2 | |
| WBSElementInternalID | Valuated Sales Order Stock WBS Element | PS_POSNR | |
| MaterialPhysInvtryInd | null | ||
| MaterialPhysInvtryIndPrev | null | ||
| BatchPhysInvtryInd | null | ||
| BatchPhysInvtryIndPrev | null | ||
| MaterialName | Material Description | TEXT40 | |
| ProductType | null | ||
| ProductGroup | null | ||
| WarehouseStorageBin | Storage Bin | CHAR10 | |
| MaterialPriceUnitQty | Price Unit | PACK3 | |
| NumberOfPhysInventoryCounts | Number of PI Counts in the current Fiscal Year | ||
| NumberOfPInvAdjustmentsPerYear | Count Adjustments Last 12 Months | ||
| NmbrOfDaysSinceLastPInvCount | null | ||
| NrOfGdsRcptSinceLastPInvCount | Goods Receipts Since Last Count | ||
| InvtryTurnoverSinceLastCnt | Turnover Since Last Count | ||
| NrOfGoodsIssSinceLastPInvCount | Goods Issues Since Last Count |
| Master Data Relations | Join Conditions |
|---|---|
Currency Key
| |
| Calendar ID | P_PHYSINVTRYPROPOSAL.FACTORYCALENDAR == TFACD.IDENT |
Serial Number Profile
|