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

110 columns | Print definition?ERP 6.0  | SHORT_TEXT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BA1/TF4_SCNSETTText Table for Scenario Sets4SHORT_TEXTDescription of Scenario Set (Short Text)nvarchar100
2/XLSO/ADVERTISEAdvertisements7SHORT_TEXTDescriptionnvarchar2250
3/XLSO/RECOM_LRNRRecommendation for Learner7SHORT_TEXTDescriptionnvarchar2250
4/XLSO/RECOM_PRODRecommendation for Product9SHORT_TEXTDescriptionnvarchar2250
5BBP_PCLOGProcurement Card Statement: Logistic data10SHORT_TEXTShort Textnvarchar400
6DBA_ALRT_METDBA: Alerting Metrics8SHORT_TEXTntext10737418230
7EPRODDET_SELIS-U: CRM Product Sel Table (for type def, dont populate)4SHORT_TEXTDescriptionnvarchar700
8IUUC_KB_AIM_GENTables processed by AIMs6SHORT_TEXTnvarchar500
9IUUC_KB_BUF_INVBuffer Tables and Invalidations3SHORT_TEXTCommentnvarchar800
10IUUC_KB_XPRA_GENXPRAs: General data5SHORT_TEXTnvarchar600
11J_3RJ_CNTRY_TCountry Conversion text4SHORT_TEXTShort Textnvarchar600
12J_3RJ_CURR_TCurrency conversion Text4SHORT_TEXTShort Textnvarchar300
13J_3RJ_UOM_TUnit of Measure Table4SHORT_TEXTShort Textnvarchar300
14OCS_CP_PAT03TLOGO PAT03 für Correction Packages2SHORT_TEXTSupport-Package-Beschreibungnvarchar600
15PAT03_PREOCS-Package Verzeichnis - Eingespielte Pre-Packages3SHORT_TEXTSupport-Package-Beschreibungnvarchar600
16REQHEADSTemporary Header Data: Requirement Coverage Request (Limit)28SHORT_TEXTShort Textnvarchar400
17REQLINEAdministrative Line Data: Requirement Coverage Request9SHORT_TEXTShort Textnvarchar400
18REQLINEMATemporary Line Data: Requirement Coverage Request(MRO Lines)10SHORT_TEXTShort Textnvarchar400
19REQLINESRTemporary Line Data: Requirement Coverage Request (Services)24SHORT_TEXTShort textnvarchar400
20T77ANAKPIMD_TKPI Metadata (Texts)6SHORT_TEXTKPI Short Textnvarchar200
21TREAC_ATTR_DESCDescription Of Free Position Account Attributes4SHORT_TEXTShort Descriptionnvarchar100
TOPAdvertising Management
22TJJPCCYTPackage Category: Texts4SHORT_TEXTIS-M: Short Textnvarchar150
TOPAMI Event Management
23EFDT_EXPR003FDT: Expression - Create Service Order12SHORT_TEXTShort Textnvarchar400
24EFDT_EXPR003AFDT: Expression - Create Service Order12SHORT_TEXTShort Textnvarchar400
25EFDT_EXPR003SFDT: Expression - Create Service Order11SHORT_TEXTShort Textnvarchar400
26EFDT_EXPR003TFDT: Expression - Create Service Order11SHORT_TEXTShort Textnvarchar400
TOPAuto-ID Infrastructure
27/AIN/TU_FLD_NAMTTag field name text descriptions5SHORT_TEXTShort descriptionnvarchar100
TOPBack Office
28TRFC_ATTR_DESCDescription Of Free Position Account Attributes4SHORT_TEXTShort Descriptionnvarchar100
29TRFT_ATTR_DESCDescription Of Free Position Account Attributes4SHORT_TEXTShort Descriptionnvarchar100
TOPBank Customer Accounts
30BKK_PRENOTEPrenotes20SHORT_TEXTShort Textnvarchar100
TOPBasis Components
31/XFT/INV_Q_6PO details (header) for an invoice receipt process12SHORT_TEXTShort Textnvarchar400
32/XFT/INV_Q_6_SPO details (header) for an invoice receipt process12SHORT_TEXTShort Textnvarchar400
TOPBRFplus - ABAP-Based Business Rules
33FDT_ADMN_0100FDT: Central Administrative Data - Texts (Version+Langu)6SHORT_TEXTFDT: Short Textnvarchar200
34FDT_ADMN_0100AFDT: Central Administrative Data - Texts (Version+Langu)6SHORT_TEXTFDT: Short Textnvarchar200
35FDT_ADMN_0100SFDT: Central Administrative Data - Texts (Version+Langu)5SHORT_TEXTFDT: Short Textnvarchar200
36FDT_ADMN_0100TFDT: Central Administrative Data - Texts (Version+Langu)5SHORT_TEXTFDT: Short Textnvarchar200
37FDT_ADMN_0101FDT: Transport Table for FDT_ADMN_0109 - Texts (Langu)5SHORT_TEXTFDT: Short Textnvarchar200
38FDT_ADMN_0101AFDT: Central Administrative Data - Texts (Langu)5SHORT_TEXTFDT: Short Textnvarchar200
39FDT_ADMN_0101SFDT: Transport Table for FDT_ADMN_0109S - Texts (Langu)4SHORT_TEXTFDT: Short Textnvarchar200
40FDT_ADMN_0101TFDT: Transport Table for FDT_ADMN_0109 - Texts (Langu)4SHORT_TEXTFDT: Short Textnvarchar200
41FDT_ADMN_0102FDT: Central Administrative Data - Texts (Version)5SHORT_TEXTFDT: Short Textnvarchar200
42FDT_ADMN_0102AFDT: Central Administrative Data - Texts (Version)5SHORT_TEXTFDT: Short Textnvarchar200
43FDT_ADMN_0102SFDT: Central Administrative Data - Texts (Version)4SHORT_TEXTFDT: Short Textnvarchar200
44FDT_ADMN_0102TFDT: Central Administrative Data - Texts (Version)4SHORT_TEXTFDT: Short Textnvarchar200
45FDT_ADMN_0103FDT: Transport Table for FDT_ADMN_0104 - Texts (ID only)4SHORT_TEXTFDT: Short Textnvarchar200
46FDT_ADMN_0103AFDT: Central Administrative Data - Texts (ID only)4SHORT_TEXTFDT: Short Textnvarchar200
47FDT_ADMN_0103SFDT: Transport Table for FDT_ADMN_0104S - Texts (ID only)3SHORT_TEXTFDT: Short Textnvarchar200
48FDT_ADMN_0103TFDT: Transport Table for FDT_ADMN_0104S - Texts (ID only)3SHORT_TEXTFDT: Short Textnvarchar200
49FDT_ADMN_0104FDT: Central Administrative Data - Texts (ID only)4SHORT_TEXTFDT: Short Textnvarchar200
50FDT_ADMN_0104AFDT: Transport Table for FDT_ADMN_0103 - Texts (ID only)4SHORT_TEXTFDT: Short Textnvarchar200
51FDT_ADMN_0104SFDT: Central Administrative Data - Texts (ID only)3SHORT_TEXTFDT: Short Textnvarchar200
52FDT_ADMN_0104TFDT: Central Administrative Data - Texts (ID only)3SHORT_TEXTFDT: Short Textnvarchar200
53FDT_ADMN_0109FDT: Central Administrative Data - Texts (Langu)5SHORT_TEXTFDT: Short Textnvarchar200
54FDT_ADMN_0109AFDT: Transport Table for FDT_ADMN_0101 - Texts (Langu)5SHORT_TEXTFDT: Short Textnvarchar200
55FDT_ADMN_0109SFDT: Central Administrative Data - Texts (Langu)4SHORT_TEXTFDT: Short Textnvarchar200
56FDT_ADMN_0109TFDT: Central Administrative Data - Texts (Langu)4SHORT_TEXTFDT: Short Textnvarchar200
TOPBusiness Partner
57RATCE_AGENCY_TXTDescription of Rating Agency4SHORT_TEXTDescription for Agencynvarchar600
58RATCE_OWNER_TXTDescription of Owner4SHORT_TEXTDescription for Ownernvarchar600
59RATCE_PROC_TXTDescription of Rating Procedure6SHORT_TEXTDescription for Rating Procedurenvarchar600
60RATCE_RATING_TXTTexts for Ratings6SHORT_TEXTDescription for Ratingnvarchar600
61RATCE_SET_TXTRating Sets5SHORT_TEXTDescription for Rating Setnvarchar600
TOPCentral Part of Product Master
62COMM_PRODUCT_IDXIndex Table for Products13SHORT_TEXTProduct Descriptionnvarchar400
63COMM_PRSHTEXTProduct Description4SHORT_TEXTProduct Descriptionnvarchar400
64COMM_PRSHTEXTHProduct Description (History)9SHORT_TEXTProduct Descriptionnvarchar400
65COMS_ALTID_VALTable for Alternative ID5SHORT_TEXTProduct Descriptionnvarchar400
66CRMC_TAX_TCODE_TDescription for Assignment of Tax Scale Code to a Country5SHORT_TEXTDescription of Tax Scale Codenvarchar600
TOPClaims Management
67TIAM130TActivity Management: Activity - Texts6SHORT_TEXTShort Text (General)nvarchar800
68TICL037TActivity Management: Activity Grouping Category - Text Table4SHORT_TEXTActivity Management: Name of Task Categorynvarchar800
TOPCondition
69TBKK92TPooling Method Text5SHORT_TEXTShort Text Interest Compensation Methodnvarchar100
TOPCustomer Bill of Services
70/SAPBOQ/HD_SESQTO header table3SHORT_TEXTService Entry Sheet - Header Textnvarchar400
TOPDealer Portal
71/SAPDII/SPP_MATEMaterials table4SHORT_TEXTCharacter field, length 64nvarchar640
TOPMaintenance Processing
72/MRSS/C_BAS_TATTexts for Time allocation types4SHORT_TEXTShort Text for Time allocation typesnvarchar100
73EAM_AUT_JOBSELIDIDs of Orders/Notifs. for unit test of job selection in EAMS5SHORT_TEXTChar 80nvarchar800
TOPMaster Data
74TBKK60TAccount Hierarchy: Hierarchy Type Texts5SHORT_TEXTAccount Hierarchy: Short Text for Heirarchy Typesnvarchar100
TOPNetWeaver Enterprise Search
75ESH_TST_LANGUAGEES Test Object Language5SHORT_TEXTES Test Objects - Short Textnvarchar800
76ESH_TST_MATTES Test Object Material - Text Data5SHORT_TEXTES Test Objects - Short Textnvarchar800
TOPOnline Correction Support Support Package and Add-On Tools
77OCSSPCOMPRIn kompatibler Komponentenversion enthaltene SPs3SHORT_TEXTSupport-Package-Beschreibungnvarchar600
78PAT03OCS Package Directory2SHORT_TEXTSupport Package descriptionnvarchar600
79PAT03_SDAPAT03 for standalone Disassembler2SHORT_TEXTSupport Package Descriptionnvarchar600
80PATHISTQHistory of SPAM/SAINT Queues10SHORT_TEXTSupport Package descriptionnvarchar600
TOPPackage Tools
81PCHKPROFTText Table for Profiles for Setting Params for Package Check3SHORT_TEXTShort Description of Repository Objectsnvarchar600
TOPPosition Budgeting and Control
82T77HRFPMFINEXC1TReason for Alternative Financing Requirement (Texts)4SHORT_TEXTReason for Alternative Financing Requirementnvarchar200
TOPProject System
83PSHLPDB_HIER_TMPTable to store temporary hierarchy data38SHORT_TEXTShort Textnvarchar10
84PSHLP_HIER_DBLocal cache:Project/Independent Network hierarchy32SHORT_TEXTShort Textnvarchar10
TOPService Data Download
85/BDL/BDLFUNCService Definition, Definition of Logical Functions4SHORT_TEXTText for documentationnvarchar800
86/BDL/COESDefinition of COE names for authority check2SHORT_TEXTText for documentationnvarchar800
87/BDL/IBUSDefinition of IBU names2SHORT_TEXTText for documentationnvarchar800
88/BDL/TASKSControl Table of Task Manager5SHORT_TEXTText, 40 Characters Longnvarchar400
89/BDL/TASK_LOGMessageLog of SDCC task manager8SHORT_TEXTText, 40 Characters Longnvarchar400
90/SDF/GRP_INFOGroup info2SHORT_TEXTnvarchar600
91/SDF/PAT03Patch Directory2SHORT_TEXTnvarchar600
92/SDF/SWCM_PAT03DOCS Package Directory for DEV2SHORT_TEXTSupport Package descriptionnvarchar600
93/SDF/SWCM_PAT03POCS Package Directory for PRD2SHORT_TEXTSupport Package descriptionnvarchar600
94/SDF/SWCM_PAT03QOCS Package Directory for QAS2SHORT_TEXTSupport Package descriptionnvarchar600
95BDLCOESDefinition of COE names for authority check2SHORT_TEXTText for documentationnvarchar800
96BDLFUNCDefinition of Logical Functions3SHORT_TEXTText for documentationnvarchar800
97BDLIBUSDefinition of IBU names2SHORT_TEXTText for documentationnvarchar800
TOPStructures Workbench
98/ISDFPS/CMATRCTTText for Record Types in Material Planning4SHORT_TEXTShort Text Record Typenvarchar60
TOPTransaction Manager
99TEMC_ATTRD_TTexts for Attribute Fields4SHORT_TEXTText (10 characters)nvarchar100
100TEXC_ATTRD_TDescription of free attributes4SHORT_TEXTText (10 characters)nvarchar100
TOPTransfer to Financial Accounting
101TRLTC_POSATT_D_Tposition attributes4SHORT_TEXTShort Field Labelnvarchar100
TOPTreasury
102VWPT_ATTR_DESCDescription of Free Security Attribute4SHORT_TEXTShort Namenvarchar100
TOPWeb Service and SOAP - ABAP
103SRT_UTIL_ERRLOGSRT Utilities: Error Log Data11SHORT_TEXTnvarchar1280
104SRT_UTIL_LOGSRT Utilities: Error Log Data9SHORT_TEXTnvarchar1280
TOPWithout Description
105KAP_PSR_TEXTSTexts for Language-Dependent User Guide3SHORT_TEXTShort text (language-dependent user guide)nvarchar200
TOPWorkforce Management Core
106/SAPAPO/LRPAINTTText Table for Appointment Interval Group Types5SHORT_TEXTShort Text for Appointment Interval Groupnvarchar100
107/SAPAPO/LRPOBJTTable for LRP Text Objects5SHORT_TEXTShort Field Labelnvarchar100
108/SAPAPO/LRPTSTYPObsolete: Classification of Time Specifications4SHORT_TEXTShort Field Labelnvarchar100
109/SAPAPO/LRPTTYPTTexts for Time Allocation Type4SHORT_TEXTShort Text for Time Allocation Typenvarchar100
110WFDC_STRG_TScheduling Strategy Text6SHORT_TEXTShort Field Labelnvarchar100