SAP ABAP Table ROIUX3_RPT_PROF_ALV_0200 (Tax Reporting - Reporting Profile Screen 0200 ALV Structure)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-TAX (Application Component) Tax Reporting
     ⤷ OIU_X3 (Package) Tax 2.0

Basic Data

Table Category	INTTAB	Structure
Structure	ROIUX3_RPT_PROF_ALV_0200	Table Relationship Diagram
Short Description	Tax Reporting - Reporting Profile Screen 0200 ALV 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	.INCLUDE	☐				0	0	Tax Reporting - Reporting Profile
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	RPT_COMP	☐	OIUX3_REPORTING_COMPANY	CHAR4	CHAR	4	0	Reporting Company	OIUX3_RPT_COMP
4	RPT_ID	☐	OIUX3_RPT_ID	OIUX3_RPT_ID	CHAR	10	0	Tax Reporting - Report ID	OIUX3_RPT_COMP
5	EFF_FROM_DT	☐	OIU_EFF_FROM_DT	DATUM	DATS	8	0	Effective from date
6	EFF_TO_DT	☐	OIU_EFF_TO_DT	DATUM	DATS	8	0	Effective To Date
7	TAXPAYER_NUMBER	☐	OIUX3_TAXPAYER_NUMBER	TEXT20	CHAR	20	0	Tax Reporting - Taxpayer Number
8	TAXPAYER_NAME	☐	OIUX3_TAXPAYER_NAME	TEXT100	CHAR	100	0	Taxpayer Name
9	ADDRESS_LINE1	☐	OIUX3_TAXPAYER_ADDRESS_LINE	TEXT35	CHAR	35	0	Tax Reporting - Taxpayer Address Line
10	ADDRESS_LINE2	☐	OIUX3_TAXPAYER_ADDRESS_LINE	TEXT35	CHAR	35	0	Tax Reporting - Taxpayer Address Line
11	ADDRESS_LINE3	☐	OIUX3_TAXPAYER_ADDRESS_LINE	TEXT35	CHAR	35	0	Tax Reporting - Taxpayer Address Line
12	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
13	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
14	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
15	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
16	CONTACT_NAME	☐	OIUX3_CONTACT_NAME	TEXT50	CHAR	50	0	Tax Reporting - Contact Name
17	CONTACT_PHONE_NO	☐	OIUX3_CONTACT_PHONE_NUMBER	NUMC10	NUMC	10	0	Tax Reporting - Contact Phone Number
18	CONTACT_PHONE_EX	☐	OIUX3_CONTACT_PHONE_EXTENSION	CHAR5	CHAR	5	0	Tax Reporting - Contact Phone Extension
19	CONTACT_EMAIL	☐	OIUX3_CONTACT_EMAIL	TEXT80	CHAR	80	0	Tax Reporting - Contact Email Address
20	FEIN_SSN	☐	OIUX3_FEIN_SSN		NUMC	9	0	Tax 2.0 - FEIN/SSN
21	.INCLUDE	☐				0	0	Tax Reporting - Last Changed Structure
22	CHANGE_USER	☐	OIUX3_LAST_CHANGED_USER	USNAM	CHAR	12	0	Tax Reporting - Last Changed User
23	CHANGE_DATE	☐	OIUX3_LAST_CHANGED_DATE		DATS	8	0	Tax Reporting - Last Changed Date
24	CHANGE_TIME	☐	OIUX3_LAST_CHANGED_TIME		TIMS	6	0	Tax Reporting - Last Changed Time
25	CONTACT_FAX_NO	☐	OIUX3_CONTACT_FAX_NUMBER	NUMC10	NUMC	10	0	Contact Fax Number
26	BAN_NO	☐	OIUX3_BLANKET_AUTH_NO	CHAR4	CHAR	4	0	Blanket Authorization Number
27	ACCOUNT_NO	☐	OIUX3_ACCOUNT_NO	NUMC10	NUMC	10	0	Rpt 2.0 - Account Number
28	RPT_COMP_DESC	☐	OIUX3_REPORTING_COMPANY_NAME	TEXT50	CHAR	50	0	Tax Reporting - Reporting Company Name
29	RPT_DESC	☐	OIUX3_RPT_NAME	TEXT50	CHAR	50	0	Tax Reporting - Report Name

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIUX3_RPT_PROF_ALV_0200	LAND1	T005	LAND1	REF
2	ROIUX3_RPT_PROF_ALV_0200	MANDT	T000	MANDT	KEY
3	ROIUX3_RPT_PROF_ALV_0200	REGIO	T005S	BLAND	REF
4	ROIUX3_RPT_PROF_ALV_0200	RPT_COMP	OIUX3_RPT_COMP	RPT_COMP	KEY
5	ROIUX3_RPT_PROF_ALV_0200	RPT_ID	OIUX3_RPT_COMP	RPT_ID	KEY

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C