SAP ABAP Table PPTS_MID_FILE (Root structure)

Hierarchy

☛ SAP_HRCPT (Software Component) Sub component SAP_HRCPT of SAP_HR
   ⤷ PY-PT (Application Component) Portugal
     ⤷ PC19 (Package) HR settlement: Portugal

Basic Data

Table Category	INTTAB	Structure
Structure	PPTS_MID_FILE	Table Relationship Diagram
Short Description	Root structure

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	HEADER_FILE	☐	PPTS_MD_HF		STRU	0	0
2	TREG	☐	PPT_TSJRE	TEXT3	CHAR	3	0	Annual income declaration - record type
3	FTYP	☐	PPT_ADFTY	CHAR5	CHAR	5	0	Annual Income Declaration - file type
4	FVER	☐	PPT_ADFVE	CHAR2	CHAR	2	0	Annual Income Declaration - file version
5	FDT	☐	PPT_ADYMD	CHAR8	CHAR	8	0	Annual Income Declaration - Date YYYYMMDD
6	HEADER_DEC	☐	PPTS_MD_HD		STRU	0	0
7	TREG	☐	PPT_TSJRE	TEXT3	CHAR	3	0	Annual income declaration - record type
8	DTYP	☐	PPT_ADDTY	CHAR6	CHAR	6	0	AD - Type of declaration
9	TAXNU	☐	PPT_FINUM	CHAR9	CHAR	9	0	Tax no.
10	YEARDEC	☐	PPT_ADYEA		CHAR	4	0	Annual Income Declaration - Year
11	MONTHDEC	☐	PPT_ADMON	NUMC2	NUMC	2	0	Month
12	CURR	☐	PPT_ADCUR		CHAR	3	0	Annual Income Declaration - currency indicator
13	HEADER_DMRAT	☐	PPTS_MD_H_DMRAT		STRU	0	0
14	TREG	☐	PPT_TSJRE	TEXT3	CHAR	3	0	Annual income declaration - record type
15	COD_SERV_FIN	☐	PPT_ADCSF		CHAR	4	0	Annual Income Declaration - Tax Office Code
16	PRI_DECL_ANO	☐	PPT_ADPDA		CHAR	1	0	AID - first declaration of the year/substitution declaration
17	DECL_APRESENT	☐	PPT_ADDAP		CHAR	1	0	AID - declaration presented in terms of d) no.1, art.119
18	DATA_FACTO	☐	PPT_ADYMD	CHAR8	CHAR	8	0	Annual Income Declaration - Date YYYYMMDD
19	NIF_TECN_CONTAS	☐	PPT_ADNFT		CHAR	9	0	Annual Income Declaration - Tax Code Statutory Accountant
20	NIF_REPRES_LEGAL	☐	PPT_ADNIF		CHAR	9	0	Annual Income Declaration - legal representative tax code
21	DETAIL_DMRAT1	☐	PPTS_MD_D_DMRAT1		STRU	0	0
22	TREG	☐	PPT_TSJRE	TEXT3	CHAR	3	0	Annual income declaration - record type
23	RSVAREN	☐	PPT_RSVRE	CHAR15	CHAR	15	0	Income liable to contribution - income value
24	RSREIRS	☐	PPT_RSRIR	CHAR14	CHAR	14	0	Income liable to contribution - IRS retention
25	RSCOOBR	☐	PPT_RSQOB	CHAR14	CHAR	14	0	Exempt income - mandatory contributions
26	RSQUSIN	☐	PPT_RSQSI	CHAR14	CHAR	14	0	Income liable to contribution - trade union quota arrangs.
27	RSRESOB	☐	PPT_RSRSO	CHAR14	CHAR	14	0	Income liable to contribution - surcharge retention
28	RIVAREN	☐	PPT_RIVRE	CHAR15	CHAR	15	0	Exempt income - income value
29	RIREIRS	☐	PPT_RIRIR	CHAR14	CHAR	14	0	Exempt income - IRS retention
30	RICOOBR	☐	PPT_RIQOB	CHAR14	CHAR	14	0	Exempt income - mandatory contributions
31	RIQUSIN	☐	PPT_RIQSI	CHAR14	CHAR	14	0	Exempt income - trade union quota arrangements
32	RIRESOB	☐	PPT_RIRSO	CHAR14	CHAR	14	0	Exempt income - surcharge retention
33	DETAIL_DMRAT2	☐	PPTS_MD_D_DMRAT2		STRU	0	0
34	TREG	☐	PPT_TSJRE	TEXT3	CHAR	3	0	Annual income declaration - record type
35	NSVAREN	☐	PPT_NSVRE	CHAR15	CHAR	15	0	Income not liable to contribution - income value
36	NSREIRS	☐	PPT_NSRIR	CHAR14	CHAR	14	0	Income not liable to contribuition - IRS retention
37	NSCOOBR	☐	PPT_NSQOB	CHAR14	CHAR	14	0	Income not liable to contribution - mandatory contributions
38	NSQUSIN	☐	PPT_NSQSI	CHAR14	CHAR	14	0	Income not liable to contrib.- trade union quota arrangs.
39	NSRESOB	☐	PPT_NSRSO	CHAR14	CHAR	14	0	Income not liable to contribution - surcharge retention
40	TOVAREN	☐	PPT_TOVRE	CHAR16	CHAR	16	0	Total - income value
41	TOREIRS	☐	PPT_TORIR	CHAR15	CHAR	15	0	Total - IRS retention
42	TOCOOBR	☐	PPT_TOCOB	CHAR15	CHAR	15	0	Total - mandatory contributions
43	TOQUSIN	☐	PPT_TOQSI	CHAR15	CHAR	15	0	Total - trade union quota arrangements
44	TORESOB	☐	PPT_TORSO	CHAR15	CHAR	15	0	Total - surcharge retention
45	DETAIL_DMRAT3	☐	PPTT_MD_D_DMRAT3		TTYP	0	0
46	TRAILER_DMRAT	☐	PPTS_MD_T_DMRAT		STRU	0	0
47	TREG	☐	PPT_TSJRE	TEXT3	CHAR	3	0	Annual income declaration - record type
48	TOTRAN	☐	PPT_TORAN	CHAR15	CHAR	15	0	Total income from previous years in records 006
49	TOTREN	☐	PPT_TOTRE	CHAR16	CHAR	16	0	Income total from year in records 006
50	TOTDED	☐	PPT_TODED	CHAR15	CHAR	15	0	Total of withholding amounts in records 006
51	TOCOOBR	☐	PPT_TOCOB	CHAR15	CHAR	15	0	Total - mandatory contributions
52	TOQUSIN	☐	PPT_TOQSI	CHAR15	CHAR	15	0	Total - trade union quota arrangements
53	TORESOB	☐	PPT_TORSO	CHAR15	CHAR	15	0	Total - surcharge retention
54	TOTREG	☐	PPT_TOREG	NUMC07	NUMC	7	0	Number of records
55	TRAILER_DEC	☐	PPTS_MD_TD		STRU	0	0
56	TREG	☐	PPT_TSJRE	TEXT3	CHAR	3	0	Annual income declaration - record type
57	NUM_RECORDS	☐	PPT_NUREG	NUMC09	NUMC	9	0	Number of records
58	TRAILER_FILE	☐	PPTS_MD_TF		STRU	0	0
59	TREG	☐	PPT_TSJRE	TEXT3	CHAR	3	0	Annual income declaration - record type
60	NUM_RECORDS	☐	PPT_NUREG	NUMC09	NUMC	9	0	Number of records

History

Last changed by/on	SAP	20131127
SAP Release Created in