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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

72 columns | Print definition?ERP 6.0  | LINE_NO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SLCE/CFG_XMLConfiguration XML Table3LINE_NOLine Numbernvarchar100
2/SLCE/CFG_XML_TMConfiguration XML Table3LINE_NOLine Numbernvarchar100
3DMC_IU_PROTOCOLMWB - Integrated Upgrade: Protocol2LINE_NOnvarchar100
4DMC_SELSTRINGSelect strings2LINE_NODMC: Line Numbersnvarchar40
5EHPRCD_ICH4TXChapter 4: Text table for Chapter 4 data3LINE_NOLine Number for Text Tablesint100
6IUUC_DD_SYNC_DDDSystem synchronization: DD_DECIDE-result for table/view5LINE_NONatural Numberint100
7IUUC_MOD_PERF_OPIUUC: Modify PERF_OPT based on automated ST10 evaluation3LINE_NODMC: Line Numbersnvarchar40
8IUUC_ODQ_PARAMODQ queue selection parameters2LINE_NODMC: Line Numbersnvarchar40
9IUUC_ODQ_PRJODQ request parameters2LINE_NODMC: Line Numbersnvarchar40
10IUUC_RECON_WCL_CIUUC: Where Cluase5LINE_NODMC: Line Numbersnvarchar40
11IUUC_SPC_PROCOPTdefine field-content-specific trigger behaviour (freeze/delt4LINE_NODMC: Line Numbersnvarchar40
12LTR_PRESEL_CONDPreselection conditions5LINE_NOnvarchar30
13LTR_TS_CHECK.2LINE_NONatural Numberint100
14OIUX8_NM_TAXDTLTax 2.0 - New Mexico Tax Details4LINE_NODocument Line Numbernvarchar50
15PQDATAPureQuantify Daten1LINE_NOVerifikation : Zeilennummerint100
TOPBusiness Analytics
16UACRCONDCosting Run: Condition Expression3LINE_NONatural Numberint100
17UALCONEXConditional Expressions3LINE_NONatural Numberint100
TOPBusiness Planning and Simulation
18UPWB_TEMPLATESTemplates to Genererate BSP Applications3LINE_NOFour-digit numbernvarchar40
19UPWB_TEMPLATES2Templates to Genererate BSP Applications4LINE_NOFour-digit numbernvarchar40
TOPCheck Input
20OIUCI_CDEXDCDEX Detail5LINE_NOCheck Line Numbernvarchar50
TOPCheck Write
21OIUCW_EXTDExtended Details from Payment Run6LINE_NOLine Numbernvarchar80
22OIUCW_PAYMENTPayment Details from Payment Run6LINE_NOLine Numbernvarchar80
23OIUCW_REJECTSPayments Not Made in the Run6LINE_NOLine Numbernvarchar80
TOPData Conversion
24DMC_CTABLEDMC: Table for Storing Coding, Documentation3LINE_NODMC: Line Numbersnvarchar40
25DMC_TMPLTSDMC: Code Templates for Runtime Objects2LINE_NODMC: Line Numbersnvarchar40
TOPData Staging
26RSAABAPABAP routine - source code3LINE_NORow number for ABAP codenvarchar60
27RSAABAPINVABAP Routine - Source Code for Inverse Routines3LINE_NORow number for ABAP codenvarchar60
28RSTSABAPSHShadow table: ABAP routine - source code5LINE_NORow number for ABAP codenvarchar60
TOPDigital Signature
29TC71DSigned Document for Signature3LINE_NOLine number of the signed documentnvarchar40
TOPEnvironment, Health and Safety
30/TDAG/CPA_ICH4TXChapter 4: Text table for Chapter 4 data3LINE_NOLine Number for Text Tablesint100
TOPliveCache Applications
31LCA_WARNINGSWarnings in the "liveCache Applications" Area3LINE_NORowtinyint30
TOPNetWeaver Enterprise Search
32ESH_OM_IE_IMPLGMLog Messages of SNOTE Software Component / Model Import3LINE_NODummy for B20 int1 (Local Everywhere)tinyint30
TOPPublic Sector Contract Accounts Receivable and Payable
33DFMCA_BRF_MSGTax Calculation and Validation: Error Messages7LINE_NOLine Numberint100
34DFMCA_NOTE_ATTNote Attributes for Process Objects11LINE_NOLine Numberint100
35DFMCA_TF_CST_LLine Item Table of Consolidated SUT Member Schedule4LINE_NOLine Numberint100
36DFMCA_TF_MFT_D_LLine Item Table of Motor Fuel Tax Disbursement Schedule4LINE_NOLine Numberint100
37DFMCA_TF_MFT_R_LLine Item Table of Motor Fuel Tax Receipts Schedule4LINE_NOLine Numberint100
38DFMCA_TF_UET_LLine Item Table of Unemployment Tax4LINE_NOLine Numberint100
39DFMCA_TF_WHT_LLine Item Table of Withholding Tax4LINE_NOLine Numberint100
TOPRevenue
40OIUE2_CW_REJECTSProc 2.0 - Check Write Rejects7LINE_NOLine Numbernvarchar80
41OIUHS_SAP_SORTPRA: Control Table for SAP Sort4LINE_NOSequence numbernvarchar20
42OIURV01_RD_REPRD Generic Report5LINE_NODocument Line Numbernvarchar50
43OIURV03_DOCMPXRFVL Doc to MP XRef4LINE_NODocument Line Numbernvarchar50
44OIURV03_DTL_BKValuation Transactions Level 1 - Vltxns4LINE_NODocument Line Numbernvarchar50
45OIURV03_DTL_ZEValuation Transactions Level 1 - Zero Volume5LINE_NODocument Line Numbernvarchar50
46OIURV03_FRMHDRValuation Transaction Level 3 - Formula4LINE_NODocument Line Numbernvarchar50
47OIURV03_FRMTAXValuation Transactions Level 3 - Formula Tax Detail4LINE_NODocument Line Numbernvarchar50
48OIURV03_TAXDTLValuation Tax Master Detail4LINE_NODocument Line Numbernvarchar50
49OIURV03_TAXEMPValuation Tax Exempt Detail4LINE_NODocument Line Numbernvarchar50
50OIURV03_TAXHDRValuation Tax Header4LINE_NODocument Line Numbernvarchar50
51OIURV03_TAXMKTValuation Tax Marketing Detail4LINE_NODocument Line Numbernvarchar50
52OIURV03_VOLDTLValuation Transaction Level 2 -Volume4LINE_NODocument Line Numbernvarchar50
TOPSupply Chain Management
53/SDF/EM_CALL_STKException Management - Call Stack4LINE_NOSequencesmallint50
54/SDF/EM_MSGMessages5LINE_NOSequencesmallint50
TOPValuation
55OIURV_DOC_COTVL Document Chain Of Title5LINE_NODocument Line Numbernvarchar50
56OIURV_DOC_DTL_BKValuation Transactions Level 1 - Vltxns4LINE_NODocument Line Numbernvarchar50
57OIURV_DOC_DTL_RVValuation Reversal Notificaton4LINE_NODocument Line Numbernvarchar50
58OIURV_DOC_DTL_ZEValuation Transactions Level 1 - Zero Volume5LINE_NODocument Line Numbernvarchar50
59OIURV_DOC_FRMHDRValuation Transaction Level 3 - Formula4LINE_NODocument Line Numbernvarchar50
60OIURV_DOC_FRMLAUValuation Formula Alternate Use4LINE_NODocument Line Numbernvarchar50
61OIURV_DOC_FRMMKTValuation Transactions Level 3 - Marketing Detail4LINE_NODocument Line Numbernvarchar50
62OIURV_DOC_FRMTAXValuation Transactions Level 3 - Formula Tax Detail4LINE_NODocument Line Numbernvarchar50
63OIURV_DOC_OOBJEOut Of Balance JEs5LINE_NODocument Line Numbernvarchar50
64OIURV_DOC_RDSUMRD summary(VL interface records to RD)4LINE_NODocument Line Numbernvarchar60
65OIURV_DOC_RUNTKTValuation Transaction - Run Ticket4LINE_NODocument Line Numbernvarchar50
66OIURV_DOC_TAXDTLValuation Tax Master Detail4LINE_NODocument Line Numbernvarchar50
67OIURV_DOC_TAXEMPValuation Tax Exempt Detail4LINE_NODocument Line Numbernvarchar50
68OIURV_DOC_TAXHDRValuation Tax Header4LINE_NODocument Line Numbernvarchar50
69OIURV_DOC_TAXMKTValuation Tax Marketing Detail4LINE_NODocument Line Numbernvarchar50
70OIURV_DOC_VOLDTLValuation Transaction Level 2 -Volume4LINE_NODocument Line Numbernvarchar50
71OIURV_DOC_VOLUNTValuation Document Concept - Volume Unit4LINE_NODocument Line Numbernvarchar50
72OIURV_DUAL_JEBRDual Accounting JE Backout / Rebook4LINE_NODocument Line Numbernvarchar50