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

73 columns | Print definition?ERP 6.0  | FTEXT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/X061VIM-System Log FunctionTexts4FTEXTDescriptionnvarchar800
2/OPT/X164Name of Items in Field Selection Definitions5FTEXTGroup Namenvarchar300
3/OPT/Y061VIM-System Log FunctionTexts4FTEXTDescriptionnvarchar800
4/OPT/Y164Name of Items in Field Selection Definitions5FTEXTGroup Namenvarchar300
5/OPT/Z061VIM-System Log FunctionTexts4FTEXTDescriptionnvarchar800
6/OPT/Z164Name of Items in Field Selection Definitions5FTEXTGroup Namenvarchar300
7/ORS/TMODPName of Items in Field Selection Definitions5FTEXTGroup Namenvarchar300
8DICS_T157BDescr. of Qty Fields (Plant Stock Avail., Stock Display)4FTEXTText (length 17)nvarchar170
9DVK00unused dummy structure xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx20FTEXTError textnvarchar730
10GRACCHANGELOGData Change Log table7FTEXTExplanatory short textnvarchar600
11P2RG_CARCO2Payroll Results: GB Company Cars (CO2 based calculation)13FTEXTText (length 32)nvarchar320
12T157BDescr. of Qty Fields (Plant Stock Avail., Stock Display)4FTEXTText (length 17)nvarchar170
13T5A3TFamily Allowance Texts4FTEXTText (20 Characters)nvarchar200
14T5D6DFields for Special Cases for Garnishment4FTEXTField Labelnvarchar100
15T5W2F(Old) RSA Tax Procedures3FTEXTTax Procedure Textnvarchar400
16T7NOEDG_AIF_FTEDAG - Additional information and fields version - text5FTEXTEDAG - Description for the field versionnvarchar800
17TBLP_MODGName of Groups in Field Selection Bar4FTEXTGroup Namenvarchar300
18TBLP_MODPName of Items in Field Selection Definitions4FTEXTGroup Namenvarchar300
19TKB7BText Table for Field Name Pseudonyms4FTEXTText (30 Characters)nvarchar300
20TMODGName of Groups in Field Selection Bar4FTEXTGroup Namenvarchar300
21TMODPName of Items in Field Selection Definitions4FTEXTGroup Namenvarchar300
TOPAustralia
22T5QSDSuperannuation Fund Designation Australia4FTEXTSuperannuation Fund Designationnvarchar300
TOPAustria
23T5A2FTax Offices (A)3FTEXTTax Office Textnvarchar570
24T5A6DFields for Special Cases for Garnishment4FTEXTField Labelnvarchar100
TOPBills of Material
25T418GFormula Texts4FTEXTFormula textnvarchar400
TOPBudget Management
26T7PMJTexts for Time Reference4FTEXTName of Time Basenvarchar250
TOPBusiness Planning and Simulation
27UPC_DISPATCHERTDispatcher in SEM-BPS - Text Table for Fcodes3FTEXTMenu Painter: Function or menu text (4.0)nvarchar400
TOPDevice Management
28EFKLASTIS-U Device Checker: Definition of Error Classes (Texts)3FTEXTError Descriptionnvarchar1320
TOPEmployee Self-Service
29T77WWW_WHO_SRDESS Who's Who: Field Selection per Country Grpg & Appl.Type10FTEXTSAP Query (S): Long text for a fieldnvarchar600
TOPEmpties Management
30/BEV1/EMMATRIXTDescription for Formulas4FTEXTDescription for Form Fieldsnvarchar300
TOPExchanges
31TOIAHTFee Account Assignment Descriptions5FTEXTFee account assignment descriptionnvarchar200
TOPFinancial Accounting
32/OPT/VIM_SLOGTXTVIM-System Log FunctionTexts4FTEXTDescriptionnvarchar800
TOPForms
33T514STable Name Texts5FTEXTDescriptionnvarchar250
34T514TField Name Texts6FTEXTDescriptionnvarchar250
35T514UConversion Texts5FTEXTDescriptionnvarchar250
TOPFrance
36T5FDA2TText for DADS-U codes5FTEXTText (100 characters)nvarchar1000
TOPGermany
37T5D2ATax Offices (D)2FTEXTTax officenvarchar570
38T5DP1PAISY Interface11FTEXTPAISY: Field Labelnvarchar300
TOPGRC Access Control Plug-In
39/VIRSA/ZFFCDHDRFirefightId Change Document12FTEXTExplanatory short textnvarchar600
TOPHong Kong
40T7HK2GNature of contribution/entitlement plan3FTEXTText for nature of contribution/entitlement plannvarchar300
TOPHR Administrative Services
41T5ASRFOLDERFolder for User Favorites4FTEXTText (20 Characters)nvarchar200
TOPJapan
42T7JP_UPDFLDFields Monitor for Update Log4FTEXTField Textnvarchar600
TOPMaster Data
43T449SUser Settings: Sort for Table9FTEXTLong Field Labelnvarchar400
44T449TUser-Setting For Field Sequence To Display A Table8FTEXTLong Field Labelnvarchar400
TOPMaterial Master
45MGVFIELDGROUPTDescription of the field group in MGVFIELDGROUP4FTEXTShort text field group material versionsnvarchar400
TOPNon Profit Organizations
46T7UNPAD_T502_TMarital Status Designators Relation to Rental Subsidy MarSta4FTEXTMarital Statusnvarchar60
TOPNorway
47PA0419HR Master record: Manual tax reporting information - Norway41FTEXTFree text for annual tax statements (record type 6)nvarchar500
TOPOrganization and Planning
48T77MWBFCTTexts for Manager's Desktop Function Codes3FTEXTText length 25nvarchar250
49T77MWBFTCCustomer-Specific Text for Manager's Desktop Function Codes3FTEXTText length 25nvarchar250
TOPOrganizational Management
50T77FDPD Function Code Texts4FTEXTFunction Code Textnvarchar250
TOPOther Functions
51WAPPTAppointments12FTEXTAppointments: Short textnvarchar300
TOPPatient Accounting
52TN16FTIS-H: Contract Scheme Items - Field List - Texts3FTEXTIS-H: Text for Field Name for Contract Scheme Itemnvarchar500
53TNT3TIS-H: Texts for Rule Types5FTEXTText for Function or Menunvarchar400
TOPPayroll General Parts
54T514VForm Name Texts5FTEXTDescriptionnvarchar500
TOPPension fund General Parts
55T72T4THR-PF: TS Master Data Field Descriptions11FTEXTField Descriptionnvarchar600
TOPPersonnel Administration
56T502TMarital Status Designators4FTEXTMarital Statusnvarchar60
57T517XBranches of Study4FTEXTText for branch of studynvarchar400
58T51C2Car factory text table4FTEXTText (length 32)nvarchar320
59T705VFunction Code Texts4FTEXTTime event type textnvarchar200
60T7SIETSchool type4FTEXTSchool textnvarchar400
TOPPortugal
61T5PFTHR-PT: (Entities) Valid Properties Texts3FTEXTField textnvarchar320
TOPPublic Sector
62T5D86TPublic Sector Functions (Texts)5FTEXTFunction Text for Public Sectornvarchar300
TOPR2-R3 Link
63LDK00Status Record for WM Communication Records12FTEXTError textnvarchar730
TOPSouth Africa
64T5W2A(Old) Tax Revenue Offices (South Africa)4FTEXTReceiver of Revenue Tax Office Textnvarchar500
65T5W2E(Old) Tax Regions (South Africa)3FTEXTTax Region Text RSAnvarchar400
66T5W2PSouth African Revenue Service Offices3FTEXTReceiver of Revenue Tax Office Textnvarchar500
TOPSwitzerland
67PA0980HR Master Record Infotype 098033FTEXTAlternative Free Text Description of Institute and Trainingnvarchar1000
TOPUSA
68T5UGDFiling Status4FTEXTDescription of filing statusnvarchar300
TOPUser and Authorization Management
69TADMTTexts for table TADMI3FTEXTTexts in user master/authorizationsnvarchar600
70USARC_CDREDReloaded Archived Change Documents for User Data13FTEXTExplanatory short textnvarchar600
TOPWarehouse Management
71T311ACross-Reference WM Group for Documents8FTEXTError Text for LVS Multiple Processingnvarchar720
TOPWork Center
72TC25Work center formulas3FTEXTFormulanvarchar700
TOPWorkbench Utilities
73RLB_DB_VSTReuse Library: Found Location for TR Documents3FTEXTText Linenvarchar1000