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

47 columns | Print definition?ERP 6.0  | TABID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVMBTSUBSTATEStatus table for execution of all subactivities and histor28TABIDsmallint50
2P2BG_BG_CUXDifference table of payroll results5TABIDTable IDnvarchar30
3P2BG_BG_DIFDifference table of payroll results5TABIDTable IDnvarchar30
4P2RO_RO_CUXDifference table of payroll results5TABIDTable IDnvarchar30
5P2RO_RO_DIFDifference table of payroll results5TABIDTable IDnvarchar30
TOPAustria
6T5A2JIncome Tax According to Effective Pay Scale2TABIDEffective Pay Scale: Table Typenvarchar10
TOPBusiness Application Support
7CNVSTATEConversion: Status of programs28TABIDint100
TOPCompensation Administration
8T71ADM28Customer's own Tabs3TABIDCustomer's Tab IDnvarchar40
9T71ADM28TCustomer's Tabs Texts4TABIDCustomer's Tab IDnvarchar40
10T71ADM29Planning UI Tab Configuration3TABIDCustomer's Tab IDnvarchar40
11T71ADM30Column Mapping3TABIDCustomer's Tab IDnvarchar40
TOPCompensation Management
12T504STo be deleted - no longer used!3TABIDMatrix IDnvarchar40
13T504TTo be deleted - no longer used!4TABIDMatrix IDnvarchar40
14T504UTo be deleted - no longer used!4TABIDMatrix IDnvarchar40
15T504VTo be deleted - no longer used!4TABIDMatrix IDnvarchar40
16T504WTo be deleted - no longer used!4TABIDMatrix IDnvarchar40
17T504XTo be deleted - no longer used!3TABIDMatrix IDnvarchar40
18T504YTo be deleted - no longer used!3TABIDMatrix IDnvarchar40
19T504ZTo be deleted - no longer used!3TABIDMatrix IDnvarchar40
TOPContract Accounts Receivable and Payable
20DFKKDOCFI-CA DMS: Administrative Data of Documents25TABIDDMS: Origin of Documentnvarchar30
TOPDevice Management
21EDTIDIS-U Device Checker: Allocation of Table Names - Table IDs2TABIDTwo digit numbernvarchar20
TOPForms
22T514KAllowed Table Names / Short IDs for Forms4TABIDTable indicator for form controlnvarchar10
TOPI18N Unicode
23UM4PMCOLLTable for Storing Collisions2TABIDnvarchar60
24UM4PMDICSPUMG dictionary1TABIDnvarchar60
25UM4PMDIIAdditional Information for UMGPMIC1TABIDnvarchar60
26UM4PMIGWorklist for Scan Levels3TABIDnvarchar60
27UMGPMCOLLTable for Storing Collisions2TABIDUnique table identifiernvarchar60
28UMGPMDICSPUMG dictionary1TABIDUnique table identifiernvarchar60
29UMGPMDIIAdditional Information for UMGPMIC1TABIDUnique table identifiernvarchar60
30UMGPMIGWorklist for Scan Levels3TABIDUnique table identifiernvarchar60
TOPIntegrated Product and Process Engineering
31CTABLAYLayout Assignment for Additional Tabstrips2TABIDTab Page for iPPE Tabstrip Controlnvarchar200
32CTABSCRTab Pages - Screen Assignment Table2TABIDTab Page for iPPE Tabstrip Controlnvarchar200
TOPMicrosoft SQL Server
33DBSTATTMSSTable sizes1TABIDMS SQL Server table object idint100
TOPPayment Cards
34CCSEC_LOGLogging of Access to Payment Card Numbers2TABIDObject Type in Which Credit Card Number is Savednvarchar30
TOPPayroll
35T5TPSCMTABHRCZ Public sector multitable2TABIDHRCZ Public sector table IDnvarchar100
36T7SKMTABHRCZ Public sector multitable2TABIDHRSK - Table IDnvarchar100
TOPPerformance Monitors TCC
37DBSTATHINFINFORMIX update statistical information1TABIDTable IDint100
38DBSTATTINFINFORMIX update statistical information1TABIDTable IDint100
TOPPersonalization Framework
39FPB_PERSARRPersonalization: Dialogs and Application Hierarchy2TABIDID of Tab Page Title for Personalization Dialognvarchar20
40FPB_PERSARRTPersonalization: Dialogs and Application Hierarchy2TABIDID of Tab Page Title for Personalization Dialognvarchar20
41FPB_PERSDIALOGPersonalization: Dialogs and Application Hierarchy7TABIDID of Tab Page Title for Personalization Dialognvarchar20
42FPB_PERSTABPersonalization: Dialogs and Application Hierarchy2TABIDID of Tab Page Title for Personalization Dialognvarchar20
43FPB_PERSTABTPersonalization: Dialogs and Application Hierarchy2TABIDID of Tab Page Title for Personalization Dialognvarchar20
TOPSAP Healthcare - Industry-Specific Components for Hospitals
44NWAT_SCOVARIS-H AT: Scoring - Layout (Karteireiter)3TABIDIS-H AT: Priorität des Karteireiters im Arbeitsumfeldnvarchar30
45TNWAT_SCOVARIIS-H AT: Scoring- Standard-Layout (Karteireiter)5TABIDIS-H AT: Priorität des Karteireiters im Arbeitsumfeldnvarchar30
TOPStructures Workbench
46/ISDFPS/CFDPDA04Detail Area - Customizing of HR Tab Pages1TABIDName of Tab Pagenvarchar200
TOPUSA
47T504RTo be deleted - no longer used!3TABIDMatrix IDnvarchar40