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

29 columns | Print definition?ERP 6.0  | XDEFAULT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBPM_BUT_FRG0031Business Partner: Quality Standards8XDEFAULTStandard Quality Management System (Obsolete)nvarchar10
2BBP_063OCodes in WEB Inventory Management4XDEFAULTDefault Movement Type Indicatornvarchar10
3BBP_TMP_BIDTemporary: Request 'Bidder/Vendor', Bidder Data11XDEFAULTStandard Quality Management System (Obsolete)nvarchar10
4BBP_TMP_BIDQMSTemporary: Request 'Bidder', Quality Management Systems5XDEFAULTStandard Quality Management System (Obsolete)nvarchar10
5BIDQMSBusiness Partner: Quality Management System5XDEFAULTStandard Quality Management System (Obsolete)nvarchar10
6T7PIQFEECTRLEFee Calculation Processing Mode3XDEFAULTDefault Processing Modenvarchar10
TOPAdvertising Management
7TJHAKPZIS-M: Sales Document Type Item Cat.Assignment (Admissible)5XDEFAULTDefault Usagenvarchar10
8TJHOLBMEIS-M/AM: Units of Measurement for Online Ads Size Fields4XDEFAULTDefault Usagenvarchar10
9TJHOLHMEIS-M: Units of Measurement for Online Advertisement Height3XDEFAULTDefault Usagenvarchar10
10TJJ57IS-M/AM: Frequency Rule10XDEFAULTIS-M: Default Value on Item Detail Screen Indicatornvarchar10
TOPClaims Management
11ICL_CWTHDRWSEQMaintenance: Withdrawal Sequence ID3XDEFAULTDefault Withdrawal Sequencenvarchar10
12TICL001Claim Bundle Type18XDEFAULTDefault Value for Each Category of Claim Bundle Typenvarchar10
13TICL002Subtypes of Claim Bundle Types4XDEFAULTDefault Valuenvarchar10
14TICL098Control of Function Codes for Context Menu and Pushbuttons10XDEFAULTFunction Code in Accordance with Standard Procedurenvarchar10
15TICL143Permitted Types of Claim Item Grouping Category8XDEFAULTDefault Valuenvarchar10
16TICL195Control of Copy Function Codes9XDEFAULTFunction Code in Accordance with Standard Procedurenvarchar10
TOPCollections Management
17UDMNEWCONTACTSSAP Collections Management: New Contact Person (Temporary)13XDEFAULTData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
18UDM_SGMT_GRPAssignment of Collection Group to Collection Segment4XDEFAULTDefault Groupnvarchar10
TOPCollectionsDisbursements
19ITAGCYPM_TYPEPayment Method Categories6XDEFAULTFlag: Standard Payment Methodnvarchar10
TOPContract Accounts Receivable and Payable
20TFKFSField Selector6XDEFAULTSingle-Character Indicatornvarchar10
TOPLoans Management
21TDPR_ATTRFIELDAttribute: Field Description7XDEFAULTAllow Default Valuenvarchar10
TOPMedia Product Sales and Distribution
22JKSDDEFAULTDATEIS-M: Default Dates in Quantity Planning6XDEFAULTIS-M: Indicator - No Proposalnvarchar10
TOPMedia Sales and Distribution
23/NAM/TJKDISPPRDispatching priority3XDEFAULTDefault Value for Dispatching Prioritynvarchar10
TOPPeriodical Sales and Distribution
24JVTRUNDEIS-M/SD: Round (Delivery Round)3XDEFAULTIS-M: Default value for ad pre-print ordernvarchar10
25JWSAPRIS-M/SD: Gift15XDEFAULTIS-M/SD: Indicator for default gift in campaign frameworknvarchar10
TOPTransaction Manager
26/TRMKR/TAB_NAMETab Name for the Tab in FWZZ3XDEFAULTTab Name selectionnvarchar10
27TEXC_EXP_TYPEExposure Position Type4XDEFAULTDefault Flagnvarchar10
TOPTreasury
28VWPT_TABNAMETab Page Name: Modifiable in Customizing3XDEFAULTName of the Tab Page in the Class Datanvarchar10
29VWPT_TAB_NAMETab Page Name: Modifiable in Customizing3XDEFAULTName of the Tab Page in the Class Datanvarchar10