/LIME/PI_DOC_IT
Table of Physical Inventory Document Items
/LIME/PI_DOC_IT is an SAP database table in S/4HANA. Table of Physical Inventory Document Items. It contains 57 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_EWM_PhysicalInventoryDoc | view | from | EXTENSION | Warehouse Physical Inventory - Extension |
| I_EWM_PhysicalInventoryDocItem | view_entity | from | BASIC | Whse Physical Inventory Document Items |
Fields (57)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | guid_doc | /LIME/PI_GUID_DOC | GUID | |||
| KEY | item_no | /LIME/LINE_ITEM_ID | Item | |||
| KEY | line_idx | SYTABIX | Table Row | |||
| KEY | change_seq | /LIME/PI_DE_CHANGE_SEQ | Version | |||
| KEY | item_type | /LIME/PI_LINE_TYPE | Line Category | |||
| item_group | /LIME/LINE_ITEM_GROUP | Item Group | ||||
| lvl | /LIME/TREE_LEVEL | Level in Tree | ||||
| doc_type | /LIME/PI_DOCUMENT_TYPE | Phys. Inv. Procedure | ||||
| doc_status | /LIME/PI_STATUS | PI Status | ||||
| count_date | /LIME/PI_COUNT_DATE | Count Date PhysInv | ||||
| count_user | UNAME | User Name | ||||
| count_reference | /LIME/PI_DE_COUNT_REFERENCE | Count Reference | ||||
| create_date | /LIME/PI_CREATE_DATE | Creation Date | ||||
| post_date | /LIME/PI_POST_DATE | Posting Date | ||||
| dif_direction | /LIME/PI_DE_DIRECTION | Movement Dir. | ||||
| post_item | /LIME/PI_IND_POST | Post | ||||
| guid_item | GUID | GUID | ||||
| type_item | /LIME/PI_TYPE_ITEM | Category Item | ||||
| idx_item | /LIME/KEY_INDEX | Key Table | ||||
| guid_parent | /LIME/GUID_PARENT | Parent | ||||
| type_parent | /LIME/PI_TYPE_PARENT | Cat. Par. Obj. | ||||
| idx_parent | /LIME/KEY_INDEX | Key Table | ||||
| pi_area | /LIME/PI_INV_AREA | Phys. Inv. Area | ||||
| block_ind | /LIME/PI_BLOCK_IND | Blocking Indic. | ||||
| freeze_ind | /LIME/PI_FREEZE_IND | Freeze Book Inv. | ||||
| time_book_quan_d | /LIME/PI_TIME_BOOK_QUAN_DETERM | Time Book Quantity | ||||
| vsi_item | /LIME/VSI | VSI | ||||
| priority | /LIME/PI_PRIORITY | Phys. Inv. Prior. | ||||
| item_new_ind | /LIME/PI_ITEM_NEW_IND | New Item | ||||
| ind_printed | /LIME/PI_DE_PRINTED | |||||
| order_seq | /LIME/PI_DE_ORDER_SEQ | Sequence | ||||
| line_guid | GUID | GUID | ||||
| ind_hu_item_comp | /LIME/PI_DE_IND_HU_ITEM_COMPL | HU Compl. Cntd | ||||
| ind_loc_par_comp | /LIME/PI_DE_IND_LOC_PAR_COMPL | Loc. Complete | ||||
| ind_loc_par_empt | /LIME/PI_DE_IND_LOC_PAR_EMPTY | Location Empty | ||||
| ind_hu_item_empt | /LIME/PI_DE_IND_HU_ITEM_EMPTY | HU Empty | ||||
| ind_hu_item_noex | /LIME/PI_DE_IND_HU_ITEM_NOEX | No HU | ||||
| ind_item_checked | /LIME/PI_DE_ITEM_CHECKED | SB Check Result | ||||
| ind_add_it_check | /LIME/PI_DE_ADD_ITEM_CHECK | Additional Item | ||||
| reason | /LIME/PI_REASON | Reason f. Phys. Inv. | ||||
| insptyp | /SCWM/DE_INSPIDTYP | Insp. ID Type | ||||
| inspid | /SCWM/DE_INSPID | Inspection Obj. | ||||
| idplate | /SCWM/DE_IDPLATE | Stock ID | ||||
| qdoccat | /SCWM/DE_DOCCAT | Document Cat. | ||||
| qdocid | /SCWM/DE_DOCID | Document ID | ||||
| qitmid | /SCWM/DE_ITMID | Item | ||||
| hold_include_inf | CHAR1 | Single-Character Flag | ||||
| wdatu | /SCWM/DE_WDATU | GR Date | ||||
| vfdat | /SCWM/SLED | Expiration Date | ||||
| coo | /SCWM/DE_COO | C/R of Orig. | ||||
| brestr | /SCMB/MDL_DZUSTD | Restricted-use | ||||
| stk_seg_long | /SCWM/DE_STK_SEG_LONG | Stock Segment | ||||
| exccode | /SCWM/DE_EXCCODE | Exception Code | ||||
| iprcode | /SCWM/DE_IPRCODE | Int. Proc. Code | ||||
| _dataaging | DATA_TEMPERATURE | Data Aging | ||||
| pi_dummy | DUMMY | Dummy function in length 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Table of Physical Inventory Document Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /LIME/PI_DOC_IT (
MANDT, -- Client [MANDT]
GUID_DOC, -- GUID [/LIME/PI_GUID_DOC]
ITEM_NO, -- Item [/LIME/LINE_ITEM_ID]
LINE_IDX, -- Table Row [SYTABIX]
CHANGE_SEQ, -- Version [/LIME/PI_DE_CHANGE_SEQ]
ITEM_TYPE, -- Line Category [/LIME/PI_LINE_TYPE]
ITEM_GROUP, -- Item Group [/LIME/LINE_ITEM_GROUP]
LVL, -- Level in Tree [/LIME/TREE_LEVEL]
DOC_TYPE, -- Phys. Inv. Procedure [/LIME/PI_DOCUMENT_TYPE]
DOC_STATUS, -- PI Status [/LIME/PI_STATUS]
COUNT_DATE, -- Count Date PhysInv [/LIME/PI_COUNT_DATE]
COUNT_USER, -- User Name [UNAME]
COUNT_REFERENCE, -- Count Reference [/LIME/PI_DE_COUNT_REFERENCE]
CREATE_DATE, -- Creation Date [/LIME/PI_CREATE_DATE]
POST_DATE, -- Posting Date [/LIME/PI_POST_DATE]
DIF_DIRECTION, -- Movement Dir. [/LIME/PI_DE_DIRECTION]
POST_ITEM, -- Post [/LIME/PI_IND_POST]
GUID_ITEM, -- GUID [GUID]
TYPE_ITEM, -- Category Item [/LIME/PI_TYPE_ITEM]
IDX_ITEM, -- Key Table [/LIME/KEY_INDEX]
GUID_PARENT, -- Parent [/LIME/GUID_PARENT]
TYPE_PARENT, -- Cat. Par. Obj. [/LIME/PI_TYPE_PARENT]
IDX_PARENT, -- Key Table [/LIME/KEY_INDEX]
PI_AREA, -- Phys. Inv. Area [/LIME/PI_INV_AREA]
BLOCK_IND, -- Blocking Indic. [/LIME/PI_BLOCK_IND]
FREEZE_IND, -- Freeze Book Inv. [/LIME/PI_FREEZE_IND]
TIME_BOOK_QUAN_D, -- Time Book Quantity [/LIME/PI_TIME_BOOK_QUAN_DETERM]
VSI_ITEM, -- VSI [/LIME/VSI]
PRIORITY, -- Phys. Inv. Prior. [/LIME/PI_PRIORITY]
ITEM_NEW_IND, -- New Item [/LIME/PI_ITEM_NEW_IND]
IND_PRINTED, -- Print [/LIME/PI_DE_PRINTED]
ORDER_SEQ, -- Sequence [/LIME/PI_DE_ORDER_SEQ]
LINE_GUID, -- GUID [GUID]
IND_HU_ITEM_COMP, -- HU Compl. Cntd [/LIME/PI_DE_IND_HU_ITEM_COMPL]
IND_LOC_PAR_COMP, -- Loc. Complete [/LIME/PI_DE_IND_LOC_PAR_COMPL]
IND_LOC_PAR_EMPT, -- Location Empty [/LIME/PI_DE_IND_LOC_PAR_EMPTY]
IND_HU_ITEM_EMPT, -- HU Empty [/LIME/PI_DE_IND_HU_ITEM_EMPTY]
IND_HU_ITEM_NOEX, -- No HU [/LIME/PI_DE_IND_HU_ITEM_NOEX]
IND_ITEM_CHECKED, -- SB Check Result [/LIME/PI_DE_ITEM_CHECKED]
IND_ADD_IT_CHECK, -- Additional Item [/LIME/PI_DE_ADD_ITEM_CHECK]
REASON, -- Reason f. Phys. Inv. [/LIME/PI_REASON]
INSPTYP, -- Insp. ID Type [/SCWM/DE_INSPIDTYP]
INSPID, -- Inspection Obj. [/SCWM/DE_INSPID]
IDPLATE, -- Stock ID [/SCWM/DE_IDPLATE]
QDOCCAT, -- Document Cat. [/SCWM/DE_DOCCAT]
QDOCID, -- Document ID [/SCWM/DE_DOCID]
QITMID, -- Item [/SCWM/DE_ITMID]
HOLD_INCLUDE_INF, -- Single-Character Flag [CHAR1]
WDATU, -- GR Date [/SCWM/DE_WDATU]
VFDAT, -- Expiration Date [/SCWM/SLED]
COO, -- C/R of Orig. [/SCWM/DE_COO]
BRESTR, -- Restricted-use [/SCMB/MDL_DZUSTD]
STK_SEG_LONG, -- Stock Segment [/SCWM/DE_STK_SEG_LONG]
EXCCODE, -- Exception Code [/SCWM/DE_EXCCODE]
IPRCODE, -- Int. Proc. Code [/SCWM/DE_IPRCODE]
_DATAAGING, -- Data Aging [DATA_TEMPERATURE]
PI_DUMMY, -- Dummy function in length 1 [DUMMY]
PRIMARY KEY (MANDT, GUID_DOC, ITEM_NO, LINE_IDX, CHANGE_SEQ, ITEM_TYPE)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA