SAP ABAP Table /LIME/V_PN_ITEM (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	/LIME/V_PN_ITEM	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client
2	GUID_PN	☑	/LIME/GUID_PN		RAW	16	0	LIME GUID for Prima Nota
3	EXT_DOC	☑	/LIME/EXT_DOC		CHAR	35	0	Number of LIME Document
4	PROCESS_TYPE	☑	/LIME/PROCESS_TYPE	/LIME/PROCESS_TYPE	CHAR	4	0	Application
5	TIMESTAMP_LIME	☑	/LIME/TIMESTAMP_INT	TZNTSTMPL	DEC	21	7	LIME Internal Time Stamp (YYYYMMDDhhmmss,mmmuuun)
6	USERID	☑	UNAME	UNAME	CHAR	12	0	User Name
7	ARCH_RESIDENT	☑	/LIME/ARCH_RESIDENT	XFLAG	CHAR	1	0	Archiving Resident: Prevents Deletion of Arch. Docs
8	ARCH_STATUS	☑	/LIME/ARCH_STATUS	/LIME/ARCH_STATUS	CHAR	1	0	Archiving Status
9	ID	☑	/LIME/LINE_ITEM_ID		NUMC	6	0	Item
10	TARGET	☑	/LIME/TARGET	/LIME/TARGET	CHAR	1	0	Describes Whether It Is Source or Target Data Record
11	ITEM_IDX	☑	SYTABIX	SYST_LONG	INT4	10	0	Row Index of Internal Tables
12	ITEM_TAB	☐	/LIME/PN_ITEM_TYPE	/LIME/PN_ITEM_TYPE	CHAR	3	0	Identifier for Type of PN Item Table (PN_ITEM)
13	IDX_LOC	☐	/LIME/KEY_INDEX		CHAR	3	0	Current Nummer of Key Table
14	GUID_LOC	☐	/LIME/GUID_LOC		RAW	16	0	Location GUID
15	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant
16	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location
17	GLN	☐	/LIME/GLN		NUMC	13	0	Global Location Number
18	DUNS4	☐	/LIME/DUNS4		NUMC	13	0	D-U-N-S+4 Number
19	LOCID	☐	/LIME/MDL_LOCID	SYSUUID	RAW	16	0	GUID for Location
20	APO_LOCNO	☐	/LIME/APO_LOCNO		CHAR	20	0	APO Location
21	PARTNER	☐	/LIME/PARTNER	BU_PARTNER	CHAR	10	0	Partner
22	PARTNER_ROLE	☐	/LIME/PARTNER_ROLE	/LIME/PARTNER_ROLE	CHAR	2	0	Partner Role
23	MOTID	☐	/LIME/MDL_MOTID		CHAR	35	0	Means of Transport Identifier
24	MOTSCODE	☐	/LIME/MDL_MOTSCODE		CHAR	4	0	Standard Code Means of Transport Acc.To UN/EDIFACT 8179
25	IDX_HU	☐	/LIME/KEY_INDEX		CHAR	3	0	Current Nummer of Key Table
26	GUID_HU	☐	/LIME/GUID_HU		RAW	16	0	GUID Handling Unit
27	SSCC	☐	/LIME/SSCC		NUMC	18	0	Serial Shipping Container Code (NVE, Number Package)
28	IDX_STOCK	☐	/LIME/KEY_INDEX		CHAR	3	0	Current Nummer of Key Table
29	GUID_STOCK	☐	/LIME/GUID_STOCK		RAW	16	0	GUID Stock Item
30	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number
31	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number
32	OWNER	☐	/LIME/OWNER	BU_PARTNER	CHAR	10	0	Owner
33	OWNER_ROLE	☐	/LIME/OWNER_ROLE	/LIME/PARTNER_ROLE	CHAR	2	0	Partner Role of Owner
34	GTIN	☐	/LIME/GTIN		NUMC	14	0	Global Trade Item Number (GTIN)
35	GTIN_VARIANT	☐	/LIME/GTIN_VARIANT		NUMC	2	0	Global Trade Item Number (GTIN) Variant
36	CAT	☐	/LIME/STOCK_CATEGORY	/LIME/STOCK_CATEGORY	CHAR	2	0	Stock Type
37	STOCK_USAGE	☐	/LIME/STOCK_USAGE	/LIME/STOCK_USAGE	CHAR	1	0	Stock Usage
38	SALES_ORD_STOCK	☐	/LIME/SALES_ORD_STOCK	VBELN	CHAR	10	0	Sales Order for Stock
39	S_ORD_ITEM_STOCK	☐	/LIME/S_ORD_ITEM_STOCK	NUM06	NUMC	6	0	Sales Order Item for Stock
40	WBS_STOCK	☐	/LIME/WBS_STOCK	PS_POSID	CHAR	24	0	WBS Element for Stock
41	VRSIOID	☐	/LIME/MDL_VRSIOID	SYSUUID	RAW	16	0	GUID for Planning Version
42	PRDID	☐	/LIME/MDL_PRDID	SYSUUID	RAW	16	0	GUID for Product
43	APO_MATNR	☐	/LIME/APO_MATNR		CHAR	40	0	APO Material Number
44	PO_NUMBER	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number
45	PO_ITEM	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document
46	PO_COMPLETE	☐	/LIME/OBSOLET_PO_COMPLETE	XFELD	CHAR	1	0	Obsolete With SCM4.1
47	ORDER_NUMBER	☐	AUFNR	AUFNR	CHAR	12	0	Order Number
48	ORDER_ITEM	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
49	ORDER_COMPLETE	☐	/LIME/OBSOLET_ORDER_COMPLETE	XFELD	CHAR	1	0	Obsolete With SCM4.1
50	DELIVERY	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number
51	DELIVERY_ITEM	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document
52	DELIV_COMPLETE	☐	/LIME/OBSOLET_DELIV_COMPLETE	XFELD	CHAR	1	0	Obsolete With SCM4.1
53	MAT_DOC	☐	/LIME/MAT_DOC	BELNR	CHAR	10	0	R/3 Material Document
54	MAT_DOC_YEAR	☐	/LIME/MAT_DOC_YEAR	GJAHR	NUMC	4	0	Material Document Year
55	MAT_DOC_ITEM	☐	/LIME/MAT_DOC_ITEM		NUMC	4	0	Item in Material Document
56	RESERV_NO	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements
57	RES_ITEM	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
58	RES_TYPE	☐	RSART	RSART	CHAR	1	0	Record type
59	RES_COMPLETE	☐	/LIME/OBSOLET_KZEAR	XFELD	CHAR	1	0	Obsolete With SCM4.1
60	ID_PARENT	☐	/LIME/LINE_ITEM_ID_PARENT		NUMC	6	0	Reference to Higher-Level Item
61	ID_GROUP	☐	/LIME/LINE_ITEM_GROUP		NUMC	6	0	Item Group
62	DIRECTION	☐	/LIME/DIRECTION	/LIME/DIRECTION	CHAR	1	0	Direction of Movement (In/Out/Transfer)
63	REVERSE_MODE	☐	/LIME/REVERSE_MODE	XFELD	CHAR	1	0	Reversal Indicator
64	ISSUE_ALL	☐	/LIME/ISSUE_ALL	XFELD	CHAR	1	0	Move Total Stock
65	TIMESTAMP	☐	/LIME/TIMESTAMP_EXT	TZNTSTMPL	DEC	21	7	UTC Time Stamp (YYYYMMDDhhmmss,mmmuuun)
66	TIMESTAMP_END	☐	/LIME/TIMESTAMP_EXT_END	TZNTSTMPL	DEC	21	7	UTC Time Stamp (YYYYMMDDhhmmss,mmmuuun) End of Operation
67	NOTE	☐	/LIME/NOTE		CHAR	50	0	Notes
68	REASON	☐	/LIME/REASON	/LIME/REASON	CHAR	4	0	Reason for Movement
69	EXT_VALUE	☐	/LIME/EXT_VALUE		CURR	13	2	External Value
70	EXT_VALUE_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key
71	VSI	☐	/LIME/VSI	/LIME/VSI	CHAR	1	0	Virtual Stock Indicator
72	IC_DESCRIP	☐	/LIME/IC_DESCRIP		CHAR	10	0	Description of Stock Change
73	EEW_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
74	OWNER_TARGET	☐	/LIME/OWNER_TARGET	BU_PARTNER	CHAR	10	0	Target Owner
75	OWNER_ROLE_TARG	☐	/LIME/OWNER_ROLE_TARGET	/LIME/PARTNER_ROLE	CHAR	2	0	Partner Role of Target Owner
76	ACTION	☐	/LIME/ACTION	/LIME/ACTION	CHAR	1	0	Action (Insert, Delete, Change, ...)
77	TOP_LEVEL	☐	/LIME/TOP_LEVEL	XFELD	CHAR	1	0	Location at Highest Hierarchy Level
78	CUSTODIAN	☐	/LIME/CUSTODIAN	BU_PARTNER	CHAR	10	0	Owner
79	CUSTODIAN_ROLE	☐	/LIME/CUSTODIAN_ROLE	/LIME/PARTNER_ROLE	CHAR	2	0	Partner Role of Owner
80	AUTH_GROUP	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
81	BLOCK_IND	☐	/LIME/BLOCK_IND		CHAR	1	0	Blocking Indicator
82	INV_BLOCK_IND	☐	/LIME/INV_BLOCK_IND		CHAR	1	0	Blocking Indicator for Physical Inventory Count
83	XCUSTODIAN	☐	/LIME/XCUSTODIAN	XFELD	CHAR	1	0	Indicator: Change Custodian and Custodian Role
84	XAUTH_GROUP	☐	/LIME/XAUTH_GROUP	XFELD	CHAR	1	0	Indicator: Change Authorization Group
85	XBLOCK_IND	☐	/LIME/XBLOCK_IND	XFELD	CHAR	1	0	Indicator: Change Posting Block
86	XINV_BLOCK_IND	☐	/LIME/XINV_BLOCK_IND	XFELD	CHAR	1	0	Indicator: Change Posting Block for Physical Inventory Count
87	XOWNER	☐	/LIME/XOWNER	XFELD	CHAR	1	0	Indicator: Change Owner and Owner Role
88	XVSI	☐	/LIME/XVSI	XFELD	CHAR	1	0	Indicator: Change VSI

History

Last changed by/on	SAP	20131122
SAP Release Created in