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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

69 columns | Print definition?ERP 6.0  | BISDAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CE4PR22Périm. résultat IDES5BISDATFin de validiténvarchar80
2CE4PR22_ACCTPérim. résultat IDES5BISDATFin de validiténvarchar80
3CE4PR22_KENCPérim. résultat IDES6BISDATFin de validiténvarchar80
4T258FCO-PA access control for Product Costing7BISDATValid-To Datenvarchar80
5ZSKTIMERTimer für TT-systems2BISDATuntil datenvarchar80
6ZSKTIMERTTTT-timer2BISDATuntil datenvarchar80
7ZZZ_IF_KRANKInterface Meldesatz Krankenstände10BISDATCharacterfeld der Länge 10nvarchar100
TOPCollectionsDisbursements
8VKKINTERESTHISTInt. Calc. History for Deposit Acct8BISDATEnd date-interest calc.nvarchar80
9VVKKDEPOTDeposit Int. Calc. Table6BISDATTime Stamp (Date and Time)nvarchar140
10VVKKIHISTDeposit Acct Interest Calc: History (Detail)9BISDATEnd date-interest calc.nvarchar80
11VVKKIHISTIOBSec. Acct Int. Calc. Acc. to Ins. Obj.: History (Detail)15BISDATEnd date-interest calc.nvarchar80
TOPConstruction Equipment Management
12J_3GKALENDSettlement Calendar4BISDATDatenvarchar80
TOPContract Accounts Receivable and Payable
13DFKKIAFI-CA: Database table for FKKIA - intrst supp10BISDATEnd date-interest calc.nvarchar80
14DFKKIAPTInterest Calculation: Log for Interest Run15BISDATEnd date-interest calc.nvarchar80
15DFKKIHFI-CA: Table with Interest History10BISDATEnd date-interest calc.nvarchar80
TOPExchanges
16OIA05HQuantity schedule header table - sales side21BISDATValid-to datenvarchar80
17OIA06HQuantity schedule header table - purchasing side22BISDATValid-to datenvarchar80
TOPGeneric Contract Accounts Receivable and Payable
18DFSCIHISTIOBBalance Int. Calculation at Contract Account Level: History14BISDATEnd date-interest calc.nvarchar80
TOPPeriodical Sales and Distribution
19TJVTMCP_EXCL_STRIS-M: Market Coverage Exclusion for Carrier Routes/GUnits5BISDATExclusion to Datenvarchar80
TOPProduct Catalog
20WWMIProduct catalog9BISDATProduct catalog valid tonvarchar80
TOPProfitability Analysis
21CE485005BISDATValid tonvarchar80
22CE48500_ACCT5BISDATValid tonvarchar80
23CE48500_KENC6BISDATValid tonvarchar80
24CE4BGISErgebnisbereich für5BISDATGültig-bis-Datumnvarchar80
25CE4BGIS_ACCTErgebnisbereich für5BISDATGültig-bis-Datumnvarchar80
26CE4BGIS_KENCErgebnisbereich für6BISDATGültig-bis-Datumnvarchar80
27CE4E_B1Model Bank5BISDATValid tonvarchar80
28CE4E_B1_ACCTModel Bank5BISDATValid tonvarchar80
29CE4E_B1_KENCModel Bank6BISDATValid tonvarchar80
30CE4IDEAOp. Concern BR World5BISDATValid tonvarchar80
31CE4IDEA_ACCTOp. Concern BR World5BISDATValid tonvarchar80
32CE4IDEA_KENCOp. Concern BR World6BISDATValid tonvarchar80
33CE4IDEBErgebnisbereich IDES5BISDATGültig-bis-Datumnvarchar80
34CE4IDEB_ACCTErgebnisbereich IDES5BISDATGültig-bis-Datumnvarchar80
35CE4IDEB_KENCErgebnisbereich IDES6BISDATGültig-bis-Datumnvarchar80
36CE4IDESErgebnisbereich IDES5BISDATGültig-bis-Datumnvarchar80
37CE4IDES_ACCTErgebnisbereich IDES5BISDATGültig-bis-Datumnvarchar80
38CE4IDES_KENCErgebnisbereich IDES6BISDATGültig-bis-Datumnvarchar80
39CE4INT1Ergebnisbereich IDES5BISDATGültig-bis-Datumnvarchar80
40CE4INT1_ACCTErgebnisbereich IDES5BISDATGültig-bis-Datumnvarchar80
41CE4INT1_KENCErgebnisbereich IDES6BISDATGültig-bis-Datumnvarchar80
42CE4OC01Bike International5BISDATValid tonvarchar80
43CE4OC01_ACCTBike International5BISDATValid tonvarchar80
44CE4OC01_KENCBike International6BISDATValid tonvarchar80
45CE4R300Operating Concern IDES5BISDATValid tonvarchar80
46CE4R300_ACCTErgebnisbereich IDES5BISDATGültig-bis-Datumnvarchar80
47CE4R300_KENCOperating Concern IDES6BISDATValid tonvarchar80
48CE4S001Sample operating concern5BISDATValid tonvarchar80
49CE4S001_ACCTSample operating con5BISDATValid tonvarchar80
50CE4S001_KENCSample operating con6BISDATValid tonvarchar80
51CE4S300Operating Concern IDES5BISDATValid tonvarchar80
52CE4S300_ACCTOperating Concern IDES5BISDATValid tonvarchar80
53CE4S300_KENCOperating Concern IDES6BISDATValid tonvarchar80
54CE4S_ALAirline Route Profit5BISDATValid tonvarchar80
55CE4S_AL_ACCTAirline Route Profit5BISDATValid tonvarchar80
56CE4S_AL_KENCAirline Route Profit6BISDATValid tonvarchar80
57CE4S_CPTemplate for Consumer Goods Industry5BISDATValid tonvarchar80
58CE4S_CP_ACCTTemplate for Consumer Goods Industry5BISDATValid tonvarchar80
59CE4S_CP_KENCTemplate for Consumer Goods Industry6BISDATValid tonvarchar80
60CE4S_GOQuickstart Template5BISDATValid tonvarchar80
61CE4S_GO_ACCTQuickstart Template5BISDATValid tonvarchar80
62CE4S_GO_KENCQuickstart Template6BISDATValid tonvarchar80
63CEST4Segment table (CO-PA)5BISDATValid tonvarchar80
64TKEVA03ACosting Key for Product7BISDATDatenvarchar80
65TKEVA03MCosting Key for Material Type7BISDATDatenvarchar80
TOPSales Plan
66SAUFSOP Orders13BISDATValid-to datenvarchar80
TOPSAP Healthcare - Industry-Specific Components for Hospitals
67NWCHPATRECIS-H CH: PATREC - erstellte Statistiksätze4BISDATIS-H: fine validità del recordnvarchar80
TOPUser and Authorization Management
68USR06Additional Data per User5BISDATSubstitute 'to date'nvarchar80
69USR06SYSSystem-Specific User Classification (License-Related)6BISDATSubstitute 'to date'nvarchar80