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

45 columns | Print definition?ERP 6.0  | RULENAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVCMIS_FIELDSExplicit conversion rules for fields during migration7RULENAMERule Namenvarchar190
2CNVCMIS_NTR_EXPTStore info about unknown values of Non transparent fields4RULENAMERule Namenvarchar190
3CNVCMIS_NTR_STRUInformation about the known values of nontransparent field3RULENAMERule Namenvarchar190
4CNVCMIS_RENAMEConversion values for rules3RULENAMERule Namenvarchar190
5CNVMBTDOMSdomains / data elements with corresponding conv. rules5RULENAMERule Namenvarchar190
6CNVMBTFIELDSexplicite conversion rules for fields during migration7RULENAMERule Namenvarchar190
7CNVMBTRULEFIELDSfield assignments for rules during migration5RULENAMERule Namenvarchar190
8CNVMBTRULEINCLRule Include names and type3RULENAMERule Namenvarchar190
9CNVMBTRULEPARSconversion rules parameter structure and types3RULENAMERule Namenvarchar190
10CNVMBTRULEPARSTText table for CNVMBTRULEPARS3RULENAMERule Namenvarchar190
11CNVMBTRULESconversion rules3RULENAMERule Namenvarchar190
12CNVMBTRULESTMBT PCL Text table for CNVMBTRULES3RULENAMERule Namenvarchar190
13CNVMBTRULESTEPSStep for Event related rules5RULENAMERule Namenvarchar190
14CNVMBTSCCUCOPARSScramble Rule Parameters7RULENAMEImport / Exportnvarchar10
15CNVMBTSTEPSsteps / rules6RULENAMERule Namenvarchar190
16CNVTDMS_08_EXEPTIntransparent Fields. Exception Table.3RULENAMERule Namenvarchar190
17CNVTDMS_08_FIELDexplicite conversion rules for fields during migration8RULENAMERule Namenvarchar190
18CNVTDMS_08_TSTRUTDMS_TSTRUCT for Client Conversion3RULENAMERule Namenvarchar190
19CNV_10020_RCOMPAssignment of rules to non-transp. field components7RULENAMERule namenvarchar300
20CNV_10020_RDTOBJAssignment of rules to determination object components7RULENAMERule namenvarchar300
21CNV_10020_RULERules - Header data3RULENAMERule namenvarchar300
22CNV_10020_RULEPRules for components of non-transp. fields/determ. objects3RULENAMERule namenvarchar300
23CNV_10020_RULETRules - Descriptions4RULENAMERule namenvarchar300
24CNV_NCE_NRIV_MAPNCE: Mapping data for number ranges18RULENAMEName of Conversion Rulenvarchar600
25T5R2GQuota Generation Rule Lists Singapore5RULENAMEQuota Generation Rule Name (Filter)nvarchar300
TOPBusiness Process Engine
26BRR_HEADERHeader Data of a Business Rule (Table Structure)5RULENAMEName of a BRR Object, not language-specificnvarchar320
27BRR_HEADER_CClient-Specific Business Rule (Table Structure)6RULENAMEName of a BRR Object, not language-specificnvarchar320
TOPConsolidation
28TF372Time Stamps for Parsing of Rules2RULENAMEValidation rulenvarchar110
29TF374Fields Used in Validation Rules2RULENAMEValidation rulenvarchar110
30TF375Validation Steps: Node Structure12RULENAMEValidation rulenvarchar110
TOPData Staging
31RSERRORLOCLocation of Check5RULENAMEName of a Rule (Includes RSTRAN_RULENAME)nvarchar300
TOPDate Rules
32TIMEPFRUContext Profile for Date Rules3RULENAMEName for Date Rulesnvarchar120
TOPLegacy System Migration Workbench
33/SAPDMC/LSODOCDocumentation12RULENAMERule Namenvarchar300
34/SAPDMC/LSORULRule Category10RULENAMERule Namenvarchar300
35/SAPDMC/LSRATTCentral Rules: Definition and Attributes3RULENAMERule Namenvarchar300
36/SAPDMC/LSRCODCentral Rules: Code3RULENAMERule Namenvarchar300
37/SAPDMC/LSRTXTCentral Rules: Name4RULENAMERule Namenvarchar300
38/SAPDMC/LSRVLICentral Rules: Interval Translation Values3RULENAMERule Namenvarchar300
39/SAPDMC/LSRVLOCentral Rules: 1:1 Translation Values3RULENAMERule Namenvarchar300
TOPRecycling Administration Core Functions
40J_7LC34REA DME: Field Mapping and Rule Set9RULENAMEName of routine to be called up in the processing programnvarchar300
TOPRuntime WorkbenchMonitoring
41SXMSALERTRULESRules for Alert Generation: Msg Header -> Alert Category14RULENAMEDescriptionnvarchar600
TOPSyntax, Compiler, Runtime
42SSYNTAXSTRUCTUREXML Representation of Syntax Diagrams1RULENAMEnvarchar700
TOPTools
43T77PYORULESRules to generate start date in payroll schedule2RULENAMERule Namenvarchar320
44T77PYORULESTText table for rules3RULENAMERule Namenvarchar320
45T77PYOTMSTPTemplate for payroll schedule4RULENAMERule Namenvarchar320