SAP ABAP Table V_OIRECH_ALL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_OIRECH_ALL	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	CHOBJ	☑	OIRE_CHOBJ	OIRE_CHOBJ	CHAR	6	0	SSR PC: Clearing house	*
3	KTOPL	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	T004
4	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
5	HKONT_V	☐	OIRE_HKONT_V	SAKNR	CHAR	10	0	SSR PC: Receivables account for payment card transactions	SKA1
6	HKONT_N	☐	OIRE_HKONT_N	SAKNR	CHAR	10	0	SSR PC: Cash clearing account	SKA1
7	ADRNR	☐	OIRE_ADRNR	AD_ADDRNUM	CHAR	10	0	SSR PC: Address number	ADRC
8	CHSMS	☐	OIRE_CHSMS	OIRH_CHSMS	CHAR	10	0	SSR PC: Clearing house settlement message structure	OIRHCHSMSC
9	KSCYC	☐	OIRE_KSCYC	CHAR6	CHAR	6	0	SSR PC: CO distribution cycle
10	CYCBADI	☐	OIRI_DIST_BADI	OIRI_DIST_BADI	CHAR	20	0	BADI for fee cost distribution	OIRI_DIST_VAL
11	INVMETH	☐	OIRI_INVMETH	OIRI_INVMETH	CHAR	3	0	Invoicing method for SSR Invoicing	OIRIMTYP
12	FNSET	☐	OIRE_FNSET	FUNCNAME	CHAR	30	0	SSR PC: Settlement function	TFDIR
13	RFCSET	☐	OIRE_RFCDEST	RFCDEST	CHAR	32	0	SSR PC: Logical destination (specified in function call)	RFCDES
14	KONDT	☐	OIRE_KONDT	OIRE_KONDT	CHAR	2	0	SSR PC: Condition type calculation level
15	OCMID1	☐	OIRE_OCMID1	CHAR10	CHAR	10	0	SSR PC: Merchant ID 1 of the company
16	OCMID2	☐	OIRE_OCMID2	CHAR10	CHAR	10	0	SSR PC: Merchant ID 2 of the company
17	OCMID3	☐	OIRE_OCMID3	CHAR10	CHAR	10	0	SSR PC: Merchant ID 3 of the company
18	OCMID4	☐	OIRE_OCMID4	CHAR10	CHAR	10	0	SSR PC: Merchant ID 4 of the company
19	OCMTX	☐	OIRE_OCMTX	CHAR40	CHAR	40	0	SSR PC: Merchant ID text of the company
20	AUGLV	☐	OIRE_AUGLV	AUGLV	CHAR	8	0	SSR PC: Clearing house settlement clearing procedure	T041A
21	NUMRI	☐	OIRE_SETTLNR_NUMRI	CHAR2	CHAR	2	0	SSR PC: Settlement document run number (internal)
22	NUMRE	☐	OIRE_SETTLNR_NUMRE	CHAR2	CHAR	2	0	SSR PC: Settlement document run number (external)
23	NUMRI_TRNSM	☐	OIRH_TRNSMN_NUMRI	CHAR2	CHAR	2	0	Number range for settlement transmission number
24	CONVGR	☐	OIRH_CONVGR	CHAR4	CHAR	4	0	SSR Interface conversion group definition (IS-Oil, SSR)	OIRHCVGRDEFC
25	LOGSYS	☐	OIRH_LOGSYS	LOGSYS	CHAR	10	0	Logical system for EDI	TBDLS
26	HKONT_W	☐	OIRE_HKONT_W	SAKNR	CHAR	10	0	SSR PC: Write off account for oil co. respons. Cr Card Txns	SKA1
27	KUNNR	☐	OIRE_KUNNR_SOLD_TO	KUNNR	CHAR	10	0	SSR PC: Customer: Sold-to party	KNA1
28	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVTA
29	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTA
30	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
31	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	CSKS
32	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
33	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
34	SDDOCCHK	☐	OIRE_SDDOCCHK	CHAR1	CHAR	1	0	SSR PC: Check indicator to create SD Billing Doc at settlemt
35	CODISTCHK	☐	OIRE_CODISTCHK	CHAR1	CHAR	1	0	SSR PC: Check indicator to create CO distribut'n at settlemt
36	FIDOCCHK	☐	OIRE_FIDOCCHK	CHAR1	CHAR	1	0	SSR PC: Check indicator to create FI Document at settlement
37	FEEMATNR	☐	OIRE_CHFEEMATNR	MATNR	CHAR	18	0	SSR PC: Default materials for clearing house fee	MARA
38	DISCMATNR	☐	OIRE_CHMATNR	MATNR	CHAR	18	0	SSR PC: Default materials for clearing house discounts	MARA
39	MATCH_PARMS	☐	OIRE_MATCHPARMS	OIRE_MATCHPARMS	CHAR	1	0	SSR PC Reconciliation - Matching User/Admin Defined
40	MATCH_KEYNO	☐	OIRE_MATCH_KEYNO	CHAR3	CHAR	3	0	Matching Key Number	OIRE_MATCHKEY
41	DESCR_REC	☐	OIRA_DESCR	TEXT50	CHAR	50	0	Descriptive text
42	DIFFTOL_BADI	☐	OIRE_DIFFTOL_BADI	OIRE_DIFFTOL_BADI	CHAR	20	0	SSR PC Reconciliation - Difference Tolerance BADI	OIRE_DIFFTOL_VAL
43	RECON_BADI	☐	OIRE_RECON_BADI	OIRE_RECON_BADI	CHAR	20	0	Reconciliation BADI: filter values	OIRE_RECON_VAL
44	RECCAL	☐	OIRE_RECON_CAL	WFCID	CHAR	2	0	SSR PC - Calendar for executing PC Reconciliation	TFACD
45	RECCAL_BADI	☐	OIRE_CHCAL_BADI	OIRE_CHCAL_BADI	CHAR	20	0	SSR PC: Calendar BADI to execute cl house processing/recon.	OIRE_CHCAL_VAL
46	KONWA_TR	☐	OIRH_KONWA_TR	WAERS	CUKY	5	0	Transmission currency	TCURC
47	KURST_TR	☐	OIRH_KURST_TR	KURST	CHAR	4	0	Transmission exchange rate type	TCURV
48	COMPRES	☐	OIRE_COMPRES	OIRE_COMPRES	CHAR	3	0	SSR PC: Complaint result	OIRECOMPRES
49	DET_AGG_IND	☐	OIRE_DET_AGG_IND	OIRE_DET_AGG_IND	CHAR	1	0	Detail/Aggregation indicator (values: D or A)
50	KONWA_FI	☐	OIRE_KONWA_FI	WAERS	CUKY	5	0	SSR PC FI Document Transaction Currency	TCURC
51	KURST_FI	☐	OIRE_KURST_FI	KURST	CHAR	4	0	SSR PC FI Document Exchange Rate Type	TCURV

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_OIRECH_ALL	ADRNR	ADRC	ADDRNUMBER	REF	1	CN
2	V_OIRECH_ALL	AUGLV	T041A	AUGLV	REF	1	CN
3	V_OIRECH_ALL	BLART	T003	BLART
4	V_OIRECH_ALL	BUKRS	T001	BUKRS	KEY	1	N
5	V_OIRECH_ALL	CHSMS	OIRHCHSMSC	MSGSTRUC
6	V_OIRECH_ALL	COMPRES	OIRECOMPRES	COMPRES	REF	1	N
7	V_OIRECH_ALL	CONVGR	OIRHCVGRDEFC	CONVGR
8	V_OIRECH_ALL	CYCBADI	OIRI_DIST_VAL	DIST_ROUTINE	REF	1	CN
9	V_OIRECH_ALL	DIFFTOL_BADI	OIRE_DIFFTOL_VAL	DIFFTOL_BADI	REF	1	N
10	V_OIRECH_ALL	DISCMATNR	MARA	MATNR	REF	1	N
11	V_OIRECH_ALL	FEEMATNR	MARA	MATNR	REF	1	N
12	V_OIRECH_ALL	FNSET	TFDIR	FUNCNAME	REF	1	CN
13	V_OIRECH_ALL	HKONT_N	SKA1	SAKNR	REF	1	CN
14	V_OIRECH_ALL	HKONT_V	SKA1	SAKNR	REF	1	CN
15	V_OIRECH_ALL	HKONT_W	SKA1	SAKNR	REF	1	CN
16	V_OIRECH_ALL	INVMETH	OIRIMTYP	INVMETH		1	CN
17	V_OIRECH_ALL	KOKRS	CSKS	KOKRS	REF	1	CN
18	V_OIRECH_ALL	KONWA_FI	TCURC	WAERS	REF	1	N
19	V_OIRECH_ALL	KONWA_TR	TCURC	WAERS	REF
20	V_OIRECH_ALL	KOSTL	CSKS	KOSTL	KEY	1	CN
21	V_OIRECH_ALL	KTOPL	T004	KTOPL	REF	1	N
22	V_OIRECH_ALL	KUNNR	KNA1	KUNNR	REF	1	CN
23	V_OIRECH_ALL	KURST_FI	TCURV	KURST	REF	1	N
24	V_OIRECH_ALL	KURST_TR	TCURV	KURST	REF
25	V_OIRECH_ALL	LOGSYS	TBDLS	LOGSYS
26	V_OIRECH_ALL	MANDT	T000	MANDT	KEY	1	N
27	V_OIRECH_ALL	MATCH_KEYNO	OIRE_MATCHKEY	MATCH_KEYNO	REF	1	N
28	V_OIRECH_ALL	RECCAL	TFACD	IDENT	REF	1	N
29	V_OIRECH_ALL	RECCAL_BADI	OIRE_CHCAL_VAL	CHCALBADI		1	N
30	V_OIRECH_ALL	RECON_BADI	OIRE_RECON_VAL	RECON_BADI	REF	1	N
31	V_OIRECH_ALL	RFCSET	RFCDES	RFCDEST	REF	1	N
32	V_OIRECH_ALL	SPART	TVTA	SPART	REF	1	CN
33	V_OIRECH_ALL	VKORG	TVTA	VKORG	REF	1	CN
34	V_OIRECH_ALL	VTWEG	TVTA	VTWEG	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in