SAP table V_554S_N (Generated Table for View)

SAP table V_554S_N has 4 primary key fields being MANDT,MOABW,SUBTY,ENDDA.

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 T000 MANDT
MOABW Personnel subarea grouping for absence and attendance types NUMC 2 0 MOABW
SUBTY Attendance or Absence Type CHAR 4 0 AWART
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
KLZBI Time constraint class NUMC 2 0 T554Y KLZBI
ABKLA Att./absence class NUMC 2 0 ABKLA
DYNNR Screen for Recording Absences or Attendances CHAR 4 0 PDYNR
ART01 Attendance or absence indicator CHAR 1 0 ART01
A Valid for absences
P Valid for attendances
ABWRG Absence type grouping to determine daily WS variants NUMC 1 0 ABWRG
AVAIL Availability for an attendance/absence CHAR 1 0 PTM_TIMAVAIL
Not available
1 Available
9 Irrelevant
ATEXT Text for Attendance/Absence Type CHAR 25 0 ABWTXT
ENDCK Check end date of attendance/absence CHAR 1 0 PTM_ENDCHECK
D2OBL Indicates whether a second date is required CHAR 1 0 D2OBL
REABF Reaction indicator when first day is a day off CHAR 1 0 REABF
REAEF Reaction indicator when last day is a day off CHAR 1 0 REAEF
REAZF Reaction indicator for non-working period CHAR 1 0 REAZF
MINTG Minimum duration in days DEC 3 0 MITAG
MAXTG Maximum duration in days DEC 3 0 MATAG
KLBEW Absence valuation rule CHAR 2 0 T554L BEWKL
ABSTP Absence/attendance category CHAR 1 0 ABSTP
DUEVO Title/Name Supplement/Prefix, DUEVO-Compliant CHAR 1 0 DUEVO
KTART Attendance or absence quota type NUMC 2 0 KTART
RGMOD Grouping of attendance and absence types for counting NUMC 2 0 RGMOD
KLBDE Class for time evaluation NUMC 2 0 KLBDE
KUNBZ Indicator for Irregular Payment CHAR 2 0 KUNBZ
01 Military/non-mil. service
02 Parental leave (> 12 months)
03 Long-term leave (> 12 months)
04 Leaving on the first of next
05 Change of employer (leg.pers.)
06 Change of employment
ERGAB Additional absence data CHAR 1 0 ERGAB
PCOPT Indicator: store attendance/absence in personal calendar CHAR 1 0 PCOPT
STKRV Subtype CHAR 4 0 SUBTY
STUND Subtype CHAR 4 0 SUBTY
URMAN Indicator for manual leave deduction CHAR 1 0 URMAN
Changes cannot be made manually
1 Only number fields can be overwritten
2 All fields can be changed
ABSTY Attendance/absence type CHAR 2 0 T5A4P ABSTY
VBLAK SP Absence Insurance Type CHAR 2 0 P01P_ABWVA
21 Maternity Protection
22 Discontinuation of Sick Pay
23 Unpaid Leave (Without Special Payment)
24 Paid Leave (with Special Payment)
25 Member of Parliament
26 Temporary Reduction in Earning Capacity Pension
27 Seasonal Worker, Forestry Worker
28 Parental Leave After June 1989
29 Other Reason
30 Mat. Protection Without Check of Child and Conversion to 28
EU Retrospective permanent REC psn (until comp. retirement age)
ABKND Attedance/Absence Category for Payroll (Country-Specific) CHAR 1 0 ABKND
CLTIM Processing type/time type class NUMC 2 0 CLTIM
MUNIT Unit for minimum/maximum number of days CHAR 1 0 PTM_MUNIT
Calendar days
A Attendance and absence days
K Calendar days
R Payroll days
CRULE Rule for attendance and absence counting NUMC 3 0 T556C CRULE
DEDQU Quota deduction through attendance/absence CHAR 1 0 PTM_DEDQUO
LVCUT Reduction indicator for quota generation CHAR 1 0 PTM_LVCUT
LVMIN Min. No. of Calendar Days for Reduction for Quota Generation NUMC 3 0 PTM_LVMIN
LVMAX Max. No. of Calendar Days for Reduction for Quota Generation NUMC 3 0 PTM_LVMAX
ACCNT Account assignment necessary/permitted/not permitted CHAR 1 0 PTM_ACCNT
Account assignment possible
I Account assignment not possible
O Account assignment necessary

V_554S_N foreign key relationships

Table Field Check Table Check Field
0 V_554S_N ABSTY T5A4P Attendance/Absence Categories MANDT
0 V_554S_N ABSTY T5A4P Attendance/Absence Categories MOABW
0 V_554S_N ABSTY T5A4P Attendance/Absence Categories ABSTY
1 V_554S_N CRULE T556C Counting Rule for Attendances and Absences MANDT
1 V_554S_N CRULE T556C Counting Rule for Attendances and Absences MOPGK
1 V_554S_N CRULE T556C Counting Rule for Attendances and Absences MOZKO
1 V_554S_N CRULE T556C Counting Rule for Attendances and Absences CTYPE
1 V_554S_N CRULE T556C Counting Rule for Attendances and Absences SEQNO
0 V_554S_N KLBEW T554L Absence Valuation Rules MANDT
0 V_554S_N KLBEW T554L Absence Valuation Rules MOLGA
0 V_554S_N KLBEW T554L Absence Valuation Rules KLBEW
1 V_554S_N KLZBI T554Y Time Constraints in HR TIME MANDT
1 V_554S_N KLZBI T554Y Time Constraints in HR TIME INFTY
1 V_554S_N KLZBI T554Y Time Constraints in HR TIME KLZBI
0 V_554S_N MANDT T000 Clients MANDT