SAP ABAP Table ROIUX3_WORKPLACE_TC_0304 (Tax Reporting - Workplace Screen 0304 Table Control Struct)

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_WORKPLACE_TC_0304	Table Relationship Diagram
Short Description	Tax Reporting - Workplace Screen 0304 Table Control Struct

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 - JE Interface Table
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	.INCLUDE	☐				0	0	Tax Reporting - JE Interface Key Fields
4	RUN_ID	☐	OIUX3_RUN_ID	NUMC10	NUMC	10	0	Tax Reporting - Run ID
5	OR_LVL_1_NO	☐	OIUH_COMPANY	CHAR3	CHAR	3	0	Company Name Code
6	ACCT_PERD_DT	☐	OIUH_ACCOUNTING_PERIOD8	CHAR8	CHAR	8	0	Accounting Period(YYYYMM01)
7	BTCH_NO	☐	OIUH_BATCH_ID	CHAR4	CHAR	4	0	Batch ID
8	LE_NO	☐	OIUH_JELINENO	CHAR8	CHAR	8	0	Journal Entry Line Number
9	.INCLUDE	☐				0	0	Tax Reporting - JE Interface Non Key Fields
10	ACCT_NO	☐	OIUH_ACCTID	CHAR10	CHAR	10	0	Account ID	OIUH_RV_COA
11	ACCT_CAT_NO	☐	OIU_ACCT_CAT_CD	OIU_ACCT_CAT_CD	CHAR	4	0	Account category code
12	BTCH_TYP_CD	☐	OIUH_BATCH_TYPE	OIUH_BATCH_TYPE	CHAR	2	0	Batch Type
13	SYS_SRCE_CD	☐	OIUH_SUB_SYSTEM_SOURCE	CHAR2	CHAR	2	0	PRA application component source
14	TRANS_AM	☐	OIUX3_TRANS_AMT	OIUX3_SIGNED_DEC_11_2	DEC	11	2	JE Transaction Amount
15	TRANS_QY	☐	OIUH_TRANS_QUANTITY	OIUH_DEC11_2	DEC	11	2	JE Transaction Quantity
16	GR_AM	☐	OIUH_GROSS_AMOUNT	OIUH_CURR11_2	CURR	11	2	Gross Amount (Value)
17	GR_QY	☐	OIUH_GROSS_QTY	OIUH_DEC11_2	DEC	11	2	Gross Quantity
18	PD_CD	☐	OIU_FULL_PD_CD	OIU_FULL_PD_CD	CHAR	3	0	Full three char. product code (Major and Detail Products)	OIUX3_PDCD
19	VL_TYPE_CD	☐	OIUH_VOLTYPE	CHAR2	CHAR	2	0	Volume Type
20	PU_NO	☐	OIUH_PU_NO	CHAR6	CHAR	6	0	Purchaser Number
21	PU_SEQ_NO	☐	OIUH_PURCHASER_SEQUENCE_NUMBER	CHAR2	CHAR	2	0	Purchaser Sequence Number
22	PRDR_NO	☐	OIUH_PRODUCER	CHAR6	CHAR	6	0	Producer ID
23	PRDR_SEQ_NO	☐	OIUH_PRODUCER_SEQUENCE_NUMBER	CHAR2	CHAR	2	0	Producer Sequence Number
24	RVRS_RSN_CD	☐	OIUH_RVRS_REASON_CODE	CHAR2	CHAR	2	0	Reversal Reason Code
25	UNIT_OF_MEAS_CD	☐	OIUH_UNIT_OF_MEASURE	CHAR3	CHAR	3	0	Unit of Measure Code
26	CT_NO	☐	OIUH_CONTRACT_ID	CHAR6	CHAR	6	0	Contract ID
27	CT_TYPE_CD	☐	OIUH_CONTRACT_TYPE_CODE	CHAR2	CHAR	2	0	Contract Type code
28	DOI_PR_NO	☐	OIUH_PR_NO	CHAR8	CHAR	8	0	Property
29	DOI_SEQ_NO	☐	OIUH_DOI_NO	CHAR5	CHAR	5	0	Division of Interest (DOI) Number
30	WL_NO	☐	OIUH_WELL_NO	CHAR6	CHAR	6	0	Well ID Number
31	WC_NO	☐	OIUH_WELL_COMPLETION_ID	CHAR2	CHAR	2	0	Well Completion ID
32	ORIG_MP	☐	OIUH_ORIGINATING_MP_NO	CHAR6	CHAR	6	0	Originating Measurement Point Number
33	SA_MP_NO	☐	OIUH_SALES_MP_NUMBER	CHAR6	CHAR	6	0	Sales Measurement Point Number
34	SA_DT	☐	OIUH_SALES_DATE	CHAR10	CHAR	10	0	Sales Date
35	STATE_CD	☐	OIUH_STATE_CODE	CHAR2	CHAR	2	0	State Code
36	UNIT_PR_NO	☐	OIUH_UNIT_PROPERTY_NUMBER	CHAR8	CHAR	8	0	Unit Property Number
37	PROC_CO	☐	OIUH_PROCESSING_COMPANY_CODE	CHAR3	CHAR	3	0	Processing Company code
38	TAX_CD	☐	OIUH_TAX_CODE	CHAR2	CHAR	2	0	Tax Code
39	REF_NO	☐	OIUH_REFERENCE_NUMBER	CHAR10	CHAR	10	0	Reference Number
40	NWK_NO	☐	OIUH_DN_NO	H_DELIVERY_NWK	CHAR	4	0	Delivery Network number
41	SUBNWK_NO	☐	OIUH_SUBNWK_NO	H_SUBDN_NO	CHAR	4	0	Subnetwork Number
42	CHV_RPT_CD	☐	RKOSTL	KOSTL	CHAR	10	0	Template cost center	*
43	.INCLUDE	☐				0	0	Royalty Reporting - JE Interface Non Key Fields
44	BTU_QY	☐	OIUH_BTU_QUANTITY	OIUH_DEC7_3	DEC	7	3	BTU Quantity
45	PS_BASE_QY	☐	OIUH_PRESSURE_BASE	OIUH_DEC6_3	DEC	6	3	Pressure Base Quantity
46	GRV_QY	☐	OIUH_GRAVITY	OIUH_DEC3_1	DEC	3	1	Gravity
47	OWN_NO	☐	OIUH_OWNER	CHAR6	CHAR	6	0	Owner Number
48	OWN_SEQ_NO	☐	OIUH_OWNER_SEQUENCE_NUMBER	CHAR2	CHAR	2	0	Owner Sequence Number
49	OWN_INT_DECM_QY	☐	OIUH_OWN_INTEREST_DECIMAL_QTY	OIUH_DEC9_8	DEC	9	8	Owner Interest Decimal Quantity
50	OWN_INT_TYPE_CD	☐	OIUH_OWN_INTEREST_TYPE_CODE	CHAR2	CHAR	2	0	Owner Interest Type Code
51	OWN_INT_SEQ_NO	☐	OIUH_OWN_INTEREST_SEQ_NUMBER	CHAR2	CHAR	2	0	Owner Interest Sequence Number
52	PAY_CD	☐	OIUH_PAY_CODE	CHAR2	CHAR	2	0	Pay Code
53	OWN_BAL_DECM_QY	☐	OIUH_OWNER_DISBUR_DECIMAL	OIUH_DEC9_8	DEC	9	8	Owner Disbursement (Balance) Decimal
54	MMBTU_OVL_AM	☐	OIUH_OWNER_MMBTU	OIUH_DEC11_2	DEC	11	2	Owner MMBTU
55	NET_TRANSP_AM	☐	OIUH_TRANSPORTATION_AMT	OIUH_CURR11_2	CURR	11	2	Net Transportation Amount
56	NET_OTH_MK_AM	☐	OIUH_NET_OTH_MARKETING_AMOUNT	OIUH_CURR11_2	CURR	11	2	Net Other Marketing Amount
57	TXN_VAL_AM	☐	OIUH_TRAN_OWNER_AMOUNT	OIUH_CURR11_2	CURR	11	2	Transaction Owner Amount
58	DED_RMB_AM	☐	OIUH_DED_REIMB_AMOUNT	OIUH_CURR11_2	CURR	11	2	Deduction/Reimbursement Amount
59	TAX_RMB_AM	☐	OIUH_TAX_REIMBURSEMENT_AMT	OIUH_CURR11_2	CURR	11	2	Tax Reimbursement Amount

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIUX3_WORKPLACE_TC_0304	ACCT_NO	OIUH_RV_COA	COA_ACCT_NO	REF
2	ROIUX3_WORKPLACE_TC_0304	MANDT	T000	MANDT	KEY
3	ROIUX3_WORKPLACE_TC_0304	PD_CD	OIUX3_PDCD	PDCD	REF

History

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