SAP table OIRECH (SSR PC: Clearing House table (IS-Oil SSR))

SAP table OIRECH has 2 primary key fields being MANDT,CHOBJ.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
CHOBJ SSR PC: Clearing house CHAR 6 0 OIRE_CHOBJ
KTOPL Chart of Accounts CHAR 4 0 T004 KTOPL
BUKRS Company Code CHAR 4 0 T001 BUKRS
HKONT_V SSR PC: Receivables account for payment card transactions CHAR 10 0 SKA1 OIRE_HKONT_V
HKONT_N SSR PC: Cash clearing account CHAR 10 0 SKA1 OIRE_HKONT_N
ADRNR SSR PC: Address number CHAR 10 0 ADRC OIRE_ADRNR
CHSMS SSR PC: Clearing house settlement message structure CHAR 10 0 OIRHCHSMSC OIRE_CHSMS
KSCYC SSR PC: CO distribution cycle CHAR 6 0 OIRE_KSCYC
CYCBADI BADI for fee cost distribution CHAR 20 0 OIRI_DIST_VAL OIRI_DIST_BADI
INVMETH Invoicing method for SSR Invoicing CHAR 3 0 OIRIMTYP OIRI_INVMETH
FNSET SSR PC: Settlement function CHAR 30 0 TFDIR OIRE_FNSET
RFCSET SSR PC: Logical destination (specified in function call) CHAR 32 0 RFCDES OIRE_RFCDEST
KONDT SSR PC: Condition type calculation level CHAR 2 0 OIRE_KONDT
DT Overall total for the settlement period
SP Sum of Location level for settlement period
TL Transaction level
OCMID1 SSR PC: Merchant ID 1 of the company CHAR 10 0 OIRE_OCMID1
OCMID2 SSR PC: Merchant ID 2 of the company CHAR 10 0 OIRE_OCMID2
OCMID3 SSR PC: Merchant ID 3 of the company CHAR 10 0 OIRE_OCMID3
OCMID4 SSR PC: Merchant ID 4 of the company CHAR 10 0 OIRE_OCMID4
OCMTX SSR PC: Merchant ID text of the company CHAR 40 0 OIRE_OCMTX
AUGLV SSR PC: Clearing house settlement clearing procedure CHAR 8 0 T041A OIRE_AUGLV
NUMRI SSR PC: Settlement document run number (internal) CHAR 2 0 OIRE_SETTLNR_NUMRI
NUMRE SSR PC: Settlement document run number (external) CHAR 2 0 OIRE_SETTLNR_NUMRE
NUMRI_TRNSM Number range for settlement transmission number CHAR 2 0 OIRH_TRNSMN_NUMRI
CONVGR SSR Interface conversion group definition (IS-Oil, SSR) CHAR 4 0 OIRHCVGRDEFC OIRH_CONVGR
LOGSYS Logical system for EDI CHAR 10 0 TBDLS OIRH_LOGSYS
HKONT_W SSR PC: Write off account for oil co. respons. Cr Card Txns CHAR 10 0 SKA1 OIRE_HKONT_W
BLART Document Type CHAR 2 0 T003 BLART
SDDOCCHK SSR PC: Check indicator to create SD Billing Doc at settlemt CHAR 1 0 OIRE_SDDOCCHK
CODISTCHK SSR PC: Check indicator to create CO distribut'n at settlemt CHAR 1 0 OIRE_CODISTCHK
FIDOCCHK SSR PC: Check indicator to create FI Document at settlement CHAR 1 0 OIRE_FIDOCCHK
KONWA_TR Transmission currency CUKY 5 0 TCURC OIRH_KONWA_TR
KURST_TR Transmission exchange rate type CHAR 4 0 TCURV OIRH_KURST_TR
KONWA_FI SSR PC FI Document Transaction Currency CUKY 5 0 TCURC OIRE_KONWA_FI
KURST_FI SSR PC FI Document Exchange Rate Type CHAR 4 0 TCURV OIRE_KURST_FI

OIRECH foreign key relationships

Table Field Check Table Check Field
0 OIRECH ADRNR ADRC Addresses (Business Address Services) DATE_FROM
0 OIRECH ADRNR ADRC Addresses (Business Address Services) NATION
1 OIRECH BLART T003 Document Types MANDT
0 OIRECH BUKRS T001 Company Codes BUKRS
1 OIRECH CHSMS OIRHCHSMSC Clearing House Settlement - Message structures (IS-Oil SSR) MSGSTRUC
0 OIRECH CONVGR OIRHCVGRDEFC Conversion Group Definitions(IS-Oil, SSR) MANDT
0 OIRECH CONVGR OIRHCVGRDEFC Conversion Group Definitions(IS-Oil, SSR) CONVGR
1 OIRECH FNSET TFDIR Function Module FUNCNAME
0 OIRECH HKONT_N SKA1 G/L Account Master (Chart of Accounts) MANDT
0 OIRECH HKONT_N SKA1 G/L Account Master (Chart of Accounts) KTOPL
0 OIRECH HKONT_N SKA1 G/L Account Master (Chart of Accounts) SAKNR
1 OIRECH HKONT_V SKA1 G/L Account Master (Chart of Accounts) MANDT
1 OIRECH HKONT_V SKA1 G/L Account Master (Chart of Accounts) KTOPL
1 OIRECH HKONT_V SKA1 G/L Account Master (Chart of Accounts) SAKNR
0 OIRECH HKONT_W SKA1 G/L Account Master (Chart of Accounts) MANDT
0 OIRECH HKONT_W SKA1 G/L Account Master (Chart of Accounts) KTOPL
0 OIRECH HKONT_W SKA1 G/L Account Master (Chart of Accounts) SAKNR
1 OIRECH INVMETH OIRIMTYP SSR Invoicing - Invoicing method parameters MANDT
0 OIRECH KONWA_FI TCURC Currency Codes MANDT
0 OIRECH KONWA_FI TCURC Currency Codes WAERS
1 OIRECH KONWA_TR TCURC Currency Codes MANDT
1 OIRECH KONWA_TR TCURC Currency Codes WAERS
0 OIRECH KTOPL T004 Directory of Charts of Accounts MANDT
1 OIRECH KURST_FI TCURV Exchange rate types for currency translation MANDT
1 OIRECH KURST_FI TCURV Exchange rate types for currency translation KURST
0 OIRECH KURST_TR TCURV Exchange rate types for currency translation MANDT
0 OIRECH KURST_TR TCURV Exchange rate types for currency translation KURST
1 OIRECH LOGSYS TBDLS Logical system LOGSYS
0 OIRECH MANDT T000 Clients MANDT