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

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

163 columns | Print definition?ERP 6.0  | DOC_NO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CMCBD_BGT_CLAIMBudget claims based on suggest level8DOC_NODocument No. in budget claimnvarchar130
2CMCBD_CONSUMECash Budgeting Consumption9DOC_NOAccounting Document Numbernvarchar100
3CNV_NCE_DOC_MAPNCE: Mapping data for individual doc numbers7DOC_NOLower limit for source number rangenvarchar200
4CNV_NCE_DOC_SIMNCE: Mapping data for individual doc numbers8DOC_NOLower limit for source number rangenvarchar200
5CNV_NCE_NRIV_TRXNumber conversion engine: Tracking data7DOC_NOLower limit for source number rangenvarchar200
6CNV_NCE_SOBJ_DUPDuplicate numbers8DOC_NOFrom numbernvarchar200
7J_1I_PM_COODETEXIM: COO line items2DOC_NODocument Numbernvarchar100
8J_1I_PM_DOCDTLEXIM : Process Management Documents Detail Data2DOC_NODocument Numbernvarchar100
9J_1I_PM_DOCHDREXIM : Process Management Documents Header Data2DOC_NODocument Numbernvarchar100
10J_1I_PM_DOC_STATEXIM : Document Status for Process2DOC_NODocument Numbernvarchar100
11J_1I_PM_PACKLISTEXIM: Packing List Items2DOC_NODocument Numbernvarchar100
12J_1I_SHIPDTLEXIM : Shipping Bill Detail2DOC_NODocument Numbernvarchar100
13J_1I_SHIPHDREXIM : Shipping Bill Header2DOC_NODocument Numbernvarchar100
14LOP_D_LIST_HDOption list header11DOC_NODocument Numbernvarchar200
15OIUX8_NM_OOSHSTTax 2.0 - NM - Out-Of-Statute Transaction History65DOC_NOVal. document numbernvarchar200
16OIUX8_NM_OOSTXNTax 2.0 - NM - Out-Of-Statute Transactions65DOC_NOVal. document numbernvarchar200
17OIUX8_NM_PRDTTax 2.0 - NM - PRA Detail Transactions67DOC_NOVal. document numbernvarchar200
18OIUX8_NM_REVSTGTax 2.0 - NM - Tax Reversals (Staging)12DOC_NOVal. document numbernvarchar200
19OIUX8_NM_REVTXNTax 2.0 - NM - Tax Reversals12DOC_NOVal. document numbernvarchar200
20OIUX8_NM_TAXDTLTax 2.0 - New Mexico Tax Details2DOC_NOVal. document numbernvarchar200
21OIUX8_NM_TAXHSTTax 2.0 - NM - Tax Transaction History65DOC_NOVal. document numbernvarchar200
22OIUX8_NM_TAXSTGTax 2.0 - NM - Tax Transactions (Staging)65DOC_NOVal. document numbernvarchar200
23OIUX8_NM_TAXTXNTax 2.0 - NM - Tax Transactions65DOC_NOVal. document numbernvarchar200
24OIUY3_TX_INTSTGRoyalty 2.0 - TX GLO - Royalty Trans Interface Staging65DOC_NOVal. document numbernvarchar200
25OIUY3_TX_INTTXNRoyalty 2.0 - TX GLO/TAMU - Royalty Transaction Interface65DOC_NOVal. document numbernvarchar200
26OIUY3_TX_OOSHSTRoyalty 2.0 - TX - Out of Statute Royalty Transaction Hist62DOC_NOVal. document numbernvarchar200
27OIUY3_TX_OOSTXNRoyalty 2.0 - TX GLO - Out of Statute Royalty Transactions62DOC_NOVal. document numbernvarchar200
28OIUY3_TX_PRDTRoyalty 2.0 - TX GLO - Royalty PRA Details64DOC_NOVal. document numbernvarchar200
29OIUY3_TX_PRDTARoyalty 2.0 - TX GLO - Royalty PRA Details (Allocated)65DOC_NOVal. document numbernvarchar200
30OIUY3_TX_REVSTGRoyalty 2.0 - TX GLO - Royalty Reversals (Staging)12DOC_NOVal. document numbernvarchar200
31OIUY3_TX_REVTXNRoyalty 2.0 - TX GLO - Royalty Reversals12DOC_NOVal. document numbernvarchar200
32OIUY3_TX_ROYHSTRoyalty 2.0 - TX GLO - Royalty Transaction History62DOC_NOVal. document numbernvarchar200
33OIUY3_TX_ROYHSTARoyalty 2.0 - TX GLO - Royalty Trans History (Allocated)63DOC_NOVal. document numbernvarchar200
34OIUY3_TX_ROYSTGRoyalty 2.0 - TX GLO - Royalty Transactions (Staging)62DOC_NOVal. document numbernvarchar200
35OIUY3_TX_ROYTXNRoyalty 2.0 - TX GLO - Royalty Transactions62DOC_NOVal. document numbernvarchar200
36OIUY3_TX_ROYTXNARoyalty 2.0 - TX GLO - Royalty Transactions (Allocated)63DOC_NOVal. document numbernvarchar200
37OIUY6_WY_INTSTGRoyalty 2.0 - WY - Royalty Transaction Interface (Staging)63DOC_NOVal. document numbernvarchar200
38OIUY6_WY_INTTXNRoyalty 2.0 - WY - Royalty Transaction Interface63DOC_NOVal. document numbernvarchar200
39OIUY6_WY_OOSHSTRoyalty 2.0 - WY - Out of Statute Royalty Transaction Hist60DOC_NOVal. document numbernvarchar200
40OIUY6_WY_OOSTXNRoyalty 2.0 - WY - Out of Statute Royalty Transactions60DOC_NOVal. document numbernvarchar200
41OIUY6_WY_PRDTRoyalty 2.0 - WY - Royalty PRA Details62DOC_NOVal. document numbernvarchar200
42OIUY6_WY_PRDTARoyalty 2.0 - WY - Royalty PRA Details (Allocated)63DOC_NOVal. document numbernvarchar200
43OIUY6_WY_REVSTGRoyalty 2.0 - WY - Royalty Reversals (Staging)12DOC_NOVal. document numbernvarchar200
44OIUY6_WY_REVTXNRoyalty 2.0 - WY - Royalty Reversals12DOC_NOVal. document numbernvarchar200
45OIUY6_WY_ROYHSTRoyalty 2.0 - WY - Royalty Transaction History60DOC_NOVal. document numbernvarchar200
46OIUY6_WY_ROYHSTARoyalty 2.0 - WY - Royalty Transaction History (Allocated)61DOC_NOVal. document numbernvarchar200
47OIUY6_WY_ROYSTGRoyalty 2.0 - WY - Royalty Transactions (Staging)60DOC_NOVal. document numbernvarchar200
48OIUY6_WY_ROYTXNRoyalty 2.0 - WY - Royalty Transactions60DOC_NOVal. document numbernvarchar200
49OIUY6_WY_ROYTXNARoyalty 2.0 - WY - Royalty Transactions (Allocated)61DOC_NOVal. document numbernvarchar200
50OIU_RV_LOAD_OILValuation Load Oil Transactions14DOC_NOVal. document numbernvarchar200
51ZPRJAPRdocument Status5DOC_NOCharacter Field Length = 10nvarchar100
TOPAccounting Engine
52/EACC/T_MSG_CTXTReduced Persistent View of Message Context Objects7DOC_NOInternal ACC Document Numbernvarchar120
TOPAccounting Interface
53GLE_ECS_BAL_ITEMGL open items that are not in ECS3DOC_NOAccounting Document Numbernvarchar100
54GLE_ECS_ITEMECS: Error Correction Items7DOC_NODocument Number of Posted (Suspense) Documentnvarchar100
TOPCheck Input
55OIUCI_DOC_CIREJContains VL/RD rejects to be reported to Check Input2DOC_NOVal. document numbernvarchar200
TOPCross-Application Components
56/OPT/S_PO_HISTVSS Staging Table: PO history10DOC_NONumber of Material Documentnvarchar100
TOPDistributor-Reseller-Management
57/SAPHT/DRMR3XNDRM relevant ERP Transactions4DOC_NOTransaction Document Numbernvarchar100
TOPDSD Connector
58/DSD/ME_CLR_HDDSD CN: Clearing header data8DOC_NODSD Connector: Document Numbernvarchar100
59/DSD/ME_CREDITDSD Connector: Credit data11DOC_NODSD Connector: Document Numbernvarchar100
60/DSD/ME_OPIM_HDDSD CN: Open Items header data2DOC_NODSD Connector: Document Numbernvarchar100
TOPInventory Accounting
61UAINVDEBCRHDocument for Revaluation Through Material Debit/Credit2DOC_NODocument Number for Material Debit/Creditnvarchar150
62UAINVDEBCRIDocument Item for Revaluation Through Material Debit/Credit2DOC_NODocument Number for Material Debit/Creditnvarchar150
63UAINVREVALHDocument for INV Price Change and Inventory Revaluation2DOC_NODocument Number for Inventory Price Changenvarchar150
64UAINVREVALIDocument Item for Inventory Price Change and Revaluation2DOC_NODocument Number for Inventory Price Changenvarchar150
TOPLogistics - General
65CRM_SRV_LOG_SCCRM Service: Logistics Scenarios7DOC_NOCharacter Field Length = 10nvarchar100
TOPOwnership
66OIUOW_DOH_WKOwnership History Workable32DOC_NORequest doc. numbernvarchar100
67OIUOW_DORHDO Owner Request History2DOC_NORequest doc. numbernvarchar100
68OIUOW_DTCHDOI Transfer Change Header2DOC_NORequest doc. numbernvarchar100
69OIUOW_DTCSDOI Transfer Change Select2DOC_NORequest doc. numbernvarchar100
70OIUOW_DTDDOI Transfer Change Detail2DOC_NORequest doc. numbernvarchar100
71OIUOW_POWOwners on Pending Requests5DOC_NORequest doc. numbernvarchar100
72OIUOW_RTCHRD DOI Transfer Change Header10DOC_NORequest doc. numbernvarchar100
73OIUOW_RTCH_WKRD DOI Transfer Change Header Worktable10DOC_NORequest doc. numbernvarchar100
74OIUOW_RTDRD DOI Transferee Detail17DOC_NORequest doc. numbernvarchar100
75OIUOW_RTD_WKRD DOI Transferee Detail Worktable17DOC_NORequest doc. numbernvarchar100
TOPPersonnel Time Management
76HRAAHDRHR Interface Table: Document Header for Activity Allocation9DOC_NODocument Numbernvarchar100
TOPProduction and Revenue Accounting
77OIUT2_INT_FDNObsolete: Funds Delete Notification Control19DOC_NODocument numbernvarchar100
78OIUXI_INT_FDNFunds Delete Notification Control19DOC_NODocument numbernvarchar100
79OIU_DO_DOHOwnership History32DOC_NORequest doc. numbernvarchar100
80OIU_RV_RVTRejected Valuation Transactions13DOC_NOVal. document numbernvarchar200
81OIU_RV_VPPNValuation Prior Period Notification14DOC_NOVal. document numbernvarchar200
82OIU_RV_VPPNMManually Created Valuation Prior Period Notifications14DOC_NOVal. document numbernvarchar200
83OIU_RV_VPPNUValuation Prior Period Notification14DOC_NOVal. document numbernvarchar200
TOPRevenue
84OIURV01_RD_REPRD Generic Report2DOC_NOVal. document numbernvarchar200
85OIURV03_DOCMPXRFVL Doc to MP XRef2DOC_NOVal. document numbernvarchar200
86OIURV03_DTL_BKValuation Transactions Level 1 - Vltxns2DOC_NOVal. document numbernvarchar200
87OIURV03_DTL_ZEValuation Transactions Level 1 - Zero Volume2DOC_NOVal. document numbernvarchar200
88OIURV03_FRMHDRValuation Transaction Level 3 - Formula2DOC_NOVal. document numbernvarchar200
89OIURV03_FRMTAXValuation Transactions Level 3 - Formula Tax Detail2DOC_NOVal. document numbernvarchar200
90OIURV03_TAXDTLValuation Tax Master Detail2DOC_NOVal. document numbernvarchar200
91OIURV03_TAXEMPValuation Tax Exempt Detail2DOC_NOVal. document numbernvarchar200
92OIURV03_TAXHDRValuation Tax Header2DOC_NOVal. document numbernvarchar200
93OIURV03_TAXMKTValuation Tax Marketing Detail2DOC_NOVal. document numbernvarchar200
94OIURV03_VOLDTLValuation Transaction Level 2 -Volume2DOC_NOVal. document numbernvarchar200
TOPTax Reporting
95OIUX1_RPT_TAXHTax transaction header for reporting19DOC_NOVal. document numbernvarchar200
96OIUX1_TRN_TAXHCTax transaction header for reporting15DOC_NOVal. document numbernvarchar200
97OIUX1_TRN_TAXHLTax transaction header for reporting15DOC_NOVal. document numbernvarchar200
98OIUX3_MIG_VLDOCTax Reporting - Migration Loaded VL Docs3DOC_NOVal. document numbernvarchar200
99OIUX3_TX_REVSTGTax Reporting - Texas Tax Transaction Reversal Staging13DOC_NOVal. document numbernvarchar200
100OIUX3_TX_TAXSTGTax Reporting - Texas Tax Transaction Staging54DOC_NOVal. document numbernvarchar200
101OIUX5_OK_OOSHSTTax 2.0 - Oklahoma Out Of Statute Transactions History69DOC_NOVal. document numbernvarchar200
102OIUX5_OK_OOSTXNTax 2.0 - Oklahoma Out Of Statute Transactions69DOC_NOVal. document numbernvarchar200
103OIUX5_OK_PRDTTax 2.0 - Oklahoma PRA Detail Tax Transactions71DOC_NOVal. document numbernvarchar200
104OIUX5_OK_PRDTCTax 2.0 - Oklahoma PRA Detail Tax Transactions Multi Count73DOC_NOVal. document numbernvarchar200
105OIUX5_OK_REVSTGTax 2.0 - Oklahoma Tax Reversals Staging12DOC_NOVal. document numbernvarchar200
106OIUX5_OK_REVTXNTax 2.0 - Oklahoma Tax Reversals12DOC_NOVal. document numbernvarchar200
107OIUX5_OK_TAXHSTTax 2.0 - Oklahoma Tax Transactions History69DOC_NOVal. document numbernvarchar200
108OIUX5_OK_TAXHSTCTax 2.0 - Oklahoma Tax Transactions History Multi-Counties71DOC_NOVal. document numbernvarchar200
109OIUX5_OK_TAXSTGTax 2.0 - Oklahoma Tax Transactions Staging69DOC_NOVal. document numbernvarchar200
110OIUX5_OK_TAXTXNTax 2.0 - Oklahoma Tax Transactions69DOC_NOVal. document numbernvarchar200
111OIUX5_OK_TAXTXNCTax 2.0 - Oklahoma Tax Transactions Multiple Counties71DOC_NOVal. document numbernvarchar200
112OIUX6_WY_COOSHSTTax 2.0 - Wyoming Out Of Statute Conservation Trans Hist48DOC_NOVal. document numbernvarchar200
113OIUX6_WY_COOSTXNTax 2.0 - Wyoming Out Of Statute Conservation Transactions48DOC_NOVal. document numbernvarchar200
114OIUX6_WY_CPRDTTax 2.0 - Wyoming Conservation Tax PRA Detail Transactions50DOC_NOVal. document numbernvarchar200
115OIUX6_WY_CREVSTGTax 2.0 - Wyoming Conservation Tax Reversals Staging12DOC_NOVal. document numbernvarchar200
116OIUX6_WY_CREVTXNTax 2.0 - Wyoming Conservation Tax Reversals12DOC_NOVal. document numbernvarchar200
117OIUX6_WY_CTAXHSTTax 2.0 - Wyoming Conservation Tax Transactions History48DOC_NOVal. document numbernvarchar200
118OIUX6_WY_CTAXSTGTax 2.0 - Wyoming Conservation Tax Transactions Staging48DOC_NOVal. document numbernvarchar200
119OIUX6_WY_CTAXTXNTax 2.0 - Wyoming Conservation Tax Transactions48DOC_NOVal. document numbernvarchar200
120OIUX6_WY_GTAXSTGTax 2.0 - Wyoming Gross Prod Tax Transactions Staging63DOC_NOVal. document numbernvarchar200
121OIUX6_WY_GTAXTXNTax 2.0 - Wyoming Gross Prod Tax Transactions63DOC_NOVal. document numbernvarchar200
122OIUX6_WY_SOOSHSTTax 2.0 - Wyoming Out Of Statute Severance Trans History63DOC_NOVal. document numbernvarchar200
123OIUX6_WY_SOOSTXNTax 2.0 - Wyoming Out Of Statute Severance Transactions63DOC_NOVal. document numbernvarchar200
124OIUX6_WY_SPRDTTax 2.0 - Wyoming Severance Tax PRA Detail Transactions65DOC_NOVal. document numbernvarchar200
125OIUX6_WY_SREVSTGTax 2.0 - Wyoming Severance Tax Reversals Staging12DOC_NOVal. document numbernvarchar200
126OIUX6_WY_SREVTXNTax 2.0 - Wyoming Severance Tax Reversals12DOC_NOVal. document numbernvarchar200
127OIUX6_WY_STAXHSTTax 2.0 - Wyoming Severance Tax Transactions History63DOC_NOVal. document numbernvarchar200
128OIUX6_WY_STAXSTGTax 2.0 - Wyoming Severance Tax Transactions Staging63DOC_NOVal. document numbernvarchar200
129OIUX6_WY_STAXTXNTax 2.0 - Wyoming Severance Tax Transactions63DOC_NOVal. document numbernvarchar200
130OIUX7_WY_GTAXTax 2.0 - Wyoming Gross Prod Tax Transactions63DOC_NOVal. document numbernvarchar200
131OIUX7_WY_GTAXHSTTax 2.0 - Wyoming Gross Prod Tax Transactions History62DOC_NOVal. document numbernvarchar200
TOPTrading Contract
132PPE_D_ITEM_LISTEvents3DOC_NODocument Numbernvarchar200
TOPValuation
133OIURV_CRH_HSTCombined Run Header History13DOC_NOVal. document numbernvarchar200
134OIURV_DOC_BCNRevenue Document Concept - Batch Control Number2DOC_NOVal. document numbernvarchar200
135OIURV_DOC_COTVL Document Chain Of Title2DOC_NOVal. document numbernvarchar200
136OIURV_DOC_CRHOil and Gas appl table2DOC_NOVal. document numbernvarchar200
137OIURV_DOC_DTL_BKValuation Transactions Level 1 - Vltxns2DOC_NOVal. document numbernvarchar200
138OIURV_DOC_DTL_RVValuation Reversal Notificaton2DOC_NOVal. document numbernvarchar200
139OIURV_DOC_DTL_ZEValuation Transactions Level 1 - Zero Volume2DOC_NOVal. document numbernvarchar200
140OIURV_DOC_FRMHDRValuation Transaction Level 3 - Formula2DOC_NOVal. document numbernvarchar200
141OIURV_DOC_FRMLAUValuation Formula Alternate Use2DOC_NOVal. document numbernvarchar200
142OIURV_DOC_FRMMKTValuation Transactions Level 3 - Marketing Detail2DOC_NOVal. document numbernvarchar200
143OIURV_DOC_FRMTAXValuation Transactions Level 3 - Formula Tax Detail2DOC_NOVal. document numbernvarchar200
144OIURV_DOC_HDRValuation Document Header2DOC_NOVal. document numbernvarchar200
145OIURV_DOC_JEINTFRevenue Document Concept - JEINTF temp table2DOC_NOVal. document numbernvarchar200
146OIURV_DOC_MMSPOPDual Accounting MMS/POP2DOC_NOVal. document numbernvarchar200
147OIURV_DOC_OOBJEOut Of Balance JEs2DOC_NOVal. document numbernvarchar200
148OIURV_DOC_RDSUMRD summary(VL interface records to RD)2DOC_NOVal. document numbernvarchar200
149OIURV_DOC_RUNTKTValuation Transaction - Run Ticket2DOC_NOVal. document numbernvarchar200
150OIURV_DOC_TAXDTLValuation Tax Master Detail2DOC_NOVal. document numbernvarchar200
151OIURV_DOC_TAXEMPValuation Tax Exempt Detail2DOC_NOVal. document numbernvarchar200
152OIURV_DOC_TAXHDRValuation Tax Header2DOC_NOVal. document numbernvarchar200
153OIURV_DOC_TAXMKTValuation Tax Marketing Detail2DOC_NOVal. document numbernvarchar200
154OIURV_DOC_VOLDTLValuation Transaction Level 2 -Volume2DOC_NOVal. document numbernvarchar200
155OIURV_DOC_VOLUNTValuation Document Concept - Volume Unit2DOC_NOVal. document numbernvarchar200
156OIURV_DUAL_COMPDual Accounting Compare2DOC_NOVal. document numbernvarchar200
157OIURV_DUAL_JEBRDual Accounting JE Backout / Rebook2DOC_NOVal. document numbernvarchar200
158OIURV_SSTDSettlement statement detail2DOC_NOVal. document numbernvarchar200
159OIURV_SSTD_MKTSettlement statement detail2DOC_NOVal. document numbernvarchar200
160OIURV_SSTD_TAXSettlement statement detail2DOC_NOVal. document numbernvarchar200
161OIUVL_SCAUDITSettlement statement batch2DOC_NOVal. document numbernvarchar200
162OIUVL_SCREJscrej2DOC_NOVal. document numbernvarchar200
163OIUVL_SSTHSettlement statement header2DOC_NOVal. document numbernvarchar200