THE COMPLETE LIST OF ALL SAP FIELDS FOR EVERY MUST HAVE DATA ANALYTICS TEST.xlsx

	A	B	C	D	E	F	G	H	I	J	K	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO	CP	CQ	CR	CS	CT	CU	CV
1	Essential SAP data for 300 must-have data analytics		Section D: Data verification									Section FR: Financial Reporting																																Section P: Purchase To Pay
2	Essential SAP data for 300 must-have data analytics		Data Integrity									Bank reconciliation	Suspense/ liaision accounts				Provisions		Accounting schemes									Closing				Dates			Accounts	Descriptions		Users				Journal entry number		Suppliers																			Purchase Orders																			Invoices
3	"U" = Useful "E" = Essential	Must have data analytics test:	General Ledger -Trial Balance reconciliation	Debit = Credit	Accounts Payable Ledger vs General Ledger	Accounts Recievable Ledger vs General Ledger	Stock ledger vs General Ledger	Fixed Assets Ledger vs General Ledger	Payroll vs General Ledger	Accounts Payable Ledger vs supply chain	Accounts Recievable Ledger vs sales	Unusual bank reconciliation adjustments	Growing Invoices To Be Received balance	Growing Invoices To Be Issued balance	Other suspense account analysis	Transactions to fictitious intercompany accounts	Provisions for bad debt not posted	Provisions for slow rotation not posted	Debit-credit suppliers	Credit-debit customers	Debit-Credit refresh	Credit-debit refresh	Debit P&L, credit bank	Credit customer, debit P&L	Unusual supplier transactions	Unusual customer transactions	Unusual accounting schemes	High value/ volume pre-closing	Post-closing clean-up	Duplicate manual journal entries	Unusual high value transactions	Document date after input date/ posting date	Posting date and document date in different periods	Manual journal entries with long delay to entry	Manual journal entries to obsolete General Ledger accounts	Manual journal entries with key word code/ user name	Manual journal entries with no description	Users entering journal entries out of hours	Journal entries entered by top management/ generic users/ IT users/ system users	Journal entries entered by users that have left the company	Manual journal entries entered by unusual users	Gaps in journal entry numbers	Duplicate journal entry numbers	Suppliers without a tax number	Suppliers without a name	Suppliers without an addresss	Suppliers without a post code	Suppliers with wrong tax number	Suppliers without PO box address	Changes in supplier IBAN	Flip-flop IBAN	Duplicate suppliers	Suppliers in OFAC list	Suppliers that are people	Different suppliers with the same bank account	Suppliers that are users	Suspicious suppliers	Suppliers only one internal contact	Suppliers friends with employees	Suppliers from black - listed countries	Suppliers with ageing balance	Suppliers that are debtors	Retroactive POs	POs with key words	POs for blocked suppliers	POs with shortened payment terms	High-value POs for generic items	Open POs	High-value PO, no approbation	POs modified following approbation	Gaps in PO numbering	POs Incorrect exchange rates	POs incorrect tax codes	POs incorrect tax percentage	PO price higher than price conditions	Single source items with price increase	Inflated prices for preferred suppliers	No price decrease	High-value PO, no call for tender	POs for items that are on slow - rotation	Split POs	Invoices without descriptions	Invoices exceeding POs	Invoices without POs	Invoices with key words	High volume of invoice cancellations	Invoices whilst blocked	Invoices with shortened payment terms	Unmatched invoices	Unmatched debit notes	Incorrect debit notes	Gaps in internal invoice numbers	Invoice document date on or after input date	Posting date different period to document date	Invoices assigned to unusual cost center/ no cost center	Invoices for obsolete POs	Incorrect exchange rates	Incorrect tax codes
4	Description	SAP field	D01	D02	D03	D04	D05	D06	D07	D08	D09	FR01_01	FR02_01	FR02_02	FR02_03	FR02_04	FR03_01	FR03_02	FR04_01	FR04_02	FR04_03	FR04_04	FR04_05	FR04_06	FR04_07	FR04_08	FR04_09	FR05_01	FR05_02	FR05_03	FR05_04	FR06_01	FR06_02	FR06_03	FR07_01	FR08_01	FR08_02	FR09_01	FR09_02	FR09_03	FR09_04	FR10_01	FR10_02	P01_01	P01_02	P01_03	P01_04	P01_05	P01_06	P01_07	P01_08	P01_09	P01_10	P01_11	P01_12	P01_13	P01_14	P01_15	P01_16	P01_17	P01_18	P01_19	P02_01	P02_02	P02_03	P02_04	P02_05	P02_06	P02_07	P02_08	P02_09	P02_10	P02_11	P02_12	P02_13	P02_14	P02_15	P02_16	P02_17	P02_18	P02_19	P03_01	P03_02	P03_03	P03_04	P03_05	P03_06	P03_07	P03_08	P03_09	P03_10	P03_11	P03_12	P03_13	P03_14	P03_15	P03_16	P03_17

5	Name of activity group profile (AGR_1016)
6	Role name	AGR_NAME
7	Menu ID for BIW	COUNTER
8	Indicator: entry generated	GENERATED
9	Profile name	PROFILE
10	Active or maintenance version	PSTATE
11	Authorization data for the activity group (AGR_1251)
12	Role name	AGR_NAME
13	Authorization name in user master maintenance	AUTH
14	Menu ID for BIW	COUNTER
15	Deleted indicator	DELETED
16	Field name of an authorization	FIELD
17	Authorization value - high	HIGH
18	Authorization value - low	LOW
19	Object status	MODIFIED
20	New indicator	NEU
21	Authorization object in user master maintenance	OBJECT
22	Composite roles (AGR_AGRS)
23	Composite role	AGR_NAME
24	Assignment active	ATTRIBUTES
25	Single role in composite role	CHILD_AGR
26	Profile name for role table (AGR_PROF)
27	Role name	AGR_NAME
28	Language key	LANGU
29	Profile name	PROFILE
30	Texts in user master/ authorisations	PTEXT
31	Assignment of roles to users (AGR_USERS)
32	Role name	AGR_NAME
33	Date of menu generation	CHANGE_DAT
34	Time when the menu was generated last	CHANGE_TIM
35	UTC time stamp	CHANGE_TST
36	Date of validity	FROM_DAT
37	Date of validity	TO_DAT
38	User name in user master record	UNAME
39	Asset line items for proportional values (ANEA)
40	Proportional unplanned depreciation for the year	AAFAL						E
41	Proportional cumulative unplanned depreciation	AAFAV						E
42	Real depreciation area	AFABE						E
43	Main asset number	ANLN1						E
44	Asset subnumber	ANLN2						E
45	Indicator: type of change to table	ANUPD
46	Proportional revaluation annual ordinary depreciation	AUFNL						E
47	Proportional cumulative revaluation on ordinary depreciation	AUFNV						E
48	Proportional revaluation for the year on replacement value	AUFWL						E
49	Proportional cumulative revaluation on replacement value	AUFWV						E
50	Company code	BUKRS						E
51	Revenue from asset sales	ERLBT						E
52	Fiscal year	GJAHR						E
53	Proportional investment grant for the year	INVZL						E
54	Proportional cumulaive investment grants	INVZV						E
55	Sequence number of asset line items in fiscal year	LNRAN						E
56	Proportional transfer of reserves for the year	MAFAL						E
57	Proportional cumulative transfer of reserves	MAFAV						E
58	Proportional ordinary depreciation for the year	NAFAL						E
59	Proportional accumulated ordinary depreciation	NAFAV						E
60	Proportional special depreciation for the year	SAFAL						E
61	Proportional cumulative special depreciation	SAFAV						E
62	Proportional statistical acquisition value retired	SANWV						E
63	Costs from asset retirement	VERKO						E
64	Asset Posting (Header) (ANEK)
65	Last change date	AEDAT						U
66	Main asset number	ANLN1						E
67	Asset subnumber	ANLN2						E
68	Reference transaction	AWTYP						E
69	Accounting number	BELNR						E
70	Document date	BLDAT						U
71	Posting date	BUDAT						E
72	Company code	BUKRS						E
73	Accounting item number	BUZEI						U
74	Input date	CPUDT						U
75	Update time	CPUTM
76	Purchase document number	EBELN						U
77	Purchase document item number	EBELP						U
78	Fiscal year	GJAHR						E
79	Sequence number of asset line items in fiscal year	LNRAN						E
80	Material number	MATNR						U
81	Unit of measure	MEINS						U
82	Quantity	MENGE						U
83	Fiscal period	MONAT						U
84	Item text	SGTXT						U
85	Transaction code	TCODE						U
86	User name	USNAM						U
87	Reference document number	XBLNR						U
88	Asset posting (line items) (ANEP)							E
89	Real depreciation area	AFABE						E
90	Amount posted	ANBTR						E
91	Main asset number	ANLN1						E
92	Asset sub number	ANLN2						E
93	Indicator: type of change to table	ANUPD						U
94	Current number of the clearing asset line item	AUGLN						U
95	Accounting document number	BELNR						E
96	Company code	BUKRS						E
97	Number of line item within accounting document	BUZEI						E
98	Asset transaction type	BWASL						U
99	Asset value date	BZDAT						U
100	Fiscal year	GJAHR						E