	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

STG_PM001 TABLE

ERP EHP7

6.0

195

Data staging - Equipment complex table

SQL: selectupdate insert create

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

SELECT MANDT, DSF_GUID, DSF_DSTORE_ID, USER_GUID, DSF_RECORD_ID, DSF_CHANGED_BY, DSF_CHANGED_TS, EQUNR, ERDAT, ERNAM, EQASP, AEDAT, AENAM, BEGRU, EQTYP, EQART, LVORM, INVNR, GROES, BRGEW, GEWEI, ANSDT, ANSWT, WAERS, ELIEF, GWLEN, GWLDT, WDBWT, HERST, HERLD, HZEIN, SERGE, TYPBZ, BAUJJ, BAUMM, APLKZ, AULDT, INBDT, GERNR, GWLDV, EQDAT, EQBER, EQNUM, OBJNR, EQSNR, CUOBJ, KRFKZ, KMATN, MATNR, SERNR, WERK, LAGER, CHARGE, KUNDE, WARPL, IMRC_POINT, REVLV, MGANR, BEGRUI, S_EQUI, S_SERIAL, S_KONFI, S_SALE, S_FHM, S_ELSE, S_ISU, S_EQBS, S_FLEET, BSTVP, SPARTE, HANDLE, TSEGTP, EMATN, ACT_CHANGE_AA, S_CC, DATLWB, DATBI, EQLFN, EQUZN, TIMBI, ESTAI, ESTAE, STNAM, DATAB, IWERK, IWERKI, SUBMT, MAPAR, HEQUI, HEQNR, INGRP, INGRPI, PM_OBJTY, GEWRK, GEWRKI, TIDNR, TIDNRI, ILOAN, KUND1, KUND2, KUND3, LIZNR, RBNR, EZDAT, EZBER, EZNUM, RBNR_I, IBLNR, BLDAT, PVS_FOCUS, PPEGUID, TECHS, FUNCID, FRCFIT, FRCRMV, SPRAS, EQKTX, KZLTX, TXASP, EQKTU, TPLNR, ABCKZ, ABCKZI, EQFNR, EQFNRI, SWERK, SWERKI, STORT, STORTI, MSGRP, MSGRPI, BEBER, BEBERI, CR_OBJTY, PPSID, PPSIDI, GSBER, GSBERI, KOKRS, KOKRSI, KOSTL, KOSTLI, PROID, PROIDI, BUKRS, BUKRSI, ANLNR, ANLNRI, ANLUN, ANLUNI, DAUFN, DAUFNI, AUFNR, AUFNRI, TPLNRI, VKORG, VKORGI, VTWEG, VTWEGI, SPART, SPARTI, ADRNR, ADRNRI, OWNER, VKBUR, VKGRP, LVORZ, ERNAZ, ERDAZ, AENAZ, AEDAZ, ARBPL_LOC, ARBPL_LOC_TEXT, ARBPL, ARBPL_TEXT, TYPTX, EARTX, STORT_TEXT, BEBER_TEXT, SYSTEM_STATUS, USER_STATUS, SYST_STATUS_CODE, USER_STATUS_CODE, TPLNR_EXT, LBBSA, B_WERK, B_LAGER, B_CHARGE, SOBKZ, KUNNR, LIFNR, KDAUF, KDPOS, PS_PSP_PNR, DISUB_OWNER FROM /SMERP/STG_PM001

TOP ERP 6.0 | /SMERP/STG_PM001 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	DSF_GUID	DSF GUID	nvarchar	32	0	CHAR	(N' ')	No		/SMFND/DSF_GUID_DTE	Allow NULL?
3	DSF_DSTORE_ID	Data Store ID	nvarchar	40	0	CHAR	(N' ')	Yes	*	/SMFND/DSF_DSTORE_ID_DTE	Allow NULL?
4	USER_GUID	User GUID	nvarchar	32	0	CHAR	(N' ')	Yes		/SYCLO/CORE_USER_GUID_DTE	Allow NULL?
5	DSF_RECORD_ID	DSF Record ID	nvarchar	10	0	NUMC	(N'0000000000')	Yes		/SMFND/DSF_RECORD_ID_DTE	Allow NULL?
6	DSF_CHANGED_BY	Last Changed By	nvarchar	12	0	CHAR	(N' ')	Yes		/SYCLO/CORE_CHANGEDBY_DTE	Allow NULL?
7	DSF_CHANGED_TS	Changed time stamp	decimal	15	0	DEC	((0))	Yes		/SYCLO/CORE_CHANGEDTS_DTE
8	EQUNR	Equipment Number	nvarchar	18	0	CHAR	(N' ')	Yes	*	EQUNR	Allow NULL?
9	ERDAT	Date on Which Record Was Created	nvarchar	8	0	DATS	(N'00000000')	Yes		ERDAT	Allow NULL?
10	ERNAM	Name of Person who Created the Object	nvarchar	12	0	CHAR	(N' ')	Yes		ERNAM	Allow NULL?
11	EQASP	Language in Which the Piece of Equipment was Entered	char	1	0	LANG	(N' ')	Yes	T002	EQASP	Allow NULL?
12	AEDAT	Changed On	nvarchar	8	0	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
13	AENAM	Name of Person Who Changed Object	nvarchar	12	0	CHAR	(N' ')	Yes		AENAM	Allow NULL?
14	BEGRU	Technical object authorization group	nvarchar	4	0	CHAR	(N' ')	Yes	T370B	IAUTG	Allow NULL?
15	EQTYP	Equipment category	char	1	0	CHAR	(N' ')	Yes	T370T	EQTYP	Allow NULL?
16	EQART	Type of Technical Object	nvarchar	10	0	CHAR	(N' ')	Yes	T370K	EQART	Allow NULL?
17	LVORM	SAP Development Reserve: Format CHAR, Length 1	char	1	0	CHAR	(N' ')	Yes		RESERVE_CHAR_001	Allow NULL?
18	INVNR	Inventory number	nvarchar	25	0	CHAR	(N' ')	Yes		INVNR	Allow NULL?
19	GROES	Size/dimension	nvarchar	18	0	CHAR	(N' ')	Yes		GROSS	Allow NULL?
20	BRGEW	Weight of object	decimal	13	3	QUAN	((0))	Yes		OBJ_WEIGHT
21	GEWEI	Unit of weight	nvarchar	3	0	UNIT	(N' ')	Yes	T006	WEIGHT_UNIT	Allow NULL?
22	ANSDT	Acquisition date	nvarchar	8	0	DATS	(N'00000000')	Yes		ANDTI	Allow NULL?
23	ANSWT	Acquisition Value	decimal	13	2	CURR	((0))	Yes		ANSWT
24	WAERS	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
25	ELIEF	Vendor number	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	ELIEF	Allow NULL?
26	GWLEN	Date on which the warranty ends	nvarchar	8	0	DATS	(N'00000000')	Yes		GWLEN	Allow NULL?
27	GWLDT	Warranty Date	nvarchar	8	0	DATS	(N'00000000')	Yes		GWLDT	Allow NULL?
28	WDBWT	Equipment replacement value	decimal	13	2	CURR	((0))	Yes		WDBWT
29	HERST	Manufacturer of asset	nvarchar	30	0	CHAR	(N' ')	Yes		HERST	Allow NULL?
30	HERLD	Country of manufacture	nvarchar	3	0	CHAR	(N' ')	Yes	T005	HERLD	Allow NULL?
31	HZEIN	Manufacturer drawing number	nvarchar	30	0	CHAR	(N' ')	Yes		HZEIN	Allow NULL?
32	SERGE	Manufacturer serial number	nvarchar	30	0	CHAR	(N' ')	Yes		SERGE	Allow NULL?
33	TYPBZ	Manufacturer model number	nvarchar	20	0	CHAR	(N' ')	Yes		TYPBZ	Allow NULL?
34	BAUJJ	Year of construction	nvarchar	4	0	CHAR	(N' ')	Yes		BAUJJ	Allow NULL?
35	BAUMM	Month of construction	nvarchar	2	0	CHAR	(N' ')	Yes		BAUMM	Allow NULL?
36	APLKZ	Indicator: Task List Exists	char	1	0	CHAR	(N' ')	Yes		APLKZ	Allow NULL?
37	AULDT	First delivery date of the equipment	nvarchar	8	0	DATS	(N'00000000')	Yes		AULDT	Allow NULL?
38	INBDT	Start-up Date of the Technical Object	nvarchar	8	0	DATS	(N'00000000')	Yes		ILOM_DATAB	Allow NULL?
39	GERNR	Serial Number	nvarchar	18	0	CHAR	(N' ')	Yes		GERNR	Allow NULL?
40	GWLDV	Warranty date for Sales and Distribution	nvarchar	8	0	DATS	(N'00000000')	Yes		GWLDV	Allow NULL?
41	EQDAT	Date, intended for SAP internal use	nvarchar	8	0	DATS	(N'00000000')	Yes		EQDAT	Allow NULL?
42	EQBER	Technical information, intended for SAP internal use	nvarchar	30	0	CHAR	(N' ')	Yes		EQBER	Allow NULL?
43	EQNUM	Numerical field, intended for SAP internal use	nvarchar	9	0	NUMC	(N'000000000')	Yes		EQNUM	Allow NULL?
44	OBJNR	Object number	nvarchar	22	0	CHAR	(N' ')	Yes	*	J_OBJNR	Allow NULL?
45	EQSNR	EQSE Number	nvarchar	18	0	CHAR	(N' ')	Yes	EQSE	EQSNR	Allow NULL?
46	CUOBJ	Configuration (internal object number)	nvarchar	18	0	NUMC	(N'000000000000000000')	Yes		CUOBJ	Allow NULL?
47	KRFKZ	Referenced Configuration	char	1	0	CHAR	(N' ')	Yes		KRFKZ	Allow NULL?
48	KMATN	Configurable Material	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	KMATN	Allow NULL?
49	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	MATNR	Allow NULL?
50	SERNR	Serial Number	nvarchar	18	0	CHAR	(N' ')	Yes		GERNR	Allow NULL?
51	WERK	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	WERKS_D	Allow NULL?
52	LAGER	Storage Location	nvarchar	4	0	CHAR	(N' ')	Yes	T001L	LGORT_D	Allow NULL?
53	CHARGE	Batch Number	nvarchar	10	0	CHAR	(N' ')	Yes	MCH1	CHARG_D	Allow NULL?
54	KUNDE	Customer to Whom Serial Number was Delivered	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	KUNDSE	Allow NULL?
55	WARPL	Maintenance Plan	nvarchar	12	0	CHAR	(N' ')	Yes	MPLA	WARPL	Allow NULL?
56	IMRC_POINT	Measuring Point	nvarchar	12	0	CHAR	(N' ')	Yes	IMPTT	IMRC_POINT	Allow NULL?
57	REVLV	Revision Level	nvarchar	2	0	CHAR	(N' ')	Yes		REVLV	Allow NULL?
58	MGANR	Master warranty number	nvarchar	20	0	CHAR	(N' ')	Yes	BGMK	MGANR	Allow NULL?
59	BEGRUI	Data origin for authorization group field	char	1	0	CHAR	(N' ')	Yes		INH_BEGRUI	Allow NULL?
60	S_EQUI	Equipment data exists	char	1	0	CHAR	(N' ')	Yes		EQUIP_KNZ	Allow NULL?
61	S_SERIAL	Serial data when maintaining equipment	char	1	0	CHAR	(N' ')	Yes		KZKSD	Allow NULL?
62	S_KONFI	Configuration supported	char	1	0	CHAR	(N' ')	Yes		KONFKNZ	Allow NULL?
63	S_SALE	Sales equipment	char	1	0	CHAR	(N' ')	Yes		SDKNZ	Allow NULL?
64	S_FHM	Equip. category relevant to production resources and tools	char	1	0	CHAR	(N' ')	Yes		FHMKZ	Allow NULL?
65	S_ELSE	Indicator: Other Data Active	char	1	0	CHAR	(N' ')	Yes		ELSE_KNZ	Allow NULL?
66	S_ISU	IS-U data	char	1	0	CHAR	(N' ')	Yes		ISU_KNZ	Allow NULL?
67	S_EQBS	EQSI Exists	char	1	0	CHAR	(N' ')	Yes		KZEQBS	Allow NULL?
68	S_FLEET	Indicator: Fleet object active	char	1	0	CHAR	(N' ')	Yes		FLEET_KNZ	Allow NULL?
69	BSTVP	Stock Check for Serial Numbers	char	1	0	CHAR	(N' ')	Yes		BSTVP	Allow NULL?
70	SPARTE	Division	nvarchar	2	0	CHAR	(N' ')	Yes	TSPA	SPARTE	Allow NULL?
71	HANDLE	SAP Development Reserve: Integration of Date Segment (Key)	nvarchar	22	0	CHAR	(N' ')	Yes		ITOBTMP_TSEGGUID	Allow NULL?
72	TSEGTP	SAP Development Reserve: Integration Date Segment (Tempate)	nvarchar	10	0	CHAR	(N' ')	Yes	*	ITOBTMP_TSEGTEMPLA	Allow NULL?
73	EMATN	Material Number Corresponding to Manufacturer Part Number	nvarchar	18	0	CHAR	(N' ')	Yes	*	EMATN	Allow NULL?
74	ACT_CHANGE_AA	Change Equipment Master when Changing Asset	char	1	0	CHAR	(N' ')	Yes		AAPM_ACT_CHANGE_AA	Allow NULL?
75	S_CC	Configuration Control Data	char	1	0	CHAR	(N' ')	Yes		CCC_KNZ	Allow NULL?
76	DATLWB	Date of Last Goods Movement	nvarchar	8	0	DATS	(N'00000000')	Yes		DATLWB	Allow NULL?
77	DATBI	Valid To Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATBI	Allow NULL?
78	EQLFN	Consecutive numbering of EquipUsagePeriods on same day	nvarchar	3	0	NUMC	(N'000')	Yes		EQLFN	Allow NULL?
79	EQUZN	Number of next EquipUsagePeriod on same day	nvarchar	3	0	NUMC	(N'000')	Yes		EQNNR	Allow NULL?
80	TIMBI	Equipment usage period time stamp	nvarchar	6	0	TIMS	(N'000000')	Yes		TIMBI	Allow NULL?
81	ESTAI	SAP Development Reserve: Format CHAR, Length 1	char	1	0	CHAR	(N' ')	Yes		RESERVE_CHAR_001	Allow NULL?
82	ESTAE	SAP Development reserve: Format CHAR, length 4	nvarchar	4	0	CHAR	(N' ')	Yes		RESERVE_CHAR_004	Allow NULL?
83	STNAM	SAP Development Reserve: Format CHAR, Length 12	nvarchar	12	0	CHAR	(N' ')	Yes		RESERVE_CHAR_012	Allow NULL?
84	DATAB	Valid-From Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATAB	Allow NULL?
85	IWERK	Maintenance Planning Plant	nvarchar	4	0	CHAR	(N' ')	Yes	*	IWERK	Allow NULL?
86	IWERKI	Data origin indicator	char	1	0	CHAR	(N' ')	Yes		INHER	Allow NULL?
87	SUBMT	Construction type material of the object	nvarchar	18	0	CHAR	(N' ')	Yes	*	SUBMT	Allow NULL?
88	MAPAR	Manufacturer part number	nvarchar	30	0	CHAR	(N' ')	Yes		MAPAR	Allow NULL?
89	HEQUI	Superordinate Equipment	nvarchar	18	0	CHAR	(N' ')	Yes	*	HEQUI	Allow NULL?
90	HEQNR	Equipment position at InstallLoc (Superior Equip./FunctLoc)	nvarchar	4	0	CHAR	(N' ')	Yes		HEQNR	Allow NULL?
91	INGRP	Planner Group for Customer Service and Plant Maintenance	nvarchar	3	0	CHAR	(N' ')	Yes	*	INGRP	Allow NULL?
92	INGRPI	Data origin indicator	char	1	0	CHAR	(N' ')	Yes		INHER	Allow NULL?
93	PM_OBJTY	Object Type of CIM Resources for Work Center	nvarchar	2	0	CHAR	(N' ')	Yes		PM_OBJTY	Allow NULL?
94	GEWRK	Object ID of the Work Center	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	LGWID	Allow NULL?
95	GEWRKI	Data origin indicator	char	1	0	CHAR	(N' ')	Yes		INHER	Allow NULL?
96	TIDNR	Technical identification number	nvarchar	25	0	CHAR	(N' ')	Yes		TIDNR	Allow NULL?
97	TIDNRI	Data origin indicator	char	1	0	CHAR	(N' ')	Yes		INHER	Allow NULL?
98	ILOAN	Location and account assignment for technical object	nvarchar	12	0	CHAR	(N' ')	Yes	*	ILOAN	Allow NULL?
99	KUND1	Customer number	nvarchar	10	0	CHAR	(N' ')	Yes	*	KUND1	Allow NULL?
100	KUND2	End customer number	nvarchar	10	0	CHAR	(N' ')	Yes	*	KUND2	Allow NULL?
101	KUND3	Operator	nvarchar	10	0	CHAR	(N' ')	Yes	*	KUND3	Allow NULL?
102	LIZNR	Equipment license number	nvarchar	20	0	CHAR	(N' ')	Yes		LIZNR	Allow NULL?
103	RBNR	Catalog Profile	nvarchar	9	0	CHAR	(N' ')	Yes	*	RBNR	Allow NULL?
104	EZDAT	Date, intended for SAP internal use	nvarchar	8	0	DATS	(N'00000000')	Yes		EQDAT	Allow NULL?
105	EZBER	Technical information, intended for SAP internal use	nvarchar	30	0	CHAR	(N' ')	Yes		EQBER	Allow NULL?
106	EZNUM	Numerical field, intended for SAP internal use	nvarchar	9	0	NUMC	(N'000000000')	Yes		EQNUM	Allow NULL?
107	RBNR_I	Data origin indicator	char	1	0	CHAR	(N' ')	Yes		INHER	Allow NULL?
108	IBLNR	Physical Inventory Document	nvarchar	10	0	CHAR	(N' ')	Yes		IBLNR	Allow NULL?
109	BLDAT	Document Date in Document	nvarchar	8	0	DATS	(N'00000000')	Yes		BLDAT	Allow NULL?
110	PVS_FOCUS	Internal Identification for PVS Objects	varbinary	16	0	RAW		Yes		PVS_GUID_CCC
111	PPEGUID	Internal Identification for PVS Objects	varbinary	16	0	RAW		Yes		PVS_GUID_CCC
112	TECHS	Parameter Variant/Standard Variant	nvarchar	12	0	CHAR	(N' ')	Yes		TECHS	Allow NULL?
113	FUNCID	Function Identifier	nvarchar	40	0	CHAR	(N' ')	Yes		CCC_FUNCID	Allow NULL?
114	FRCFIT	Indicator: Forced Installation/Dismantling	char	1	0	CHAR	(N' ')	Yes		CCC_FRCFIT	Allow NULL?
115	FRCRMV	Force Dismantling Flag	char	1	0	CHAR	(N' ')	Yes		CCC_FRCRMV	Allow NULL?
116	SPRAS	Language Key	char	1	0	LANG	(N' ')	Yes	*	SPRAS	Allow NULL?
117	EQKTX	Description of technical object	nvarchar	40	0	CHAR	(N' ')	Yes		KTX01	Allow NULL?
118	KZLTX	Long Text Indicator	char	1	0	CHAR	(N' ')	Yes		KZLTA	Allow NULL?
119	TXASP	Primary language indicator for text segment	char	1	0	CHAR	(N' ')	Yes		KZMLA	Allow NULL?
120	EQKTU	Equipment description in capital letters	nvarchar	40	0	CHAR	(N' ')	Yes		EQKTU	Allow NULL?
121	TPLNR	Functional Location	nvarchar	30	0	CHAR	(N' ')	Yes	*	TPLNR	Allow NULL?
122	ABCKZ	ABC indicator for technical object	char	1	0	CHAR	(N' ')	Yes	*	ABCKZ	Allow NULL?
123	ABCKZI	Data origin for ABC indicator field	char	1	0	CHAR	(N' ')	Yes		INH_ABCKZI	Allow NULL?
124	EQFNR	Sort field	nvarchar	30	0	CHAR	(N' ')	Yes		EQFNR	Allow NULL?
125	EQFNRI	Data origin for sort field	char	1	0	CHAR	(N' ')	Yes		INH_EQFNRI	Allow NULL?
126	SWERK	Maintenance plant	nvarchar	4	0	CHAR	(N' ')	Yes	*	SWERK	Allow NULL?
127	SWERKI	Data origin for maintenance plant field	char	1	0	CHAR	(N' ')	Yes		INH_SWERKI	Allow NULL?
128	STORT	Location of maintenance object	nvarchar	10	0	CHAR	(N' ')	Yes	*	PMLOC	Allow NULL?
129	STORTI	Data origin for location field	char	1	0	CHAR	(N' ')	Yes		INH_STORTI	Allow NULL?
130	MSGRP	Room	nvarchar	8	0	CHAR	(N' ')	Yes		RAUMNR	Allow NULL?
131	MSGRPI	Data origin for room number field	char	1	0	CHAR	(N' ')	Yes		INH_MSGRPI	Allow NULL?
132	BEBER	Plant section	nvarchar	3	0	CHAR	(N' ')	Yes	*	BEBER	Allow NULL?
133	BEBERI	Data origin for plant section field	char	1	0	CHAR	(N' ')	Yes		INH_BEBERI	Allow NULL?
134	CR_OBJTY	Object types of the CIM resource	nvarchar	2	0	CHAR	(N' ')	Yes		CR_OBJTY	Allow NULL?
135	PPSID	Object ID of PP work center	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	PPSID	Allow NULL?
136	PPSIDI	Data origin for PP work center field	char	1	0	CHAR	(N' ')	Yes		INH_PPSIDI	Allow NULL?
137	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	*	GSBER	Allow NULL?
138	GSBERI	Data origin for business area field	char	1	0	CHAR	(N' ')	Yes		INH_GSBERI	Allow NULL?
139	KOKRS	Controlling Area	nvarchar	4	0	CHAR	(N' ')	Yes	*	KOKRS	Allow NULL?
140	KOKRSI	Data origin for controlling area field	char	1	0	CHAR	(N' ')	Yes		INH_KOKRSI	Allow NULL?
141	KOSTL	Cost Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	KOSTL	Allow NULL?
142	KOSTLI	Data origin for cost center field	char	1	0	CHAR	(N' ')	Yes		INH_KOSTLI	Allow NULL?
143	PROID	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	PS_PSP_PNR	Allow NULL?
144	PROIDI	Data origin for WBS element field	char	1	0	CHAR	(N' ')	Yes		INH_PROIDI	Allow NULL?
145	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	*	BUKRS	Allow NULL?
146	BUKRSI	Data origin for company code field	char	1	0	CHAR	(N' ')	Yes		INH_BUKRSI	Allow NULL?
147	ANLNR	Main Asset Number	nvarchar	12	0	CHAR	(N' ')	Yes	*	ANLN1	Allow NULL?
148	ANLNRI	Data origin for asset main no./sub-no. fields	char	1	0	CHAR	(N' ')	Yes		INH_ANLNRI	Allow NULL?
149	ANLUN	Asset Subnumber	nvarchar	4	0	CHAR	(N' ')	Yes	*	ANLN2	Allow NULL?
150	ANLUNI	Data origin indicator	char	1	0	CHAR	(N' ')	Yes		INHER	Allow NULL?
151	DAUFN	Standing order number	nvarchar	12	0	CHAR	(N' ')	Yes	*	DAUFN	Allow NULL?
152	DAUFNI	Data origin of standing order number field	char	1	0	CHAR	(N' ')	Yes		INH_DAUFNI	Allow NULL?
153	AUFNR	Settlement order	nvarchar	12	0	CHAR	(N' ')	Yes	*	ILOM_ORDST	Allow NULL?
154	AUFNRI	Data origin for settlement order field	char	1	0	CHAR	(N' ')	Yes		INH_AUFNRI	Allow NULL?
155	TPLNRI	Data origin for functional location field	char	1	0	CHAR	(N' ')	Yes		INH_TPLNRI	Allow NULL?
156	VKORG	Sales Organization	nvarchar	4	0	CHAR	(N' ')	Yes	*	VKORG	Allow NULL?
157	VKORGI	Data origin for sales organization field	char	1	0	CHAR	(N' ')	Yes		INH_VKORGI	Allow NULL?
158	VTWEG	Distribution Channel	nvarchar	2	0	CHAR	(N' ')	Yes	*	VTWEG	Allow NULL?
159	VTWEGI	Data origin of distribution channel field	char	1	0	CHAR	(N' ')	Yes		INH_VTWEGI	Allow NULL?
160	SPART	Division	nvarchar	2	0	CHAR	(N' ')	Yes	*	SPART	Allow NULL?
161	SPARTI	Data origin for division field	char	1	0	CHAR	(N' ')	Yes		INH_SPARTI	Allow NULL?
162	ADRNR	Address number	nvarchar	10	0	CHAR	(N' ')	Yes	*	AD_ADDRNUM	Allow NULL?
163	ADRNRI	Data origin for address field	char	1	0	CHAR	(N' ')	Yes		INH_ADRNRI	Allow NULL?
164	OWNER	Object reference indicator	char	1	0	CHAR	(N' ')	Yes		ILOM_OWNER	Allow NULL?
165	VKBUR	Sales Office	nvarchar	4	0	CHAR	(N' ')	Yes	*	VKBUR	Allow NULL?
166	VKGRP	Sales Group	nvarchar	3	0	CHAR	(N' ')	Yes	*	VKGRP	Allow NULL?
167	LVORZ	SAP Development Reserve: Format CHAR, Length 1	char	1	0	CHAR	(N' ')	Yes		RESERVE_CHAR_001	Allow NULL?
168	ERNAZ	Name of Person who Created the Object	nvarchar	12	0	CHAR	(N' ')	Yes		ERNAM	Allow NULL?
169	ERDAZ	Date on Which Record Was Created	nvarchar	8	0	DATS	(N'00000000')	Yes		ERDAT	Allow NULL?
170	AENAZ	Name of Person Who Changed Object	nvarchar	12	0	CHAR	(N' ')	Yes		AENAM	Allow NULL?
171	AEDAZ	Changed On	nvarchar	8	0	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
172	ARBPL_LOC	Work center	nvarchar	8	0	CHAR	(N' ')	Yes		ARBPL	Allow NULL?
173	ARBPL_LOC_TEXT	Short description	nvarchar	40	0	CHAR	(N' ')	Yes		CR_KTEXT	Allow NULL?
174	ARBPL	Work center	nvarchar	8	0	CHAR	(N' ')	Yes		ARBPL	Allow NULL?
175	ARBPL_TEXT	Short description	nvarchar	40	0	CHAR	(N' ')	Yes		CR_KTEXT	Allow NULL?
176	TYPTX	Equipment category description	nvarchar	30	0	CHAR	(N' ')	Yes		ETYTX	Allow NULL?
177	EARTX	Text for Object Type	nvarchar	20	0	CHAR	(N' ')	Yes		EARTX	Allow NULL?
178	STORT_TEXT	Text, length 40	nvarchar	40	0	CHAR	(N' ')	Yes		TXT40	Allow NULL?
179	BEBER_TEXT	Text, length 40	nvarchar	40	0	CHAR	(N' ')	Yes		TXT40	Allow NULL?
180	SYSTEM_STATUS	Display lines for system status	nvarchar	40	0	CHAR	(N' ')	Yes		ILOM_STTXS	Allow NULL?
181	USER_STATUS	Display lines for user status	nvarchar	40	0	CHAR	(N' ')	Yes		ILOM_STTXU	Allow NULL?
182	SYST_STATUS_CODE	Text	nvarchar	50	0	CHAR	(N' ')	Yes		TXT50	Allow NULL?
183	USER_STATUS_CODE	Text	nvarchar	50	0	CHAR	(N' ')	Yes		TXT50	Allow NULL?
184	TPLNR_EXT		nvarchar	40	0		(N' ')	Yes			Allow NULL?
185	LBBSA	Stock Type of Goods Movement (Primary Posting)	nvarchar	2	0	CHAR	(N' ')	Yes	T156C	LBBSA	Allow NULL?
186	B_WERK	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	*	WERKS_D	Allow NULL?
187	B_LAGER	Storage Location	nvarchar	4	0	CHAR	(N' ')	Yes	*	LGORT_D	Allow NULL?
188	B_CHARGE	Batch Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	B_CHARGE	Allow NULL?
189	SOBKZ	Special Stock Indicator	char	1	0	CHAR	(N' ')	Yes	*	SOBKZ	Allow NULL?
190	KUNNR	Customer account number	nvarchar	10	0	CHAR	(N' ')	Yes	*	B_KUNNR	Allow NULL?
191	LIFNR	Account number of the vendor	nvarchar	10	0	CHAR	(N' ')	Yes	*	B_LIFNR	Allow NULL?
192	KDAUF	Sales Order Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	KDAUF	Allow NULL?
193	KDPOS	Item Number in Sales Order	nvarchar	6	0	NUMC	(N'000000')	Yes		KDPOS	Allow NULL?
194	PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	PS_PSP_PNR	Allow NULL?
195	DISUB_OWNER	Owner of stock	nvarchar	10	0	CHAR	(N' ')	Yes	*	OWNER_D	Allow NULL?

TOP ERP 6.0 | /SMERP/STG_PM001 INDEXES

Name	Primary	Unique	Type	Columns
/SMERP/STG_PM00100	No	No	NONCLUSTERED	DSF_RECORD_ID, MANDT
/SMERP/STG_PM001A0	No	No	NONCLUSTERED	DSF_DSTORE_ID, MANDT
/SMERP/STG_PM001~0	Yes	Yes	CLUSTERED	DSF_GUID, 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

195 COLUMNS | 3 INDEXES | ERP 6.0 | /SMERP/STG_PM001 TABLE

TOP ERP 6.0 | /SMERP/STG_PM001 COLUMNS

TOP ERP 6.0 | /SMERP/STG_PM001 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

195 COLUMNS | 3 INDEXES | ERP 6.0 | /SMERP/STG_PM001 TABLE

TOPERP 6.0 | /SMERP/STG_PM001 COLUMNS

TOPERP 6.0 | /SMERP/STG_PM001 INDEXES

TOP ERP 6.0 | /SMERP/STG_PM001 COLUMNS

TOP ERP 6.0 | /SMERP/STG_PM001 INDEXES