SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | OIUH_RV_JE
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Industry Specific :: Industry Solution Oil :: Production and Revenue Accounting :: Revenue
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0OIUH_RV_JE2663Journal EntryRevenue
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, JE_OR_LVL_1_NO, JE_ACCT_PERD_DT, JE_BTCH_NO, JE_LE_NO, JE_VOU_NO, JE_REJ_FL, JE_ACCT_CAT_CD, JE_BRD_CD, JE_ACCT_NO, JE_BTCH_TYPE_CD, E_LE_PRCS_ST_CD, JE_TRANS_AM, JE_SYS_SRCE_CD, JE_TRANS_QY, JE_GR_AM, JE_GR_QY, JE_PD_CD, JE_VL_TYPE_CD, JE_CK_NO, JE_VL_CLASS_CD, JE_VL_SRCE_CD, JE_VL_FRQ_CD, JE_VL_LVL_CD, JE_BTU_QY, JE_MMBTU_DET_CD, JE_PS_BASE_QY, JE_GRV_QY, JE_OWN_NO9, JE_OWN_NO, JE_OWN_SEQ_NO9, JE_OWN_SEQ_NO, JE_PU_NO9, JE_PU_NO, JE_PU_SEQ_NO9, JE_PU_SEQ_NO, JE_PRDR_NO9, JE_PRDR_NO, JE_PRDR_SEQ_NO9, JE_PRDR_SEQ_NO, OWN_INT_DECM_QY, OWN_INT_TYPE_CD, JE_CK_DT9, JE_CK_DT, JE_RVRS_RSN_CD, UNIT_OF_MEAS_CD, JE_CASH_RCPT_DT9, JE_CASH_RCPT_DT, JE_SUS_RSN_CD, JE_CT_NO9, JE_CT_NO, JE_CT_TYPE_CD, JE_DOI_PR_NO9, JE_DOI_PR_NO, JE_DOI_SEQ_NO9, JE_DOI_SEQ_NO, JE_TRACE_CO_NO, E_TRACE_APRD_DT9, E_TRACE_APRD_DT, E_TRACE_ACCT_NO, E_TRACE_BTCH_NO, E_TRACE_BTCH_CD, E_TRACE_VOUC_NO, JE_TRACE_LE_NO, JE_WL_NO9, JE_WL_NO, JE_WC_NO9, JE_WC_NO, JE_DED_RMB_AM, E_DED_GR_RMB_AM, JE_TAX_1_AM, JE_TAX_2_AM, JE_TAX_3_AM, JE_TAX_4_AM, JE_TAX_5_AM, JE_TAX_6_AM, JE_TAX_7_AM, JE_TAX_8_AM, JE_TAX_9_AM, JE_TAX_10_AM, JE_TAX_RMB_AM, E_TAX_GR_RMB_AM, JE_INV_NO, JE_INV_DT9, JE_INV_DT, JE_INV_TYPE_CD, OWN_INT_SEQ_NO, JE_PAY_CD, JE_SA_MP_NO9, JE_SA_MP_NO, JE_SA_DT9, JE_SA_DT, JE_ST_CD, JE_TAX_AUTH_NO, TAX_AUTH_SEQ_NO, OWN_BAL_DECM_QY, JE_PR_TYPE_CD, JE_OP_NON_OP_FL, JE_PU_PR_NO, JE_PU_PD_CD, JE_ERROR_1_CD, JE_ERROR_2_CD, JE_ERROR_3_CD, JE_ERROR_4_CD, JE_ERROR_5_CD, JE_UNIT_PR_NO9, JE_UNIT_PR_NO, E_ARMT_LVL_1_CD, E_ARMT_LVL_2_CD, JE_TRANS_DE9, JE_TRANS_DE, JE_GR_TAX_AM, JE_PROC_CO, JE_AES_FL, JE_TAX_CD, JE_GRP_GROUP_NO9, JE_GRP_GROUP_NO, JE_JIB_DOI_NO9, JE_JIB_DOI_NO, JIB_DOI_SEQ_NO9, JIB_DOI_SEQ_NO, JE_BILL_CD, JE_TXN_VAL_AM, JE_TXN_DT, JE_GAS_PLANT_NO9, JE_GAS_PLANT_NO, JE_GPLT_SEQ_NO9, JE_GPLT_SEQ_NO, JE_REF_NO, JE_SELLER_NO9, JE_SELLER_NO, E_SELLER_SEQ_NO9, E_SELLER_SEQ_NO, JE_AUD_BTCH_NO, JE_DI_PR_NO, JE_DI_NO, JE_JDI_PR_NO, JE_JDI_NO, JE_OWN_PVR_AM, JE_GR_PVR_AM, E_OTH_DED_01_AM, E_OTH_DED_02_AM, E_OTH_DED_03_AM, E_OTH_DED_04_AM, E_OTH_DED_05_AM, E_OTH_DED_06_AM, E_OTH_DED_07_AM, E_OTH_DED_08_AM, E_OTH_DED_09_AM, E_OTH_DED_10_AM, E_OTH_DED_11_AM, E_OTH_DED_12_AM, E_OTH_DED_13_AM, E_OTH_DED_14_AM, E_OTH_DED_15_AM, E_OTH_DED_16_AM, E_OTH_DED_17_AM, E_OTH_DED_18_AM, JE_INT_PAID_FL, MMBTU_OWN_VL_AM, MMBTU_GR_VL_AM, JE_REMT_NO9, JE_REMT_NO, JE_REMT_SEQ_NO9, JE_REMT_SEQ_NO, JE_RCV_GLWL_NO9, JE_RCV_GLWL_NO, JE_RCV_GLWC_NO9, JE_RCV_GLWC_NO, JE_REL_CT_NO9, JE_REL_CT_NO, JE_ORIG_MP_NO9, JE_ORIG_MP_NO, E_ORIG_MP_TP_CD, JE_PHS_NO, JE_CMT_SYS_NO9, JE_CMT_SYS_NO, JE_ESCH_FL, JE_INT_SYM_CD, JE_LGND_CD, JE_MK_TYPE_NO, JE_OR_LVL_2_NO, E_SPEC_PYMNT_CD, JE_OVRD_OWN_CD, JE_RCPTN_PT_NO, JE_TRNSP_NO, JE_TRNSP_SEQ_NO, JE_OWN_VAL, JE_RBUR_DECM_PC, JE_GR_TAX_1_AM, JE_GR_TAX_2_AM, JE_GR_TAX_3_AM, JE_GR_TAX_4_AM, JE_GR_TAX_5_AM, JE_GR_TAX_6_AM, JE_GR_TAX_7_AM, JE_GR_TAX_8_AM, JE_GR_TAX_9_AM, JE_GR_TAX_10_AM, JE_GR_TRNDED_AM, E_OWN_TRNDED_AM, E_GR_OTH_MKD_AM, OWN_OTH_MKD_AM, JE_ORIG_PR_NO, JE_INJ_DT9, JE_INJ_DT, E_GR_APC_RMB_AM, NET_APC_RMB_AM, JE_JI_OWN_NO, E_JI_OWN_SEQ_NO, JE_SECT_PR_NO9, JE_SECT_PR_NO, JE_SECT_SEQ_NO9, JE_SECT_SEQ_NO, JE_NWK_NO9, JE_NWK_NO, JE_SUB_NWK_NO9, JE_SUB_NWK_NO, JE_CHV_RPT_CD, E_CUSA_TRSPK_NO, JE_DEAL_I_NO, JE_VER_NO, JE_USER_ID, JE_TIMESTAMP, JE_GR_PTR_AM, JE_OWN_PTR_AM, O_INT_1_AM, O_INT_2_AM, O_INT_3_AM, O_INT_4_AM, O_INT_5_AM, O_INT_6_AM, O_INT_7_AM, O_INT_8_AM, O_INT_9_AM, O_INT_10_AM, O_EXT_1_AM, O_EXT_2_AM, O_EXT_3_AM, O_EXT_4_AM, O_EXT_5_AM, O_EXT_6_AM, O_EXT_7_AM, O_EXT_8_AM, O_EXT_9_AM, O_EXT_10_AM, G_INT_1_AM, G_INT_2_AM, G_INT_3_AM, G_INT_4_AM, G_INT_5_AM, G_INT_6_AM, G_INT_7_AM, G_INT_8_AM, G_INT_9_AM, G_INT_10_AM, G_EXT_1_AM, G_EXT_2_AM, G_EXT_3_AM, G_EXT_4_AM, G_EXT_5_AM, G_EXT_6_AM, G_EXT_7_AM, G_EXT_8_AM, G_EXT_9_AM, G_EXT_10_AM FROM OIUH_RV_JE
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2JE_OR_LVL_1_NOCompany Name Codenvarchar30CHAR(N' ')NoOIUH_COMPANY Allow NULL? 
3JE_ACCT_PERD_DTAccounting Period(YYYYMM01)nvarchar80CHAR(N' ')NoOIUH_ACCOUNTING_PERIOD8 Allow NULL? 
4JE_BTCH_NOBatch IDnvarchar40CHAR(N' ')NoOIUH_BATCH_ID Allow NULL? 
5JE_LE_NOJournal Entry Line Numbernvarchar80CHAR(N' ')NoOIUH_JELINENO Allow NULL? 
6JE_VOU_NOOIUH_CHAR6nvarchar60CHAR(N' ')NoOIUH_CHAR6 Allow NULL? 
7JE_REJ_FLOIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
8JE_ACCT_CAT_CDOIUH_CHAR4nvarchar40CHAR(N' ')NoOIUH_CHAR4 Allow NULL? 
9JE_BRD_CDOIUH_CHAR4nvarchar40CHAR(N' ')NoOIUH_CHAR4 Allow NULL? 
10JE_ACCT_NOOIUH_CHAR10nvarchar100CHAR(N' ')NoOIUH_CHAR10 Allow NULL? 
11JE_BTCH_TYPE_CDOIUH_CHAR2nvarchar20CHAR(N' ')NoOIUH_CHAR2 Allow NULL? 
12E_LE_PRCS_ST_CDOIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
13JE_TRANS_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
14JE_SYS_SRCE_CDOIUH_CHAR2nvarchar20CHAR(N' ')NoOIUH_CHAR2 Allow NULL? 
15JE_TRANS_QYOIUH_DEC11_2decimal112DEC((0))NoOIUH_DEC11_2
16JE_GR_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
17JE_GR_QYOIUH_DEC11_2decimal112DEC((0))NoOIUH_DEC11_2
18JE_PD_CDOIUH_CHAR3nvarchar30CHAR(N' ')NoOIUH_CHAR3 Allow NULL? 
19JE_VL_TYPE_CDVolume Type Codenvarchar20CHAR(N' ')No*OIU_VL_TYPE_CD Allow NULL? 
20JE_CK_NOOIUH_CHAR10nvarchar100CHAR(N' ')NoOIUH_CHAR10 Allow NULL? 
21JE_VL_CLASS_CDOIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
22JE_VL_SRCE_CDOIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
23JE_VL_FRQ_CDOIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
24JE_VL_LVL_CDOIUH_CHAR2nvarchar20CHAR(N' ')NoOIUH_CHAR2 Allow NULL? 
25JE_BTU_QYOIUH_DEC7_3decimal73DEC((0))NoOIUH_DEC7_3
26JE_MMBTU_DET_CDOIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
27JE_PS_BASE_QYOIUH_DEC6_3decimal63DEC((0))NoOIUH_DEC6_3
28JE_GRV_QYOIUH_DEC3_1decimal31DEC((0))NoOIUH_DEC3_1
29JE_OWN_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
30JE_OWN_NOOIUH_CHAR6nvarchar60CHAR(N' ')YesOIUH_CHAR6 Allow NULL? 
31JE_OWN_SEQ_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
32JE_OWN_SEQ_NOOIUH_CHAR2nvarchar20CHAR(N' ')YesOIUH_CHAR2 Allow NULL? 
33JE_PU_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
34JE_PU_NOOIUH_CHAR6nvarchar60CHAR(N' ')YesOIUH_CHAR6 Allow NULL? 
35JE_PU_SEQ_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
36JE_PU_SEQ_NOOIUH_CHAR2nvarchar20CHAR(N' ')YesOIUH_CHAR2 Allow NULL? 
37JE_PRDR_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
38JE_PRDR_NOOIUH_CHAR6nvarchar60CHAR(N' ')YesOIUH_CHAR6 Allow NULL? 
39JE_PRDR_SEQ_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
40JE_PRDR_SEQ_NOOIUH_CHAR2nvarchar20CHAR(N' ')YesOIUH_CHAR2 Allow NULL? 
41OWN_INT_DECM_QYOIUH_DEC9_8decimal98DEC((0))NoOIUH_DEC9_8
42OWN_INT_TYPE_CDOIUH_CHAR2nvarchar20CHAR(N' ')NoOIUH_CHAR2 Allow NULL? 
43JE_CK_DT9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
44JE_CK_DTOIUH_CHAR14nvarchar140CHAR(N' ')YesOIUH_CHAR14 Allow NULL? 
45JE_RVRS_RSN_CDOIUH_CHAR2nvarchar20CHAR(N' ')NoOIUH_CHAR2 Allow NULL? 
46UNIT_OF_MEAS_CDOIUH_CHAR3nvarchar30CHAR(N' ')NoOIUH_CHAR3 Allow NULL? 
47JE_CASH_RCPT_DT9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
48JE_CASH_RCPT_DTOIUH_CHAR14nvarchar140CHAR(N' ')YesOIUH_CHAR14 Allow NULL? 
49JE_SUS_RSN_CDOIUH_CHAR2nvarchar20CHAR(N' ')NoOIUH_CHAR2 Allow NULL? 
50JE_CT_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
51JE_CT_NOContract IDnvarchar60CHAR(N' ')YesOIUH_CONTRACT_ID Allow NULL? 
52JE_CT_TYPE_CDOIUH_CHAR2nvarchar20CHAR(N' ')NoOIUH_CHAR2 Allow NULL? 
53JE_DOI_PR_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
54JE_DOI_PR_NOOIUH_CHAR8nvarchar80CHAR(N' ')YesOIUH_CHAR8 Allow NULL? 
55JE_DOI_SEQ_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
56JE_DOI_SEQ_NOOIUH_CHAR5nvarchar50CHAR(N' ')YesOIUH_CHAR5 Allow NULL? 
57JE_TRACE_CO_NOOIUH_CHAR3nvarchar30CHAR(N' ')NoOIUH_CHAR3 Allow NULL? 
58E_TRACE_APRD_DT9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
59E_TRACE_APRD_DTAccounting Period(YYYYMM01)nvarchar80CHAR(N' ')YesOIUH_ACCOUNTING_PERIOD8 Allow NULL? 
60E_TRACE_ACCT_NOOIUH_CHAR10nvarchar100CHAR(N' ')NoOIUH_CHAR10 Allow NULL? 
61E_TRACE_BTCH_NOOIUH_CHAR4nvarchar40CHAR(N' ')NoOIUH_CHAR4 Allow NULL? 
62E_TRACE_BTCH_CDOIUH_CHAR2nvarchar20CHAR(N' ')NoOIUH_CHAR2 Allow NULL? 
63E_TRACE_VOUC_NOOIUH_CHAR6nvarchar60CHAR(N' ')NoOIUH_CHAR6 Allow NULL? 
64JE_TRACE_LE_NOOIUH_CHAR8nvarchar80CHAR(N' ')NoOIUH_CHAR8 Allow NULL? 
65JE_WL_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
66JE_WL_NOOIUH_CHAR6nvarchar60CHAR(N' ')YesOIUH_CHAR6 Allow NULL? 
67JE_WC_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
68JE_WC_NOOIUH_CHAR2nvarchar20CHAR(N' ')YesOIUH_CHAR2 Allow NULL? 
69JE_DED_RMB_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
70E_DED_GR_RMB_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
71JE_TAX_1_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
72JE_TAX_2_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
73JE_TAX_3_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
74JE_TAX_4_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
75JE_TAX_5_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
76JE_TAX_6_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
77JE_TAX_7_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
78JE_TAX_8_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
79JE_TAX_9_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
80JE_TAX_10_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
81JE_TAX_RMB_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
82E_TAX_GR_RMB_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
83JE_INV_NOOIUH_CHAR6nvarchar60CHAR(N' ')NoOIUH_CHAR6 Allow NULL? 
84JE_INV_DT9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
85JE_INV_DTOIUH_CHAR14nvarchar140CHAR(N' ')YesOIUH_CHAR14 Allow NULL? 
86JE_INV_TYPE_CDOIUH_CHAR2nvarchar20CHAR(N' ')NoOIUH_CHAR2 Allow NULL? 
87OWN_INT_SEQ_NOOIUH_CHAR2nvarchar20CHAR(N' ')NoOIUH_CHAR2 Allow NULL? 
88JE_PAY_CDOIUH_CHAR2nvarchar20CHAR(N' ')NoOIUH_CHAR2 Allow NULL? 
89JE_SA_MP_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
90JE_SA_MP_NOOIUH_CHAR6nvarchar60CHAR(N' ')YesOIUH_CHAR6 Allow NULL? 
91JE_SA_DT9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
92JE_SA_DTOIUH_CHAR14nvarchar140CHAR(N' ')YesOIUH_CHAR14 Allow NULL? 
93JE_ST_CDOIUH_CHAR2nvarchar20CHAR(N' ')NoOIUH_CHAR2 Allow NULL? 
94JE_TAX_AUTH_NOOIUH_CHAR6nvarchar60CHAR(N' ')NoOIUH_CHAR6 Allow NULL? 
95TAX_AUTH_SEQ_NOOIUH_CHAR2nvarchar20CHAR(N' ')NoOIUH_CHAR2 Allow NULL? 
96OWN_BAL_DECM_QYOIUH_DEC9_8decimal98DEC((0))NoOIUH_DEC9_8
97JE_PR_TYPE_CDOIUH_CHAR2nvarchar20CHAR(N' ')NoOIUH_CHAR2 Allow NULL? 
98JE_OP_NON_OP_FLOIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
99JE_PU_PR_NOOIUH_CHAR18nvarchar180CHAR(N' ')NoOIUH_CHAR18 Allow NULL? 
100JE_PU_PD_CDOIUH_CHAR3nvarchar30CHAR(N' ')NoOIUH_CHAR3 Allow NULL? 
101JE_ERROR_1_CDOIUH_CHAR5nvarchar50CHAR(N' ')NoOIUH_CHAR5 Allow NULL? 
102JE_ERROR_2_CDOIUH_CHAR5nvarchar50CHAR(N' ')NoOIUH_CHAR5 Allow NULL? 
103JE_ERROR_3_CDOIUH_CHAR5nvarchar50CHAR(N' ')NoOIUH_CHAR5 Allow NULL? 
104JE_ERROR_4_CDOIUH_CHAR5nvarchar50CHAR(N' ')NoOIUH_CHAR5 Allow NULL? 
105JE_ERROR_5_CDOIUH_CHAR5nvarchar50CHAR(N' ')NoOIUH_CHAR5 Allow NULL? 
106JE_UNIT_PR_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
107JE_UNIT_PR_NOOIUH_CHAR8nvarchar80CHAR(N' ')YesOIUH_CHAR8 Allow NULL? 
108E_ARMT_LVL_1_CDOIUH_CHAR8nvarchar80CHAR(N' ')NoOIUH_CHAR8 Allow NULL? 
109E_ARMT_LVL_2_CDOIUH_CHAR5nvarchar50CHAR(N' ')NoOIUH_CHAR5 Allow NULL? 
110JE_TRANS_DE9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
111JE_TRANS_DEOIUH_CHAR60nvarchar600CHAR(N' ')YesOIUH_CHAR60 Allow NULL? 
112JE_GR_TAX_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
113JE_PROC_COOIUH_CHAR3nvarchar30CHAR(N' ')NoOIUH_CHAR3 Allow NULL? 
114JE_AES_FLOIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
115JE_TAX_CDOIUH_CHAR2nvarchar20CHAR(N' ')NoOIUH_CHAR2 Allow NULL? 
116JE_GRP_GROUP_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
117JE_GRP_GROUP_NOOIUH_CHAR8nvarchar80CHAR(N' ')YesOIUH_CHAR8 Allow NULL? 
118JE_JIB_DOI_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
119JE_JIB_DOI_NOOIUH_CHAR8nvarchar80CHAR(N' ')YesOIUH_CHAR8 Allow NULL? 
120JIB_DOI_SEQ_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
121JIB_DOI_SEQ_NOOIUH_CHAR5nvarchar50CHAR(N' ')YesOIUH_CHAR5 Allow NULL? 
122JE_BILL_CDOIUH_CHAR2nvarchar20CHAR(N' ')NoOIUH_CHAR2 Allow NULL? 
123JE_TXN_VAL_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
124JE_TXN_DTOIUH_CHAR14nvarchar140CHAR(N' ')NoOIUH_CHAR14 Allow NULL? 
125JE_GAS_PLANT_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
126JE_GAS_PLANT_NOOIUH_CHAR8nvarchar80CHAR(N' ')YesOIUH_CHAR8 Allow NULL? 
127JE_GPLT_SEQ_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
128JE_GPLT_SEQ_NOOIUH_CHAR5nvarchar50CHAR(N' ')YesOIUH_CHAR5 Allow NULL? 
129JE_REF_NOOIUH_CHAR10nvarchar100CHAR(N' ')NoOIUH_CHAR10 Allow NULL? 
130JE_SELLER_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
131JE_SELLER_NOOIUH_CHAR6nvarchar60CHAR(N' ')YesOIUH_CHAR6 Allow NULL? 
132E_SELLER_SEQ_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
133E_SELLER_SEQ_NOOIUH_CHAR2nvarchar20CHAR(N' ')YesOIUH_CHAR2 Allow NULL? 
134JE_AUD_BTCH_NOOIUH_CHAR4nvarchar40CHAR(N' ')NoOIUH_CHAR4 Allow NULL? 
135JE_DI_PR_NOOIUH_CHAR8nvarchar80CHAR(N' ')NoOIUH_CHAR8 Allow NULL? 
136JE_DI_NOOIUH_CHAR5nvarchar50CHAR(N' ')NoOIUH_CHAR5 Allow NULL? 
137JE_JDI_PR_NOOIUH_CHAR8nvarchar80CHAR(N' ')NoOIUH_CHAR8 Allow NULL? 
138JE_JDI_NOOIUH_CHAR5nvarchar50CHAR(N' ')NoOIUH_CHAR5 Allow NULL? 
139JE_OWN_PVR_AMOIUH_DEC11_2decimal112DEC((0))NoOIUH_DEC11_2
140JE_GR_PVR_AMOIUH_DEC11_2decimal112DEC((0))NoOIUH_DEC11_2
141E_OTH_DED_01_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
142E_OTH_DED_02_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
143E_OTH_DED_03_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
144E_OTH_DED_04_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
145E_OTH_DED_05_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
146E_OTH_DED_06_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
147E_OTH_DED_07_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
148E_OTH_DED_08_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
149E_OTH_DED_09_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
150E_OTH_DED_10_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
151E_OTH_DED_11_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
152E_OTH_DED_12_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
153E_OTH_DED_13_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
154E_OTH_DED_14_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
155E_OTH_DED_15_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
156E_OTH_DED_16_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
157E_OTH_DED_17_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
158E_OTH_DED_18_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
159JE_INT_PAID_FLOIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
160MMBTU_OWN_VL_AMOIUH_DEC11_2decimal112DEC((0))NoOIUH_DEC11_2
161MMBTU_GR_VL_AMOIUH_DEC11_2decimal112DEC((0))NoOIUH_DEC11_2
162JE_REMT_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
163JE_REMT_NOOIUH_CHAR6nvarchar60CHAR(N' ')YesOIUH_CHAR6 Allow NULL? 
164JE_REMT_SEQ_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
165JE_REMT_SEQ_NOOIUH_CHAR2nvarchar20CHAR(N' ')YesOIUH_CHAR2 Allow NULL? 
166JE_RCV_GLWL_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
167JE_RCV_GLWL_NOOIUH_CHAR6nvarchar60CHAR(N' ')YesOIUH_CHAR6 Allow NULL? 
168JE_RCV_GLWC_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
169JE_RCV_GLWC_NOOIUH_CHAR2nvarchar20CHAR(N' ')YesOIUH_CHAR2 Allow NULL? 
170JE_REL_CT_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
171JE_REL_CT_NOContract IDnvarchar60CHAR(N' ')YesOIUH_CONTRACT_ID Allow NULL? 
172JE_ORIG_MP_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
173JE_ORIG_MP_NOOIUH_CHAR6nvarchar60CHAR(N' ')YesOIUH_CHAR6 Allow NULL? 
174E_ORIG_MP_TP_CDOIUH_CHAR2nvarchar20CHAR(N' ')NoOIUH_CHAR2 Allow NULL? 
175JE_PHS_NOOIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
176JE_CMT_SYS_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
177JE_CMT_SYS_NOOIUH_DEC18decimal180DEC((0))YesOIUH_DEC18
178JE_ESCH_FLOIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
179JE_INT_SYM_CDOIUH_CHAR2nvarchar20CHAR(N' ')NoOIUH_CHAR2 Allow NULL? 
180JE_LGND_CDOIUH_CHAR2nvarchar20CHAR(N' ')NoOIUH_CHAR2 Allow NULL? 
181JE_MK_TYPE_NOOIUH_CHAR2nvarchar20CHAR(N' ')NoOIUH_CHAR2 Allow NULL? 
182JE_OR_LVL_2_NOOIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
183E_SPEC_PYMNT_CDOIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
184JE_OVRD_OWN_CDOIUH_CHAR2nvarchar20CHAR(N' ')NoOIUH_CHAR2 Allow NULL? 
185JE_RCPTN_PT_NOOIUH_CHAR6nvarchar60CHAR(N' ')NoOIUH_CHAR6 Allow NULL? 
186JE_TRNSP_NOOIUH_CHAR6nvarchar60CHAR(N' ')NoOIUH_CHAR6 Allow NULL? 
187JE_TRNSP_SEQ_NOOIUH_CHAR2nvarchar20CHAR(N' ')NoOIUH_CHAR2 Allow NULL? 
188JE_OWN_VALLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
189JE_RBUR_DECM_PCOIUH_DEC9_8decimal98DEC((0))NoOIUH_DEC9_8
190JE_GR_TAX_1_AMLocal amountdecimal132CURR((0))NoOIUH_CURR13_2
191JE_GR_TAX_2_AMLocal amountdecimal132CURR((0))NoOIUH_CURR13_2
192JE_GR_TAX_3_AMLocal amountdecimal132CURR((0))NoOIUH_CURR13_2
193JE_GR_TAX_4_AMLocal amountdecimal132CURR((0))NoOIUH_CURR13_2
194JE_GR_TAX_5_AMLocal amountdecimal132CURR((0))NoOIUH_CURR13_2
195JE_GR_TAX_6_AMLocal amountdecimal132CURR((0))NoOIUH_CURR13_2
196JE_GR_TAX_7_AMLocal amountdecimal132CURR((0))NoOIUH_CURR13_2
197JE_GR_TAX_8_AMLocal amountdecimal132CURR((0))NoOIUH_CURR13_2
198JE_GR_TAX_9_AMLocal amountdecimal132CURR((0))NoOIUH_CURR13_2
199JE_GR_TAX_10_AMLocal amountdecimal132CURR((0))NoOIUH_CURR13_2
200JE_GR_TRNDED_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
201E_OWN_TRNDED_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
202E_GR_OTH_MKD_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
203OWN_OTH_MKD_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
204JE_ORIG_PR_NOOIUH_CHAR8nvarchar80CHAR(N' ')NoOIUH_CHAR8 Allow NULL? 
205JE_INJ_DT9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
206JE_INJ_DTOIUH_CHAR14nvarchar140CHAR(N' ')YesOIUH_CHAR14 Allow NULL? 
207E_GR_APC_RMB_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
208NET_APC_RMB_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
209JE_JI_OWN_NOOIUH_CHAR6nvarchar60CHAR(N' ')NoOIUH_CHAR6 Allow NULL? 
210E_JI_OWN_SEQ_NOOIUH_CHAR2nvarchar20CHAR(N' ')NoOIUH_CHAR2 Allow NULL? 
211JE_SECT_PR_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
212JE_SECT_PR_NOOIUH_CHAR8nvarchar80CHAR(N' ')YesOIUH_CHAR8 Allow NULL? 
213JE_SECT_SEQ_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
214JE_SECT_SEQ_NOOIUH_CHAR5nvarchar50CHAR(N' ')YesOIUH_CHAR5 Allow NULL? 
215JE_NWK_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
216JE_NWK_NOOIUH_CHAR4nvarchar40CHAR(N' ')YesOIUH_CHAR4 Allow NULL? 
217JE_SUB_NWK_NO9OIUH_CHAR1char10CHAR(N' ')NoOIUH_CHAR1 Allow NULL? 
218JE_SUB_NWK_NOOIUH_CHAR4nvarchar40CHAR(N' ')YesOIUH_CHAR4 Allow NULL? 
219JE_CHV_RPT_CDOIUH_CHAR10nvarchar100CHAR(N' ')NoOIUH_CHAR10 Allow NULL? 
220E_CUSA_TRSPK_NOOIUH_CHAR8nvarchar80CHAR(N' ')NoOIUH_CHAR8 Allow NULL? 
221JE_DEAL_I_NOOIUH_CHAR12nvarchar120CHAR(N' ')NoOIUH_CHAR12 Allow NULL? 
222JE_VER_NOOIUH_DEC5decimal50DEC((0))NoOIUH_DEC5
223JE_USER_IDOIUH_CHAR8nvarchar80CHAR(N' ')NoOIUH_CHAR8 Allow NULL? 
224JE_TIMESTAMPOIUH_CHAR14nvarchar140CHAR(N' ')NoOIUH_CHAR14 Allow NULL? 
225JE_GR_PTR_AMGross Plant Thermal Reduction amountdecimal112DEC((0))YesOIUH_GR_PLANT_THERMAL_RED
226JE_OWN_PTR_AMOwner Plant Thermal Reduction amountdecimal112DEC((0))YesOIUH_OWN_PLANT_THERMAL_RED
227O_INT_1_AMOwner internal mkt amt 1decimal112CURR((0))YesOIU_O_INT_1_AM
228O_INT_2_AMOwner internal mkt amt 2decimal112CURR((0))YesOIU_O_INT_2_AM
229O_INT_3_AMOwner internal mkt amt 3decimal112CURR((0))YesOIU_O_INT_3_AM
230O_INT_4_AMOwner internal mkt amt 4decimal112CURR((0))YesOIU_O_INT_4_AM
231O_INT_5_AMOwner internal mkt amt 5decimal112CURR((0))YesOIU_O_INT_5_AM
232O_INT_6_AMOwner internal mkt amt 6decimal112CURR((0))YesOIU_O_INT_6_AM
233O_INT_7_AMOwner internal mkt amt 7decimal112CURR((0))YesOIU_O_INT_7_AM
234O_INT_8_AMOwner internal mkt amt 8decimal112CURR((0))YesOIU_O_INT_8_AM
235O_INT_9_AMOwner internal mkt amt 9decimal112CURR((0))YesOIU_O_INT_9_AM
236O_INT_10_AMOwner internal mkt amt10decimal112CURR((0))YesOIU_O_INT_10_AM
237O_EXT_1_AMOwner external mkt amt 1decimal112CURR((0))YesOIU_O_EXT_1_AM
238O_EXT_2_AMOwner external mkt amt 2decimal112CURR((0))YesOIU_O_EXT_2_AM
239O_EXT_3_AMOwner external mkt amt 3decimal112CURR((0))YesOIU_O_EXT_3_AM
240O_EXT_4_AMOwner external mkt amt 4decimal112CURR((0))YesOIU_O_EXT_4_AM
241O_EXT_5_AMOwner external mkt amt 5decimal112CURR((0))YesOIU_O_EXT_5_AM
242O_EXT_6_AMOwner external mkt amt 6decimal112CURR((0))YesOIU_O_EXT_6_AM
243O_EXT_7_AMOwner external mkt amt 7decimal112CURR((0))YesOIU_O_EXT_7_AM
244O_EXT_8_AMOwner external mkt amt 8decimal112CURR((0))YesOIU_O_EXT_8_AM
245O_EXT_9_AMOwner external mkt amt 9decimal112CURR((0))YesOIU_O_EXT_9_AM
246O_EXT_10_AMOwner external mkt amt10decimal112CURR((0))YesOIU_O_EXT_10_AM
247G_INT_1_AMGross internal mkt amt 1decimal112CURR((0))YesOIU_G_INT_1_AM
248G_INT_2_AMGross internal mkt amt 2decimal112CURR((0))YesOIU_G_INT_2_AM
249G_INT_3_AMGross internal mkt amt 3decimal112CURR((0))YesOIU_G_INT_3_AM
250G_INT_4_AMGross internal mkt amt 4decimal112CURR((0))YesOIU_G_INT_4_AM
251G_INT_5_AMGross internal mkt amt 5decimal112CURR((0))YesOIU_G_INT_5_AM
252G_INT_6_AMGross internal mkt amt 6decimal112CURR((0))YesOIU_G_INT_6_AM
253G_INT_7_AMGross internal mkt amt 7decimal112CURR((0))YesOIU_G_INT_7_AM
254G_INT_8_AMGross internal mkt amt 8decimal112CURR((0))YesOIU_G_INT_8_AM
255G_INT_9_AMGross internal mkt amt 9decimal112CURR((0))YesOIU_G_INT_9_AM
256G_INT_10_AMGross internal mkt amt10decimal112CURR((0))YesOIU_G_INT_10_AM
257G_EXT_1_AMGross external mkt amt 1decimal112CURR((0))YesOIU_G_EXT_1_AM
258G_EXT_2_AMGross external mkt amt 2decimal112CURR((0))YesOIU_G_EXT_2_AM
259G_EXT_3_AMGross external mkt amt 3decimal112CURR((0))YesOIU_G_EXT_3_AM
260G_EXT_4_AMGross external mkt amt 4decimal112CURR((0))YesOIU_G_EXT_4_AM
261G_EXT_5_AMGross external mkt amt 5decimal112CURR((0))YesOIU_G_EXT_5_AM
262G_EXT_6_AMGross external mkt amt 6decimal112CURR((0))YesOIU_G_EXT_6_AM
263G_EXT_7_AMGross external mkt amt 7decimal112CURR((0))YesOIU_G_EXT_7_AM
264G_EXT_8_AMGross external mkt amt 8decimal112CURR((0))YesOIU_G_EXT_8_AM
265G_EXT_9_AMGross external mkt amt 9decimal112CURR((0))YesOIU_G_EXT_9_AM
266G_EXT_10_AMGross external mkt amt 10decimal112CURR((0))YesOIU_G_EXT_10_AM
NamePrimaryUniqueTypeColumns
OIUH_RV_JE~0YesYesCLUSTEREDJE_LE_NO, JE_BTCH_NO, JE_ACCT_PERD_DT, JE_OR_LVL_1_NO, MANDT
OIUH_RV_JE~I02NoNoNONCLUSTEREDJE_SA_DT, JE_SA_MP_NO, JE_WC_NO, JE_WL_NO, JE_DOI_SEQ_NO, JE_DOI_PR_NO, MANDT
OIUH_RV_JE~I03NoNoNONCLUSTEREDJE_PD_CD, JE_DOI_SEQ_NO, JE_DOI_PR_NO, JE_ACCT_CAT_CD, JE_ACCT_NO, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy