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

69 columns | Print definition?ERP 6.0  | SHORT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1GRPC_UPG_HRP1000Upgrade Back Up Data17SHORTObject Abbreviationnvarchar120
2T5FDSNOPSIDList of OPS (Social Protection Agencies)6SHORTText for an OPS (Social Protection Agency)nvarchar200
3T5FDSNOPSTYDefinition of types of OPS (Social Protection Agencies)5SHORTText for a type of OPSnvarchar200
4T5W12Link reason for income diff to occupational level. - Equity10SHORTShortage of relevant skillsnvarchar10
5T7QAPBS35TRank of Academic Study4SHORTRank Textnvarchar200
6T7QAPBS36TRank of Academic Study5SHORTRank Textnvarchar200
7T7RUPARDESC1TParameters description of seniority6SHORTShort name of description parameternvarchar30
8ZRP1000Infotype 1000 DB Table17SHORTObject Abbreviationnvarchar120
9PIQDBOFFERTMPLTEvent Offering Templates (Text Table)4SHORTBusiness event abbreviationnvarchar120
10T7PIQ_NL_PREEDUCPrevious Education Details6SHORTPrevious Education Short Namenvarchar350
11T7PIQ_NL_SUBSubjects6SHORTSubjectnvarchar40
TOPBudget Management
12T7PMKNames of Budget Structure Elements8SHORTObject Abbreviationnvarchar120
TOPBusiness Rule Framework
13TBRF000TBRF: Application Class - Text3SHORTBRF: General Short Textnvarchar800
14TBRF100TBRF: Application Class - Text (Customer-Specific)5SHORTBRF: General Short Textnvarchar800
15TBRF110TBRF: Event - Text7SHORTBRF: General Short Textnvarchar800
16TBRF120TBRF: Technical Context5SHORTBRF: General Short Textnvarchar800
17TBRF150TBRF: Expression - Text7SHORTBRF: General Short Textnvarchar800
18TBRF170TBRF: Action - Text7SHORTBRF: General Short Textnvarchar800
19TBRF180TBRF: Implementing Class - Text7SHORTBRF: General Short Textnvarchar800
20TBRF190TBRF: Operators, Texts5SHORTBRF: General Short Textnvarchar800
21TBRF193TBRF: Operators, Texts4SHORTBRF: General Short Textnvarchar800
22TBRF230TBRF: Groups - Text Table5SHORTBRF: General Short Textnvarchar800
23TBRF280TBRF: Rule Set - Text Table7SHORTBRF: General Short Textnvarchar800
24TBRF330TBRF: Filter Values for Expression BAdI - Text Table3SHORTBRF: General Short Textnvarchar800
25TBRF331TBRF: Filter Values for Action BAdI - Text Table3SHORTBRF: General Short Textnvarchar800
26TBRF360TBRF: Standard Context - Text Table7SHORTBRF: General Short Textnvarchar800
27TBRF910BRF: Test Data Records - Header Data9SHORTBRF: General Short Textnvarchar800
TOPCapacity and Resource Planning
28/MRSS/C_RM_JT_TDescription for Job Texts5SHORTObject Abbreviationnvarchar120
TOPClaims Management
29IMP_WORKSETSIMP: Workset14SHORTIMP: Short Text - Generalnvarchar800
30TIAM000TActivity Management: Application Class3SHORTShort Text (General)nvarchar800
31TIAM110TActivity Management: Tasks - Texts5SHORTShort Text (General)nvarchar800
32TIAM130STActivity Management: Activity - Texts3SHORTShort Text (General)nvarchar800
33TIAM130TActivity Management: Activity - Texts5SHORTShort Text (General)nvarchar800
34TIAM140TActivity Management: Navigation Target - Texts5SHORTShort Text (General)nvarchar800
35TIAM150TActivity Management: Task Type - Texts5SHORTShort Text (General)nvarchar800
36TICLB_AC_NEUNew and Old Names for Actions5SHORTShort Decription of the Objectnvarchar800
37TICLB_EXCEL_T2New and Old Names and Short Descriptions for Rule Sets5SHORTShort Decription of the Objectnvarchar800
38TICLB_EX_NEUNew and Old Names for Expressions5SHORTShort Decription of the Objectnvarchar800
39TICLB_GR_NEWNew Group Names with Description4SHORTBRF: General Short Textnvarchar800
40TICLB_LOGLog of Renaming7SHORTShort Decription of the Objectnvarchar800
41TICLB_RS_NEUNew and Old Names for Rule Sets5SHORTShort Decription of the Objectnvarchar800
42TIMP000TIMP: Application Class3SHORTIMP: Short Text - Generalnvarchar800
43TIMP110TIMP: Trigger Categories5SHORTIMP: Short Text - Generalnvarchar800
TOPClassification System New
44CHARACTERTEXTDML Text Object16SHORTDescriptionnvarchar2550
45CHARACTERTEXTHDML Text Object16SHORTDescriptionnvarchar2550
46CME_ST_VAL_TXTDML Text Object16SHORTDescriptionnvarchar2550
47CME_ST_VAL_TXTHDML Text Object16SHORTDescriptionnvarchar2550
48DEFSCOPETEXTDML Text Object16SHORTDescriptionnvarchar2550
49DEFSCOPETEXTHDML Text Object16SHORTDescriptionnvarchar2550
50DTYPETEXTDML Text Object16SHORTDescriptionnvarchar2550
51DTYPETEXTHDML Text Object16SHORTDescriptionnvarchar2550
TOPContract Accounts Receivable and Payable
52DFKKCMBRFTRACEBRF Trace for Collections Management28SHORTBRF: General Short Textnvarchar800
TOPFunctional Locations
53IFLOUSRUser Profile for Labeling Functional Locations10SHORTShortened form allowednvarchar10
TOPMaintenance Orders
54/MRSS/D_RSBUFDATResource Buffering Data11SHORTObject Abbreviationnvarchar120
TOPMaster Data Framework
55DML_DELIVERY_TXTMDF Text Object13SHORTDescriptionnvarchar2550
56DML_ST_TEXTDML Text Object16SHORTDescriptionnvarchar2550
57DML_ST_TEXTHDML Text Object16SHORTDescriptionnvarchar2550
TOPNon Profit Organizations
58T7UNOM_P_TITLEPosition Title5SHORTObject Abbreviationnvarchar120
TOPOrganizational Management
59HRP1000Infotype 1000 DB Table17SHORTObject Abbreviationnvarchar120
60HRS1000Standard Infotype 1000 (SAP) Object Existence6SHORTObject Abbreviationnvarchar120
TOPPatient Management
61TN14BIS-H: Movement types26SHORTIS-H: Indicator for Admission Type "Short Treatment"nvarchar10
TOPPerformance Assessment Workbench
62SLS_LOOKVPAW - Lookup Values6SHORTPAW - Short Description of Lookup Valuenvarchar200
TOPPosition Budgeting and Control
63T77HRFPM_CIL_TDescription Legal Grounds4SHORTShort Name for Legal Groundsnvarchar100
TOPPublic Sector Contract Accounts Receivable and Payable
64DFMCA_BRFFEXGenerated Expressions for Form Fields10SHORTBRF: General Short Textnvarchar800
TOPQualifications and Requirements
65T77QBQualifications Catalog Texts5SHORTObject Abbreviationnvarchar120
TOPRole Generator
66/ISDFPS/AGR_TIMECycle Control Table for the Role Generator9SHORTObject Abbreviationnvarchar120
TOPRuntime
67SWFDEBUGF4HELPEmpty Table as Basis for Search Help (swfdebug)4SHORTTask Abbreviationnvarchar120
TOPTraining Management
68PA3225Personnel Record for Infotype 322530SHORTCourse Type Abbreviationnvarchar120
TOPUser Administration
69BBPORGF4F4 for User Assignment - Organizational Units for BBP5SHORTObject Abbreviationnvarchar120