	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	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
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

ORDER_HDR TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Cross-Application Components :: General Application Functions :: Technical Application Support :: Postprocessing Office
1	ERP EHP7	6.0	/SAPPO/ORDER_HDR	86	7	Postprocessing Order - Header Data	Postprocessing Office

SQL: selectupdate insert create

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

SELECT MANDT, ORDER_ID, COMPONENT, BUSINESS_PROCESS, BUSINESS_PROC_ID, MAIN_OBJCAT, MAIN_OBJTYPE, MAIN_OBJKEY, MAIN_OBJLOGSYS, BASIC_OBJCAT, BASIC_OBJTYPE, BASIC_OBJKEY, BASIC_OBJLOGSYS, ENV1_OBJCAT, ENV1_OBJTYPE, ENV1_OBJKEY, ENV1_OBJLOGSYS, ENV2_OBJCAT, ENV2_OBJTYPE, ENV2_OBJKEY, ENV2_OBJLOGSYS, MSGID, MSGTY, MSGNO, MSGV1, MSGV2, MSGV3, MSGV4, LOG_CAT, LOG_NO, LOG_HANDLE, LOG_MSG_NO, BAPI_PARAMETER, BAPI_ROW, BAPI_FIELD, MSG_OBJCAT, MSG_OBJTYPE, MSG_OBJKEY, MSG_OBJLOGSYS, STATUS, TEXT, PROCESSOR, POSTDATE, CREATIONDATE, PROCMETH, PRIORITY, WORKLIST, PROCESS, HASH_1, HASH_2, ERROR_CATEGORY, CLOSING_TYPE, EARLIEST_MANUAL, RETRY_CLASS, RETRY_MODE, RETRY_GROUP, EARLIEST_RETRY, FINISH_CLASS, FAIL_CLASS, FAIL_MODE, EARLIEST_CMPLTN, EARLIEST_CMPDAT, EARLIEST_CMPTIME, ADD1_CLASS, ADD2_CLASS, FA_AMNT, FA_CURR, FA1, FA2, FA3, FA4, FA5, FA6, USER_CREATE, TIMESTAMP_CREATE, USER_CHANGE, TIMESTAMP_CHANGE, ARCHIVE_STATUS, ARCHIVE_FLUD, REJECTION, FLG_WF, MORE_MSG, MORE_OBJ, MORE_DATA, ABAP_TYPEKIND, PK FROM /SAPPO/ORDER_HDR

TOP ERP 6.0 | /SAPPO/ORDER_HDR 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	ORDER_ID	Order ID	varbinary	16	0	RAW		No		/SAPPO/DTE_ORDER_ID
3	COMPONENT	Software Component	nvarchar	30	0	CHAR	(N' ')	Yes		/SAPPO/DTE_COMPONENT	Allow NULL?
4	BUSINESS_PROCESS	Business Process	nvarchar	10	0	CHAR	(N' ')	Yes		/SAPPO/DTE_BUSINESS_PROCESS	Allow NULL?
5	BUSINESS_PROC_ID	Business Process ID	nvarchar	100	0	CHAR	(N' ')	Yes		/SAPPO/DTE_BUSINESS_PROCESS_ID	Allow NULL?
6	MAIN_OBJCAT	Main Object Category	char	1	0	NUMC	(N'0')	Yes		/SAPPO/DTE_MAIN_OBJCAT	Allow NULL?
7	MAIN_OBJTYPE	Main Object Type	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPPO/DTE_MAIN_OBJTYPE	Allow NULL?
8	MAIN_OBJKEY	Main Object Key	nvarchar	70	0	CHAR	(N' ')	Yes		/SAPPO/DTE_MAIN_OBJKEY	Allow NULL?
9	MAIN_OBJLOGSYS	Logical System: Main Object	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPPO/DTE_MAIN_OBJLOGSYS	Allow NULL?
10	BASIC_OBJCAT	Base Object Category	char	1	0	NUMC	(N'0')	Yes		/SAPPO/DTE_BASIC_OBJCAT	Allow NULL?
11	BASIC_OBJTYPE	Base Object Type	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPPO/DTE_BASIC_OBJTYPE	Allow NULL?
12	BASIC_OBJKEY	Base Object Key	nvarchar	70	0	CHAR	(N' ')	Yes		/SAPPO/DTE_BASIC_OBJKEY	Allow NULL?
13	BASIC_OBJLOGSYS	Base Object for Logical System	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPPO/DTE_BASIC_OBJLOGSYS	Allow NULL?
14	ENV1_OBJCAT	Related Object 1 Category	char	1	0	NUMC	(N'0')	Yes		/SAPPO/DTE_ENV1_OBJCAT	Allow NULL?
15	ENV1_OBJTYPE	Related Object Type 1	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPPO/DTE_ENV1_OBJTYPE	Allow NULL?
16	ENV1_OBJKEY	Related Object Key 1	nvarchar	70	0	CHAR	(N' ')	Yes		/SAPPO/DTE_ENV1_OBJKEY	Allow NULL?
17	ENV1_OBJLOGSYS	Related Object 1 for Logical System	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPPO/DTE_ENV1_OBJLOGSYS	Allow NULL?
18	ENV2_OBJCAT	Related Object Category 2	char	1	0	NUMC	(N'0')	Yes		/SAPPO/DTE_ENV2_OBJCAT	Allow NULL?
19	ENV2_OBJTYPE	Related Object Type 2	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPPO/DTE_ENV2_OBJTYPE	Allow NULL?
20	ENV2_OBJKEY	Related Object Key 2	nvarchar	70	0	CHAR	(N' ')	Yes		/SAPPO/DTE_ENV2_OBJKEY	Allow NULL?
21	ENV2_OBJLOGSYS	Related Object 2 for Logical System	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPPO/DTE_ENV2_OBJLOGSYS	Allow NULL?
22	MSGID	Message Class	nvarchar	20	0	CHAR	(N' ')	Yes	*	SYMSGID	Allow NULL?
23	MSGTY	Message Type	char	1	0	CHAR	(N' ')	Yes		SYMSGTY	Allow NULL?
24	MSGNO	Message Number	nvarchar	3	0	NUMC	(N'000')	Yes		SYMSGNO	Allow NULL?
25	MSGV1	Message Variable	nvarchar	50	0	CHAR	(N' ')	Yes		SYMSGV	Allow NULL?
26	MSGV2	Message Variable	nvarchar	50	0	CHAR	(N' ')	Yes		SYMSGV	Allow NULL?
27	MSGV3	Message Variable	nvarchar	50	0	CHAR	(N' ')	Yes		SYMSGV	Allow NULL?
28	MSGV4	Message Variable	nvarchar	50	0	CHAR	(N' ')	Yes		SYMSGV	Allow NULL?
29	LOG_CAT	Log Category	char	1	0	NUMC	(N'0')	Yes		/SAPPO/DTE_LOG_CAT	Allow NULL?
30	LOG_NO	Log Number	nvarchar	20	0	CHAR	(N' ')	Yes		/SAPPO/DTE_LOG_NO	Allow NULL?
31	LOG_HANDLE	Log Handle	nvarchar	22	0	CHAR	(N' ')	Yes		/SAPPO/DTE_LOG_HANDLE	Allow NULL?
32	LOG_MSG_NO	ID in Log	nvarchar	6	0	NUMC	(N'000000')	Yes		/SAPPO/DTE_LOG_MSG_NO	Allow NULL?
33	BAPI_PARAMETER	Parameter Name	nvarchar	32	0	CHAR	(N' ')	Yes		BAPI_PARAM	Allow NULL?
34	BAPI_ROW	Lines in parameter	int	10	0	INT4	((0))	Yes		BAPI_LINE	Allow NULL?
35	BAPI_FIELD	Field in parameter	nvarchar	30	0	CHAR	(N' ')	Yes	*	BAPI_FLD	Allow NULL?
36	MSG_OBJCAT	Message Object Category	char	1	0	NUMC	(N'0')	Yes		/SAPPO/DTE_MSG_OBJCAT	Allow NULL?
37	MSG_OBJTYPE	Message Object Type	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPPO/DTE_MSG_OBJTYPE	Allow NULL?
38	MSG_OBJKEY	Message Object Key	nvarchar	70	0	CHAR	(N' ')	Yes		/SAPPO/DTE_MSG_OBJKEY	Allow NULL?
39	MSG_OBJLOGSYS	Logical System: Message Object	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPPO/DTE_MSG_OBJLOGSYS	Allow NULL?
40	STATUS	Order Status	char	1	0	CHAR	(N' ')	Yes		/SAPPO/DTE_STATUS	Allow NULL?
41	TEXT	Comment	nvarchar	50	0	CHAR	(N' ')	Yes		/SAPPO/DTE_TEXT	Allow NULL?
42	PROCESSOR	Current Processor	nvarchar	12	0	CHAR	(N' ')	Yes		/SAPPO/DTE_PROCESSOR	Allow NULL?
43	POSTDATE	Posting Date	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPPO/DTE_POSTDATE	Allow NULL?
44	CREATIONDATE	Created On	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPPO/DTE_CREATIONDATE	Allow NULL?
45	PROCMETH	Mode of Postprocessing Order	char	1	0	NUMC	(N'0')	Yes		/SAPPO/DTE_PROCMETH	Allow NULL?
46	PRIORITY	Priority	char	1	0	NUMC	(N'0')	Yes		/SAPPO/DTE_PRIORITY	Allow NULL?
47	WORKLIST	Worklist	nvarchar	4	0	CHAR	(N' ')	Yes	/SAPPO/WL	/SAPPO/DTE_WORKLIST	Allow NULL?
48	PROCESS	Process	char	1	0	NUMC	(N'0')	Yes		/SAPPO/DTE_PROCESS	Allow NULL?
49	HASH_1	Hash Value: Same Messages	varbinary	16	0	RAW		Yes		/SAPPO/DTE_HASH_1
50	HASH_2	Hash Value: Same Message Sequence	varbinary	16	0	RAW		Yes		/SAPPO/DTE_HASH_2
51	ERROR_CATEGORY	Error Category	nvarchar	15	0	CHAR	(N' ')	Yes	/SAPPO/SERR_CAT	/SAPPO/DTE_ERROR_CATEGORY	Allow NULL?
52	CLOSING_TYPE	Order Closing Typ	nvarchar	2	0	NUMC	(N'00')	Yes		/SAPPO/DTE_CLOSING_TYPE	Allow NULL?
53	EARLIEST_MANUAL	Processing Permitted From	decimal	15	0	DEC	((0))	Yes		/SAPPO/DTE_PIT_EARLIEST_MANUAL
54	RETRY_CLASS	RETRY Class	nvarchar	30	0	CHAR	(N' ')	Yes		/SAPPO/DTE_RETRY_CLASS	Allow NULL?
55	RETRY_MODE	Retry Mode	char	1	0	NUMC	(N'0')	Yes		/SAPPO/DTE_RETRY_MODE	Allow NULL?
56	RETRY_GROUP	Retry Group	nvarchar	3	0	CHAR	(N' ')	Yes	/SAPPO/CRTRY_GRP	/SAPPO/DTE_RETRY_GROUP	Allow NULL?
57	EARLIEST_RETRY	Repeat Permitted From	decimal	15	0	DEC	((0))	Yes		/SAPPO/DTE_PIT_EARLIEST_RETRY
58	FINISH_CLASS	FINISH Class	nvarchar	30	0	CHAR	(N' ')	Yes		/SAPPO/DTE_FINISH_CLASS	Allow NULL?
59	FAIL_CLASS	FAIL Class	nvarchar	30	0	CHAR	(N' ')	Yes		/SAPPO/DTE_FAIL_CLASS	Allow NULL?
60	FAIL_MODE	Discard Mode	char	1	0	NUMC	(N'0')	Yes		/SAPPO/DTE_FAIL_MODE	Allow NULL?
61	EARLIEST_CMPLTN	Settlment Permitted From	decimal	15	0	DEC	((0))	Yes		/SAPPO/DTE_PIT_EARLIEST_CMPLTN
62	EARLIEST_CMPDAT	Obsolete: Settlment Permitted From	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPPO/TYP_P_EARLIEST_CMPDAT	Allow NULL?
63	EARLIEST_CMPTIME	Obsolete: Settlment Permitted From	nvarchar	6	0	TIMS	(N'000000')	Yes		/SAPPO/TYP_P_EARLIEST_CMPTIME	Allow NULL?
64	ADD1_CLASS	AddOn 1 Class	nvarchar	30	0	CHAR	(N' ')	Yes		/SAPPO/DTE_FUNCTION_CLASS1	Allow NULL?
65	ADD2_CLASS	AddOn2 Class	nvarchar	30	0	CHAR	(N' ')	Yes		/SAPPO/DTE_FUNCTION_CLASS2	Allow NULL?
66	FA_AMNT	Own Filter Attribute - Amount	decimal	23	2	CURR	((0))	Yes		/SAPPO/DTE_FA_AMNT
67	FA_CURR	Own Filter Attribute - Currency	nvarchar	5	0	CUKY	(N' ')	Yes		/SAPPO/DTE_FA_CURR	Allow NULL?
68	FA1	Own Filter Attribute 1	nvarchar	40	0	CHAR	(N' ')	Yes		/SAPPO/DTE_FA1	Allow NULL?
69	FA2	Own Filter Attribute 2	nvarchar	40	0	CHAR	(N' ')	Yes		/SAPPO/DTE_FA2	Allow NULL?
70	FA3	Own Filter Attribute 3	nvarchar	40	0	CHAR	(N' ')	Yes		/SAPPO/DTE_FA3	Allow NULL?
71	FA4	Own Filter Attribute 4	nvarchar	40	0	CHAR	(N' ')	Yes		/SAPPO/DTE_FA4	Allow NULL?
72	FA5	Own Filter Attribute 5	nvarchar	40	0	CHAR	(N' ')	Yes		/SAPPO/DTE_FA5	Allow NULL?
73	FA6	Own Filter Attribute 6	nvarchar	40	0	CHAR	(N' ')	Yes		/SAPPO/DTE_FA6	Allow NULL?
74	USER_CREATE	Created By	nvarchar	12	0	CHAR	(N' ')	Yes		/SAPPO/DTE_USER_CREATE	Allow NULL?
75	TIMESTAMP_CREATE	Create Time Stamp	decimal	21	7	DEC	((0))	Yes		/SAPPO/DTE_TIMESTAMP_CREATE
76	USER_CHANGE	Changed By	nvarchar	12	0	CHAR	(N' ')	Yes		/SAPPO/DTE_USER_CHANGE	Allow NULL?
77	TIMESTAMP_CHANGE	Change Time Stamp	decimal	21	7	DEC	((0))	Yes		/SAPPO/DTE_TIMESTAMP_CHANGE
78	ARCHIVE_STATUS		char	1	0		(N' ')	Yes			Allow NULL?
79	ARCHIVE_FLUD		nvarchar	8	0		(N'00000000')	Yes			Allow NULL?
80	REJECTION		nvarchar	2	0		(N' ')	Yes			Allow NULL?
81	FLG_WF	Workflow Active	char	1	0	CHAR	(N' ')	Yes		/SAPPO/DTE_WORKFLOW_ACTIVE	Allow NULL?
82	MORE_MSG	Additional Messages Exist	char	1	0	CHAR	(N' ')	Yes		/SAPPO/DTE_MORE_MSG	Allow NULL?
83	MORE_OBJ	Additional Objects Exist	char	1	0	CHAR	(N' ')	Yes		/SAPPO/DTE_MORE_OBJ	Allow NULL?
84	MORE_DATA	Additional Data Exists	char	1	0	CHAR	(N' ')	Yes		/SAPPO/DTE_MORE_DATA	Allow NULL?
85	ABAP_TYPEKIND	ABAP Category for Additional Data	char	1	0	CHAR	(N' ')	Yes		/SAPPO/DTE_ABAP_TYPEKIND	Allow NULL?
86	PK	Partitioning Key	varbinary	2	0	RAW		Yes		/SAPPO/DTE_PK

TOP ERP 6.0 | /SAPPO/ORDER_HDR INDEXES

Name	Primary	Unique	Type	Columns
/SAPPO/ORDER_HDR01	No	No	NONCLUSTERED	STATUS, COMPONENT, MANDT
/SAPPO/ORDER_HDR02	No	No	NONCLUSTERED	STATUS, MAIN_OBJLOGSYS, MAIN_OBJKEY, MAIN_OBJTYPE, MAIN_OBJCAT, MANDT
/SAPPO/ORDER_HDR03	No	No	NONCLUSTERED	STATUS, BASIC_OBJLOGSYS, BASIC_OBJKEY, BASIC_OBJTYPE, BASIC_OBJCAT, MANDT
/SAPPO/ORDER_HDR04	No	No	NONCLUSTERED	STATUS, ENV1_OBJLOGSYS, ENV1_OBJKEY, ENV1_OBJTYPE, ENV1_OBJCAT, MANDT
/SAPPO/ORDER_HDR05	No	No	NONCLUSTERED	STATUS, ENV2_OBJLOGSYS, ENV2_OBJKEY, ENV2_OBJTYPE, ENV2_OBJCAT, MANDT
/SAPPO/ORDER_HDR06	No	No	NONCLUSTERED	STATUS, PK, MANDT
/SAPPO/ORDER_HDR~0	Yes	Yes	CLUSTERED	ORDER_ID, 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

86 COLUMNS | 7 INDEXES | ERP 6.0 | /SAPPO/ORDER_HDR TABLE

TOP ERP 6.0 | /SAPPO/ORDER_HDR COLUMNS

TOP ERP 6.0 | /SAPPO/ORDER_HDR 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

86 COLUMNS | 7 INDEXES | ERP 6.0 | /SAPPO/ORDER_HDR TABLE

TOPERP 6.0 | /SAPPO/ORDER_HDR COLUMNS

TOPERP 6.0 | /SAPPO/ORDER_HDR INDEXES

TOP ERP 6.0 | /SAPPO/ORDER_HDR COLUMNS

TOP ERP 6.0 | /SAPPO/ORDER_HDR INDEXES