T5Q_SUPERSTREAM - Super Stream Master Table

Super Stream Master Table information is stored in SAP table T5Q_SUPERSTREAM.
It is part of development package PB13 in software component PA-PA-AU. This development package consists of objects that can be grouped under "HR master data: Australia".

Fields for table T5Q_SUPERSTREAM

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
RUNID	HR B2A: Global Object ID	X	PC_B2A_GLBID	CHAR	64
PERNR	Personnel Number	X	PERSNO	NUMC	16
SRNO	Super Stream Unique running sequence number	X	P13Q_SRNO	NUMC	20
STATUS	Status of Record		P13Q_STATUS	CHAR	4
SEQNR	Sequence Number		CDSEQ	NUMC	10
IABKRS	Payroll Area		ABKRS	CHAR	4
INPER	In-period for payroll		IPERI	CHAR	12
FPPER	For-period for garnishment		FPPER	CHAR	12
PAYTY	Payroll type		PAYTY	CHAR	2
PAYID	Payroll Identifier		PAYID	CHAR	2
BONDT	Off-cycle payroll payment date		BONDT	DATS	16
PAYDT	Pay date for payroll result		PAY_DATE	DATS	16
SDATE	Date of updation of Record		P13_SDATE	DATS	16
STIME	Time of update of record		P13_STIME	TIMS	12
SUSER	User Name		UNAME	CHAR	24
PRN2	Payment Reference Number		P13Q_PRN	CHAR	36
FCODE	Superannuation Fund Code		P13Q_FCODE	CHAR	8
NEGSP	Negatives Supported		P13_NEGSP	CHAR	10
FILID	FILE ID		P13_FILEID	CHAR	100
BUKRS	Company Code		BUKRS	CHAR	8
.INCLUDE				P13_SUPERMEMBER	0
LINID	LINE ID		P13_LINEID	NUMC	16
SOUID	Source Entity ID		P13_SRCEID	NUMC	22
SOENT	Source Entity ID Type		P13_SOUENTY	CHAR	82
SOADD	Source Electronic Service Address		P13_SOUADD	CHAR	240
ERMSG	Electronic Error Messaging		P13_ERRMSG	CHAR	20
SEABN	HR AU: Super Stream Source ABN		P13_SUPFABN	NUMC	22
SORGN	Sender Organization Name		P13_ORGNM	CHAR	240
SFNAM	Sender Family Name		P13_SFNAM	CHAR	80
SGNAM	Sender Given Name		P13_SGNAM	CHAR	80
SONAM	Sender Other Given Name		P13_SONAM	CHAR	80
SEMAL	Sender E-mail Address Text		P13_SEMAIL	CHAR	240
STELN	Telephone Contact Number		P13_TELNO	CHAR	20
PAABN	Payer ABN		P13_PABN	NUMC	22
PORGN	Payer Organization Name		P13Q_ORGNAME1	CHAR	240
PABSB	Bank State Branch Number		P13_SBRNO	CHAR	30
PAACN	Financial Institution Account Number		P13_FACNO	CHAR	40
PACNT	Financial Institution Account Name		P13_FACNM	CHAR	80
PYABN	HR AU: Super Stream Target ABN		P13_SUPTABN	NUMC	22
PYUSI	Unique Superannuation Identification Number		P13_USINO	CHAR	28
PYORG	Fund Organization Name		P13Q_ORGNAME2	CHAR	240
PYTAD	End Point URL		P13_EPURL	CHAR	240
PYMTH	Payment Method		P13_PAYMD	CHAR	30
TRNDT	Payment Date		P13_PAYDT	DATS	16
PRNUM	Payment Reference Number		P13Q_PRN	CHAR	36
BPAYC	BPay Biller Code		P13_BPBCD	CHAR	20
PYAMT	Super Stream Payment Amount		P13_SUPAMNT	CURR	7
PYBSB	Bank State Branch Number		P13_SBRNO	CHAR	30
PYACN	Financial Institution Account Number		P13_FACNO	CHAR	40
PYACT	Financial Institution Account Name		P13_FACNM	CHAR	80
ERABN	Employer ABN		P13_EABN	NUMC	22
LOCID	Location ID		P13_LOCID	CHAR	40
EORGN	Employer Organizational Name Text		P13_EORGNAM	CHAR	400
FNDGE	Superannuation Fund Generated Employer Identifier		P13Q_EMPLR	CHAR	40
TAXFN	Tax File Number (TFN)		P13Q_TAXFN	NUMC	18
NTITL	Person Name Title Text		P13_NTITL	CHAR	30	*
NSUFX	Person Name Suffix text		P13_NSUFX	CHAR	30	*
PFNAM	Member Family Name		P13_PFNAM	CHAR	80
PGNAM	Member Given Name		P13_PGNAM	CHAR	80
PONAM	Member Other Given Name		P13_PONAM	CHAR	80
SEXCD	Sex Code		P13_SEXCODE	CHAR	14
BDATE	Date of Birth		GBDAT	DATS	16
ADRCO	Address Usage Code		P13_ADDCD	CHAR	8
ADDL1	Address Details Line 1 Text		P13_ADL1	CHAR	140
ADDL2	Address Details Line 2 Text		P13_ADL2	CHAR	140
ADDL3	Address Details Line 3 Text		P13_ADL3	CHAR	140
ADDL4	Address Details Line 4 Text		P13_ADL4	CHAR	140
LOCNM	Locality Name Text		P13_LOCNAM	CHAR	140
PSTCD	Postal Code		PSTLZ_HR	CHAR	20
STACO	State or Territory Code		P13_STATCO	CHAR	140
CNTRY	Country/Region Key		LAND1	CHAR	6	*
MEMAL	E-mail Address		P13_EADDR	CHAR	240
MEMTL	Member Telephone Minimal Number Landline		P13_MTELNO	CHAR	40
MEMMB	Member Telephone Minimal Number Mobile		P13_MMOBNO	CHAR	40
MEMID	Member Client Identifier		P13_MEMIDEN	CHAR	40
PAYNO	Payroll Number Identifier		P13_PAYIDN	NUMC	16	*
EMPEN	Employee Employment End date		P13_EMPENDT	DATS	16
EMPET	Employment End Reason Text		P13_EMPENDTEXT	CHAR	60
PSTDT	Pay Period Start Date		P13_PSRTDT	DATS	16
PENDT	Pay Period End Date		P13_PENDT	DATS	16
SAGAM	Employer Super Annuation Guarantee Amount		P13_SGCAMT	CURR	7
AWDAM	Employer Contributions Award Or Productivity Amount		P13_AWDAMT	CURR	7
PCONT	Employee Personal Contributions Amount		P13_EECAMT	CURR	7
SALSC	Employer Contributions Salary Sacrificed Amount		P13_SCFAMT	CURR	7
VOLAM	Employer Voluntary contribution amount		P13_ERVOL	CURR	7
SPCON	Spouse Contribution Amount		P13_SPOUSE	CURR	7
CHCON	Child Contribution Amount		P13_CHILD	CURR	7
OTCON	Third Party Contribution Amount		P13_3PCNTR	CURR	7
EMSTD	Employment Start Date		P13_EMSTDT	DATS	16
ATWRK	At Work Indicator		P13_ATWRK	CHAR	14
ANBEN	Annual Salary for Benefits Amount		P13_ANBEN	CURR	7
ANCON	Annual Salary for Contributions Amount		P13_ANSALCON	CURR	7
ACONS	Super Contribution Start Date		P13_CONTSTDAT	DATS	16
ACONE	Super Contribution End Date		P13_CONTENDAT	DATS	16
AINAM	Annual Salary for Insurance Amount		P13_ANSALINS	CURR	7
WHRSW	Weekly Hours Worked Number		P13_WHRS	DEC	3
OCCUD	Occupation Description		P13_OCCDS	CHAR	80
INSIN	Insurance Opt Out Indicator		P13_INSIN	CHAR	20
FNDRG	Super Fund Registration Date		P13_FUNDREGDT	DATS	16
BENCT	Benefit Category		P13_BNFCT	CHAR	240
EMPST	HR AU: Employment Status Of Employee		P13_EMP_STAT	CHAR	40
COSDT	Super Contribution Commence Date		P13_CONTCOMDAT	DATS	16
COEDT	Super Contribution Cease Date		P13_CONTCEADAT	DATS	16
MEMRT	Member Registration Text		P13_REGTX	CHAR	80
MPRTX	Defined Benefit Member Pre Tax Contribution		P13_DBPRT	CURR	7
MPOTC	Defined Benefit Member Post Tax Contribution		P13_DBPOT	CURR	7
DBERC	Defined Benefit Employer Contribution		P13_DBERCON	CURR	7
NMPRT	Defined Benefit Notional Member Pre Tax Contribution		P13_DBNPRT	CURR	7
NMPOT	Defined Benefit Notional Member Post Tax Contribution		P13_DBNPOT	CURR	7
NOERC	Defined Benefit Notional Employer Contribution		P13_DBNERCON	CURR	7
ORTER	Ordinary Time Earnings		P13_DBOTE	CURR	7
APSWE	Actual Periodic Salary or Wages Earned		P13_DBAPS	CURR	7
SUAPD	Superannuable Allowances Paid		P13_DBSAP	CURR	7
NSUAP	Notional Superannuable Allowances		P13_DBNSAP	CURR	7
SERFR	Service Fraction		P13_DBSFR	DEC	4
SERED	Service Fraction Effective Date		P13_DBSED	DATS	16
FUTHR	Full Time Hours		P13_DBFTH	DEC	4
CONHR	Contracted Hours		P13_DBCNH	DEC	4
ACHRP	Actual Hours Paid		P13_DBAHP	DEC	4
EMLOC	Employee Location Identifier		P13_DBELOC	CHAR	40
DSERF	Defined Benefits Registration Service Fraction		P13_DBRSF	DEC	4
DSERS	Service Fraction Start Date		P13_DBRSD	DATS	16
DSERE	Service Fraction End Date		P13_DBRSED	DATS	16
EMPRT	Defined Benefit Employer Rate		P13_DBRER	DEC	3
EMPRS	Defined Benefit Employer Rate Start Date		P13_DBERS	DATS	16
EMPRE	Defined Benefit Employer Rate End Date		P13_DBERE	DATS	16
MERAT	Defined Benefit Member Rate		P13_DBMRT	DEC	3
MERAS	Defined Benefit Member Rate Start Date		P13_DBMRS	DATS	16
MERAE	Defined Benefit Member Rate End Date		P13_DBMRE	DATS	16
ANSA1	Defined Benefit Annual Salary 1		P13_DBAS1	CURR	7
ANSD1	Defined Benefit Annual Salary 1 Start Date		P13_DBASS1	DATS	16
ANSE1	Defined Benefit Annual Salary 1 End Date		P13_DBASE1	DATS	16
ANSA2	Defined Benefit Annual Salary 2		P13_DBAS2	CURR	7
ANSD2	Defined Benefit Annual Salary 2 Start Date		P13_DBASS2	DATS	16
ANSE2	Defined Benefit Annual Salary 2 End Date		P13_DBASE2	DATS	16
ANSA3	Defined Benefit Annual Salary 3		P13_DBAS3	CURR	7
ANSD3	Defined Benefit Annual Salary 3 Start Date		P13_DBASS3	DATS	16
ANSE3	Defined Benefit Annual Salary 3 End Date		P13_DBASE3	DATS	16
ANSA4	Defined Benefit Annual Salary 4		P13_DBAS4	CURR	7
ANSD4	Defined Benefit Annual Salary 4 Start Date		P13_DBASS4	DATS	16
ANSE4	Defined Benefit Annual Salary 4 End Date		P13_DBASE4	DATS	16
ANSA5	Defined Benefit Annual Salary 5		P13_DBAS5	CURR	7
ANSD5	Defined Benefit Annual Salary 5 Start Date		P13_DBASS5	DATS	16
ANSE5	Defined Benefit Annual Salary 5 End Date		P13_DBASE5	DATS	16
LWPCD	Leave Without Pay Code		P13_DBLWPC	NUMC	2
LWPCS	Leave Without Pay Code Start Date		P13_DBLWPS	DATS	16
LWPCE	Leave Without Pay Code End Date		P13_DBLWPE	DATS	16
ASIED	Annual Salary for Insurance Effective Date		P13_ASIED	DATS	16
ASBED	Annual Salary for Benefits Effective Date		P13_ASBED	DATS	16
EMSED	Employee Status Effective Date		P13_ESED	DATS	16
EBEND	Employee Benefit Category Effective Date		P13_EBCED	DATS	16
DEMLC	Employee Location Identifier		P13_DBELOC	CHAR	40
DEMLS	Employee Location Identifier Start Date		P13_ELOCS	DATS	16
DEMLE	Employee Location Identifier End Date		P13_ELOCE	DATS	16
ADICP	ADIC Payment		P13_ADIC	CURR	7
CODUD	Contribution Due Days		P13_CDUD	NUMC	2
NADIC	Negative ADIC Payment		P13_NADIC	CURR	7
NEPSC	Negative Employer Productivity Superannuation Contribution		P13_NEPSC	CURR	7
NEMCO	Negative Member Contribution		P13_NEMCO	CURR	7
FULTH	Full Time Hours		P13_FULTH	DEC	3
PARTH	Part Time Hours		P13_PARTH	DEC	3
PTHED	Part Time Hours Effective Date		P13_PTHED	DATS	16
MRPSD	Member Registration Pay Period Start Date		P13_MRPPSD	DATS	16
MRPED	Member Registration Pay Period End Date		P13_MRPPED	DATS	16