SAP ABAP View /LIME/V_PN_ITEM (View of tables /LIME/PN_ITEM and /LIME/LOG_HEAD)

Hierarchy

☛ SAP_AP (Software Component) SAP Application Platform
   ⤷ AP-LIM (Application Component) AP-LIM Logistics Inventory Management Engine
     ⤷ /LIME/PLT_CORE (Package) Platform - Core

Basic Data

View Type	D	Database View
Database View	/LIME/V_PN_ITEM
Short Description	View of tables /LIME/PN_ITEM and /LIME/LOG_HEAD
Root table	/LIME/LOG_HEAD	Log Table for Header Data of a Prima Nota Document

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	/LIME/LOG_HEAD	/LIME/LOG_HEAD
2	/LIME/PN_ITEM

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	/LIME/LOG_HEAD	MANDT	JL	EQ				0	0
2	/LIME/PN_ITEM	MANDT	JR	EQ			AND	0	0
3	/LIME/LOG_HEAD	GUID_PN	JL	EQ				0	0
4	/LIME/PN_ITEM	GUID_PN	JR	EQ				0	0

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20131122
SAP Release Created in	700