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  | OFFST

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T021Fields for Line Item and Document Line Layout10OFFSTDistance between Field and Previous Fieldnvarchar20
2T527AOrganizational Key Creation Rules6OFFSTField offset for creating the organizational keynvarchar20
3T585BField Group Definition5OFFSTOffset field in infotype structurenvarchar60
4TKSBSFields for Line Structure10OFFSTDistance between Field and Previous Fieldnvarchar20
5TOBJ_D_INDEX_ARCBatch History: Atchive Index - Batch History by Batch4OFFSTArchive file data object offsetint100
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
6CRM_CATJCATT - Log Index18OFFSTArchive file data object offsetint100
TOPAccount Determination
7T180SReporting: Display Variants: Fields13OFFSTDistance between Field and Previous Fieldnvarchar20
TOPBasic Functions
8ARCID_P_VBRKArchiving SD_VBRK: Index table (primary)4OFFSTArchive file data object offsetint100
9ARCID_VBRKArchiving SD_VBRK: Index Table4OFFSTArchive file data object offsetint100
TOPBatches
10CHVW_ARC_1Archive Index: Batch Where-Used Data by Order Number4OFFSTArchive file data object offsetint100
11CHVW_ARC_2Archive Index: Batch Where-Used Data by Purchasing Document4OFFSTArchive file data object offsetint100
12CHVW_ARC_3Archive Index: Batch Where-Used Data by Plant, Mat., Batches6OFFSTArchive file data object offsetint100
TOPBusiness Planning and Simulation
13UPC_NEVALPlanning Functions: New Values8OFFSTOffset of Variableint100
14UPC_OPTIOSPlanning: Conditions for Fields12OFFSTOffset of Variableint100
15UPX_KFS_LKFKey Figure Schemes for Planning Layouts: Layout Key Figures8OFFSTOffset of Variableint100
TOPClasses
16KSMLCharacteristics of a Class18OFFSTOffset in work areasmallint50
TOPContract Accounts Receivable and Payable
17ARCH_FKKKOFI-CA doc: Header-oriented doc index for archive7OFFSTinteger field for passing factory calendar date to FMint100
18ARCH_FKKOPFI-CA doc: Header-oriented doc index for archive7OFFSTinteger field for passing factory calendar date to FMint100
19TFK021Line layout variants: Fields10OFFSTDistance between field and previous fieldnvarchar20
20TFK047ICharges11OFFSTOffset With Percentage Chargedecimal132
21TFK063ACharge Categories for Installment Plan Surcharges12OFFSTOffset With Percentage Chargedecimal132
TOPCross-Application Components
22J_2GFIELDSCustomer/Vendor/Company - Field mappings7OFFSTOffset in fieldnvarchar20
TOPData Collection
23T242DData transfer control16OFFSTField offsetnvarchar40
TOPData Transfer
24KCDRMData Transfer Rules: Offsets and Lengths of Sender Fields6OFFSTField offsetnvarchar40
TOPEnvironment
25LKSMLCharacteristics of a Class18OFFSTOffset in work areasmallint50
TOPFinancial Accounting
26ARIX_BKPFFI_DOCUMNT: Header-Oriented Document Index for Archive12OFFSTArchive file data object offsetint100
27ARIX_BSADFI_DOCUMNT: Line-Oriented Index for Archiving Customer Accts7OFFSTArchive file data object offsetint100
28ARIX_BSAKFI_DOCUMNT: Line-Oriented Indx for Archiving Vendor Accounts7OFFSTArchive file data object offsetint100
29ARIX_BSASFI_DOCUMNT: Line-Oriented Index for Archiving G/L Accounts7OFFSTArchive file data object offsetint100
30ARIX_BSISFI_DOCUMNT: Line-Oriented Index for Archiving G/L Accounts7OFFSTArchive file data object offsetint100
TOPNetwork and Activity
31TCNTM03Assignment of date type/milestone to group8OFFSTRelative offset in daysnvarchar30
32TCNTMSCHDSuggestions for Scheduling Events5OFFSTRelative offset in daysnvarchar30
TOPProduct Safety
33CCGLC_SECCEHS: Sec. Value Determination for Report Symbols - Rules10OFFSTPosition of Stringint100
TOPTax Reporter
34T51T3Fields for tax information on magnetic media9OFFSTPosition of first character of a stringnvarchar30