SAP ABAP Table BSIUDTT (HR-US: BSI test data (tax record))

Hierarchy

☛ SAP_HRCUS (Software Component) Sub component SAP_HRCUS of SAP_HR
   ⤷ PY-US-NT-TX-BSI (Application Component) BSI
     ⤷ PZ1B (Package) HR payroll accounting: BSI tax interface for USA

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	BSIUDTT	Table Relationship Diagram
Short Description	HR-US: BSI test data (tax record)

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	TSTCASE	☑	PC10_TSTNO	PC10_TSTNO	NUMC	5	0	BSI: Test Case Number	BSIUDTA
3	SEQNO	☑	NUMC2	NUMC2	NUMC	2	0	Two digit number
4	AUTH_CODE	☐	BSIAUTHCOD	BSI_CHAR11	CHAR	11	0	Authority Code
5	RESID_CODE	☐	BSIRESCODE	BSI_SHRT01	CHAR	1	0	Resident Code
6	TAX_TYPE	☐	BSITAXTYPE	BSI_CHAR02	CHAR	2	0	Tax Type
7	RECIP_FORM	☐	BSIRCIPFRM	BSI_SHRT06	CHAR	6	0	Reciprocal Formula
8	FORMULA_NO	☐	BSIFORMUNO	BSI_SHRT06	CHAR	6	0	Formula Number
9	TAX_EX_IND	☐	BSITXEXIND	BSI_SHRT01	CHAR	1	0	Tax Exemption Indicator
10	RECI_PARTI	☐	BSIRCIPART	BSI_SHRT01	CHAR	1	0	Reciprocal Participation
11	CERT_CODE	☐	BSICERTCOD	BSI_SHRT01	CHAR	1	0	Certificate Code
12	PAY_PER_WA	☐	BSIPAYPRWA	BSI_AMOUNT	CHAR	24	0	Pay Period Wages
13	PAYPERWAID	☐	BSI_BOOL	CHAR1	CHAR	1	0	BSI interface: BOOL
14	YTD_WAGES	☐	BSIYTDWAGE	BSI_AMOUNT	CHAR	24	0	Year To Date Wages
15	YTD_TAX	☐	BSIYTD_TAX	BSI_AMOUNT	CHAR	24	0	Year To Date Tax
16	ROUND_IND	☐	BSIRONDIND	BSI_SHRT01	CHAR	1	0	Rounding Indicator
17	MAR_STA_IN	☐	BSIMARSTIN	BSI_SHRT02	CHAR	2	0	Marital Status Indicator
18	REG_EXEMP	☐	BSIREGEXMP	BSI_SHRT06	CHAR	6	0	Regular Exemptions
19	REG_EXE_AM	☐	BSIREGEXAM	BSI_AMOUNT	CHAR	24	0	Regular Exemption Amount
20	PERS_EXEMP	☐	BSIPERSEXM	BSI_SHRT06	CHAR	6	0	Personal Exemptions
21	DEPE_EXEMP	☐	BSIDEPEEXM	BSI_SHRT06	CHAR	6	0	Dependent Exemptions
22	ADD_EXEMP	☐	BSIADDEXMP	BSI_SHRT06	CHAR	6	0	Additional Exemptions
23	ADD_EX_AM	☐	BSIADDEXAM	BSI_AMOUNT	CHAR	24	0	Additional Exemption Amount
24	SUPPL_CODE	☐	BSISUPLCOD	BSI_SHRT01	CHAR	1	0	Supplemental Code
25	BASE_WAGES	☐	BSIBASWAGE	BSI_AMOUNT	CHAR	24	0	Base Wages
26	ADD_TAX_CO	☐	BSIADTAXCO	BSI_SHRT01	CHAR	1	0	Additional Tax Code
27	ADD_TAX_RT	☐	BSIADTAXRT	BSI_RATE	CHAR	24	0	Additional Tax Rate
28	ADD_AMOUNT	☐	BSIADAMONT	BSI_AMOUNT	CHAR	24	0	Additional Amount
29	EIC_STATUS	☐	BSIEICSTAT	BSI_SHRT01	CHAR	1	0	EIC Status Indicator
30	PAY_PER_TX	☐	BSIPAYPRTX	BSI_AMOUNT	CHAR	24	0	Pay Period Tax
31	MTD_WAGES	☐	BSIMTDWAGE	BSI_AMOUNT	CHAR	24	0	Month To Date or Quarter to Date Wages
32	MTD_TAX	☐	BSIMTD_TAX	BSI_AMOUNT	CHAR	24	0	Month To Date or Quarter to Date Taxes
33	PERC_WORKD	☐	BSIPRCWRKD	BSI_RATE	CHAR	24	0	Percent Worked
34	R_TX_CR_AM	☐	BSIRTXCRAM	BSI_AMOUNT	CHAR	24	0	Reciprocal Tax Credit Amount
35	EXPERIE_RT	☐	BSIEXPIERT	BSI_RATE	CHAR	24	0	Experience Rate
36	MAX_WG_OVR	☐	BSIMXWGOVR	BSI_AMOUNT	CHAR	24	0	Maximum Wage Override
37	SE_ADJ_TAX	☐	BSISEADJTX	BSI_SHRT01	CHAR	1	0	Self Adjust Tax
38	CALCED_TAX	☐	BSICALCDTX	BSI_AMOUNT	CHAR	24	0	Calculated Tax
39	TAXBLE_WAG	☐	BSITXBLWAG	BSI_AMOUNT	CHAR	24	0	Taxable Wages
40	TOTAL_WAG	☐	BSI_AMOUNT	CHAR_DOUBL	CHAR	24	0	BSI interface: AMOUNT
41	TAX_RATE	☐	BSITAXRATE	BSI_RATE	CHAR	24	0	Tax Rate
42	TAX_EXEMP	☐	BSITAXEXMP	BSI_AMOUNT	CHAR	24	0	Total Exemption Value
43	CALC_STA	☐	BSICLCSTA	BSI_SHRT01	CHAR	1	0	Calculation Status

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BSIUDTT	MANDT	T000	MANDT	KEY	1	CN
2	BSIUDTT	TSTCASE	BSIUDTA	TSTCASE	KEY	1	CN

History

Last changed by/on	SAP	19980706
SAP Release Created in