SAP ABAP Table J_1IE_RCT (Table for Storing contract details(Ireland))

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ ID-FI-WT (Package) Withholding Tax reporting

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	J_1IE_RCT	Table Relationship Diagram
Short Description	Table for Storing contract details(Ireland)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	LIFNR	☑	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
3	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	IE_CONTRACT_NO	☑	IE_CONTRACT_NO	INT4	INT4	10	0	Contract Number for Multiple Contracts
5	IE_NO_TAX	☐	IE_NO_TAX	XFELD	CHAR	1	0	Activate Tax Number
6	IE_FIXED_PLACE	☐	IE_FIXED_PLACE	XFELD	CHAR	1	0	Fixed Business Place
7	IE_CONTRACT_RATE	☐	IE_CONTRACT_RATE	PRZ32	DEC	5	2	Contract Deduction Rate
8	IE_SECTOR	☐	IE_SECTOR	IE_SECTOR	INT1	3	0	Sector
9	IE_NATURE	☐	IE_NATURE	CHAR90	CHAR	90	0	Nature of Work
10	IE_LOCATION	☐	IE_LOCATION	CHAR90	CHAR	90	0	Location of Work
11	IE_START_DATE	☐	IE_START_DATE	DATUM	DATS	8	0	Start Date
12	IE_END_DATE	☐	IE_END_DATE	DATUM	DATS	8	0	End Date
13	IE_CONTRACT_VAL	☐	IE_CONTRACT_VAL	INT4	INT4	10	0	Estimated Value of Contract
14	IE_IFPARTNERSHIP	☐	IE_IF_PARTNERSHIP	XFELD	CHAR	1	0	Subcontractor Partnership
15	IE_PARTNER_NAME	☐	IE_PARTNER_NAME	CHAR70	CHAR	70	0	Partner Name
16	IE_PARTNER_DOB	☐	IE_PARTNER_DOB	DATUM	DATS	8	0	Date of Birth
17	IE_NOTICE_EXCL	☐	IE_NOTICE_EXCL	XFELD	CHAR	1	0	Laborless Contract
18	IE_SUPPLY_MATRL	☐	IE_SUPPLY_MATRL	XFELD	CHAR	1	0	Material Supply
19	IE_PROVIDE_MACH	☐	IE_PROVIDE_MACH	XFELD	CHAR	1	0	Plant and Machinery
20	IE_ENGAGE_OTHERS	☐	IE_ENGAGE_OTHERS	XFELD	CHAR	1	0	Indicator : If subcontractor engages others people
21	IE_REC_PAYMT	☐	IE_REC_PAYMT	XFELD	CHAR	1	0	Contract Payment Received
22	IE_PENSION_EXC	☐	IE_PENSION_EXC	IE_PENSION_EXC	CHAR	1	0	Exclusion from Industry Pension
23	IE_ORGANISE_TRAN	☐	IE_ORGANISE_TRAN	XFELD	CHAR	1	0	Self-Transport
24	IE_AGREE_PRICE	☐	IE_AGREE_PRICE	XFELD	CHAR	1	0	Agreed Subcontractor Cost
25	IE_PROVIDE_INSRC	☐	IE_PROVIDE_INSRC	XFELD	CHAR	1	0	Insurance Cover
26	IE_CHOOSE_METHOD	☐	IE_CHOOSE_METHOD	XFELD	CHAR	1	0	Subcontractor Method
27	IE_OWN_ACCOUNT	☐	IE_OWN_ACCOUNT	XFELD	CHAR	1	0	Own Account
28	IE_FINANCIAL_EXP	☐	IE_FINANCIAL_EXP	XFELD	CHAR	1	0	Exposure to Financial Risk
29	IE_DCLRN_CHK	☐	IE_DCLRN_CHK	XFELD	CHAR	1	0	Contract Declaration
30	IE_CONTRACT_ID	☐	IE_CONTRACT_ID	INT4	INT4	10	0	Contract identifier from Tax Authority
31	IE_PAYMT_ID	☐	IE_PAYMT_ID	INT4	INT4	10	0	Payment Notification Identifier
32	IE_CONTRACT_DESC	☐	IE_CONTRACT_DESC	CHAR60	CHAR	60	0	Contract Description
33	IE_CANCELLED_CON	☐	IE_CANCELLED_CONTRACT	XFELD	CHAR	1	0	Marked for Cancellation
34	IE_ORGN_COUNTRY	☐	IE_ORGN_COUNTRY	QLAND	CHAR	3	0	Country of Origin	T005Q
35	IE_COUNTRY	☐	IE_COUNTRY	QLAND	CHAR	3	0	Country	T005Q
36	IE_PAY_ID	☐	IE_PAYMT_ID	INT4	INT4	10	0	Payment Notification Identifier
37	IE_EXM_DATE	☐	IE_START_DATE	DATUM	DATS	8	0	Start Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_1IE_RCT	BUKRS	T001	BUKRS
2	J_1IE_RCT	IE_COUNTRY	T005Q	QLAND
3	J_1IE_RCT	IE_ORGN_COUNTRY	T005Q	QLAND
4	J_1IE_RCT	LIFNR	LFA1	LIFNR

History

Last changed by/on	SAP	20130529
SAP Release Created in