SAP table OIUHS_JE_ACC_TYP (PRA: Journal Entry Posting Rules per Account Type)
SAP table OIUHS_JE_ACC_TYP has 3 primary key fields being MANDT,BUKRS,ACC_TYP.
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
Client
CLNT
3
0
MANDT
Company Code
CHAR
4
0
T001
BUKRS
Account Type for Posting Rules
CHAR
2
0
OIUHS_ACC_TYP
Possible values
AP
Account Payable
AR
Account Receivable
EX
Expenses
IC
Intercompany
IN
Income
LS
Legal suspense
MS
Miscellaneous
OP
Owner Payable
ST
Statistical
TP
Taxes Payable
DOC_TYP
Document Type
CHAR
2
0
T003
BLART
DOC_TEXT
Item Text
CHAR
50
0
SGTXT
RECID
Recovery Indicator
CHAR
2
0
T8JJ
JV_RECIND
DEST_CD
Destination code
CHAR
2
0
OIUHS_JE_DPK
OIUHS_DEST_CD
Possible values
AP
Accounts Payable
AR
Accounts Receivable
CW
Carried Working
GL
General Ledger
NP
Net Profit
ACC_CAT
Account Category for Posting rules
NUMC
4
0
OIUHS_ACC_CAT
SUMMARIZE
Summarize by
CHAR
2
0
OIUHS_SUMMARIZE
Possible values
CV
Cost Center and Volume
HC
High Cost Center
HL
High Level
LL
Low Level
CUST_TYP
Customer Type for JE
CHAR
2
0
OIUHS_CUST_TYP
Possible values
OW
Owner
PU
Purchaser
RM
Remitter
SE
Seller
PROD_DATE_TYP
Production date Type
CHAR
1
0
OIUHS_PROD_DATE_TYP
Possible values
C
Current Date
S
Sales Date
CC_TYP
Cost Center Type for JE
CHAR
1
0
OIUHS_CC_TYP
Possible values
D
Default Rule
F
Format Rule
R
Required
S
Split Rule
ALLOC_TYP
Allocation Type for JE
CHAR
1
0
OIUHS_ALLOC_TYP
Possible values
OIUHS_JE_ACC_TYP foreign key relationships
Table
Field
Check Table
Check Field
0 OIUHS_JE_ACC_TYP
BUKRS
T001 Company Codes
BUKRS
1 OIUHS_JE_ACC_TYP
DEST_CD
OIUHS_JE_DPK JE Rules - Destination Code/Posting-key
MANDT
1 OIUHS_JE_ACC_TYP
DEST_CD
OIUHS_JE_DPK JE Rules - Destination Code/Posting-key
DEST_CD
0 OIUHS_JE_ACC_TYP
DOC_TYP
T003 Document Types
MANDT
1 OIUHS_JE_ACC_TYP
RECID
T8JJ Recovery Indicator
MANDT
1 OIUHS_JE_ACC_TYP
RECID
T8JJ Recovery Indicator
BUKRS