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

46 columns | Print definition?ERP 6.0  | MTEXT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DMC_IU_T000MWB: Backup Copy of Table T0002MTEXTClient namenvarchar250
2DRP_SMTC_TYPETDEV Reporting (SE28): Metric List (Text)4MTEXTDEV Reporting (SE28): Unit of Metricnvarchar100
3OA2_SD_CLTOAuth2 Client Texts4MTEXTOAuth 2.0 Client Descriptionnvarchar400
4P2RG_CARCO2Payroll Results: GB Company Cars (CO2 based calculation)14MTEXTText, 40 Characters Longnvarchar400
5T059TTexts for Minority Indicators4MTEXTTextnvarchar300
6T7RU_STAT_VFLD_TNames of View Variant Fields10MTEXTMedium Field Labelnvarchar200
7ZLANGIEClients in IDES3MTEXTClient namenvarchar250
8ZSK_T000t0003MTEXTBezeichnung des Mandantennvarchar250
TOPAssortment Maintenance
9TMETTDescription for unit of measure categories4MTEXTDescriptionnvarchar200
TOPBasic Data
10TN16TIS-H: Type of Insurance Coverage - Text Table5MTEXTIS-H: Text for Type of Coveragenvarchar200
TOPBasic Settings
11T8APP_HRKFTTTexts for values of field HRFKT in profit center planning6MTEXTMedium Field Labelnvarchar200
TOPClient Copy
12CCC_CHECKClient dummy6MTEXTClient namenvarchar250
13T000Clients2MTEXTClient namenvarchar250
TOPCollectionsDisbursements
14TKKVAKTIVActivities and/or Notes for the Clerk4MTEXTMail Textnvarchar800
15VVKKDRKODunning Printout:Header Items15MTEXTName of Dunning Levelnvarchar500
TOPContract Accounts Receivable and Payable
16TFK047ATDunning procedure texts4MTEXTDunning procedure textnvarchar500
17TFK047BTDunning level texts5MTEXTName of Dunning Levelnvarchar500
18TFK047FTDunning grouping texts4MTEXTName of Dunning Groupingnvarchar500
19TFKBA_GRIDTDescription of Balances Grid5MTEXTMedium Field Labelnvarchar200
TOPCost Object
20TKKAFText Table for Results Analysis Methods3MTEXTDesignation of Results Analysis Methodnvarchar800
TOPFinland
21T7FIAWT_TMMain groups for annual working time report4MTEXTMain group texts for annual working time reportnvarchar800
TOPFunds Management
22TBUDVGTIS-PS Budget Types: Texts4MTEXTText (20 Characters)nvarchar200
TOPInformation System
23TCNETTexts: Object Table for Reporting Structures in PS System4MTEXTText (20 Characters)nvarchar200
TOPLease Accounting
24TFILA_GF_000MTMethod Texts3MTEXTMethod Descriptionnvarchar740
TOPOrganizational Management
25T77MTCross-Module Texts4MTEXTModule Pool-Independent Textnvarchar500
TOPPayroll
26T5H1ZTK32 urlap: magánpénztári tagság értékeinek szövegei3MTEXTmagánnyugdíjpénztári tag-e: szövegeknvarchar400
27T7UA_STAT_VFLD_TNames of View Variant Fields10MTEXTMedium Field Labelnvarchar200
TOPPension fund General Parts
28T5CA7PC Method Type Names6MTEXTHR-CH: PC method type namenvarchar150
TOPPersonnel Administration
29T513FAppraisal Criteria Texts4MTEXTText for Appraisal Criterionnvarchar250
30T51C4Car model text table5MTEXTText, 40 Characters Longnvarchar400
31T7CO26Employee grouping for calculation types3MTEXTEmployee type descriptionnvarchar400
TOPProcess Management
32CMX_XSR_DB_FOLDStandard Execution Step Repository: Folder8MTEXTXSteps: Text of Medium Lengthnvarchar2550
33CMX_XSR_DB_FOLDTStandard Execution Step Repository: Texts for Folder5MTEXTXSteps: Text of Medium Lengthnvarchar2550
34CMX_XSR_DB_ITEMStandard Execution Step Repository: Items8MTEXTXSteps: Text of Medium Lengthnvarchar2550
35CMX_XSR_DB_ITEMTStandard Execution Step Repository: Texts for Items5MTEXTXSteps: Text of Medium Lengthnvarchar2550
TOPPublic Sector
36T5D5DSupplementary Pension Public Sector: Notification Fields7MTEXTDescription of Notification Fieldnvarchar380
TOPSales Plan
37T445GTexts of LIS Planning Macros4MTEXTMacro Descriptionnvarchar400
TOPSAP Business Workflow
38TOJMTObjects in the SAP System: method descriptions3MTEXTObjects in SAP System: method namenvarchar200
TOPService Data Download
39/SDF/CMO_T_53CMO Service: Clients of DEV system2MTEXTnvarchar250
40/SDF/CMO_T_54CMO Service: Clients of QAS system2MTEXTnvarchar250
41/SDF/SWCM_T000_PClients of PRD2MTEXTnvarchar250
TOPTraders and Schedulers Workbench
42OIJIMEXTOIL-TSW: Flag for importer/exporter or others texts5MTEXTMedium Textnvarchar250
43OIJRRTTOIL-TSW: Partner role type texts5MTEXTMedium Textnvarchar250
44OIJ_SPTYPESTStock Projection Type Texts4MTEXTDescriptive text of medium length (30)nvarchar300
45OIJ_TIMEBUCKETSTOIL-TSW : Time Bucket Text4MTEXTCharacter field length 20 with upper/lower casenvarchar200
TOPUser and Authorization Management
46TUL_CLIENTSSystem Measurement: Client Handling3MTEXTClient namenvarchar250