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

34 columns | Print definition?ERP 6.0  | P_VERSION

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPConditions
1A600IDES_Global Agreement for Valuation, depend on the Catagory7P_VERSIONVersion Date as Timestampnvarchar140
2A610Valuation for Campaign6P_VERSIONVersion Date as Timestampnvarchar140
3A611Sun.Vine Commission Rates10P_VERSIONVersion Date as Timestampnvarchar140
4A612Sun.Vine - Contingency Rate7P_VERSIONVersion Date as Timestampnvarchar140
5A631Appl./Version/Status5P_VERSIONVersion Date as Timestampnvarchar140
6A802Appl./AgreemntNo/Version/Status6P_VERSIONVersion Date as Timestampnvarchar140
7A803Appl./AgreemntNo/Busi. Type/Segment/Version/Status8P_VERSIONVersion Date as Timestampnvarchar140
8A840Appl./AgreemntNo/Branch/Module/Version/Status8P_VERSIONVersion Date as Timestampnvarchar140
9A841Appl./AgreemntNo/Branch/AgreeCat/Version/Status8P_VERSIONVersion Date as Timestampnvarchar140
10A844Appl./AgreemntNo/Version/Status6P_VERSIONVersion Date as Timestampnvarchar140
11A845Rateplan Traffic Voice and Data Usage - YTEL057P_VERSIONVersion Date as Timestampnvarchar140
12A846Traffic Type Traffic Voice and Data Usage - YTEL057P_VERSIONVersion Date as Timestampnvarchar140
13A850Branch dependent valuation6P_VERSIONVersion Date as Timestampnvarchar140
14A851Branch and Agreement category dependent valuation7P_VERSIONVersion Date as Timestampnvarchar140
15A860Appl./Class/Version/Status6P_VERSIONVersion Date as Timestampnvarchar140
16A870Appl./AgreemntNo/Std.Con.No/Version/Status7P_VERSIONVersion Date as Timestampnvarchar140
17A871Monthly Incentive Target7P_VERSIONVersion Date as Timestampnvarchar140
18A872Monthly Transaction Target7P_VERSIONVersion Date as Timestampnvarchar140
19A873YTD Accelerator7P_VERSIONVersion Date as Timestampnvarchar140
20A880Appl./Rate Plan/Version/Status6P_VERSIONVersion Date as Timestampnvarchar140
21A881YTEL01 - Product Multiplier6P_VERSIONVersion Date as Timestampnvarchar140
22A882YTEL01 - Term Multiplier6P_VERSIONVersion Date as Timestampnvarchar140
23A883YTEL01 - Discount Multiplier6P_VERSIONVersion Date as Timestampnvarchar140
24A884YTEL01 - Listprice Multiplier6P_VERSIONVersion Date as Timestampnvarchar140
25A885YTEL01 - Margin Multiplier6P_VERSIONVersion Date as Timestampnvarchar140
26A896Complex Target7P_VERSIONVersion Date as Timestampnvarchar140
27A904Appl./AgreemntNo/Divis./Contr. no./RemBusTrCt/Version/Status9P_VERSIONVersion Date as Timestampnvarchar140
28A905Appl./AgreemntNo/Contr. no./RemBusTrCt/Version/Status8P_VERSIONVersion Date as Timestampnvarchar140
TOPIncentive and Commission Management ICM
29A194A1947P_VERSIONFecha de la versión como cronomarcadornvarchar140
30A195A1957P_VERSIONFecha de la versión como cronomarcadornvarchar140
31A196A1968P_VERSIONFecha de la versión como cronomarcadornvarchar140
32A197A1977P_VERSIONFecha de la versión como cronomarcadornvarchar140
33A198A1986P_VERSIONFecha de la versión como cronomarcadornvarchar140
TOPSAP Business Workflow
34SWF_WFPRECWF: Recovery information for Workflow Wizards2P_VERSIONVersionnvarchar40