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

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T021BLine Item Total Variants4FELD2Field namenvarchar300
2T161IDetermination of Release Strategy3FELD2Material Groupnvarchar90
3TKSBBTotals Versions4FELD2Name of fieldnvarchar160
4TRTESTest table for testing SE132FELD2Testtinyint30
5TZUNRules for 'Allocation' Field Layout15FELD2Field Name from Tables BKPF, BSEG, BSEC, BSEDnvarchar300
6VTEST102FELD2nvarchar40
TOPAccount Determination
7T180BReporting: Totals Variants4FELD2Name of fieldnvarchar160
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
8CD0BAS6VIDD Veri: Table without data elements2FELD2nvarchar10
9CD0BAS7VITabelle wird in View und dann wieder in Struktur includier2FELD2Dummyfunktion in der Laenge 1nvarchar10
10CD0FRK1TABABAP/4 Dict. Veri: Table with many foreign keys2FELD2ABAP/4 Dict. veri: default data element NUMC4nvarchar40
11CD2APP0Table to which client appends APP1 to 9 are appended2FELD2ABAP/4 Dict. Veri: default data element CHAR 1nvarchar10
12CD2HV1PTABCheck table for testing a help view3FELD2Dummy function in length 1nvarchar10
13CD2HV2FTABForeign key table as base table for a help view2FELD2Dummy function in length 1nvarchar10
TOPArchiveLink
14OABUS0817Table for ArchiveLink Test Object Types4FELD2Field 1nvarchar200
15OABUS817AAttribute Table of BUS081713FELD2Field 1nvarchar200
TOPAustria
16PA0135HR Master Record: Infotype 0135 (Spec. Garn. Cond. A)48FELD2Field for Special Casedecimal72
17T5A6CSpecial Garnishment Cases5FELD2Using a field for a special case (infotype 0135)nvarchar10
TOPCapacity Leveling
18TCY46Graphical object type selection: Decision steps11FELD2Field according to which groupings are madenvarchar300
19TCY47Object display selection12FELD2Field according to which groupings are madenvarchar300
20TCY61Line representation selection in table section11FELD2Field according to which groupings are madenvarchar300
21TCY63Axis representation selection11FELD2Field according to which groupings are madenvarchar300
22TCY65Curve representation selection11FELD2Field according to which groupings are madenvarchar300
TOPConstruction Equipment Management
23J_3GMCIDMatchcode ID Choice for Selecting PSP Elem. for Proj. Def.4FELD2Field Namenvarchar300
TOPContract Accounts Receivable and Payable
24TFK021SVSort Variants5FELD2Field Namenvarchar300
TOPDefense Forces and Public Security
25/ISDFPS/ZDMTESTTest Table (Described in Customizing Tables)3FELD230 Charactersnvarchar300
TOPEmpties Management
26/BEV1/EM0LGMTXCustomizing - Empties Calculation5FELD2Field Namenvarchar210
27/BEV1/EMMATRIXEmpties: Calculation Matrix5FELD2Empties Fieldnvarchar30
TOPFinancial Accounting
28T021MSort Variants6FELD2Field Namenvarchar300
TOPGermany
29PA0114HR Master Record: Infotype 0114 (Garnishment Amount D)50FELD2Field for Special Casedecimal72
30PA0904HR Master Record Infotype 090450FELD2Field for Special Casedecimal72
31T5D6CSpecial Garnishment Cases7FELD2Using a field for a special case (infotype 0114)nvarchar10
TOPLoans Management
32TDREPAY_GSTEERGeneral Control Data for Payoff and Notice8FELD2Field Ready for Inputnvarchar10
TOPMaster Data
33T457CTransaction calls control8FELD2Field namenvarchar100
TOPPatient Management
34NTPLNV2000IS-H: Template Subscreen Data5FELD2Text Fieldnvarchar500
TOPPerformance Monitors TCC
35AMRHApplication Monitor: Hierarchy acc. to TCODE/REPORT3FELD2Char 20nvarchar200
TOPStaffing
36T777NName Format7FELD2Transfer parameter field namenvarchar300
TOPWorkbench Tools Editors, Painters, Modelers
37EUF4VALUESRepository Infosystem: Last F4 Help value selected6FELD2Character Field Length = 10nvarchar100