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  | OIUE2_RV_CHD
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.0OIUE2_RV_CHD1011Proc 2.0 - Check DetailsRevenue
SQL:  selectupdate insert create

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

SELECT MANDT, RUN_ID, CHD_OR_LVL_1_NO, HD_ACCT_PERD_DT, CHD_BTCH_NO, CHD_VOU_NO, CHD_LE_NO, CHD_ACCT_NO, HD_BTCH_TYPE_CD, D_LE_PRCS_ST_CD, CHD_TRANS_AM, CHD_SYS_SRCE_CD, CHD_TRANS_QY, CHD_GR_AM, CHD_GR_QY, CHD_PD_CD, CHD_VL_TYPE_CD, CHD_CK_NO, CHD_BNK_NO, CHD_BNK_ACC_NO, CHD_VL_CLASS_CD, CHD_VL_SRCE_CD, CHD_VL_FRQ_CD, CHD_BTU_QY, HD_MMBTU_DET_CD, CHD_PS_BASE_QY, CHD_GRV_QY, CHD_OWN_NO, CHD_OWN_SEQ_NO, CHD_PU_NO9, CHD_PU_NO, CHD_PU_SEQ_NO9, CHD_PU_SEQ_NO, CHD_PRDR_NO9, CHD_PRDR_NO, CHD_PRDR_SEQ_NO9, CHD_PRDR_SEQ_NO, CHD_OI_DECM_QY, CHD_OI_TYPE_CD, D_OI_INT_SEQ_NO, CHD_CK_DT, CHD_RVRS_RSN_CD, HD_UNIT_MEAS_CD, HD_CASH_RCPT_DT9, HD_CASH_RCPT_DT, CHD_SUS_RSN_CD, CHD_CT_NO9, CHD_CT_NO, CHD_CT_TYPE_CD, CHD_DOI_PR_NO, CHD_DOI_SEQ_NO, CHD_TR_PR_NO9, CHD_TR_PR_NO, CHD_TR_SEQ_NO9, CHD_TR_SEQ_NO, CHD_TRACE_CO_NO, D_TRACE_APRD_DT9, D_TRACE_APRD_DT, D_TRACE_ACCT_NO, D_TRACE_BTCH_NO, D_TRACE_VOUC_NO, CHD_TRACE_LE_NO, CHD_WL_NO9, CHD_WL_NO, CHD_WC_NO9, CHD_WC_NO, CHD_DED_TOT_AM, D_DED_TOT_GR_AM, CHD_DED_RMB_AM, D_DED_GR_RMB_AM, CHD_TAX_RMB_AM, D_TAX_GR_RMB_AM, CHD_INV_NO, CHD_INV_DT9, CHD_INV_DT, CHD_PAY_CD, CHD_SA_MP_NO, CHD_SA_DT, CHD_ST_CD, CHD_TAX_AUT_NO, TAX_AUT_SEQ_NO, OWN_BAL_DEC_QY, CHD_PR_TYPE_CD, HD_OP_NON_OP_FL, CHD_PU_PR_NO, CHD_PU_PD_NO, CHD_REJ_FL, CHD_UNIT_PR_NO, D_ARMT_LVL_1_CD, D_ARMT_LVL_2_CD, CHD_TRANS_DE9, CHD_TRANS_DE, CHD_INT_PAID_FL, CHD_OWN_GRVA_AM, D_PLT_VL_RED_AM, CHD_LGND_CD, CHD_CMT_SYS_NO9, CHD_CMT_SYS_NO, CHD_VER_NO, CHD_USER_ID, CHD_TIMESTAMP FROM OIUE2_RV_CHD
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2RUN_IDProc 2.0 - Run IDnvarchar100NUMC(N'0000000000')NoOIUE2_RUN_HDROIUE2_RUN_ID Allow NULL? 
3CHD_OR_LVL_1_NOCompany Name Codenvarchar30CHAR(N' ')NoOIUH_COMPANY Allow NULL? 
4HD_ACCT_PERD_DTAccounting Period Datenvarchar140CHAR(N' ')NoOIUH_ACCT_PERD_DT Allow NULL? 
5CHD_BTCH_NOBatch Numbernvarchar40CHAR(N' ')NoOIU_BATCH_NO Allow NULL? 
6CHD_VOU_NOVoucher Numbernvarchar60CHAR(N' ')NoOIUH_VOUCHER_NUMBER Allow NULL? 
7CHD_LE_NOCheck Line Numbernvarchar80CHAR(N' ')NoOIUH_CHECK_LINE Allow NULL? 
8CHD_ACCT_NOAccount IDnvarchar100CHAR(N' ')YesOIUH_ACCTID Allow NULL? 
9HD_BTCH_TYPE_CDBatch Typenvarchar20CHAR(N' ')YesOIUH_BATCH_TYPE Allow NULL? 
10D_LE_PRCS_ST_CDOIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
11CHD_TRANS_AMJE Transaction Amountdecimal112CURR((0))YesOIUH_TRANS_AMT
12CHD_SYS_SRCE_CDGL Source Codenvarchar20CHAR(N' ')YesOIUREP_GL_SYS_SRCE_CD Allow NULL? 
13CHD_TRANS_QYJE Transaction Quantitydecimal112DEC((0))YesOIUH_TRANS_QUANTITY
14CHD_GR_AMGross Amount (Value)decimal112CURR((0))YesOIUH_GROSS_AMOUNT
15CHD_GR_QYGross Quantitydecimal112DEC((0))YesOIUH_GROSS_QTY
16CHD_PD_CDFull three char. product code (Major and Detail Products)nvarchar30CHAR(N' ')YesOIU_FULL_PD_CD Allow NULL? 
17CHD_VL_TYPE_CDVolume Type Codenvarchar20CHAR(N' ')Yes*OIU_VL_TYPE_CD Allow NULL? 
18CHD_CK_NOCheck Numbernvarchar100CHAR(N' ')YesOIUH_CHECK_NUMBER Allow NULL? 
19CHD_BNK_NOBank Identificationnvarchar90CHAR(N' ')YesOIUCW_BANK_ID Allow NULL? 
20CHD_BNK_ACC_NOBank Accountnvarchar90CHAR(N' ')YesOIUCW_BANK_ACCT Allow NULL? 
21CHD_VL_CLASS_CDVolume Class Codechar10CHAR(N' ')YesOIU_VL_CLS_CD Allow NULL? 
22CHD_VL_SRCE_CDVolume source codechar10CHAR(N' ')YesOIUH_VOL_SOURCE_CODE Allow NULL? 
23CHD_VL_FRQ_CDVolume Frequency codechar10CHAR(N' ')YesOIUH_VOL_FREQUENCY_CODE Allow NULL? 
24CHD_BTU_QYBTU Quantitydecimal73DEC((0))YesOIUH_BTU_QUANTITY
25HD_MMBTU_DET_CDMMBTU Determination Codechar10CHAR(N' ')YesOIUH_MMBTU_DET_CODE Allow NULL? 
26CHD_PS_BASE_QYPressure Base Quantitydecimal63DEC((0))YesOIUH_PRESSURE_BASE
27CHD_GRV_QYGravitydecimal31DEC((0))YesOIUH_GRAVITY
28CHD_OWN_NOOwner Numbernvarchar60CHAR(N' ')YesOIUH_OWNER Allow NULL? 
29CHD_OWN_SEQ_NOOwner Sequence Numbernvarchar20CHAR(N' ')YesOIUH_OWNER_SEQUENCE_NUMBER Allow NULL? 
30CHD_PU_NO9OIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
31CHD_PU_NOPurchaser IDnvarchar60CHAR(N' ')YesOIUH_PURCHASER Allow NULL? 
32CHD_PU_SEQ_NO9OIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
33CHD_PU_SEQ_NOPurchaser Sequence Numbernvarchar20CHAR(N' ')YesOIUH_PURCHASER_SEQUENCE_NUMBER Allow NULL? 
34CHD_PRDR_NO9OIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
35CHD_PRDR_NOProducer IDnvarchar60CHAR(N' ')YesOIUH_PRODUCER Allow NULL? 
36CHD_PRDR_SEQ_NO9OIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
37CHD_PRDR_SEQ_NOProducer Sequence Numbernvarchar20CHAR(N' ')YesOIUH_PRODUCER_SEQUENCE_NUMBER Allow NULL? 
38CHD_OI_DECM_QYOwner Interest Decimal Quantitydecimal98DEC((0))YesOIUH_OWN_INTEREST_DECIMAL_QTY
39CHD_OI_TYPE_CDOwner Interest Type Codenvarchar20CHAR(N' ')YesOIUH_OWN_INTEREST_TYPE_CODE Allow NULL? 
40D_OI_INT_SEQ_NOOwner Interest Sequence Numbernvarchar20CHAR(N' ')YesOIUH_OWN_INTEREST_SEQ_NUMBER Allow NULL? 
41CHD_CK_DTOIUH_CHAR14nvarchar140CHAR(N' ')YesOIUH_CHAR14 Allow NULL? 
42CHD_RVRS_RSN_CDReversal Reason Codenvarchar20CHAR(N' ')YesOIUH_RVRS_REASON_CODE Allow NULL? 
43HD_UNIT_MEAS_CDUnit of Measure Codenvarchar30CHAR(N' ')YesOIUH_UNIT_OF_MEASURE Allow NULL? 
44HD_CASH_RCPT_DT9OIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
45HD_CASH_RCPT_DTCash Receipt Datenvarchar140CHAR(N' ')YesOIUH_CASH_RCPT_DT Allow NULL? 
46CHD_SUS_RSN_CDSuspense Reason Codenvarchar20CHAR(N' ')YesOIUH_SUSPENSE_REASON_CODE Allow NULL? 
47CHD_CT_NO9OIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
48CHD_CT_NOContract IDnvarchar60CHAR(N' ')YesOIUH_CONTRACT_ID Allow NULL? 
49CHD_CT_TYPE_CDContract Type codenvarchar20CHAR(N' ')YesOIUH_CONTRACT_TYPE_CODE Allow NULL? 
50CHD_DOI_PR_NOProperty / DOInvarchar80CHAR(N' ')YesOIUH_PROPERTY_DOI Allow NULL? 
51CHD_DOI_SEQ_NODivision of Interest (DOI) Numbernvarchar50CHAR(N' ')YesOIUH_DOI_NO Allow NULL? 
52CHD_TR_PR_NO9OIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
53CHD_TR_PR_NOSection Property Numbernvarchar80CHAR(N' ')YesOIUH_SECTION_PROP_NUMBER Allow NULL? 
54CHD_TR_SEQ_NO9OIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
55CHD_TR_SEQ_NOSection Sequence Numbernvarchar50CHAR(N' ')YesOIUH_SECTION_SEQ_NUMBER Allow NULL? 
56CHD_TRACE_CO_NOCompany Name Codenvarchar30CHAR(N' ')YesOIUH_COMPANY Allow NULL? 
57D_TRACE_APRD_DT9OIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
58D_TRACE_APRD_DTOIUH_CHAR14nvarchar140CHAR(N' ')YesOIUH_CHAR14 Allow NULL? 
59D_TRACE_ACCT_NOAccount IDnvarchar100CHAR(N' ')YesOIUH_ACCTID Allow NULL? 
60D_TRACE_BTCH_NOBatch IDnvarchar40CHAR(N' ')YesOIUH_BATCH_ID Allow NULL? 
61D_TRACE_VOUC_NOVoucher Numbernvarchar60CHAR(N' ')YesOIUH_VOUCHER_NUMBER Allow NULL? 
62CHD_TRACE_LE_NOJournal Entry Line Numbernvarchar80CHAR(N' ')YesOIUH_JELINENO Allow NULL? 
63CHD_WL_NO9OIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
64CHD_WL_NOWell ID Numbernvarchar60CHAR(N' ')YesOIUH_WELL_NO Allow NULL? 
65CHD_WC_NO9OIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
66CHD_WC_NOWell Completion Numbernvarchar20CHAR(N' ')YesOIUH_WC_NO Allow NULL? 
67CHD_DED_TOT_AMLocal amountdecimal112CURR((0))YesOIUH_CURR11_2
68D_DED_TOT_GR_AMLocal amountdecimal112CURR((0))YesOIUH_CURR11_2
69CHD_DED_RMB_AMDeduction/Reimbursement Amountdecimal112CURR((0))YesOIUH_DED_REIMB_AMOUNT
70D_DED_GR_RMB_AMGross Deduction/Reimbursement amountdecimal112CURR((0))YesOIUH_DED_GR_REIMB_AMOUNT
71CHD_TAX_RMB_AMTax Reimbursement Amountdecimal112CURR((0))YesOIUH_TAX_REIMBURSEMENT_AMT
72D_TAX_GR_RMB_AMGross Tax Reimbursement Amountdecimal112CURR((0))YesOIUH_GROSS_TAX_REIMB_AMT
73CHD_INV_NOInvoice Numbernvarchar60CHAR(N' ')YesOIUH_INVOICE_NUMBER Allow NULL? 
74CHD_INV_DT9OIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
75CHD_INV_DTOIUH_CHAR14nvarchar140CHAR(N' ')YesOIUH_CHAR14 Allow NULL? 
76CHD_PAY_CDPay Codenvarchar20CHAR(N' ')YesOIUH_PAY_CODE Allow NULL? 
77CHD_SA_MP_NOMeasurement Pointnvarchar60CHAR(N' ')YesOIUH_MP_NO Allow NULL? 
78CHD_SA_DTGL Sales Datenvarchar140CHAR(N' ')YesOIUREP_GL_SA_DT Allow NULL? 
79CHD_ST_CDState Codenvarchar20CHAR(N' ')YesOIUH_STATE_CODE Allow NULL? 
80CHD_TAX_AUT_NOTax Authority Numbernvarchar60CHAR(N' ')YesOIUH_TAX_AUTHORITY_NUMBER Allow NULL? 
81TAX_AUT_SEQ_NOTax Authority Sequence Numbernvarchar20CHAR(N' ')YesOIUH_TAX_AUTHORITY_SEQ_NUMBER Allow NULL? 
82OWN_BAL_DEC_QYOwner Disbursement (Balance) Decimaldecimal98DEC((0))YesOIUH_OWNER_DISBUR_DECIMAL
83CHD_PR_TYPE_CDProperty Type Codenvarchar20CHAR(N' ')YesOIUH_PROPERTY_TYPE_CODE Allow NULL? 
84HD_OP_NON_OP_FLOperated Flagchar10CHAR(N' ')YesOIUH_OPERATED_FLAG Allow NULL? 
85CHD_PU_PR_NOPurchaser Property Numbernvarchar180CHAR(N' ')YesOIUH_PURCHASER_PROPERTY_NUMBER Allow NULL? 
86CHD_PU_PD_NOPurchaser Product Codenvarchar30CHAR(N' ')YesOIUH_PURCHASER_PRODUCT_CODE Allow NULL? 
87CHD_REJ_FLLine item Reject Flag (Y=Yes, N=No)char10CHAR(N' ')YesOIUH_REJECT_FLAG Allow NULL? 
88CHD_UNIT_PR_NOUnit Property Numbernvarchar80CHAR(N' ')YesOIUH_UNIT_PROPERTY_NUMBER Allow NULL? 
89D_ARMT_LVL_1_CDA/R Remittance Level 1 codenvarchar80CHAR(N' ')YesOIUH_AR_REMIT_LVL_1_CODE Allow NULL? 
90D_ARMT_LVL_2_CDA/R Remittance Level 2 codenvarchar50CHAR(N' ')YesOIUH_AR_REMIT_LVL_2_CODE Allow NULL? 
91CHD_TRANS_DE9OIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
92CHD_TRANS_DEDescriptive Text for financial transactionnvarchar600CHAR(N' ')YesOIUH_DESCRIPTION Allow NULL? 
93CHD_INT_PAID_FLInterest Paid Flagchar10CHAR(N' ')YesOIUH_INTEREST_PAID_FLAG Allow NULL? 
94CHD_OWN_GRVA_AMLocal amountdecimal112CURR((0))YesOIUH_CURR11_2
95D_PLT_VL_RED_AMGross Plant Volume Reduction amountdecimal112DEC((0))YesOIUH_GROSS_PLANT_VOLUME_RED_AM
96CHD_LGND_CDLegend Codenvarchar20CHAR(N' ')YesOIUH_LEGEND_CODE Allow NULL? 
97CHD_CMT_SYS_NO9OIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
98CHD_CMT_SYS_NOComment System Numberdecimal180DEC((0))YesOIUH_COMMENT_SYSTEM_NUMBER
99CHD_VER_NOOIUH_DEC5decimal50DEC((0))YesOIUH_DEC5
100CHD_USER_IDUser IDnvarchar80CHAR(N' ')YesOIUH_USER_ID Allow NULL? 
101CHD_TIMESTAMPTime Stampnvarchar140CHAR(N' ')YesOIUH_TT_TIMESTAMP Allow NULL? 
NamePrimaryUniqueTypeColumns
OIUE2_RV_CHD~0YesYesCLUSTEREDCHD_LE_NO, CHD_VOU_NO, CHD_BTCH_NO, HD_ACCT_PERD_DT, CHD_OR_LVL_1_NO, RUN_ID, 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