/SCWM/TWF_PI - Object Persistency: Physical Inventory Document (Workflow)
Object Persistency: Physical Inventory Document (Workflow) information is stored in SAP table /SCWM/TWF_PI.
It is part of development package /SCWM/EXCEPTIONS in software component SCM-EWM-EH. This development package consists of objects that can be grouped under "Exception Handling in the WME".
It is part of development package /SCWM/EXCEPTIONS in software component SCM-EWM-EH. This development package consists of objects that can be grouped under "Exception Handling in the WME".
Fields for table /SCWM/TWF_PI
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | |
GUID | Workflow Object ID | X | /SCWM/DE_WFOBJECT_ID | RAW | 16 | |
START_DATE | Workflow: Start Date | /SCWM/WF_START_DATE | DATS | 16 | ||
START_TIME | Workflow: Start Time | /SCWM/WF_START_TIME | TIMS | 12 | ||
CREUSER | User Name in User Master Record | XUBNAME | CHAR | 24 | ||
WF_STARTED | Actual Start Time (in UTC) | /SCWM/START_TST_ACTUAL | DEC | 8 | ||
WF_ENDED | Actual End Time (in UTC) | /SCWM/END_TST_ACTUAL | DEC | 8 | ||
.INCLUDE | /SCWM/S_RF_INVENTORY_EXCEP | 0 | ||||
DOC_NUMBER | Physical Inventory Document Number | /LIME/PI_DOC_NUMBER | NUMC | 40 | ||
DOC_YEAR | Document Year of Physical Inventory Document | /LIME/PI_DOC_YEAR | NUMC | 8 | ||
ITEM_NO | Item | /LIME/LINE_ITEM_ID | NUMC | 12 | ||
LVL | Level in Tree Hierarchy Observed from Leaf | /LIME/TREE_LEVEL | INT4 | 4 | ||
COUNT_TIMESTAMP | Entered Date of Physical Inventory Count (Time Stamp) | /LIME/PI_COUNT_DATE | DEC | 11 | ||
COUNT_USER | User Name | UNAME | CHAR | 24 | ||
REF_DOC_ID | Document ID of Reference Document | /LIME/REF_DOC_ID | CHAR | 140 | ||
REF_DOC_TYPE | Document Type of Reference Document | /LIME/REF_DOC_TYPE | CHAR | 20 | ||
DOC_TYPE | Physical Inventory Procedure (Document Type of Phys. Inv.) | /LIME/PI_DOCUMENT_TYPE | CHAR | 4 | ||
DOC_STATUS | Physical Inventory Status | /LIME/PI_STATUS | CHAR | 8 | ||
PI_AREA | Physical Inventory Area (GUID) | /LIME/PI_INV_AREA | RAW | 16 | ||
BLOCK_IND | Inventory Blocking Indicator | /LIME/PI_BLOCK_IND | CHAR | 2 | ||
FREEZE_IND | Freeze Book Inventory | /LIME/PI_FREEZE_IND | CHAR | 2 | ||
TIME_BOOK_QUAN_D | Time of Determination of Book Quantity and Serial Numbers | /LIME/PI_TIME_BOOK_QUAN_DETERM | DEC | 11 | ||
REASON_TXT | Description | /SCWM/DE_DESC40 | CHAR | 80 | ||
REASON | Reason for Physical Inventory/Inventory Difference | /LIME/PI_REASON | CHAR | 8 | ||
CLASS_PRIO | Priority Description | /SCWM/PI_PRIORITY_TXT | CHAR | 24 | ||
PRIORITY | Priority of Physical Inventory | /LIME/PI_PRIORITY | NUMC | 2 | ||
WHORD | Warehouse Order Number | /SCWM/DE_RF_WHO | NUMC | 20 | ||
LGNUM | Warehouse Number/Warehouse Complex | /SCWM/LGNUM | CHAR | 8 | ||
LGTYP | Storage Type | /SCWM/LGTYP | CHAR | 8 | ||
LGPLA | Storage Bin | /SCWM/LGPLA | CHAR | 36 | * | |
RSRC | Resource (Means of Transportation or User) | /SCWM/DE_RSRC | CHAR | 36 | ||
HU_PAR | Handling Unit Identification | /SCWM/DE_HUIDENT | CHAR | 40 | ||
HU | Handling Unit Identification | /SCWM/DE_HUIDENT | CHAR | 40 | ||
HU_EMPTY | Item HU Counted as Empty | /LIME/PI_DE_IND_HU_ITEM_EMPTY | CHAR | 2 | ||
HU_COMPLETE | HU Item is Completely Counted | /LIME/PI_DE_IND_HU_ITEM_COMPL | CHAR | 2 | ||
MATNR | APO Material Number | /LIME/APO_MATNR | CHAR | 80 | ||
MATID | Product | /SCWM/DE_MATID | RAW | 16 | ||
MAKTX | Material Description | MAKTX | CHAR | 80 | ||
CHARGID | Batch | /SCWM/DE_BATCHID | RAW | 16 | ||
CHARG | Batch Number | CHARG_D | CHAR | 20 | * | |
OWNER | Owner | /LIME/OWNER | CHAR | 20 | * | |
OWNER_ROLE | Partner Role of Owner | /LIME/OWNER_ROLE | CHAR | 4 | ||
ENTITLED | Party Entitled to Dispose | /SCWM/DE_ENTITLED | CHAR | 20 | * | |
ENTITLED_ROLE | Partner Role of Party Entitled to Dispose | /SCWM/DE_ENTITLED_ROLE | CHAR | 4 | ||
STOCK_USAGE | Stock Usage | /LIME/STOCK_USAGE | CHAR | 2 | ||
CAT | Stock Type | /LIME/STOCK_CATEGORY | CHAR | 4 | ||
GR_DATE | Created On | /SCWM/DE_CREATED_DATE | DATS | 16 | ||
VFDAT | Shelf Life Expiration Date | /SCWM/SLED | DATS | 16 | ||
STOCK_DOCCAT | Type: Sales Order Stock or Project Stock | /SCWM/DE_STOCK_DOCCAT | CHAR | 6 | ||
STOCK_DOCNO | Number of the Sales Order or Project for Special Stock | /SCWM/DE_STOCK_DOCNO | CHAR | 70 | ||
STOCK_ITMNO | Sales Order Item for Sales Order Stock | /SCWM/DE_STOCK_ITMNO | NUMC | 20 | ||
COO | Country/Region of Origin | /SCWM/DE_COO | CHAR | 6 | ||
HAZMAT | Hazardous Substance | /SCMB/DE_HAZMAT | CHAR | 2 | ||
QUAN | Quantity Entered in Physical Inventory | /LIME/PI_ENTERED_QUANTITY | QUAN | 16 | ||
UNIT | Base Unit of Measure | /SCWM/DE_BASE_UOM | UNIT | 6 | * | |
QUAN_SUM | Quantity Entered in Physical Inventory | /LIME/PI_ENTERED_QUANTITY | QUAN | 16 | ||
UNIT_SUM | Base Unit of Measure | /SCWM/DE_BASE_UOM | UNIT | 6 | * | |
IND_ZERO_COUNT | Zero Count Executed | /LIME/PI_ZERO_COUNT_INDICATOR | CHAR | 2 | ||
DOCCAT | Doc. Category for Doc. Reference and Doc.-Related Stock | /SCWM/DE_DOCCAT | CHAR | 6 | ||
DOCNO | Document Number | /SCDL/DL_DOCNO | CHAR | 70 | ||
ITEMNO | Item Number | /SCWM/DE_ITEMNO | NUMC | 20 | ||
IDPLATE | Identification Number of Stock | /SCWM/DE_IDPLATE | CHAR | 40 | ||
EXCCODE | Exception Code | /SCWM/DE_EXCCODE | CHAR | 8 | * | |
.INCLUDE | /SCWM/S_EXCEP_WFCTL_COMMON | 0 | ||||
EXC_BUSCON | Business Context | /SCWM/DE_BUSCON | CHAR | 6 | ||
EXC_TYPEID | Type of Objects in Persistent Object References | SIBFTYPEID | CHAR | 64 | ||
EXEMODE | Control Workflow | /SCWM/DE_EXEMODE | CHAR | 2 |