SAP ABAP Table ISI_SEARCH_CRITERIA (Search criteria used for all SWP transaktions)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ IS-A-SWP (Application Component) Supplier Workplace
     ⤷ ISIA (Package) Internet Supplier Integration: Application layer

Basic Data

Table Category	INTTAB	Structure
Structure	ISI_SEARCH_CRITERIA	Table Relationship Diagram
Short Description	Search criteria used for all SWP transaktions

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	VENDOR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	*
2	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
3	STORE_LOC	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
4	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
5	VEND_MAT	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
6	PO_NUMBER	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
7	PO_ITEM	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
8	NUMBER_DOCS	☐	NUMBER_DOCS	INT3	NUMC	3	0	Number of documents to display
9	DATE_FROM	☐	ISI_ORDER_FROM	DATUM	DATS	8	0	Order-from date
10	DATE_TO	☐	ISI_ORDER_TO	DATUM	DATS	8	0	Order-to date
11	LAST_DAYS	☐	ANZDAYS	ANZ	INT4	10	0	Number of days
12	NEXT_DAYS	☐	ANZDAYS	ANZ	INT4	10	0	Number of days
13	GR_LDAYS	☐	ANZDAYS	ANZ	INT4	10	0	Number of days
14	REQ_LDAYS	☐	ANZDAYS	ANZ	INT4	10	0	Number of days
15	SETL_NDAYS	☐	ANZDAYS	ANZ	INT4	10	0	Number of days
16	GR_NDAYS	☐	ANZDAYS	ANZ	INT4	10	0	Number of days
17	.INCLUDE	☐				0	0	Date and time of last data base selection
18	SEL_DATE	☐	DATUM	DATUM	DATS	8	0	Date
19	SEL_TIME	☐	UZEIT	UZEIT	TIMS	6	0	Time
20	.INCLUDE	☐				0	0	Search criteria current schedules
21	CREL	☐	ISI_CREL	CHAR1	CHAR	1	0	Display only non confirmed releases
22	VENDOR_SHVAL	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
23	PLANT_SHVAL	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
24	MATERIAL_SHVAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
25	CREL_SHVAL	☐	ISI_CREL	CHAR1	CHAR	1	0	Display only non confirmed releases
26	ABART_SHVAL	☐	ABART	ABART	CHAR	1	0	Release type
27	EPSTP_SHVAL	☐	EPSTP	EPSTP	CHAR	1	0	Item category in purchasing document
28	.INCLUDE	☐				0	0	Search criteria consignement procurement
29	JTYPE	☐	ISI_JTYPE	CHAR1	CHAR	1	0	Display only JIT release lines
30	FTYPE	☐	ISI_FTYPE	CHAR1	CHAR	1	0	Display only FRC release lines
31	.INCLUDE	☐				0	0	Search criteria packaging accounts
32	CUSTOMER_EXT	☐	RL_EXTERNAL_ID	RL_EXTERNAL_ID	CHAR	35	0	Description of Object at Partner
33	REF_DOCNO	☐	RL_DOCNO	RL_DOCNO	CHAR	35	0	Document Number for Transaction
34	.INCLUDE	☐				0	0	Search criteria JIT
35	LSTAT	☐	JIT_LSTAT	CHAR10	CHAR	10	0	lower status
36	USTAT	☐	JIT_USTAT	CHAR10	CHAR	10	0	upper status
37	VIEWS	☐	SICJIT_VIEW	SICJIT_VIEW	CHAR	1	0	View of Internet scenario
38	SUMJIT_VIEWS	☐	ISI_SUMJIT_VIEW	ISI_SUMJIT_VIEW	CHAR	1	0	Summarised JIT views
39	SORTB	☐	SICJIT_SORTB	SICJIT_SORTB	CHAR	1	0	Sort criteria for SICJIT scenario
40	SUMJIT_SORTB	☐	ISI_SUMJIT_SORTB	ISI_SUMJIT_SORTB	CHAR	1	0	Summarised JIT sorting order
41	PRODN	☐	JIT_PRODN	TEXT35	CHAR	35	0	External Call Number
42	SEQNR	☐	JIT_SEQNR	TEXT35	CHAR	35	0	External Sequence Number
43	OUTPO	☐	JITO_OUTPO		NUMC	10	0	Components Group Number JIT Outbound
44	CALLTYPE	☐	ISI_JITCALL_TYPE	ISI_JITCALL_TYPE	CHAR	1	0	JIT call type
45	FROMTIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
46	TOTIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
47	LPKBST	☐	PKBST	PKBST	CHAR	1	0	Kanban status
48	HPKBST	☐	PKBST	PKBST	CHAR	1	0	Kanban status
49	PABWEF	☐	PABWEF	XFELD	CHAR	1	0	Goods receipt flag for JIT call
50	PABDKZ	☐	PABDKZ	PABDKZ	CHAR	1	0	Message: JIT call edited
51	SUMJIT_GRSTATUS	☐	ISI_SUMJIT_GR_STATUS	ISI_SUMJIT_GR_STATUS	CHAR	1	0	GR status for JIT call
52	.INCLUDE	☐				0	0	Search criteria Bordero
53	TKNUM	☐	TKNUM	TKNUM	CHAR	10	0	Shipment Number	*
54	SIGNI	☐	SIGNI	TEXT20	CHAR	20	0	Container ID
55	EXTI1	☐	EXTI1	TEXT20	CHAR	20	0	External identification 1
56	EXTI2	☐	EXTI2	TEXT20	CHAR	20	0	External identification 2
57	TPBEZ	☐	TPBEZ	TEXT20	CHAR	20	0	Description of Shipment
58	BOR_PUS	☐	BOR_PUS	CHAR35	CHAR	35	0	Pick Up List number
59	.INCLUDE	☐				0	0	Shuffler criteria for consignment processing
60	ALERT_SHVAL	☐	ALBOOL	CHAR1	CHAR	1	0	Alerts: Boolean value (1 = true, 0 = false)
61	NSETL_SHVAL	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
62	COVERAGE_SHVAL	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
63	.INCLUDE	☐				0	0	Pick Up List
64	PL_NUM	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
65	.INCLUDE	☐				0	0	Search criteria for Purchase history
66	REF_DOC_NO	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
67	.INCLUDE	☐				0	0	ASN search criteria
68	INBD_NUMBER	☐	VBELN_VLAV	VBELN	CHAR	10	0	Inbound delivery	*
69	INBD_ENUMBER	☐	LIFEX	TEXT35	CHAR	35	0	External Identification of Delivery Note
70	.INCLUDE	☐				0	0	Search Criteria Proof of Delivery
71	PER_PAGE_SHVAL	☐	NUMC10	NUMC10	NUMC	10	0	Numeric Character Field, Length 10
72	PDSTK_SHVAL	☐	PDSTK	STATV	CHAR	1	0	POD status on header level
73	POD_FLAG_SHVAL	☐	ISI_PODFLAG_SEL	ISI_PODFLAG_SEL	CHAR	1	0	Selection Help: Relvant for POD creation
74	PODVWK_SHVAL	☐	ISI_PODVWK_SEL	ISI_PODVWK_SEL	CHAR	1	0	Selection Help for the POD Viewed Flag
75	POD_FLAG	☐	ISI_PODFLAG_SEL	ISI_PODFLAG_SEL	CHAR	1	0	Selection Help: Relvant for POD creation
76	PODVWK	☐	ISI_PODVWK_SEL	ISI_PODVWK_SEL	CHAR	1	0	Selection Help for the POD Viewed Flag
77	PODVWK_TST_FROM	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
78	PODVWK_TST_TO	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
79	PDSTK	☐	PDSTK	STATV	CHAR	1	0	POD status on header level
80	DELV_DATE_FROM	☐	DATUM	DATUM	DATS	8	0	Date
81	DELV_DATE_TO	☐	DATUM	DATUM	DATS	8	0	Date
82	GM_DATE_FROM	☐	DATUM	DATUM	DATS	8	0	Date
83	GM_DATE_TO	☐	DATUM	DATUM	DATS	8	0	Date
84	DELV_GROUP	☐	BORGR_GRP	CHAR35	CHAR	35	0	Inbound Dely Group: Multi-Level Goods Receipt Automotive
85	.INCLUDE	☐				0	0	Search Criteria for MPN
86	EMATN	☐	EMATNR	MATNR	CHAR	18	0	Material number	*
87	EMATN_SHVAL	☐	EMATNR	MATNR	CHAR	18	0	Material number	*

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C2