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

42 columns | Print definition?ERP 6.0  | LAUFNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DFKK_ACCADJAdjustment Postings when Implementing Acct Assgmt Chars4LAUFNRSequence Numbernvarchar20
2DFKK_NEWACCADJObsolete: See DFKK_ACCADJ4LAUFNRSequence Numbernvarchar20
3P01BN_STATStatus Table for Contribution Statements17LAUFNRRun Numbernvarchar30
4T5D4Y_MAPMapping of Previous Months HI Fund List or Run Number2LAUFNRRun Numbernvarchar30
TOPContract Accounts Receivable and Payable
5DFKK_DUEGRIDOI - Reclassifications4LAUFNRSequence Numbernvarchar20
6DFKK_RECLASSOI - Reclassifications4LAUFNRSequence Numbernvarchar20
TOPContract Billing
7DBERCHZ4Individual line items (rarely used fields)34LAUFNRSequence Number of Service Frequencynvarchar50
8DBERCHZ8Document line items (rarely used fields, unimportant)34LAUFNRSequence Number of Service Frequencynvarchar50
TOPMeter Reading
9DBTAB_TEMPPCdatabase table for temporary Periodic consumption3LAUFNRCounternvarchar30
TOPRisk Analysis
10JBRBDSGUVRM-BDS: P+L Distribution2LAUFNRRDB: Run Numbernvarchar200
11JBRBDSGUV10RM-BDS: P+L Distribution in Blocks of Ten2LAUFNRRDB: Run Numbernvarchar200
12JBRBDSLFNRM-BDS: Run Number Definition2LAUFNRRDB: Run Numbernvarchar200
13JBRBDSLFNARM-BDS: Index for P+L Data in the Archive File2LAUFNRRDB: Run Numbernvarchar200
14JBRBDSLFNBRM-BDS: Archive Information per Run2LAUFNRRDB: Run Numbernvarchar200
15JBRBDSLFNCRM-BDS: Calculation Basis per Run Number3LAUFNRRDB: Run Numbernvarchar200
16JBRBDSLFNSRM-BDS: Run Number Status2LAUFNRRDB: Run Numbernvarchar200
17JBRBDSVARRM-BDS: VaR Data2LAUFNRRDB: Run Numbernvarchar200
TOPSAP Healthcare - Industry-Specific Components for Hospitals
18NEO_NFALIS-H: External Orders - Order Data13LAUFNRIS-H: EO Laboratory Order Numbernvarchar160
19NWCH91Fee Breakdown Results4LAUFNRRun Number for Fee Resultsnvarchar150
20NWCH91_AUSGFee Breakdown Results from Clearing Report4LAUFNRRun Number for Fee Resultsnvarchar150
21NWCHNBEWIS-H CH: Bewegungen zum Fall - Zusatzfelder Schweiz29LAUFNRIS-H: OE n. ordine esterno laboratorionvarchar160
TOPSAP Media
22J_1SPUPBESTANDIS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet5LAUFNRSequence Numbernvarchar30
23J_1SSUPBESTANDIS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet5LAUFNRCharacter field of length 6nvarchar60
TOPWaste Management
24EWAEHSGP_FBusiness Partner Integration Table EHS/ IS-W: Vehicles3LAUFNRConsecutive Numbernvarchar40
25EWAOBJHService Frequency -> Services (History for EWAOBJ)3LAUFNRSequence Number of Service Frequencynvarchar50
26EWAOBJH_AATWaste Billing Categories for Service Frequency Service3LAUFNRSequence Number of Service Frequencynvarchar50
27EWAOBJH_AAT_HISTHistory and Valution of WBCs for Service Freq. Service3LAUFNRSequence Number of Service Frequencynvarchar50
28EWAOBJH_DATESAppendix table of changed data for service frequency3LAUFNRSequence Number of Service Frequencynvarchar50
29EWAOBJH_DIFFCULTService Frequency Notes3LAUFNRSequence Number of Service Frequencynvarchar50
30EWAOBJH_SDSHARESubitems of Sales Document for Service Type3LAUFNRSequence Number of Service Frequencynvarchar50
31EWAOBJH_SEQUENCERoute Sequence per EWAOBJH3LAUFNRSequence Number of Service Frequencynvarchar50
32EWAOBJH_UPOSSubitems of Sales Document for Service Type3LAUFNRSequence Number of Service Frequencynvarchar50
33EWATDEVLOCProvisional Container/Container Location Allocation3LAUFNRSequence Numbernvarchar40
34EWA_BILL_RELEVNTValuation of Fields Relevant for Billing in Waste Bill.Cat.3LAUFNRConsecutive Number for Valuation of Waste Billing Categorynvarchar40
35EWA_ORDER_HD_COHeader Table for Waste Disposal Order (CO Data)3LAUFNRSequence Number of CO Itemnvarchar100
36EWA_ORDER_HD_CPHeader Table for Waste Disposal Order (CO-PA Data)3LAUFNRSequence Number of CO Itemnvarchar100
37EWA_ORDER_OBJ_COItem Table in Waste Disposal Order (CO Data)4LAUFNRSequence Number of CO Itemnvarchar100
38EWA_ORDER_OBJ_CPItem Table in Waste Disposal Order (CO-PA Data)4LAUFNRSequence Number of CO Itemnvarchar100
39EWA_ORDER_WGH_COWeighing Data Table for Waste Disposal Order (CO Data)4LAUFNRSequence Number of CO Itemnvarchar100
40EWA_ORDER_WGH_CPWeighing Data Table for Waste Disposal Order (CO-PA Data)4LAUFNRSequence Number of CO Itemnvarchar100
41EWA_WA_WPROC_COWeighing Transaction (CO Data)3LAUFNRSequence Number of CO Itemnvarchar100
42EWA_WA_WPROC_CPWeighing Transaction (CO-PA - Data)3LAUFNRSequence Number of CO Itemnvarchar100