	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

CS_EXLST TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Defense Forces and Public Security :: Materials Management
1	ERP EHP7	6.0	/ISDFPS/CS_EXLST	198	1	Exception List: Overwritten Purchase Requisitions	Materials Management

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, PREQ_NO, PREQ_ITEM, COUNTER, VERSION, CHANGEDATE, CHANGETIME, BNFPO, BSART, BSTYP, BSAKZ, LOEKZ, STATU, ESTKZ, FRGKZ, FRGZU, FRGST, EKGRP, ERNAM, ERDAT, AFNAM, TXZ01, MATNR, EMATN, WERKS, LGORT, BEDNR, MATKL, RESWK, MENGE, MEINS, BUMNG, BADAT, LPEIN, LFDAT, FRGDT, WEBAZ, PREIS, PEINH, PSTYP, KNTTP, KZVBR, KFLAG, VRTKZ, TWRKZ, WEPOS, WEUNB, REPOS, LIFNR, FLIEF, EKORG, VRTYP, KONNR, KTPNR, INFNR, ZUGBA, QUNUM, QUPOS, DISPO, SERNR, BVDAT, BATOL, BVDRK, EBELN, EBELP, BEDAT, BSMNG, LBLNI, BWTAR, XOBLR, EBAKZ, RSNUM, SOBKZ, ARSNR, ARSPS, FIXKZ, BMEIN, REVLV, VORAB, PACKNO, KANBA, BPUEB, CUOBJ, FRGGR, FRGRL, AKTNR, CHARG, UMSOK, VERID, FIPOS, FISTL, GEBER, KZKFG, SATNR, MNG02, DAT01, ATTYP, ADRNR, ADRN2, KUNNR, EMLIF, LBLKZ, KZBWS, GSWRT, WAERS, IDNLF, GSFRG, MPROF, KZFME, SPRAS, TECHS, MFRPN, MFRNR, EMNFR, FORDN, FORDP, PLIFZ, BERID, UZEIT, REF_BANFN, REF_BNFPO, GRANT_NBR, FKBER, MEMORY, BANPR, RLWRT, BLCKD, BLCKT, REVNO, BESWK, EPROFILE, EPREFDOC, EPREFITM, GMMNG, WRTKZ, RESLO, KBLNR, KBLPOS, PRIO_URG, PRIO_REQ, ANZSN, SERNP, MHDRZ, IPRKZ, MEMORYTYPE, EXT_PROC_STATUS, EXT_PROC_DATE, PROC_STATUS, PROC_DATE, EXT_DOC_NUMBER, EXT_DOC_ITEM, EXT_DOC_TYPE, NODISP, SRM_CONTRACT_ID, SRM_CONTRACT_ITM, SC_OBJECT_ID, SC_ITM_NO, MEREQITEMDUMMY, DUMMY1, J_1BMATUSE, J_1BOWNPRO, J_1BMATORG, J_1BINDUST, J_1BNBM, J_1AINDXP, J_1AIDATEP, LAND1, PEROP_BEG, PEROP_END, BUDGET_PD, FMFGUS_KEY, ADVCODE, STACODE, BANFN_CS, BNFPO_CS, ITEM_CS, BSMNG_SND, NO_MARD_DATA, ADMOI, ADPRI, ADACN, PNSTAT, SERRU, DISUB_SOBKZ, DISUB_PSPNR, DISUB_KUNNR, DISUB_VBELN, DISUB_POSNR, DISUB_OWNER, IUID_RELEVANT, SGT_SCAT, SGT_RCAT, WRF_CHARSTC1, WRF_CHARSTC2, WRF_CHARSTC3, WRF_CHARSTC1_TXT, WRF_CHARSTC2_TXT, WRF_CHARSTC3_TXT FROM /ISDFPS/CS_EXLST

TOP ERP 6.0 | /ISDFPS/CS_EXLST COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	PREQ_NO	Purchase Requisition Number	nvarchar	10	0	CHAR	(N' ')	No		BANFN	Allow NULL?
3	PREQ_ITEM	Item Number of Purchase Requisition	nvarchar	5	0	NUMC	(N'00000')	No	*	BNFPO	Allow NULL?
4	COUNTER	5 Character Numeric NUMC	nvarchar	5	0	NUMC	(N'00000')	No		NUMC5	Allow NULL?
5	VERSION	Version of Purchase Requisition (Old/New)	char	1	0	CHAR	(N' ')	No		/ISDFPS/PREQ_VRSN	Allow NULL?
6	CHANGEDATE	Change Date	nvarchar	8	0	DATS	(N'00000000')	Yes		/ISDFPS/CHANGEDATE	Allow NULL?
7	CHANGETIME	Change Time	nvarchar	6	0	TIMS	(N'000000')	Yes		/ISDFPS/CHANGETIME	Allow NULL?
8	BNFPO	Item Number of Purchase Requisition	nvarchar	5	0	NUMC	(N'00000')	Yes	*	BNFPO	Allow NULL?
9	BSART	Purchase Requisition Document Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	BBSRT	Allow NULL?
10	BSTYP	Purchasing Document Category	char	1	0	CHAR	(N' ')	Yes		BSTYP	Allow NULL?
11	BSAKZ	Control indicator for purchasing document type	char	1	0	CHAR	(N' ')	Yes		BSAKZ	Allow NULL?
12	LOEKZ	Deletion Indicator in Purchasing Document	char	1	0	CHAR	(N' ')	Yes		ELOEK	Allow NULL?
13	STATU	Processing status of purchase requisition	char	1	0	CHAR	(N' ')	Yes		BANST	Allow NULL?
14	ESTKZ	Creation Indicator (Purchase Requisition/Schedule Lines)	char	1	0	CHAR	(N' ')	Yes		ESTKZ	Allow NULL?
15	FRGKZ	Release Indicator	char	1	0	CHAR	(N' ')	Yes	*	FRGKZ	Allow NULL?
16	FRGZU	Release status	nvarchar	8	0	CHAR	(N' ')	Yes		FRGZU	Allow NULL?
17	FRGST	Release Strategy in Purchase Requisition	nvarchar	2	0	CHAR	(N' ')	Yes		FRGST	Allow NULL?
18	EKGRP	Purchasing Group	nvarchar	3	0	CHAR	(N' ')	Yes	*	EKGRP	Allow NULL?
19	ERNAM	Name of Person who Created the Object	nvarchar	12	0	CHAR	(N' ')	Yes		ERNAM	Allow NULL?
20	ERDAT	Changed On	nvarchar	8	0	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
21	AFNAM	Name of Requisitioner/Requester	nvarchar	12	0	CHAR	(N' ')	Yes		AFNAM	Allow NULL?
22	TXZ01	Short Text	nvarchar	40	0	CHAR	(N' ')	Yes		TXZ01	Allow NULL?
23	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	*	MATNR	Allow NULL?
24	EMATN	Material Number Corresponding to Manufacturer Part Number	nvarchar	18	0	CHAR	(N' ')	Yes	*	EMATN	Allow NULL?
25	WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	*	EWERK	Allow NULL?
26	LGORT	Storage Location	nvarchar	4	0	CHAR	(N' ')	Yes	*	LGORT_D	Allow NULL?
27	BEDNR	Requirement Tracking Number	nvarchar	10	0	CHAR	(N' ')	Yes		BEDNR	Allow NULL?
28	MATKL	Material Group	nvarchar	9	0	CHAR	(N' ')	Yes	*	MATKL	Allow NULL?
29	RESWK	Supplying (Issuing) Plant in Stock Transport Order	nvarchar	4	0	CHAR	(N' ')	Yes	*	RESWK	Allow NULL?
30	MENGE	Purchase Requisition Quantity	decimal	13	3	QUAN	((0))	Yes		BAMNG
31	MEINS	Purchase Requisition Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	BAMEI	Allow NULL?
32	BUMNG	Shortage (stock undercoverage) quantity	decimal	13	3	QUAN	((0))	Yes		BUMNG
33	BADAT	Requisition (Request) Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BADAT	Allow NULL?
34	LPEIN	Category of Delivery Date	char	1	0	CHAR	(N' ')	Yes	*	LPEIN	Allow NULL?
35	LFDAT	Item Delivery Date	nvarchar	8	0	DATS	(N'00000000')	Yes		EINDT	Allow NULL?
36	FRGDT	Purchase Requisition Release Date	nvarchar	8	0	DATS	(N'00000000')	Yes		FRGDT	Allow NULL?
37	WEBAZ	Goods Receipt Processing Time in Days	decimal	3	0	DEC	((0))	Yes		WEBAZ
38	PREIS	Price in Purchase Requisition	decimal	11	2	CURR	((0))	Yes		BAPRE
39	PEINH	Price Unit	decimal	5	0	DEC	((0))	Yes		EPEIN
40	PSTYP	Item Category in Purchasing Document	char	1	0	CHAR	(N' ')	Yes	*	PSTYP	Allow NULL?
41	KNTTP	Account Assignment Category	char	1	0	CHAR	(N' ')	Yes	*	KNTTP	Allow NULL?
42	KZVBR	Consumption Posting	char	1	0	CHAR	(N' ')	Yes		KZVBR	Allow NULL?
43	KFLAG	Acct.asst.changeable	char	1	0	CHAR	(N' ')	Yes		KFLAG	Allow NULL?
44	VRTKZ	Distribution indicator for multiple account assignment	char	1	0	CHAR	(N' ')	Yes		VRTKZ	Allow NULL?
45	TWRKZ	Partial Invoice Indicator	char	1	0	CHAR	(N' ')	Yes		TWRKZ	Allow NULL?
46	WEPOS	Goods Receipt Indicator	char	1	0	CHAR	(N' ')	Yes		WEPOS	Allow NULL?
47	WEUNB	Goods Receipt, Non-Valuated	char	1	0	CHAR	(N' ')	Yes		WEUNB	Allow NULL?
48	REPOS	Invoice Receipt Indicator	char	1	0	CHAR	(N' ')	Yes		REPOS	Allow NULL?
49	LIFNR	Desired Vendor	nvarchar	10	0	CHAR	(N' ')	Yes	*	WLIEF	Allow NULL?
50	FLIEF	Fixed Vendor	nvarchar	10	0	CHAR	(N' ')	Yes	*	FLIEF	Allow NULL?
51	EKORG	Purchasing Organization	nvarchar	4	0	CHAR	(N' ')	Yes	*	EKORG	Allow NULL?
52	VRTYP	Purchasing Document Category	char	1	0	CHAR	(N' ')	Yes		BSTYP	Allow NULL?
53	KONNR	Number of Principal Purchase Agreement	nvarchar	10	0	CHAR	(N' ')	Yes	*	KONNR	Allow NULL?
54	KTPNR	Item Number of Principal Purchase Agreement	nvarchar	5	0	NUMC	(N'00000')	Yes	*	KTPNR	Allow NULL?
55	INFNR	Number of Purchasing Info Record	nvarchar	10	0	CHAR	(N' ')	Yes	*	INFNR	Allow NULL?
56	ZUGBA	Assigned Source of Supply	char	1	0	CHAR	(N' ')	Yes		DZUGBA	Allow NULL?
57	QUNUM	Number of Quota Arrangement	nvarchar	10	0	CHAR	(N' ')	Yes		QUNUM	Allow NULL?
58	QUPOS	Quota Arrangement Item	nvarchar	3	0	NUMC	(N'000')	Yes		QUPOS	Allow NULL?
59	DISPO	MRP Controller (Materials Planner)	nvarchar	3	0	CHAR	(N' ')	Yes	*	DISPO	Allow NULL?
60	SERNR	BOM explosion number	nvarchar	8	0	CHAR	(N' ')	Yes	*	SERNR	Allow NULL?
61	BVDAT	Date of last resubmission	nvarchar	8	0	DATS	(N'00000000')	Yes		BVDAT	Allow NULL?
62	BATOL	Resubmission Interval of Purchase Requisition	decimal	3	0	DEC	((0))	Yes		BATOL
63	BVDRK	Number of resubmissions	decimal	7	0	DEC	((0))	Yes		BVDRK
64	EBELN	Purchase Order Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	BSTNR	Allow NULL?
65	EBELP	Purchase Order Item Number	nvarchar	5	0	NUMC	(N'00000')	Yes	*	BSTPO	Allow NULL?
66	BEDAT	Purchase Order Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEDAT	Allow NULL?
67	BSMNG	Quantity Ordered Against this Purchase Requisition	decimal	13	3	QUAN	((0))	Yes		BSMNG
68	LBLNI	Entry Sheet Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	LBLNI	Allow NULL?
69	BWTAR	Valuation Type	nvarchar	10	0	CHAR	(N' ')	Yes	*	BWTAR_D	Allow NULL?
70	XOBLR	Item affects commitments	char	1	0	CHAR	(N' ')	Yes		XOBLR	Allow NULL?
71	EBAKZ	Purchase Requisition Closed	char	1	0	CHAR	(N' ')	Yes		EBAKZ	Allow NULL?
72	RSNUM	Number of Reservation/Dependent Requirement	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	RSNUM	Allow NULL?
73	SOBKZ	Special Stock Indicator	char	1	0	CHAR	(N' ')	Yes	*	SOBKZ	Allow NULL?
74	ARSNR	Settlement reservation number	nvarchar	10	0	NUMC	(N'0000000000')	Yes		ARSNR	Allow NULL?
75	ARSPS	Item number of the settlement reservation	nvarchar	4	0	NUMC	(N'0000')	Yes		ARSPS	Allow NULL?
76	FIXKZ	Purchase Requisition is Fixed	char	1	0	CHAR	(N' ')	Yes		BAFIX	Allow NULL?
77	BMEIN	Purchase Order Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	BSTME	Allow NULL?
78	REVLV	Revision Level	nvarchar	2	0	CHAR	(N' ')	Yes		REVLV	Allow NULL?
79	VORAB	Advance procurement: project stock	char	1	0	CHAR	(N' ')	Yes		VORAB	Allow NULL?
80	PACKNO	Package number	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	PACKNO	Allow NULL?
81	KANBA	Kanban Indicator	char	1	0	CHAR	(N' ')	Yes		KBNKZ	Allow NULL?
82	BPUEB	Adopt Requisition Price in Purchase Order	char	1	0	CHAR	(N' ')	Yes		BPUEB	Allow NULL?
83	CUOBJ	Configuration (internal object number)	nvarchar	18	0	NUMC	(N'000000000000000000')	Yes		CUOBJ	Allow NULL?
84	FRGGR	Release group	nvarchar	2	0	CHAR	(N' ')	Yes	*	FRGGR	Allow NULL?
85	FRGRL	Release Not Yet Completely Effected	char	1	0	CHAR	(N' ')	Yes		FRGRL	Allow NULL?
86	AKTNR	Promotion	nvarchar	10	0	CHAR	(N' ')	Yes	*	WAKTION	Allow NULL?
87	CHARG	Batch Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	CHARG_D	Allow NULL?
88	UMSOK	Special Stock Indicator for Physical Stock Transfer	char	1	0	CHAR	(N' ')	Yes	*	UMSOK	Allow NULL?
89	VERID	Production Version	nvarchar	4	0	CHAR	(N' ')	Yes	*	VERID	Allow NULL?
90	FIPOS	Commitment Item	nvarchar	14	0	CHAR	(N' ')	Yes	*	FIPOS	Allow NULL?
91	FISTL	Funds Center	nvarchar	16	0	CHAR	(N' ')	Yes	*	FISTL	Allow NULL?
92	GEBER	Fund	nvarchar	10	0	CHAR	(N' ')	Yes	*	BP_GEBER	Allow NULL?
93	KZKFG	Origin of Configuration	char	1	0	CHAR	(N' ')	Yes		KZCUH	Allow NULL?
94	SATNR	Cross-Plant Configurable Material	nvarchar	18	0	CHAR	(N' ')	Yes	*	SATNR	Allow NULL?
95	MNG02	Committed Quantity	decimal	13	3	QUAN	((0))	Yes		MNG06
96	DAT01	Committed Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DAT05	Allow NULL?
97	ATTYP	Material Category	nvarchar	2	0	CHAR	(N' ')	Yes		ATTYP	Allow NULL?
98	ADRNR	Manual address number in purchasing document item	nvarchar	10	0	CHAR	(N' ')	Yes	*	ADRNR_MM	Allow NULL?
99	ADRN2	Number of delivery address	nvarchar	10	0	CHAR	(N' ')	Yes	*	ADRN2	Allow NULL?
100	KUNNR	Customer	nvarchar	10	0	CHAR	(N' ')	Yes	*	EKUNNR	Allow NULL?
101	EMLIF	Vendor to be supplied/who is to receive delivery	nvarchar	10	0	CHAR	(N' ')	Yes	*	EMLIF	Allow NULL?
102	LBLKZ	Subcontracting vendor	char	1	0	CHAR	(N' ')	Yes		LBLKZ	Allow NULL?
103	KZBWS	Valuation of Special Stock	char	1	0	CHAR	(N' ')	Yes		KZBWS	Allow NULL?
104	GSWRT	Total Value of Item	decimal	13	2	CURR	((0))	Yes		GSWRT
105	WAERS	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	*	WAERS	Allow NULL?
106	IDNLF	Material Number Used by Vendor	nvarchar	35	0	CHAR	(N' ')	Yes		IDNLF	Allow NULL?
107	GSFRG	Overall release of purchase requisitions	char	1	0	CHAR	(N' ')	Yes		GSFRG	Allow NULL?
108	MPROF	Manufacturer Part Profile	nvarchar	4	0	CHAR	(N' ')	Yes	*	MPROF	Allow NULL?
109	KZFME	Units of measure usage	char	1	0	CHAR	(N' ')	Yes		KZWSO	Allow NULL?
110	SPRAS	Language Key	char	1	0	LANG	(N' ')	Yes	*	SPRAS	Allow NULL?
111	TECHS	Parameter Variant/Standard Variant	nvarchar	12	0	CHAR	(N' ')	Yes		TECHS	Allow NULL?
112	MFRPN	Manufacturer Part Number	nvarchar	40	0	CHAR	(N' ')	Yes		MFRPN	Allow NULL?
113	MFRNR	Number of a Manufacturer	nvarchar	10	0	CHAR	(N' ')	Yes	*	MFRNR	Allow NULL?
114	EMNFR	External manufacturer code name or number	nvarchar	10	0	CHAR	(N' ')	Yes		EMNFR	Allow NULL?
115	FORDN	Framework Order	nvarchar	10	0	CHAR	(N' ')	Yes	*	SFORDN	Allow NULL?
116	FORDP	Item of framework order	nvarchar	5	0	NUMC	(N'00000')	Yes	*	FORDP	Allow NULL?
117	PLIFZ	Planned Delivery Time in Days	decimal	3	0	DEC	((0))	Yes		PLIFZ
118	BERID	MRP Area	nvarchar	10	0	CHAR	(N' ')	Yes	*	BERID	Allow NULL?
119	UZEIT	Delivery Date Time-Spot	nvarchar	6	0	TIMS	(N'000000')	Yes		LZEIT	Allow NULL?
120	REF_BANFN	Number of Reference Purchase Requisition	nvarchar	10	0	CHAR	(N' ')	Yes		REFBN	Allow NULL?
121	REF_BNFPO	Item of Reference Purchase Requisition	nvarchar	5	0	NUMC	(N'00000')	Yes	*	RFBPS	Allow NULL?
122	GRANT_NBR	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
123	FKBER	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
124	MEMORY	Purchase Requisition not yet Complete	char	1	0	CHAR	(N' ')	Yes		MEMBF	Allow NULL?
125	BANPR	Requisition Processing State	nvarchar	2	0	CHAR	(N' ')	Yes		BANPR	Allow NULL?
126	RLWRT	Total value at time of release	decimal	15	2	CURR	((0))	Yes		RLWRT
127	BLCKD	Purchase Requisition Blocked	char	1	0	CHAR	(N' ')	Yes		BLCKD	Allow NULL?
128	BLCKT	Reason for Item Block	nvarchar	60	0	CHAR	(N' ')	Yes		BLCKT	Allow NULL?
129	REVNO	Version number in Purchasing	nvarchar	8	0	CHAR	(N' ')	Yes		REVNO	Allow NULL?
130	BESWK	Procuring Plant	nvarchar	4	0	CHAR	(N' ')	Yes	*	BESWK	Allow NULL?
131	EPROFILE	External Procurement Profile	nvarchar	2	0	CHAR	(N' ')	Yes		MEPROFILE	Allow NULL?
132	EPREFDOC	External Procurement Reference Document	nvarchar	10	0	CHAR	(N' ')	Yes		EPREFDOC	Allow NULL?
133	EPREFITM	External Procurement Reference Item	nvarchar	5	0	NUMC	(N'00000')	Yes		EPREFITM	Allow NULL?
134	GMMNG	PO Quantity of Purchase Requisition in POs on Hold	decimal	13	3	QUAN	((0))	Yes		GMMNG
135	WRTKZ	Value-Based Commitment Reduction for Service Purchase Reqs	char	1	0	CHAR	(N' ')	Yes		WRTKZ	Allow NULL?
136	RESLO	Issuing Storage Location for Stock Transport Order	nvarchar	4	0	CHAR	(N' ')	Yes	*	RESLO	Allow NULL?
137	KBLNR	Document Number for Earmarked Funds	nvarchar	10	0	CHAR	(N' ')	Yes	*	KBLNR	Allow NULL?
138	KBLPOS	Earmarked Funds: Document Item	nvarchar	3	0	NUMC	(N'000')	Yes	*	KBLPOS	Allow NULL?
139	PRIO_URG	Requirement Urgency	nvarchar	2	0	NUMC	(N'00')	Yes	PURG	PRIO_URG	Allow NULL?
140	PRIO_REQ	Requirement Priority	nvarchar	3	0	NUMC	(N'000')	Yes	PREQ	PRIO_REQ	Allow NULL?
141	ANZSN	Number of serial numbers	int	10	0	INT4	((0))	Yes		ANZSN	Allow NULL?
142	SERNP	Serial Number Profile	nvarchar	4	0	CHAR	(N' ')	Yes	*	SERAIL	Allow NULL?
143	MHDRZ	Minimum Remaining Shelf Life	decimal	4	0	DEC	((0))	Yes		MHDRZ
144	IPRKZ	Period Indicator for Shelf Life Expiration Date	char	1	0	CHAR	(N' ')	Yes		DATTP	Allow NULL?
145	MEMORYTYPE	Category of Incompleteness	char	1	0	CHAR	(N' ')	Yes		MEMORYTYPE	Allow NULL?
146	EXT_PROC_STATUS	Processing State	char	1	0	CHAR	(N' ')	Yes		MEREQ_PROC_STATUS	Allow NULL?
147	EXT_PROC_DATE	Timestamp	nvarchar	14	0	CHAR	(N' ')	Yes		MMPUR_UTC	Allow NULL?
148	PROC_STATUS	Processing State	char	1	0	CHAR	(N' ')	Yes		MEREQ_PROC_TYPE	Allow NULL?
149	PROC_DATE	Timestamp	nvarchar	14	0	CHAR	(N' ')	Yes		MMPUR_UTC	Allow NULL?
150	EXT_DOC_NUMBER	Document Number of External Document	nvarchar	35	0	CHAR	(N' ')	Yes		ME_PUR_EXT_DOC_ID	Allow NULL?
151	EXT_DOC_ITEM	Item Number of External Document	nvarchar	10	0	CHAR	(N' ')	Yes		ME_PUR_EXT_DOC_ITEM_ID	Allow NULL?
152	EXT_DOC_TYPE	External Document Type	nvarchar	4	0	CHAR	(N' ')	Yes		ME_PUR_EXT_DOC_TYPE	Allow NULL?
153	NODISP	Ind: Reserv. not applicable to MRP;Purc. req. not created	char	1	0	CHAR	(N' ')	Yes		NODISP	Allow NULL?
154	SRM_CONTRACT_ID	Central Contract	nvarchar	10	0	CHAR	(N' ')	Yes		SRM_CONTRACT_ID	Allow NULL?
155	SRM_CONTRACT_ITM	Central Contract Item Number	nvarchar	10	0	NUMC	(N'0000000000')	Yes		SRM_CONTRACT_ITEM	Allow NULL?
156	SC_OBJECT_ID	Object ID - Document Number	nvarchar	10	0	CHAR	(N' ')	Yes		/SRMERP/OBJECT_ID	Allow NULL?
157	SC_ITM_NO	Internal Shopping Cart Item Number	int	10	0	INT4	((0))	Yes		/SRMERP/SC_ITM_NO	Allow NULL?
158	MEREQITEMDUMMY	Checkbox	char	1	0	CHAR	(N' ')	Yes		XFELD	Allow NULL?
159	DUMMY1	Type of consolidation of investments method	char	1	0	CHAR	(N' ')	Yes		XFELD1	Allow NULL?
160	J_1BMATUSE	Usage of the material	char	1	0	CHAR	(N' ')	Yes		J_1BMATUSE	Allow NULL?
161	J_1BOWNPRO	Produced in-house	char	1	0	CHAR	(N' ')	Yes		J_1BOWNPRO	Allow NULL?
162	J_1BMATORG	Origin of the material	char	1	0	CHAR	(N' ')	Yes		J_1BMATORG	Allow NULL?
163	J_1BINDUST	Material CFOP category	nvarchar	2	0	CHAR	(N' ')	Yes		J_1BINDUS3	Allow NULL?
164	J_1BNBM	Brazilian NCM Code	nvarchar	16	0	CHAR	(N' ')	Yes	*	J_1BNBMCO1	Allow NULL?
165	J_1AINDXP	Inflation Index	nvarchar	5	0	CHAR	(N' ')	Yes	*	J_1AINDXP	Allow NULL?
166	J_1AIDATEP	Inflation Index Date	nvarchar	8	0	DATS	(N'00000000')	Yes		J_1AIDATEP	Allow NULL?
167	LAND1	Country Key	nvarchar	3	0	CHAR	(N' ')	Yes	*	LAND1	Allow NULL?
168	PEROP_BEG	Period of Performance Start	nvarchar	8	0	DATS	(N'00000000')	Yes		FM_PEROP_LOW	Allow NULL?
169	PEROP_END	Period of Performance End	nvarchar	8	0	DATS	(N'00000000')	Yes		FM_PEROP_HIGH	Allow NULL?
170	BUDGET_PD	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?
171	FMFGUS_KEY	United States Federal Government Fields	nvarchar	22	0	CHAR	(N' ')	Yes		FMFG_US_KEY	Allow NULL?
172	ADVCODE	Advice Code	nvarchar	2	0	CHAR	(N' ')	Yes	/ISDFPS/ADVCODE2	/ISDFPS/ADVCODE	Allow NULL?
173	STACODE	Status Code	nvarchar	2	0	CHAR	(N' ')	Yes	/ISDFPS/CSTACODE	/ISDFPS/STACODE	Allow NULL?
174	BANFN_CS	Cross-System PReq Number	nvarchar	10	0	CHAR	(N' ')	Yes		/ISDFPS/BANFN_CS	Allow NULL?
175	BNFPO_CS	Cross-System PReq Item	nvarchar	5	0	NUMC	(N'00000')	Yes	*	/ISDFPS/BNFPO_CS	Allow NULL?
176	ITEM_CS	Cross-System Item Category	char	1	0	CHAR	(N' ')	Yes		/ISDFPS/ITEM_CS	Allow NULL?
177	BSMNG_SND	PO Quantity Sender	decimal	13	3	QUAN	((0))	Yes		/ISDFPS/BSMNG_SND
178	NO_MARD_DATA	No Storage Location Data Exists for Material	char	1	0	CHAR	(N' ')	Yes		/ISDFPS/NO_MARD_DATA	Allow NULL?
179	ADMOI	Model ID code	nvarchar	4	0	CHAR	(N' ')	Yes		ADMOI	Allow NULL?
180	ADPRI	Order priority	nvarchar	3	0	CHAR	(N' ')	Yes		ADPRI	Allow NULL?
181	ADACN	Aircraft registration number	nvarchar	5	0	CHAR	(N' ')	Yes		ADACN	Allow NULL?
182	PNSTAT	Flag for the S1PNSTAT message	char	1	0	CHAR	(N' ')	Yes		ADSPC_PNSTAT	Allow NULL?
183	SERRU	Type of subcontracting	char	1	0	CHAR	(N' ')	Yes		SERRU	Allow NULL?
184	DISUB_SOBKZ	Special stock indicator Subcontracting - for help	char	1	0	CHAR	(N' ')	Yes		DISUB_SOBKZ_LB2	Allow NULL?
185	DISUB_PSPNR	WBS Element	nvarchar	8	0	NUMC	(N'00000000')	Yes	PRPS	DISUB_PS_POSNR2	Allow NULL?
186	DISUB_KUNNR	Customer Number	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	DISUB_KUNNR2	Allow NULL?
187	DISUB_VBELN	Sales Document	nvarchar	10	0	CHAR	(N' ')	Yes	VBUK	DISUB_VBELN_VA2	Allow NULL?
188	DISUB_POSNR	Item number of the SD document	nvarchar	6	0	NUMC	(N'000000')	Yes	VBUP	DISUB_POSNR2	Allow NULL?
189	DISUB_OWNER	Owner of stock	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	DISUB_OWNER_D	Allow NULL?
190	IUID_RELEVANT	IUID-Relevant	char	1	0	CHAR	(N' ')	Yes		IUID_RELEVANT	Allow NULL?
191	SGT_SCAT	Stock Segment	nvarchar	16	0	CHAR	(N' ')	Yes		SGT_SCAT	Allow NULL?
192	SGT_RCAT	Requirement Segment	nvarchar	16	0	CHAR	(N' ')	Yes		SGT_RCAT	Allow NULL?
193	WRF_CHARSTC1	Characteristic Value 1	nvarchar	18	0	CHAR	(N' ')	Yes		WRF_CHARSTC1	Allow NULL?
194	WRF_CHARSTC2	Characteristic Value 2	nvarchar	18	0	CHAR	(N' ')	Yes		WRF_CHARSTC2	Allow NULL?
195	WRF_CHARSTC3	Characteristic Value 3	nvarchar	18	0	CHAR	(N' ')	Yes		WRF_CHARSTC3	Allow NULL?
196	WRF_CHARSTC1_TXT	Characteristic Description 1	nvarchar	30	0	CHAR	(N' ')	Yes		WRF_CHARSTC1_TEXT	Allow NULL?
197	WRF_CHARSTC2_TXT	Characteristic Description 2	nvarchar	30	0	CHAR	(N' ')	Yes		WRF_CHARSTC2_TEXT	Allow NULL?
198	WRF_CHARSTC3_TXT	Characteristic Description 3	nvarchar	30	0	CHAR	(N' ')	Yes		WRF_CHARSTC3_TEXT	Allow NULL?

TOP ERP 6.0 | /ISDFPS/CS_EXLST INDEXES

Name	Primary	Unique	Type	Columns
/ISDFPS/CS_EXLST~0	Yes	Yes	CLUSTERED	VERSION, COUNTER, PREQ_ITEM, PREQ_NO, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

198 COLUMNS | 1 INDEXES | ERP 6.0 | /ISDFPS/CS_EXLST TABLE

TOP ERP 6.0 | /ISDFPS/CS_EXLST COLUMNS

TOP ERP 6.0 | /ISDFPS/CS_EXLST INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

198 COLUMNS | 1 INDEXES | ERP 6.0 | /ISDFPS/CS_EXLST TABLE

TOPERP 6.0 | /ISDFPS/CS_EXLST COLUMNS

TOPERP 6.0 | /ISDFPS/CS_EXLST INDEXES

TOP ERP 6.0 | /ISDFPS/CS_EXLST COLUMNS

TOP ERP 6.0 | /ISDFPS/CS_EXLST INDEXES