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

37 columns | Print definition?ERP 6.0  | SERIES

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1EDOPEINVeDocument Peru Invoice4SERIESeDocument Peru: Seriesnvarchar40
2EDOPENGRASSIGNeDocument Peru: Assign Number Group to CompCode and Series3SERIESeDocument Peru: Seriesnvarchar40
3EDOPENUMBERAssign Series and Number Range to Document Type5SERIESeDocument Peru: Seriesnvarchar40
4EDOPESERIESeDocument Peru: Series2SERIESeDocument Peru: Seriesnvarchar40
5EDOPESERIESTeDocument Peru: Series Description3SERIESeDocument Peru: Seriesnvarchar40
6ISM_PT_JFRKPortugal: Digital Signature for Billing Document6SERIESSignature Portugal: Seriesnvarchar40
7ISM_PT_JHTFKPortugal: Digital Signature for M/AM Billing Document6SERIESSignature Portugal: Seriesnvarchar40
8ISM_PT_NUMBR_AMSignature PT: Relevancy of M/AM Billing Number range4SERIESSignature Portugal: Seriesnvarchar40
9ISM_PT_NUMBR_SDSignature PT: Relevancy of Billing Number range4SERIESSignature Portugal: Seriesnvarchar40
10SIPT_LIKPPortugal: Digital Signature for Delivery Document7SERIESSignature Portugal: Seriesnvarchar40
11SIPT_NUMBR_OBDSignature PT: Relevancy of Delivery Number range6SERIESSignature Portugal: Seriesnvarchar40
12SIPT_NUMBR_OIGSiganture PT : Customizing Table for Signature in IS-OIL6SERIESSignature Portugal: Seriesnvarchar40
TOPBusiness Server Pages
13BSBOOKBookshop - Table of Books5SERIESSeriesnvarchar400
TOPCollaborative Cross Applications
14/POA/D_CLM_PG01Main Details of Package5SERIESPackage Seriesnvarchar600
TOPContract Accounts Receivable and Payable
15DFKK_PT_ODNGAPSequential Fractures of Official Document Numbers11SERIESSeries ID of a SAF-T Invoice Numbernvarchar120
TOPCross-Application Components
16J_2GLPDOCSFIFI legal documents15SERIESSeriesnvarchar60
17J_2GLPDSDDigital Sign Device (DSD) parameters5SERIESValid seriesnvarchar1320
18J_2GLPLEGDOCLegal printed documents17SERIESSeriesnvarchar60
19J_2GLPP3Print Task codes Series and numbers8SERIESSeriesnvarchar60
TOPFinancial Accounting
20/OPT/VIM_1HEADDocument Header207SERIESSeriesnvarchar30
21OFF_NUM_LV2Assign Number Ranges to Document Class, Number Group, Date7SERIESSeriesnvarchar160
TOPLocalization
22J_1BAQForm4SERIESSeriesnvarchar30
23J_1BB2Nota Fiscal print configuration9SERIESSeriesnvarchar30
24J_1BB2DYNAMICNota Fiscal Print Configuration dependent on dynamic key11SERIESSeriesnvarchar30
25J_1BFIFOINIncoming FIFO relevant Consignment movements (BRAZIL)11SERIESSeriesnvarchar30
26J_1BNFDOCNota Fiscal Header16SERIESSeriesnvarchar30
27J_1BNFENUMGAPNF-e Numbering Gaps7SERIESSeriesnvarchar30
28SIPT_BKPFPortugal: Digital Signature for Accounting Documents8SERIESSignature Portugal: Seriesnvarchar40
29SIPT_NUMBR_FISignature PT: Relevancy of FI Number range7SERIESSignature Portugal: Seriesnvarchar40
30SIPT_NUMBR_MMSignature PT: Relevancy of Self Billing Number range6SERIESSignature Portugal: Seriesnvarchar40
31SIPT_NUMBR_SDSignature PT: Relevancy of Billing Number range4SERIESSignature Portugal: Seriesnvarchar40
32SIPT_RBKPPortugal: Digital Signature for Self Billing Document10SERIESSignature Portugal: Seriesnvarchar40
33SIPT_VBRKPortugal: Digital Signature for Billing Document6SERIESSignature Portugal: Seriesnvarchar40
34TIVXCPTCERTInvoice certification5SERIESSignature Portugal: Seriesnvarchar40
35VIXCPTSIPTDigital Signature for Invoices9SERIESSignature Portugal: Seriesnvarchar40
TOPManagement Cockpit
36UMM_DFT_CHARTDefault BW Data for Cockpit Frame9SERIESValue Identifier (Series, Category and Axis)nvarchar1200
TOPUser Interface
37/PLMPCV/D_CHARTChart Output Appearance for Query Views6SERIESSeries of Chart Output (y Axis)nvarchar300