SAP ABAP Table BAPI_PHYSINV_ITEM (BAPI Communication Structure: Item of Phys. Inv. Doc.)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MB (Package) Application development R/3 inventory management

Basic Data

Table Category	INTTAB	Structure
Structure	BAPI_PHYSINV_ITEM	Table Relationship Diagram
Short Description	BAPI Communication Structure: Item of Phys. Inv. Doc.

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	PHYSINVENTORY	☐	IBLNR	BELNR	CHAR	10	0	Physical inventory document
2	FISCALYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
3	ITEM	☐	DZEILE	ZEILE	NUMC	3	0	Line Number
4	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
5	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	MARC
6	STGE_LOC	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
7	BATCH	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
8	SPEC_STOCK	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
9	STOCK_TYPE	☐	BSTAR	BSTAR	CHAR	1	0	Stock type	T064A
10	SALES_ORD	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
11	S_ORD_ITEM	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
12	SCHED_LINE	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
13	VENDOR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
14	CUSTOMER	☐	EKUNN	KUNNR	CHAR	10	0	Account number of customer	KNA1
15	PRODBINLOC	☐	PLPLA	PLPLA	CHAR	10	0	Distribution of Differences
16	CHANGE_USER	☐	USNAA	USNAM	CHAR	12	0	Changed by
17	CHANGE_DATE	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
18	COUNT_USER	☐	USNAZ	USNAM	CHAR	12	0	Counted By
19	COUNT_DATE	☐	DZLDAT	DATUM	DATS	8	0	Date of last count
20	PSTNG_NAME	☐	USNAD	USNAM	CHAR	12	0	Adjustment posting made by
21	PSTNG_DATE	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
22	PH_INV_REF	☐	XBLNI	XBLNR	CHAR	16	0	Reference number for physical inventory
23	COUNTED	☐	XZAEL	XFELD	CHAR	1	0	Item has been counted
24	DIFF_POSTED	☐	XDIFF	XFELD	CHAR	1	0	Difference posted
25	RECOUNT	☐	XNZAE	XFELD	CHAR	1	0	Item will be recounted
26	DELETE_IND	☐	XLOEK	XFELD	CHAR	1	0	Item is deleted
27	ALT_UNIT	☐	XAMEI	XFELD	CHAR	1	0	Handling in Alternative Unit of Measure
28	BOOK_QTY	☐	BUCHM	MENGV13	QUAN	13	3	Book quantity immediately prior to count
29	ZERO_COUNT	☐	XNULL	XFELD	CHAR	1	0	Zero count
30	QUANTITY	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
31	BASE_UOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
32	BASE_UOM_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
33	ENTRY_QNT	☐	ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry
34	ENTRY_UOM	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	T006
35	ENTRY_UOM_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
36	MAT_DOC	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
37	DOC_YEAR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
38	MATDOC_ITM	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
39	RECOUNTDOC	☐	NBLNR	BELNR	CHAR	10	0	Number of recount document
40	DIFFERENCE	☐	BAPI_DIFWR	BAPICURR	DEC	23	4	Difference amount in local currency
41	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
42	CURRENCY_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
43	CC_PH_INV	☐	ABCIN	ABCIN	CHAR	1	0	Physical inventory indicator for cycle counting	T159C
44	WBS_ELEMENT	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
45	SV_INC_VAT	☐	BAPI_VKWRT	BAPICURR	DEC	23	4	Value at sales prices (incl. tax)
46	SALES_VAL	☐	BAPI_EXVKW	BAPICURR	DEC	23	4	Externally entered sales value in local currency (for Bapi)
47	BOOK_VALUE	☐	BAPI_BUCHW	BAPICURR	DEC	23	4	Book value based on sales prices (SP) at time of count
48	VO_MAT	☐	XWART	XFELD	CHAR	1	0	Indicates that the value-only material is to be inventoried
49	SV_W_O_VAT	☐	BAPI_VKWRA	BAPICURR	DEC	23	4	Value at sales prices excl. tax
50	DIFFSALCNTVAT	☐	BAPI_VKMZL	BAPICURR	DEC	23	4	Sales val. of inv. diffs (incl. tax) upon count entry
51	DIFFSALCNT	☐	BAPI_VKNZL	BAPICURR	DEC	23	4	Sales val. of inv. diffs (excl. tax) upon count entry
52	VALCOUNTQNT	☐	BAPI_WRTZL	BAPICURR	DEC	23	4	Value of physical inventory count
53	VALBOOKAMT	☐	BAPI_WRTBM	BAPICURR	DEC	23	4	Value of book quantity
54	DIFF_VALUE	☐	BAPI_DIWZL	BAPICURR	DEC	23	4	Inventory difference value upon count entry
55	REASON	☐	GRDIF	MB_GRBEW	NUMC	4	0	Reason for inventory diff.	T157D
56	MATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
57	MATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
58	MATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field
59	PH_INV_REF_LONG	☐	XBLNI_LONG	XBLNR_LONG	CHAR	35	0	Phys. Inv. Reference Number (Dependencies see Long Text)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPI_PHYSINV_ITEM	BASE_UOM	T006	MSEHI
2	BAPI_PHYSINV_ITEM	BASE_UOM_ISO	T006I	ISOCODE
3	BAPI_PHYSINV_ITEM	BATCH	MCHA	CHARG
4	BAPI_PHYSINV_ITEM	CC_PH_INV	T159C	ABCIN
5	BAPI_PHYSINV_ITEM	CURRENCY	TCURC	WAERS
6	BAPI_PHYSINV_ITEM	CUSTOMER	KNA1	KUNNR
7	BAPI_PHYSINV_ITEM	ENTRY_UOM	T006	MSEHI
8	BAPI_PHYSINV_ITEM	ENTRY_UOM_ISO	T006I	ISOCODE
9	BAPI_PHYSINV_ITEM	MATERIAL	MARA	MATNR
10	BAPI_PHYSINV_ITEM	PLANT	MARC	WERKS
11	BAPI_PHYSINV_ITEM	REASON	T157D	GRUND
12	BAPI_PHYSINV_ITEM	SALES_ORD	VBUK	VBELN
13	BAPI_PHYSINV_ITEM	SPEC_STOCK	T148	SOBKZ
14	BAPI_PHYSINV_ITEM	STGE_LOC	T001L	LGORT
15	BAPI_PHYSINV_ITEM	STOCK_TYPE	T064A	BSTAR
16	BAPI_PHYSINV_ITEM	VENDOR	LFA1	LIFNR

History

Last changed by/on	SAP	20050219
SAP Release Created in