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

29 columns | Print definition?ERP 6.0  | ATYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1GRPCQCATATYPEQuestion Category Question Answer assignemnt3ATYPEAnswer Typenvarchar10
2P2RG_MSAMaternity and Sickness Absences (GB)5ATYPEAbsence valuation rulenvarchar20
3P2RG_NIRANI and Rebate Arrears5ATYPENI contributions/arrears typenvarchar20
4P2RX_ABCCumulation of Absence Classes5ATYPEActivity Type for Transactionsnvarchar10
5T7RU80SBasic normal grafiks Russia6ATYPEActivity Type for Transactionsnvarchar10
6T7RUADVADV-6-2 external sums2ATYPEPaymentnvarchar20
7T7RUADVNADV-6-2 external sums2ATYPEPaymentnvarchar20
8T7RUADVN_CEADV-11 external sums (CE)2ATYPEPaymentnvarchar20
9T7RUADVTYPEPayment types2ATYPEPaymentnvarchar20
10T7RUADVTYPETPayment types: Texts3ATYPEPaymentnvarchar20
TOPAutomatic Payments
11PAYRQTReference Texts for Payment Request3ATYPENotification Type (Note to Payee)nvarchar10
TOPB2A Business to Administration
12PB2ADATEMAILHR-B2A: Data Table for Incoming E-Mails8ATYPEName of Application Typenvarchar40
TOPBank Accounting
13DFPAYHTNote to Payee and Payment Advice Note Texts6ATYPEType of Notification Without Control Breaknvarchar10
TOPBasis Components
14/SSF/DHEADService Software Framework: Analysis/download control header6ATYPEnvarchar80
TOPCCMS Database Monitors for Oracle
15SDBACDBA Action Table13ATYPEType of the DBA action (for grouping)nvarchar50
TOPCompensation Management
16T71LA1Award type (check table)1ATYPEAward typenvarchar30
17T71LA1TText table for award type2ATYPEAward typenvarchar30
18T71LA2Award type2ATYPEAward typenvarchar30
19T71LB1Award5ATYPEAward typenvarchar30
TOPData Collection
20TKCAAspects5ATYPEAspect typenvarchar10
TOPDatabase Interface, Database Platforms
21SDBAC_DATADB13: DBA Action Table - Configuration Data Part11ATYPEType of the DBA action (for grouping)nvarchar50
TOPFinancial Accounting
22ACCRBDAccruals/Deferrals Master Data - Basic Data16ATYPEAccrual Typenvarchar10
TOPPerformance Monitors TCC
23SAPWLT000SAP workload: statistics data3ATYPESAP Workload: Aggregate or entry typenvarchar10
24SAPWLT001SAP workload: Table statistics3ATYPESAP Workload: Aggregate or entry typenvarchar10
25SAPWLT002SAP workload: RFC statistics data3ATYPESAP Workload: Aggregate or entry typenvarchar10
TOPProcess Controls
26GRPCQLIBRARYQuestion Library6ATYPEAnswer Typenvarchar10
TOPSubsequent Settlement
27EBABSettlement Runs Subsequent Settlement, Header Data9ATYPEType of sett. re condition rec.: reb. arrangements (Purch.)nvarchar10
28EBABPSettlement Runs Subsequent Settlement, Condition Record25ATYPEType of sett. re condition rec.: reb. arrangements (Purch.)nvarchar10
TOPTravel Expenses
29T706B2Travel Expense Types: Default Value/Maximum Amounts11ATYPEAmount Typenvarchar10