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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

68 columns | Print definition?ERP 6.0  | CNAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SDF/DRM_CONFData Readyness Monitoring - Configuration3CNAMEChar255nvarchar2550
2CNVHCM_XMLTABTDMS4HCM XML Table Entries8CNAMEChar255nvarchar2550
3CNV_10940_HEADAnalyze report variants6CNAMEUser Namenvarchar120
4GRACIDMSCHEMABUFGrac : Buffer Schema for connection id5CNAMELong Descriptionnvarchar2550
5SAIS_LOGLog for Usage of Audit Log5CNAMELast Changed Bynvarchar120
6SSF_PSE_HISTPSE History7CNAMEUser Name in User Master Recordnvarchar120
7SSF_PSE_LConfiguration Table for PSE File Mode5CNAMEUser Name in User Master Recordnvarchar120
8T5F99CLASSReference classes6CNAMEReference typenvarchar300
9T5FDSNCLASSDSN : classes de référence6CNAMEType de référencenvarchar300
10T5FPBSD1Décision - Sous-écran16CNAMENom de programme (Acte collectif)nvarchar400
11T5FPYCLASSPY: reference classes5CNAMEReference typenvarchar300
12T7RUOKINOKIN6CNAMEOKIN Descriptionnvarchar1500
13T7RUOKINFACETOKIN: Facet5CNAMENamenvarchar1000
14T7RUOKSOOKSO10CNAMENamenvarchar1000
15TCY40KDefinition of control6CNAMEPerson who changed flow controlnvarchar120
TOPAustria
16T5A7DPayslip Checking Rules3CNAMEField Namenvarchar300
17T5A7EPayslip Validation Rules7CNAMEField Namenvarchar300
TOPBilling in Contract Accounts Receivable and Payable
18FKKBIXTEST_PPBALPrepaid Test Environment: Prepaid Account Balance6CNAMEUser Namenvarchar120
TOPBrazil
19T7BRC0Construction site code6CNAMEName of construction sitenvarchar300
TOPBudget Management
20HRPMPROTHR-FPM Log Table19CNAMEUser Namenvarchar120
TOPCCMS Database Monitors for Oracle
21SDBACDBA Action Table10CNAMEName of command or report to executenvarchar300
TOPChina
22T7CN3FReported Tax Data9CNAMEAlternative namenvarchar600
TOPData Staging
23RSCSTRU2Help table for structure change1CNAMEObject Namenvarchar400
TOPDatabase Interface, Database Platforms
24SDBAC_DATADB13: DBA Action Table - Configuration Data Part8CNAMEName of command or report to executenvarchar300
TOPEnergy Data Management
25EFORMULAINSTCALCISU EDM Control Data for Calculation Run Number (DB Table)6CNAMECreated bynvarchar120
TOPFinancial Accounting
26/BGLOCS/FI001ZVAT Company detail settings5CNAMEName of the companynvarchar1500
27/BGLOCS/FI001ZTCompany detail settings - language dependent4CNAMEName of the companynvarchar1500
TOPFunds Management
28FMFGT_SS03Statistical Sampling Clerk/Supervisor Relationship3CNAMEClerk for Payment Certification Sampling Processnvarchar120
TOPLocalization
29TAXCD_REPR_ITDefine data for Tax code representative20CNAMELegal Person Company Namenvarchar600
TOPMonitoring
30ALNAMEDUSERSCustomizing Settings for CCMS Named Used Data Collector1CNAMEAlert: Short Name of Monitoring Typenvarchar400
TOPOrganizational Management
31HRP1028Infotype 1028 DB Table18CNAMEAddress Supplement (c/o)nvarchar250
32T777ABuilding Addresses4CNAMEAddress Supplement (c/o)nvarchar250
TOPPayroll
33T7SIA1Annual tax - Master data11CNAMEName of Company Code or Companynvarchar250
34T7SIA4DPZ temporary data6CNAMEName of Company Code or Companynvarchar250
TOPPayroll General Parts
35T52CEDirectory of Personnel Calculation Rules2CNAMEPersonnel Calculation Rulenvarchar40
TOPPension fund Netherlands
36T5NDKHR-NL: Gebeurtenissentabel SAP HR Pension Funds Netherlands11CNAMEGebeurtenis aangemaakt door gebruikernvarchar120
TOPPersonnel Administration
37PA0002HR Master Record: Infotype 0002 (Personal Data)29CNAMEComplete Namenvarchar800
38T52CE_TText table for PCR directory3CNAMEPersonnel Calculation Rulenvarchar40
39T7PL0TTexts for T7PL054CNAMELong textnvarchar800
40T7PL1TTexts for T7PL053CNAMELong textnvarchar800
TOPPrint and Output Management
41TSPCPCDSCPC: Distribution status5CNAMECreator's namenvarchar120
42TSPCPCDSEExtended distribution status information10CNAMECreator's namenvarchar120
43TSPCPCFAVTarget Systems and Target System Groups as Favorite Targets5CNAMECreator's namenvarchar120
44TSPCPCPGCCPC: Printer group configuration3CNAMECreator's namenvarchar120
45TSPCPCPGLCPC: Printer group list3CNAMECreator's namenvarchar120
46TSPCPCPLCPC: List of CPC managed printers on central system4CNAMECreator's namenvarchar120
47TSPCPCTPROBSOLETE CPC: Target system group / printer group relations3CNAMECreator's namenvarchar120
48TSPCPCTSGCCPC: Target system group configuration3CNAMECreator's namenvarchar120
49TSPCPCTSGLCPC: Target system group list3CNAMECreator's namenvarchar120
50TSPCPCTSLCPC: Target system list5CNAMECreator's namenvarchar120
TOPProduction Optimization Interface POI
51TCBP_MODContains all supply chain planning models6CNAMEPerson responsible for latest change in modelnvarchar120
TOPPublic Sector
52T5PBSR6IGuideline for Salary Components11CNAMESalary Component Textnvarchar300
TOPRecruitment
53PB0002HR Master Record: Infotype 0002 (Personal Data)29CNAMEComplete Namenvarchar800
TOPRetention Warehouse
54IWP_WP_JOBJobs for the Backgroundprocessing9CNAMECreated Bynvarchar120
55IWP_WP_LOGLog for Backgroundprocessing7CNAMECreated Bynvarchar120
TOPReuse Services for Country Development
56PA3228XSS Online Election27CNAMEUser Namenvarchar120
TOPSecure Network Communications
57RFCDESSECUSNC extensions for RFC destinations6CNAMEUser Name in User Master Recordnvarchar120
58SNCSYSACLSNC Access Control List (ACL): Systems11CNAMEUser Name in User Master Recordnvarchar120
59TXCOMSECUSNC extension for CPIC destinations5CNAMEUser Name in User Master Recordnvarchar120
60USRACLSNC Access Control List (ACL): User7CNAMEUser Name in User Master Recordnvarchar120
61USRACLEXTExtended SNC Access Control List (ACL) for Users7CNAMEUser Name in User Master Recordnvarchar120
62USREXTIDAssignment of External ID to Users10CNAMEUser Name in User Master Recordnvarchar120
63USREXTIDHExternal ID (Access Using Hash Value)4CNAMEUser Name in User Master Recordnvarchar120
TOPSecure Store and Forward
64SSF_PSE_HSSF: Personel Security Environment6CNAMEUser Name in User Master Recordnvarchar120
TOPSouth Africa
65T5WERSouth Africa - IRP5 Company Contact Person Details5CNAMEContact Person Namenvarchar300
TOPTax
66P01T_LST2ETStmt: Addnl Data on Employment Tax Statement6CNAMEETStmt: Name of Tax Basisnvarchar300
TOPTax Reporter
67T5UX6W-2/W-2C Puerto Rico Control Number6CNAMECharacter field of length 6nvarchar60
TOPUSA
68PA0566HR Master Record: Infotype 056627CNAMEQDRO Court Namenvarchar400