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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

46 columns | Print definition?ERP 6.0  | CLASSIFICATION

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/IC_ASSETSInvestment Approval assets9CLASSIFICATIONApproved Asset classificationnvarchar20
2/ATL/IC_ASSET_CLasset classification master data1CLASSIFICATIONApproved Asset classificationnvarchar20
3/NAKISA/HRP9824DB Table for Infotype 982422CLASSIFICATIONClassification typenvarchar120
4/NAKISA/THRADZNHTable for additional data relationship ZNK/ZNL7CLASSIFICATIONClassification typenvarchar120
5/NAKISA/THRADZNKTable for additional data relationship ZNK/ZNL6CLASSIFICATIONClassification typenvarchar120
6/NAKISA/THRCLASTClassification type3CLASSIFICATIONClassification typenvarchar120
7/OTTM/BL_T_ERME-Receipt metadata9CLASSIFICATIONClassification of Meta Datanvarchar500
8/OTTM/BL_T_MACMapping of Classification to Expense Types3CLASSIFICATIONClassification of Meta Datanvarchar500
9CNVTDMS_04_TABTable Pool for TDMS MD&C4CLASSIFICATIONClassification for TDM MD&Cnvarchar10
10DIAN_C_VAT_1001Additional VAT Settings for Format 10016CLASSIFICATIONDIAN Vat Classificationnvarchar50
11DIAN_C_WTH_1001Additional Withholding Settings for Format 10016CLASSIFICATIONDIAN Withholding Classification Format 1001nvarchar50
12DMS_TBL_LOCKEDMaintain Lock Field Status12CLASSIFICATIONClassificationnvarchar10
13EHFNDD_CHM_HCEWGChemical - Hazard Classification GWS9CLASSIFICATIONCategories of Danger According to 67/548/EECnvarchar210
14EHFNDD_CHM_HCLSSChemical - Hazard Classificationi9CLASSIFICATIONHazard Class/Hazard Categorynvarchar210
15T5PPBS5CCTMaintain Performance Classification Values5CLASSIFICATIONPerformance Classification Descriptionnvarchar300
16WGDS_C_ERR_CLSError Classifications2CLASSIFICATIONTrade Item Error Classificationnvarchar30
17WGDS_C_ERR_CLS_TText table of error classifications2CLASSIFICATIONTrade Item Error Classificationnvarchar30
18WGDS_D_TI_ERRORErrors of Trade Item22CLASSIFICATIONTrade Item Error Classificationnvarchar30
19ZMATERIALDemo Teched6CLASSIFICATIONnvarchar20
TOPAccounts Receivable Accounting Process Integration
20FDM_DCOBJFSCM-DM Integration: Disputed Objects7CLASSIFICATIONObject Classificationnvarchar100
TOPAudit Management
21PLMM_AUDITAudit18CLASSIFICATIONRating Profilenvarchar20
TOPBack Office
22TRSC_DFLOWTYPETreasury: Attributes of Update Type for TRS6CLASSIFICATIONCFM: Flow Classification for Securities Account Managementnvarchar20
TOPBasic Functions
23UDM_CLASS_ADMINFSCM-DM: Mapping of Classification to Anchor and Relationshp1CLASSIFICATIONObject Classificationnvarchar100
TOPBusiness Configuration Tools Runtime
24SC2_BO_ASSOCC2 Server: Associations in Active Configuration Object9CLASSIFICATIONClassification of Relation (Parent-Child...)nvarchar10
TOPBusiness Partner
25EKUNIS-U-Specific Fields for Business Partner35CLASSIFICATIONClassification of Business Partnernvarchar40
26TE181Classification of Business Partner2CLASSIFICATIONClassification of Business Partnernvarchar40
27TE181TText for Classification of Business Partner3CLASSIFICATIONClassification of Business Partnernvarchar40
TOPClaims Management
28TICL036Process3CLASSIFICATIONProcess Classificationnvarchar10
TOPClinical System
29TN2CARDREFReference Values for Medical Examinations32CLASSIFICATIONShort Text for Classificationnvarchar600
TOPE-Recruiting
30HRP5102DB Table for Infotype 510225CLASSIFICATIONCandidate Rankingdecimal52
31HRP5133DB Table for Infotype 513321CLASSIFICATIONRanking of Candidacydecimal52
32HRP5142DB Table for Infotype 514234CLASSIFICATIONRankingdecimal52
TOPEnterprise Service Framework Layer
33SCOL_ND_ASSOCESF : Business Object - Association13CLASSIFICATIONClassification of Relation (Parent-Child...)nvarchar10
TOPFlexible Real Estate Management
34TIVLULACLASSLUM: Katasterliche Klassifizierung5CLASSIFICATIONKlassifizierungnvarchar40
35TIVLULACLASSTLUM: Katasterliche Klassifizierung Texte6CLASSIFICATIONKlassifizierungnvarchar40
36VILUBIKATUSALUM: Ausschreibung - Katasterliche Nutzung7CLASSIFICATIONKlassifizierungnvarchar40
37VILULAKATLUM: Flurstück - Katasterliche Klassifizierung6CLASSIFICATIONKlassifizierungnvarchar40
TOPList Processing
38SABP_LISTTR_MList Trace Manager10CLASSIFICATIONnvarchar650
TOPNetWeaver Demonstration
39SDEMO_SOSAP NetWeaver Demo Model - Sales Order Header18CLASSIFICATIONClassification Codenvarchar30
TOPPatient Management
40N1TC_MATRIX_BUFMatrix Temporary Storage6CLASSIFICATIONClassification of Matrix Assignmentnvarchar10
TOPProduct Configurator
41COMM_CFGDOCOBJStructure for Identifying Document6CLASSIFICATIONClassification IDsmallint50
TOPProvisioning
42SPCIPPROFKEYSKey fields and values of IP profiles3CLASSIFICATIONIP: Classification Datanvarchar10
TOPRecords and Case Management
43RMPSD_TRF_EX_ITExport Run - Item List13CLASSIFICATIONClassification Criterionnvarchar200
TOPRights
44CMS_RIGCMS: Rights table. Includes claims, patents, other rights.9CLASSIFICATIONClassificationnvarchar60
TOPShip
45CMS_SHPDescription of a Ship - Master Table20CLASSIFICATIONClassification of a Shipnvarchar400
TOPTransaction Manager
46VWPPOOLDATAAsset Pool Data3CLASSIFICATIONAsset Pool Classificationnvarchar30