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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

35 columns | Print definition?ERP 6.0  | FELD1

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T021BLine Item Total Variants3FELD1Field namenvarchar300
2T161IDetermination of Release Strategy2FELD1Account Assignment Categorynvarchar10
3TFKY3Serves as check table (for issuer help-view structure)1FELD1Partner ID issuernvarchar100
4TFKY4Serves as check table for depos. bank help-view structure1FELD1Partner ID depositary banknvarchar100
5TKSBBTotals Versions3FELD1Name of fieldnvarchar160
6TRTESTest table for testing SE131FELD1Testnvarchar300
7TZUNRules for 'Allocation' Field Layout14FELD1Field Name from Tables BKPF, BSEG, BSEC, BSEDnvarchar300
8VTEST101FELD1nvarchar10
TOPAccount Determination
9T180BReporting: Totals Variants3FELD1Name of fieldnvarchar160
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
10CD0BAS6VIDD Veri: Table without data elements1FELD1nvarchar30
11CD0BAS7VITabelle wird in View und dann wieder in Struktur includier1FELD1Dummyfunktion in der Laenge 1nvarchar10
12CD0FRK1TABABAP/4 Dict. Veri: Table with many foreign keys1FELD1ABAP/4 Dict. Veri: default data element CHAR 1nvarchar10
13CD0VB1PFRKValue table for domain CD0DO1CFRK1FELD1Data element for check table CD0DO1CFRKnvarchar40
14CD2APP0Table to which client appends APP1 to 9 are appended1FELD1ABAP/4 Dict. Veri: default data element CHAR 1nvarchar10
15CD2HV1PTABCheck table for testing a help view2FELD1Dummy function in length 1nvarchar10
16CD2HV2FTABForeign key table as base table for a help view1FELD1Dummy function in length 1nvarchar10
TOPArchiveLink
17OABUS0817Table for ArchiveLink Test Object Types3FELD110 Characters (BUS0817)nvarchar100
18OABUS817AAttribute Table of BUS081712FELD110 Characters (BUS0817)nvarchar100
TOPAustria
19PA0135HR Master Record: Infotype 0135 (Spec. Garn. Cond. A)47FELD1Field for Special Casedecimal72
20T5A6CSpecial Garnishment Cases4FELD1Using a field for a special case (infotype 0135)nvarchar10
TOPConstruction Equipment Management
21J_3GMCIDMatchcode ID Choice for Selecting PSP Elem. for Proj. Def.3FELD1Field Namenvarchar300
TOPContract Accounts Receivable and Payable
22TFK021SVSort Variants4FELD1Field Namenvarchar300
TOPDefense Forces and Public Security
23/ISDFPS/ZDMTESTTest Table (Described in Customizing Tables)2FELD1Character Field of Length 12nvarchar120
TOPEmpties Management
24/BEV1/EM0LGMTXCustomizing - Empties Calculation3FELD1Field Namenvarchar210
25/BEV1/EMMATRIXEmpties: Calculation Matrix3FELD1Empties Fieldnvarchar30
TOPFinancial Accounting
26T021MSort Variants5FELD1Field Namenvarchar300
TOPGermany
27PA0114HR Master Record: Infotype 0114 (Garnishment Amount D)49FELD1Field for Special Casedecimal72
28PA0904HR Master Record Infotype 090449FELD1Field for Special Casedecimal72
29T5D6CSpecial Garnishment Cases6FELD1Using a field for a special case (infotype 0114)nvarchar10
TOPLoans Management
30TDREPAY_GSTEERGeneral Control Data for Payoff and Notice7FELD1Field Ready for Inputnvarchar10
TOPMaster Data
31T457CTransaction calls control7FELD1Field namenvarchar100
TOPPatient Management
32NTPLNV2000IS-H: Template Subscreen Data4FELD1Text (12 characters)nvarchar120
TOPPerformance Monitors TCC
33AMRHApplication Monitor: Hierarchy acc. to TCODE/REPORT2FELD1Char 20nvarchar200
TOPStaffing
34T777NName Format6FELD1Transfer parameter field namenvarchar300
TOPWorkbench Tools Editors, Painters, Modelers
35EUF4VALUESRepository Infosystem: Last F4 Help value selected5FELD1Character Field Length = 10nvarchar100