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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

27 columns | Print definition?ERP 6.0  | ETEXT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/XLSO/T77STSystem Tables5ETEXTText Fieldnvarchar540
2T5T77STSystem Tables5ETEXTText Fieldnvarchar500
TOPBasic Data
3TNC301EEIS-H: EDI Error Messages (External)5ETEXTIS-H: Text of EDI Error Message (External)nvarchar2540
TOPBills of Material
4T413TSpare part indicator description4ETEXTSpare part indicator textnvarchar300
TOPClinical System
5N1EMPFTYPIS-H*MED: Recipient type4ETEXTRecipient Type - Externalnvarchar10
6N1EMPFTYP2IS-H*MED: Recipient Types for Default in the Doc. Dispatch4ETEXTRecipient Type - Externalnvarchar10
TOPCollectionsDisbursements
7TVS030BTIS-IS Scheduling: Posting Event Definition for Payment Plan3ETEXTEvent Textnvarchar600
8TVS030DTIS-IS Scheduling: Change Event Def. for Scheduling Item3ETEXTEvent Textnvarchar600
TOPHR Administrative Services
9T5ASROBJGROUPTTexts for Object Grouping for Processes4ETEXTText (20 Characters)nvarchar200
TOPJoint Venture und Production Sharing Accounting
10T8JETInvestment Type Description5ETEXTInvestment Type Descriptionnvarchar350
TOPLease Accounting
11TFILA_GF_000PTProcess Texts5ETEXTProcess Namenvarchar500
12TFILA_GF_001EProcesses for Changing Value ID Contents5ETEXTProcess Namenvarchar500
TOPOrganizational Management
13T77STSystem Tables5ETEXTText Fieldnvarchar500
TOPPayroll
14T5TPS77S0TSystem Tables5ETEXTText Fieldnvarchar500
15T7ROG7EE register - Contract History26ETEXTnvarchar1000
TOPPension Fund Switzerland
16PA3230Personnel Master Record for Infotype 323045ETEXTPayee Textnvarchar400
TOPPersonnel Administration
17T521BPayee Keys15ETEXTPayee designationnvarchar250
18T538TUnits of Time/Measurement Texts4ETEXTTime/Measurement Unit Textnvarchar200
19T7PLATEvidence codes for RP-6 form texts4ETEXTText Fieldnvarchar500
TOPPersonnel Time Management
20T555FTime Evaluation Error Texts6ETEXTMessage Long Textnvarchar350
TOPPublic Sector
21T5D90TEvents at Start of Calc. Period for Leave/Sick Pay Premium4ETEXTEvent at Start of New Calc. Period for Leave/Sick Pay Prem.nvarchar300
TOPRussia
22T7RU1BPayee Keys of receiving orders (Russia standard)19ETEXTPurpose of Bank Transfersnvarchar400
TOPTraining and Event Management
23HRPAD34Additional Data for Relationship 'has attended'6ETEXTName of the business eventnvarchar400
TOPTraining Management
24LSO_CUSTOMIZET_CTexts for Customizing Table in Learning Solution5ETEXTText Fieldnvarchar500
25LWMLSO_CUSTTXT_CTexts for Customizing Table in Mobile Learning Solution5ETEXTText Fieldnvarchar500
TOPUSA
26T5UA0TInterface Default Values Text Table5ETEXTText Fieldnvarchar500
27T5UGLFunction Exit for Garnishment Letters3ETEXTDescription of Exit Namenvarchar400