SAP table P05T_IV_ADM_STAT_VIEWER (Wage Return: Income Relationship - Status Table)
SAP table P05T_IV_ADM_STAT_VIEWER has 9 primary key fields being MANDT,JUPER,ANPRJ,ANPRM,SEQNO,SRTAANG,PERNR,BEGDAIV,SEQNOSTATUS.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
MANDT
Client
CLNT
3
0
MANDT
JUPER
Legal Person
CHAR
4
0
JUPER
ANPRJ
Wage Return For-Period Year
NUMC
4
0
P05T_LAFPJ
ANPRM
Wage Return For-Period
NUMC
2
0
P05T_LAFPM
SEQNO
Wage Return: Sequence Number
NUMC
4
0
P05T_SEQNO
SRTAANG
Wage Return: Type of Return
CHAR
1
0
P05T_SRTAANG
A
Additional Data for Return
V
Complete Return
PERNR
Personnel Number
NUMC
8
0
P_PERNR
BEGDAIV
Start Date
DATS
8
0
BEGDA
SEQNOSTATUS
Wage Return: Sequence Number
NUMC
4
0
P05T_SEQNO
STATUS
Wage Return: Return Status
NUMC
2
0
P05T_STATUS
00
Undefined (arch.)
01
New
02
New (Arch.)
03
To Be Sent
04
To Be Sent (Arch.)
05
Sent
06
Sent (Arch.)
07
OK
08
OK (Arch.)
09
Error
10
Error (Arch.)
11
Cancelled
12
Cancelled (Arch.)
13
Printed
14
Printed (Arch.)
15
Already reported
16
Already reported (arch.)
17
Change of Citizen Service Number (BSN)
18
Change of Citizen Service Number (arch.)
19
Change of Citizen Service Number (BSN) Correction
20
Change of Citizen Service Number (BSN) Correction (arch.)