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

59 columns | Print definition?ERP 6.0  | RTEXT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BGLOCS/FIDO_TAXAccounting Document Types7RTEXTFixed reporting text - Purchasesnvarchar300
2/BGLOCS/MMFI_TAXMapping between MM doc. types and FI doc. types VAT BG8RTEXTFixed reporting text - Purchasesnvarchar300
3T5C1ITexts for Pension Types5RTEXTText for pension typenvarchar300
4T5GPBSB_REASONTBar pointing: Text for reason for changes4RTEXTText on Reason for Change (Basic Pay Infotype)nvarchar300
5T5M1T!Not used: Field 27 Texts4RTEXTReason namenvarchar550
6T691TCredit management risk classes text5RTEXTName of the risk classnvarchar300
7T803BReport Writer: Key Figure Blocks (Descriptions)6RTEXTName of the key figure blocknvarchar600
TOPAdvertising Management
8/NAM/JHACCBUNDLECredit Card Processing - Bundling and Delta Processing18RTEXTPayment cards: Result textnvarchar400
TOPAppraisal Systems
9HRT1045Infotype 1045 Table Section11RTEXTRating text of an appraisal elementnvarchar400
TOPBank Accounting
10BSEGCDocument: Data on Payment Card Payments31RTEXTPayment cards: Result textnvarchar400
11TCCRCTPayment cards: Results of checks (texts)5RTEXTPayment cards: Result textnvarchar400
TOPBasic Functions
12TABBTNames of the rules for determining the asset value date4RTEXTName of rule for setting asset value datenvarchar900
TOPBudget Management
13T7PMVTText of Reason for Reducing Teaching Hours5RTEXTText of Reason for Reducing Teaching Hoursnvarchar400
TOPBusiness Package for Manager Self-Service HR
14TWPC_RC_RANK_T_CText Table for TWPC_RC_RANK4RTEXTApplicant Assignment Priority - Namenvarchar400
TOPClinical System
15N2DETIS-H*MED: Texts for documentation elements6RTEXTPrint Labelnvarchar800
16N2ETTIS-H*MED: Texts for document category assignments (N2ET)9RTEXTPrint Labelnvarchar800
TOPContract Accounts Receivable and Payable
17DPAYHPayment program - data for payment68RTEXTNumber of Text Lines for the Items Paiddecimal50
18TFK045ATReturns texts5RTEXTName of Returns Reasonnvarchar500
TOPControlling
19COK41C_IDIdentification Table for Posting Runs4RTEXTUser-Defined Text for Data Transfernvarchar300
TOPDocument Builder
20/IPRO/TTEMPTXTTemporary text storage8RTEXTimage21474836470
TOPFinancial Accounting
21/BGLOCS/FIDOCUTAccounting Document Types5RTEXTFixed reporting text - Purchasesnvarchar300
22/BGLOCS/MMFIMAPMapping between MM doc. types and FI doc. types VAT BG6RTEXTFixed reporting text - Purchasesnvarchar300
TOPGermany
23T5DL4Texts for Rules for Absence Events5RTEXTName of Rule for Absence Eventnvarchar400
TOPInformation System
24T800TReport Writer: Texts for Reports5RTEXTDescription for Report Writer objectsnvarchar350
TOPLease Accounting
25TFILA_GF_000RTChange Reason Texts5RTEXTReason for Changenvarchar500
TOPOrganizational Management
26T777VRelationship Texts4RTEXTRelationship Name (Bottom Up)nvarchar250
27T77RQText for Substitute Profile4RTEXTText for Substitute Profilenvarchar250
28T787VText Table: Relationships for Standard Objects3RTEXTRelationship Name (Bottom Up)nvarchar250
TOPPatient Accounting
29TN29TIS-H: Text table for TN29R5RTEXTIS-H: Rule textnvarchar800
TOPPayment Cards
30FPLTCPayment cards: Transaction data - SD36RTEXTPayment cards: Result textnvarchar400
TOPPayment Transactions
31REGUHSettlement data from payment program70RTEXTNumber of Text Lines for the Items Paiddecimal50
32REGUHHREGUH version before the 'n'th change29RTEXTNumber of Text Lines for the Items Paiddecimal50
33REGUHOREGUH version before the 'n'th change41RTEXTNumber of Text Lines for the Items Paiddecimal50
TOPPayroll
34T7UAF230TForm 23 rows texts6RTEXTRow textnvarchar1280
35T7UAF23PTForm 23 parts texts5RTEXTPart textnvarchar1280
TOPPension Administration
36T7PBSCA2BTResults Calculation Periods (Text)6RTEXTResult Textnvarchar800
37T7PBSCA2CTResults of Calculation Points Customer (Text)6RTEXTResult Textnvarchar800
38T7PBSCA2FTIndividual Texts Notice Creation - Texts9RTEXTResult Textnvarchar800
TOPPeriodical Sales and Distribution
39JFRKCCIS-M/SD: Billing - Payment Card Data36RTEXTPayment cards: Result textnvarchar400
40JKAPCCSales Order: Payment Card Data37RTEXTPayment cards: Result textnvarchar400
41TJKRRSTIS-M/SD: Reminder Procedure - Texts4RTEXTIS-M: Long Textnvarchar500
TOPPersonnel Administration
42T530FReasons for Changes5RTEXTText on Reason for Change (Basic Pay Infotype)nvarchar300
43T705UAdditional Texts for Record Types4RTEXTAdditional text for record typesnvarchar200
44T7PL2TCost Counting Rule Texts3RTEXTRule textnvarchar300
45T7PL3TFree amount rule texts3RTEXTRule textnvarchar300
TOPPersonnel Categories
46/ISDFPS/NATOROTTNATO Rotation (Defense)- Text5RTEXTText (30 Characters)nvarchar300
TOPPersonnel Time Management
47T508SText Table for Work Schedule Rules (T508A)7RTEXTText for Work Schedule Rule (Planned Working Time Infotype)nvarchar250
TOPPublic Sector
48T5RPBS10JTText table for Blacklist Reason5RTEXTDescription of blacklist reasonnvarchar300
TOPReport Tree
49SREPORTEXTTexts in Report Tree9RTEXTError message text - long text of the errornvarchar700
TOPReporting
50TMCSGLIS Standard Reports/Layouts for Evaluations: Texts4RTEXTDescription for Report Writer objectsnvarchar350
TOPSAP Business Workflow
51TOJRTObjects in the SAP System: return value texts4RTEXTObjects in SAP System: Description of return valuenvarchar400
TOPStructural Graphics
52T77LVTexts for Relationship Data4RTEXTField Labelnvarchar250
TOPStructures Workbench
53/ISDFPS/CFDPSC1TText Table Relationship Types4RTEXTRelationship Type Descriptionnvarchar400
TOPTraders and Schedulers Workbench
54TOIJ_STOP_MT_RTTdescription of stop meter calculation routine values3RTEXTdescriptive text for end meter calculation routinenvarchar400
55TOIJ_ST_GAUG_RTTdescription of stop meter calculation routine values3RTEXTdescriptive text for stop gauge calculation routinenvarchar400
TOPTraining and Event Management
56HRP1029Infotype 1029 DB table18RTEXTFlag for reading business event text from event itselfnvarchar10
TOPTransfer Postings
57J_1AAWAYBLWay Bills for asset movements21RTEXTError message text - long text of the errornvarchar700
TOPUSA
58T5UGASpecial Rule for Calculation of the Non-Exempt Amount3RTEXTDescription of special rulenvarchar400
TOPUser Administration
59WP3ROLEDEFTPortal Roles: Short and Long Texts5RTEXTPortal Role Textnvarchar1320