	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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
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	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

169 COLUMNS | 1 INDEXES | ERP 6.0 | PA0795 TABLE

ERP EHP7

6.0

169

HR Master Record: Infotype 0795

SQL: selectupdate insert create

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

SELECT MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR, AEDTM, UNAME, HISTO, ITXEX, REFEX, ORDEX, ITBLD, PREAS, FLAG1, FLAG2, FLAG3, FLAG4, RESE1, RESE2, GRPVL, TYPEC, CTNUM, CTBEG, CTEND, CSTAT, RENCD, SBG01, SEN01, SCD01, SCL01, SDN01, SST01, SHQ01, SBG02, SEN02, SCD02, SCL02, SDN02, SST02, SHQ02, SBG03, SEN03, SCD03, SCL03, SDN03, SST03, SHQ03, SBG04, SEN04, SCD04, SCL04, SDN04, SST04, SHQ04, SBG05, SEN05, SCD05, SCL05, SDN05, SST05, SHQ05, SBG06, SEN06, SCD06, SCL06, SDN06, SST06, SHQ06, SBG07, SEN07, SCD07, SCL07, SDN07, SST07, SHQ07, SBG08, SEN08, SCD08, SCL08, SDN08, SST08, SHQ08, SBG09, SEN09, SCD09, SCL09, SDN09, SST09, SHQ09, SBG10, SEN10, SCD10, SCL10, SDN10, SST10, SHQ10, SBG11, SEN11, SCD11, SCL11, SDN11, SST11, SHQ11, SBG12, SEN12, SCD12, SCL12, SDN12, SST12, SHQ12, SBG13, SEN13, SCD13, SCL13, SDN13, SST13, SHQ13, SBG14, SEN14, SCD14, SCL14, SDN14, SST14, SHQ14, SBG15, SEN15, SCD15, SCL15, SDN15, SST15, SHQ15, SBG16, SEN16, SCD16, SCL16, SDN16, SST16, SHQ16, SBG17, SEN17, SCD17, SCL17, SDN17, SST17, SHQ17, SBG18, SEN18, SCD18, SCL18, SDN18, SST18, SHQ18, SBG19, SEN19, SCD19, SCL19, SDN19, SST19, SHQ19, SBG20, SEN20, SCD20, SCL20, SDN20, SST20, SHQ20 FROM PA0795

TOP ERP 6.0 | PA0795 COLUMNS

Column	Field	Description	SQL Type	Length	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	PERNR	Personnel number	nvarchar	8	NUMC	(N'00000000')	No	PA0003	PERSNO	Allow NULL?
3	SUBTY	Subtype	nvarchar	4	CHAR	(N' ')	No		SUBTY	Allow NULL?
4	OBJPS	Object Identification	nvarchar	2	CHAR	(N' ')	No		OBJPS	Allow NULL?
5	SPRPS	Lock Indicator for HR Master Data Record	char	1	CHAR	(N' ')	No		SPRPS	Allow NULL?
6	ENDDA	End Date	nvarchar	8	DATS	(N'00000000')	No		ENDDA	Allow NULL?
7	BEGDA	Start Date	nvarchar	8	DATS	(N'00000000')	No		BEGDA	Allow NULL?
8	SEQNR	Number of Infotype Record with Same Key	nvarchar	3	NUMC	(N'000')	No		SEQNR	Allow NULL?
9	AEDTM	Changed On	nvarchar	8	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
10	UNAME	Name of Person Who Changed Object	nvarchar	12	CHAR	(N' ')	Yes		AENAM	Allow NULL?
11	HISTO	Historical Record Flag	char	1	CHAR	(N' ')	Yes		HISTO	Allow NULL?
12	ITXEX	Text Exists for Infotype	char	1	CHAR	(N' ')	Yes		ITXEX	Allow NULL?
13	REFEX	Reference Fields Exist (Primary/Secondary Costs)	char	1	CHAR	(N' ')	Yes		PRFEX	Allow NULL?
14	ORDEX	Confirmation Fields Exist	char	1	CHAR	(N' ')	Yes		ORDEX	Allow NULL?
15	ITBLD	Infotype Screen Control	nvarchar	2	CHAR	(N' ')	Yes		ITBLD	Allow NULL?
16	PREAS	Reason for Changing Master Data	nvarchar	2	CHAR	(N' ')	Yes	T530E	PREAS	Allow NULL?
17	FLAG1	Reserved Field/Unused Field	char	1	CHAR	(N' ')	Yes		NUSED	Allow NULL?
18	FLAG2	Reserved Field/Unused Field	char	1	CHAR	(N' ')	Yes		NUSED	Allow NULL?
19	FLAG3	Reserved Field/Unused Field	char	1	CHAR	(N' ')	Yes		NUSED	Allow NULL?
20	FLAG4	Reserved Field/Unused Field	char	1	CHAR	(N' ')	Yes		NUSED	Allow NULL?
21	RESE1	Reserved Field/Unused Field of Length 2	nvarchar	2	CHAR	(N' ')	Yes		NUSED2	Allow NULL?
22	RESE2	Reserved Field/Unused Field of Length 2	nvarchar	2	CHAR	(N' ')	Yes		NUSED2	Allow NULL?
23	GRPVL	Grouping Value for Personnel Assignments	nvarchar	4	CHAR	(N' ')	Yes		PCCE_GPVAL	Allow NULL?
24	TYPEC	Certificate Category	nvarchar	4	CHAR	(N' ')	Yes	T5UPBSTC11	P10P_TYPEC	Allow NULL?
25	CTNUM	Certificate Identification	nvarchar	10	CHAR	(N' ')	Yes		P10P_CTNUM	Allow NULL?
26	CTBEG	Certificate Effective Begin Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_CTBEG	Allow NULL?
27	CTEND	Certificate Effective End Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_CTEND	Allow NULL?
28	CSTAT	Certificate and Area Status	char	1	CHAR	(N' ')	Yes	T5UPBSTC30	P10P_CSTAT	Allow NULL?
29	RENCD	Renewal Code	nvarchar	4	CHAR	(N' ')	Yes	T5UPBSTC21	P10P_RENCD	Allow NULL?
30	SBG01	Area Effective Begin Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SBEGD	Allow NULL?
31	SEN01	Area Effective End Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SENDD	Allow NULL?
32	SCD01	Code (Classification, Area and Level)	nvarchar	6	CHAR	(N' ')	Yes	T5UPBSTC16	P10P_SCODE	Allow NULL?
33	SCL01	Classification	nvarchar	4	CHAR	(N' ')	Yes	T5UPBSTC03	P10P_CLASS	Allow NULL?
34	SDN01	Area Document Number	nvarchar	10	CHAR	(N' ')	Yes		P10P_SDNUM	Allow NULL?
35	SST01	Area Status	char	1	CHAR	(N' ')	Yes	T5UPBSTC30	P10P_SSTAT	Allow NULL?
36	SHQ01	Highly Qualified	char	1	CHAR	(N' ')	Yes		P10P_HQUAL	Allow NULL?
37	SBG02	Area Effective Begin Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SBEGD	Allow NULL?
38	SEN02	Area Effective End Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SENDD	Allow NULL?
39	SCD02	Code (Classification, Area and Level)	nvarchar	6	CHAR	(N' ')	Yes	T5UPBSTC16	P10P_SCODE	Allow NULL?
40	SCL02	Classification	nvarchar	4	CHAR	(N' ')	Yes	T5UPBSTC03	P10P_CLASS	Allow NULL?
41	SDN02	Area Document Number	nvarchar	10	CHAR	(N' ')	Yes		P10P_SDNUM	Allow NULL?
42	SST02	Area Status	char	1	CHAR	(N' ')	Yes	T5UPBSTC30	P10P_SSTAT	Allow NULL?
43	SHQ02	Highly Qualified	char	1	CHAR	(N' ')	Yes		P10P_HQUAL	Allow NULL?
44	SBG03	Area Effective Begin Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SBEGD	Allow NULL?
45	SEN03	Area Effective End Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SENDD	Allow NULL?
46	SCD03	Code (Classification, Area and Level)	nvarchar	6	CHAR	(N' ')	Yes	T5UPBSTC16	P10P_SCODE	Allow NULL?
47	SCL03	Classification	nvarchar	4	CHAR	(N' ')	Yes	T5UPBSTC03	P10P_CLASS	Allow NULL?
48	SDN03	Area Document Number	nvarchar	10	CHAR	(N' ')	Yes		P10P_SDNUM	Allow NULL?
49	SST03	Area Status	char	1	CHAR	(N' ')	Yes	T5UPBSTC30	P10P_SSTAT	Allow NULL?
50	SHQ03	Highly Qualified	char	1	CHAR	(N' ')	Yes		P10P_HQUAL	Allow NULL?
51	SBG04	Area Effective Begin Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SBEGD	Allow NULL?
52	SEN04	Area Effective End Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SENDD	Allow NULL?
53	SCD04	Code (Classification, Area and Level)	nvarchar	6	CHAR	(N' ')	Yes	T5UPBSTC16	P10P_SCODE	Allow NULL?
54	SCL04	Classification	nvarchar	4	CHAR	(N' ')	Yes	T5UPBSTC03	P10P_CLASS	Allow NULL?
55	SDN04	Area Document Number	nvarchar	10	CHAR	(N' ')	Yes		P10P_SDNUM	Allow NULL?
56	SST04	Area Status	char	1	CHAR	(N' ')	Yes	T5UPBSTC30	P10P_SSTAT	Allow NULL?
57	SHQ04	Highly Qualified	char	1	CHAR	(N' ')	Yes		P10P_HQUAL	Allow NULL?
58	SBG05	Area Effective Begin Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SBEGD	Allow NULL?
59	SEN05	Area Effective End Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SENDD	Allow NULL?
60	SCD05	Code (Classification, Area and Level)	nvarchar	6	CHAR	(N' ')	Yes	T5UPBSTC16	P10P_SCODE	Allow NULL?
61	SCL05	Classification	nvarchar	4	CHAR	(N' ')	Yes	T5UPBSTC03	P10P_CLASS	Allow NULL?
62	SDN05	Area Document Number	nvarchar	10	CHAR	(N' ')	Yes		P10P_SDNUM	Allow NULL?
63	SST05	Area Status	char	1	CHAR	(N' ')	Yes	T5UPBSTC30	P10P_SSTAT	Allow NULL?
64	SHQ05	Highly Qualified	char	1	CHAR	(N' ')	Yes		P10P_HQUAL	Allow NULL?
65	SBG06	Area Effective Begin Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SBEGD	Allow NULL?
66	SEN06	Area Effective End Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SENDD	Allow NULL?
67	SCD06	Code (Classification, Area and Level)	nvarchar	6	CHAR	(N' ')	Yes		P10P_SCODE	Allow NULL?
68	SCL06	Classification	nvarchar	4	CHAR	(N' ')	Yes		P10P_CLASS	Allow NULL?
69	SDN06	Area Document Number	nvarchar	10	CHAR	(N' ')	Yes		P10P_SDNUM	Allow NULL?
70	SST06	Area Status	char	1	CHAR	(N' ')	Yes		P10P_SSTAT	Allow NULL?
71	SHQ06	Highly Qualified	char	1	CHAR	(N' ')	Yes		P10P_HQUAL	Allow NULL?
72	SBG07	Area Effective Begin Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SBEGD	Allow NULL?
73	SEN07	Area Effective End Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SENDD	Allow NULL?
74	SCD07	Code (Classification, Area and Level)	nvarchar	6	CHAR	(N' ')	Yes		P10P_SCODE	Allow NULL?
75	SCL07	Classification	nvarchar	4	CHAR	(N' ')	Yes		P10P_CLASS	Allow NULL?
76	SDN07	Area Document Number	nvarchar	10	CHAR	(N' ')	Yes		P10P_SDNUM	Allow NULL?
77	SST07	Area Status	char	1	CHAR	(N' ')	Yes		P10P_SSTAT	Allow NULL?
78	SHQ07	Highly Qualified	char	1	CHAR	(N' ')	Yes		P10P_HQUAL	Allow NULL?
79	SBG08	Area Effective Begin Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SBEGD	Allow NULL?
80	SEN08	Area Effective End Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SENDD	Allow NULL?
81	SCD08	Code (Classification, Area and Level)	nvarchar	6	CHAR	(N' ')	Yes		P10P_SCODE	Allow NULL?
82	SCL08	Classification	nvarchar	4	CHAR	(N' ')	Yes		P10P_CLASS	Allow NULL?
83	SDN08	Area Document Number	nvarchar	10	CHAR	(N' ')	Yes		P10P_SDNUM	Allow NULL?
84	SST08	Area Status	char	1	CHAR	(N' ')	Yes		P10P_SSTAT	Allow NULL?
85	SHQ08	Highly Qualified	char	1	CHAR	(N' ')	Yes		P10P_HQUAL	Allow NULL?
86	SBG09	Area Effective Begin Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SBEGD	Allow NULL?
87	SEN09	Area Effective End Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SENDD	Allow NULL?
88	SCD09	Code (Classification, Area and Level)	nvarchar	6	CHAR	(N' ')	Yes		P10P_SCODE	Allow NULL?
89	SCL09	Classification	nvarchar	4	CHAR	(N' ')	Yes		P10P_CLASS	Allow NULL?
90	SDN09	Area Document Number	nvarchar	10	CHAR	(N' ')	Yes		P10P_SDNUM	Allow NULL?
91	SST09	Area Status	char	1	CHAR	(N' ')	Yes		P10P_SSTAT	Allow NULL?
92	SHQ09	Highly Qualified	char	1	CHAR	(N' ')	Yes		P10P_HQUAL	Allow NULL?
93	SBG10	Area Effective Begin Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SBEGD	Allow NULL?
94	SEN10	Area Effective End Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SENDD	Allow NULL?
95	SCD10	Code (Classification, Area and Level)	nvarchar	6	CHAR	(N' ')	Yes		P10P_SCODE	Allow NULL?
96	SCL10	Classification	nvarchar	4	CHAR	(N' ')	Yes		P10P_CLASS	Allow NULL?
97	SDN10	Area Document Number	nvarchar	10	CHAR	(N' ')	Yes		P10P_SDNUM	Allow NULL?
98	SST10	Area Status	char	1	CHAR	(N' ')	Yes		P10P_SSTAT	Allow NULL?
99	SHQ10	Highly Qualified	char	1	CHAR	(N' ')	Yes		P10P_HQUAL	Allow NULL?
100	SBG11	Area Effective Begin Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SBEGD	Allow NULL?
101	SEN11	Area Effective End Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SENDD	Allow NULL?
102	SCD11	Code (Classification, Area and Level)	nvarchar	6	CHAR	(N' ')	Yes		P10P_SCODE	Allow NULL?
103	SCL11	Classification	nvarchar	4	CHAR	(N' ')	Yes		P10P_CLASS	Allow NULL?
104	SDN11	Area Document Number	nvarchar	10	CHAR	(N' ')	Yes		P10P_SDNUM	Allow NULL?
105	SST11	Area Status	char	1	CHAR	(N' ')	Yes		P10P_SSTAT	Allow NULL?
106	SHQ11	Highly Qualified	char	1	CHAR	(N' ')	Yes		P10P_HQUAL	Allow NULL?
107	SBG12	Area Effective Begin Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SBEGD	Allow NULL?
108	SEN12	Area Effective End Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SENDD	Allow NULL?
109	SCD12	Code (Classification, Area and Level)	nvarchar	6	CHAR	(N' ')	Yes		P10P_SCODE	Allow NULL?
110	SCL12	Classification	nvarchar	4	CHAR	(N' ')	Yes		P10P_CLASS	Allow NULL?
111	SDN12	Area Document Number	nvarchar	10	CHAR	(N' ')	Yes		P10P_SDNUM	Allow NULL?
112	SST12	Area Status	char	1	CHAR	(N' ')	Yes		P10P_SSTAT	Allow NULL?
113	SHQ12	Highly Qualified	char	1	CHAR	(N' ')	Yes		P10P_HQUAL	Allow NULL?
114	SBG13	Area Effective Begin Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SBEGD	Allow NULL?
115	SEN13	Area Effective End Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SENDD	Allow NULL?
116	SCD13	Code (Classification, Area and Level)	nvarchar	6	CHAR	(N' ')	Yes		P10P_SCODE	Allow NULL?
117	SCL13	Classification	nvarchar	4	CHAR	(N' ')	Yes		P10P_CLASS	Allow NULL?
118	SDN13	Area Document Number	nvarchar	10	CHAR	(N' ')	Yes		P10P_SDNUM	Allow NULL?
119	SST13	Area Status	char	1	CHAR	(N' ')	Yes		P10P_SSTAT	Allow NULL?
120	SHQ13	Highly Qualified	char	1	CHAR	(N' ')	Yes		P10P_HQUAL	Allow NULL?
121	SBG14	Area Effective Begin Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SBEGD	Allow NULL?
122	SEN14	Area Effective End Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SENDD	Allow NULL?
123	SCD14	Code (Classification, Area and Level)	nvarchar	6	CHAR	(N' ')	Yes		P10P_SCODE	Allow NULL?
124	SCL14	Classification	nvarchar	4	CHAR	(N' ')	Yes		P10P_CLASS	Allow NULL?
125	SDN14	Area Document Number	nvarchar	10	CHAR	(N' ')	Yes		P10P_SDNUM	Allow NULL?
126	SST14	Area Status	char	1	CHAR	(N' ')	Yes		P10P_SSTAT	Allow NULL?
127	SHQ14	Highly Qualified	char	1	CHAR	(N' ')	Yes		P10P_HQUAL	Allow NULL?
128	SBG15	Area Effective Begin Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SBEGD	Allow NULL?
129	SEN15	Area Effective End Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SENDD	Allow NULL?
130	SCD15	Code (Classification, Area and Level)	nvarchar	6	CHAR	(N' ')	Yes		P10P_SCODE	Allow NULL?
131	SCL15	Classification	nvarchar	4	CHAR	(N' ')	Yes		P10P_CLASS	Allow NULL?
132	SDN15	Area Document Number	nvarchar	10	CHAR	(N' ')	Yes		P10P_SDNUM	Allow NULL?
133	SST15	Area Status	char	1	CHAR	(N' ')	Yes		P10P_SSTAT	Allow NULL?
134	SHQ15	Highly Qualified	char	1	CHAR	(N' ')	Yes		P10P_HQUAL	Allow NULL?
135	SBG16	Area Effective Begin Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SBEGD	Allow NULL?
136	SEN16	Area Effective End Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SENDD	Allow NULL?
137	SCD16	Code (Classification, Area and Level)	nvarchar	6	CHAR	(N' ')	Yes		P10P_SCODE	Allow NULL?
138	SCL16	Classification	nvarchar	4	CHAR	(N' ')	Yes		P10P_CLASS	Allow NULL?
139	SDN16	Area Document Number	nvarchar	10	CHAR	(N' ')	Yes		P10P_SDNUM	Allow NULL?
140	SST16	Area Status	char	1	CHAR	(N' ')	Yes		P10P_SSTAT	Allow NULL?
141	SHQ16	Highly Qualified	char	1	CHAR	(N' ')	Yes		P10P_HQUAL	Allow NULL?
142	SBG17	Area Effective Begin Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SBEGD	Allow NULL?
143	SEN17	Area Effective End Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SENDD	Allow NULL?
144	SCD17	Code (Classification, Area and Level)	nvarchar	6	CHAR	(N' ')	Yes		P10P_SCODE	Allow NULL?
145	SCL17	Classification	nvarchar	4	CHAR	(N' ')	Yes		P10P_CLASS	Allow NULL?
146	SDN17	Area Document Number	nvarchar	10	CHAR	(N' ')	Yes		P10P_SDNUM	Allow NULL?
147	SST17	Area Status	char	1	CHAR	(N' ')	Yes		P10P_SSTAT	Allow NULL?
148	SHQ17	Highly Qualified	char	1	CHAR	(N' ')	Yes		P10P_HQUAL	Allow NULL?
149	SBG18	Area Effective Begin Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SBEGD	Allow NULL?
150	SEN18	Area Effective End Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SENDD	Allow NULL?
151	SCD18	Code (Classification, Area and Level)	nvarchar	6	CHAR	(N' ')	Yes		P10P_SCODE	Allow NULL?
152	SCL18	Classification	nvarchar	4	CHAR	(N' ')	Yes		P10P_CLASS	Allow NULL?
153	SDN18	Area Document Number	nvarchar	10	CHAR	(N' ')	Yes		P10P_SDNUM	Allow NULL?
154	SST18	Area Status	char	1	CHAR	(N' ')	Yes		P10P_SSTAT	Allow NULL?
155	SHQ18	Highly Qualified	char	1	CHAR	(N' ')	Yes		P10P_HQUAL	Allow NULL?
156	SBG19	Area Effective Begin Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SBEGD	Allow NULL?
157	SEN19	Area Effective End Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SENDD	Allow NULL?
158	SCD19	Code (Classification, Area and Level)	nvarchar	6	CHAR	(N' ')	Yes		P10P_SCODE	Allow NULL?
159	SCL19	Classification	nvarchar	4	CHAR	(N' ')	Yes		P10P_CLASS	Allow NULL?
160	SDN19	Area Document Number	nvarchar	10	CHAR	(N' ')	Yes		P10P_SDNUM	Allow NULL?
161	SST19	Area Status	char	1	CHAR	(N' ')	Yes		P10P_SSTAT	Allow NULL?
162	SHQ19	Highly Qualified	char	1	CHAR	(N' ')	Yes		P10P_HQUAL	Allow NULL?
163	SBG20	Area Effective Begin Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SBEGD	Allow NULL?
164	SEN20	Area Effective End Date	nvarchar	8	DATS	(N'00000000')	Yes		P10P_SENDD	Allow NULL?
165	SCD20	Code (Classification, Area and Level)	nvarchar	6	CHAR	(N' ')	Yes		P10P_SCODE	Allow NULL?
166	SCL20	Classification	nvarchar	4	CHAR	(N' ')	Yes		P10P_CLASS	Allow NULL?
167	SDN20	Area Document Number	nvarchar	10	CHAR	(N' ')	Yes		P10P_SDNUM	Allow NULL?
168	SST20	Area Status	char	1	CHAR	(N' ')	Yes		P10P_SSTAT	Allow NULL?
169	SHQ20	Highly Qualified	char	1	CHAR	(N' ')	Yes		P10P_HQUAL	Allow NULL?

TOP ERP 6.0 | PA0795 INDEXES

Name	Primary	Unique	Type	Columns
PA0795~0	Yes	Yes	CLUSTERED	SEQNR, BEGDA, ENDDA, SPRPS, OBJPS, SUBTY, PERNR, 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

169 COLUMNS | 1 INDEXES | ERP 6.0 | PA0795 TABLE

TOP ERP 6.0 | PA0795 COLUMNS

TOP ERP 6.0 | PA0795 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

169 COLUMNS | 1 INDEXES | ERP 6.0 | PA0795 TABLE

TOPERP 6.0 | PA0795 COLUMNS

TOPERP 6.0 | PA0795 INDEXES

TOP ERP 6.0 | PA0795 COLUMNS

TOP ERP 6.0 | PA0795 INDEXES