	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	BSEG	345	Accounting Document Segment
8	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
10	FMARCPAR	4	Parallelization of FMARC_BATCH

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

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

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	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	ORDER_ID	Order ID	varbinary	16	0
3	COMPONENT	Software Component	nvarchar	30	0	Allow NULL?
4	BUSINESS_PROCESS	Business Process	nvarchar	10	0	Allow NULL?
5	BUSINESS_PROC_ID	Business Process ID	nvarchar	100	0	Allow NULL?
6	MAIN_OBJCAT	Main Object Category	char	1	0	Allow NULL?
7	MAIN_OBJTYPE	Main Object Type	nvarchar	10	0	Allow NULL?
8	MAIN_OBJKEY	Main Object Key	nvarchar	70	0	Allow NULL?
9	MAIN_OBJLOGSYS	Logical System: Main Object	nvarchar	10	0	Allow NULL?
10	BASIC_OBJCAT	Base Object Category	char	1	0	Allow NULL?
11	BASIC_OBJTYPE	Base Object Type	nvarchar	10	0	Allow NULL?
12	BASIC_OBJKEY	Base Object Key	nvarchar	70	0	Allow NULL?
13	BASIC_OBJLOGSYS	Base Object for Logical System	nvarchar	10	0	Allow NULL?
14	ENV1_OBJCAT	Related Object 1 Category	char	1	0	Allow NULL?
15	ENV1_OBJTYPE	Related Object Type 1	nvarchar	10	0	Allow NULL?
16	ENV1_OBJKEY	Related Object Key 1	nvarchar	70	0	Allow NULL?
17	ENV1_OBJLOGSYS	Related Object 1 for Logical System	nvarchar	10	0	Allow NULL?
18	ENV2_OBJCAT	Related Object Category 2	char	1	0	Allow NULL?
19	ENV2_OBJTYPE	Related Object Type 2	nvarchar	10	0	Allow NULL?
20	ENV2_OBJKEY	Related Object Key 2	nvarchar	70	0	Allow NULL?
21	ENV2_OBJLOGSYS	Related Object 2 for Logical System	nvarchar	10	0	Allow NULL?
22	MSGID	Message Class	nvarchar	20	0	Allow NULL?
23	MSGTY	Message Type	char	1	0	Allow NULL?
24	MSGNO	Message Number	nvarchar	3	0	Allow NULL?
25	MSGV1	Message Variable	nvarchar	50	0	Allow NULL?
26	MSGV2	Message Variable	nvarchar	50	0	Allow NULL?
27	MSGV3	Message Variable	nvarchar	50	0	Allow NULL?
28	MSGV4	Message Variable	nvarchar	50	0	Allow NULL?
29	LOG_CAT	Log Category	char	1	0	Allow NULL?
30	LOG_NO	Log Number	nvarchar	20	0	Allow NULL?
31	LOG_HANDLE	Log Handle	nvarchar	22	0	Allow NULL?
32	LOG_MSG_NO	ID in Log	nvarchar	6	0	Allow NULL?
33	BAPI_PARAMETER	Parameter Name	nvarchar	32	0	Allow NULL?
34	BAPI_ROW	Lines in parameter	int	10	0	Allow NULL?
35	BAPI_FIELD	Field in parameter	nvarchar	30	0	Allow NULL?
36	MSG_OBJCAT	Message Object Category	char	1	0	Allow NULL?
37	MSG_OBJTYPE	Message Object Type	nvarchar	10	0	Allow NULL?
38	MSG_OBJKEY	Message Object Key	nvarchar	70	0	Allow NULL?
39	MSG_OBJLOGSYS	Logical System: Message Object	nvarchar	10	0	Allow NULL?
40	STATUS	Order Status	char	1	0	Allow NULL?
41	TEXT	Comment	nvarchar	50	0	Allow NULL?
42	PROCESSOR	Current Processor	nvarchar	12	0	Allow NULL?
43	POSTDATE	Posting Date	nvarchar	8	0	Allow NULL?
44	CREATIONDATE	Created On	nvarchar	8	0	Allow NULL?
45	PROCMETH	Mode of Postprocessing Order	char	1	0	Allow NULL?
46	PRIORITY	Priority	char	1	0	Allow NULL?
47	WORKLIST	Worklist	nvarchar	4	0	Allow NULL?
48	PROCESS	Process	char	1	0	Allow NULL?
49	HASH_1	Hash Value: Same Messages	varbinary	16	0
50	HASH_2	Hash Value: Same Message Sequence	varbinary	16	0
51	ERROR_CATEGORY	Error Category	nvarchar	15	0	Allow NULL?
52	CLOSING_TYPE	Order Closing Typ	nvarchar	2	0	Allow NULL?
53	EARLIEST_MANUAL	Processing Permitted From	decimal	15	0
54	RETRY_CLASS	RETRY Class	nvarchar	30	0	Allow NULL?
55	RETRY_MODE	Retry Mode	char	1	0	Allow NULL?
56	RETRY_GROUP	Retry Group	nvarchar	3	0	Allow NULL?
57	EARLIEST_RETRY	Repeat Permitted From	decimal	15	0
58	FINISH_CLASS	FINISH Class	nvarchar	30	0	Allow NULL?
59	FAIL_CLASS	FAIL Class	nvarchar	30	0	Allow NULL?
60	FAIL_MODE	Discard Mode	char	1	0	Allow NULL?
61	EARLIEST_CMPLTN	Settlment Permitted From	decimal	15	0
62	EARLIEST_CMPDAT	Obsolete: Settlment Permitted From	nvarchar	8	0	Allow NULL?
63	EARLIEST_CMPTIME	Obsolete: Settlment Permitted From	nvarchar	6	0	Allow NULL?
64	ADD1_CLASS	AddOn 1 Class	nvarchar	30	0	Allow NULL?
65	ADD2_CLASS	AddOn2 Class	nvarchar	30	0	Allow NULL?
66	FA_AMNT	Own Filter Attribute - Amount	decimal	23	2
67	FA_CURR	Own Filter Attribute - Currency	nvarchar	5	0	Allow NULL?
68	FA1	Own Filter Attribute 1	nvarchar	40	0	Allow NULL?
69	FA2	Own Filter Attribute 2	nvarchar	40	0	Allow NULL?
70	FA3	Own Filter Attribute 3	nvarchar	40	0	Allow NULL?
71	FA4	Own Filter Attribute 4	nvarchar	40	0	Allow NULL?
72	FA5	Own Filter Attribute 5	nvarchar	40	0	Allow NULL?
73	FA6	Own Filter Attribute 6	nvarchar	40	0	Allow NULL?
74	USER_CREATE	Created By	nvarchar	12	0	Allow NULL?
75	TIMESTAMP_CREATE	Create Time Stamp	decimal	21	7
76	USER_CHANGE	Changed By	nvarchar	12	0	Allow NULL?
77	TIMESTAMP_CHANGE	Change Time Stamp	decimal	21	7
78	ARCHIVE_STATUS		char	1	0	Allow NULL?
79	ARCHIVE_FLUD		nvarchar	8	0	Allow NULL?
80	REJECTION		nvarchar	2	0	Allow NULL?
81	FLG_WF	Workflow Active	char	1	0	Allow NULL?
82	MORE_MSG	Additional Messages Exist	char	1	0	Allow NULL?
83	MORE_OBJ	Additional Objects Exist	char	1	0	Allow NULL?
84	MORE_DATA	Additional Data Exists	char	1	0	Allow NULL?
85	ABAP_TYPEKIND	ABAP Category for Additional Data	char	1	0	Allow NULL?
86	PK	Partitioning Key	varbinary	2	0

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