/LIME/PI_DOC_IT - Table of Physical Inventory Document Items

Table of Physical Inventory Document Items information is stored in SAP table /LIME/PI_DOC_IT.
It is part of development package /LIME/PI_CORE in software component SCM-ECT-LIM-INV. This development package consists of objects that can be grouped under "Physical Inventory Core".

Fields for table /LIME/PI_DOC_IT

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
GUID_DOC	GUID for Physical Inventory Document	X	/LIME/PI_GUID_DOC	RAW	16
ITEM_NO	Item	X	/LIME/LINE_ITEM_ID	NUMC	12
LINE_IDX	Row Index of Internal Tables	X	SYTABIX	INT4	4
CHANGE_SEQ	Change Version	X	/LIME/PI_DE_CHANGE_SEQ	INT4	4
ITEM_TYPE	Line Category of Physical Inventory Document Item	X	/LIME/PI_LINE_TYPE	CHAR	4
ITEM_GROUP	Item Group		/LIME/LINE_ITEM_GROUP	NUMC	12
LVL	Level in Tree Hierarchy Observed from Leaf		/LIME/TREE_LEVEL	INT4	4
DOC_TYPE	Physical Inventory Procedure (Document Type of Phys. Inv.)		/LIME/PI_DOCUMENT_TYPE	CHAR	4	/LIME/PI_DOCTYPE
DOC_STATUS	Physical Inventory Status		/LIME/PI_STATUS	CHAR	8
COUNT_DATE	Entered Date of Physical Inventory Count (Time Stamp)		/LIME/PI_COUNT_DATE	DEC	11
COUNT_USER	User Name		UNAME	CHAR	24
COUNT_REFERENCE	Count Reference		/LIME/PI_DE_COUNT_REFERENCE	CHAR	70
CREATE_DATE	Creation Date of Physical Inventory Doc. Item (Time Stamp)		/LIME/PI_CREATE_DATE	DEC	11
POST_DATE	Posting Date of Physical Inventory Document Item (Timestamp)		/LIME/PI_POST_DATE	DEC	11
DIF_DIRECTION	Direction of Movement (In/Out)		/LIME/PI_DE_DIRECTION	CHAR	2
POST_ITEM	Post Physical Inventory Document Item		/LIME/PI_IND_POST	CHAR	2
.INCLUDE	PI_GTI			/LIME/PI_GTI	0
GUID_ITEM	Globally Unique Identifier		GUID	RAW	16
TYPE_ITEM	Object Category of Physical Inventory (Item Object)		/LIME/PI_TYPE_ITEM	CHAR	2
IDX_ITEM	Current Nummer of Key Table		/LIME/KEY_INDEX	CHAR	6
GUID_PARENT	Parent GUID		/LIME/GUID_PARENT	RAW	16
TYPE_PARENT	Object Category of Physical Inventory (Parent Object)		/LIME/PI_TYPE_PARENT	CHAR	2
IDX_PARENT	Current Nummer of Key Table		/LIME/KEY_INDEX	CHAR	6
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
VSI_ITEM	Virtual Stock Indicator		/LIME/VSI	CHAR	2
PRIORITY	Priority of Physical Inventory		/LIME/PI_PRIORITY	NUMC	2
ITEM_NEW_IND	Additional New Item Found		/LIME/PI_ITEM_NEW_IND	CHAR	2
IND_PRINTED	Status: Physical Inventory Document Item Already Printed Out		/LIME/PI_DE_PRINTED	CHAR	2
ORDER_SEQ	Sequence of Physical Inventory Document Items		/LIME/PI_DE_ORDER_SEQ	FLTP	8
LINE_GUID	Globally Unique Identifier		GUID	RAW	16
.INCLUDE	PI_ATTRIBUTES			/LIME/PI_ATTRIBUTES	0
IND_HU_ITEM_COMP	HU Item is Completely Counted		/LIME/PI_DE_IND_HU_ITEM_COMPL	CHAR	2
IND_LOC_PAR_COMP	Parent Location Completely Counted		/LIME/PI_DE_IND_LOC_PAR_COMPL	CHAR	2
IND_LOC_PAR_EMPT	Parent Location Counted as Empty		/LIME/PI_DE_IND_LOC_PAR_EMPTY	CHAR	2
IND_HU_ITEM_EMPT	Item HU Counted as Empty		/LIME/PI_DE_IND_HU_ITEM_EMPTY	CHAR	2
IND_HU_ITEM_NOEX	Item HU Does Not Exist		/LIME/PI_DE_IND_HU_ITEM_NOEX	CHAR	2
IND_ITEM_CHECKED	Result of Storage Bin Check		/LIME/PI_DE_ITEM_CHECKED	CHAR	2
IND_ADD_IT_CHECK	Additional Item Found in Check Procedure		/LIME/PI_DE_ADD_ITEM_CHECK	CHAR	2
REASON	Reason for Physical Inventory/Inventory Difference		/LIME/PI_REASON	CHAR	8
.INCLUDE	APPEND_OBJECT_SEPARATING			/LIME/PI_ATTRIBUTES_APPEND_SEP	0
HOLD_INCLUDE	Single-Character Flag		CHAR1	CHAR	2
.INCLU--AP				/SCWM/PI_ATTRIBUTES_SEPARATING	0
.INCLUDE				/SCWM/S_QUAN_STOCK2	0
INSPTYP	Inspection ID Type		/SCWM/DE_INSPIDTYP	CHAR	2
INSPID	Identification of a Quality Object		/SCWM/DE_INSPID	RAW	16
IDPLATE	Identification Number of Stock		/SCWM/DE_IDPLATE	CHAR	40
QDOCCAT	Doc. Category for Doc. Reference and Doc.-Related Stock		/SCWM/DE_DOCCAT	CHAR	6
QDOCID	Doc. Identification for Document-Related Stocks		/SCWM/DE_DOCID	RAW	16
QITMID	Document Item for Document-Related Stocks		/SCWM/DE_ITMID	RAW	16
.INCLUDE	APPEND_OBJECT_INFO			/LIME/PI_ATTRIBUTES_APPEND_INF	0
HOLD_INCLUDE_INF	Single-Character Flag		CHAR1	CHAR	2
.INCLU--AP				/SCWM/PI_ATTRIBUTES_INF	0
.INCLUDE				/SCWM/S_QUAN_STOCK1	0
WDATU	Goods Receipt Date		/SCWM/DE_WDATU	DEC	8
VFDAT	Shelf Life Expiration Date		/SCWM/SLED	DATS	16
COO	Country/Region of Origin		/SCWM/DE_COO	CHAR	6
BRESTR	Batch in Restricted-Use Stock		/SCMB/MDL_DZUSTD	CHAR	2
EXCCODE	Exception Code		/SCWM/DE_EXCCODE	CHAR	8	*
IPRCODE	Internal Process Code		/SCWM/DE_IPRCODE	CHAR	8
_DATAAGING	Data Filter Value for Data Aging		DATA_TEMPERATURE	DATS	16