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

51 columns | Print definition?ERP 6.0  | CONSTANT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1COMC_TEXT_ASFAssignment of Fields in Access Sequence8CONSTANTFixed Key for Text Accessnvarchar700
2T5N25Payroll Parameters for Tax Rebates (NL)3CONSTANTConstant for Tax Calculation Rulesnvarchar100
3T7CNRMP_FRMOPRFormula Operand10CONSTANTFloat Constantdecimal244
4T7CNRMP_VALUEITMValue Item of Statistical Item with Value Reading Type18CONSTANTFloat Constantnvarchar600
5TXX_C_RELA_GCDERelationships Between Segments8CONSTANTConstantnvarchar300
TOPAddress ManagementBusiness Address
6ADRSTATUSSADR -> ADRC address conversion status per address group2CONSTANTAddress Group (Key) (Business Address Services)nvarchar40
TOPBusiness Consolidation
7UCT8014Mapping Rule: Details of Move Operator8CONSTANTCharacteristic Valuenvarchar450
TOPBusiness Partner
8BPCONSTANTSFS BP Constants Table: Adopted Values (Internal)2CONSTANTKey for a Constantnvarchar60
9TPZ_CONST_DEFFS BP Constants Table: Definition of Constants (Internal)1CONSTANTKey for a Constantnvarchar60
10TPZ_CONST_DEF_TFS BP Constants Table: Text for Definition of Constants2CONSTANTKey for a Constantnvarchar60
11TPZ_CONST_VALFS BP Constants Table: Values of Constants (Internal)1CONSTANTKey for a Constantnvarchar60
TOPBusiness Rule Framework
12TBRF143BRF: Constant6CONSTANTName of Constantsnvarchar500
13TBRF261BRF: Dependent Constant7CONSTANTResultnvarchar500
TOPConsolidation
14TF375Validation Steps: Node Structure13CONSTANTValidation: Fixed valuedecimal173
TOPControlling
15SURQUESTQEXTSurvey: Supplements to individual questions of questionnaire9CONSTANTSurvey: field valuenvarchar2550
16SURREFSSurvey: Array references9CONSTANTSurvey: field valuenvarchar2550
TOPData Retention Tool
17TXW_C_RELARelations of tables and domains8CONSTANTConstantnvarchar300
18TXW_C_V2Data view: Join conditions7CONSTANTConstantnvarchar300
19TXX_C_RELARelationships Between Segments8CONSTANTConstantnvarchar300
20TXX_C_V2View: Join Conditions7CONSTANTConstantnvarchar300
TOPData Staging
21RSDSSEGFDDataSource - Segment Fields13CONSTANTFixed Value of DataSource Fieldnvarchar600
22RSDSSEGFDSHDataSource in BW - Shadow Table Fields13CONSTANTFixed Value of DataSource Fieldnvarchar600
23RSTRANSTEPMASTERRule Type: Read Master Data7CONSTANTConstantnvarchar13330
24RSTRANSTEPODSORule Type: Read DataStore Object7CONSTANTConstantnvarchar13330
25RSUPDDATUpdate rules key figures15CONSTANTConstant, possibly lowercasenvarchar600
26RSUPDKEYUpdate rule: Key per key figure11CONSTANTDim: Field for a Characteristic Value Shorter Than 60 Char.nvarchar600
TOPEmployee Interaction Center
27THREIC_CON_TEIC: Constants (Texts)3CONSTANTEIC: Constant Namenvarchar100
28THRSSC_CON_TCRM_SSC: Constants (Texts)3CONSTANTCRM_SSC: Constant Namenvarchar100
TOPEnvironment, Health and Safety
29/TDAG/CPC_REP005CP: Define attributes for element14CONSTANTDescription (128 Characters)nvarchar1280
TOPEvent Management
30/SAPTRX/EXT_EEExtraction of Expected Events7CONSTANTConstant Valuenvarchar600
31/SAPTRX/EXT_EVTExtraction table for Event Types8CONSTANTConstant Valuenvarchar600
32/SAPTRX/EXT_FLDSExtraction fields8CONSTANTConstant Valuenvarchar600
33/SAPTRX/EXT_PARParameter and IDs for EM generic extraction12CONSTANTConstant Valuenvarchar600
TOPFinland
34T7FIVACWage types, constants and rules for Vacation Statement8CONSTANTPayroll constantnvarchar50
TOPFunds Management
35FMDERIVEFUNCList of functions available in the FM Derivation tools9CONSTANTConstantnvarchar600
TOPGeneral Application Functions
36TABADRSFCharacteristic Derivation: Steps, Fields18CONSTANTConstantnvarchar600
TOPGlobal Trade Services
37/SAPSLL/GENDEPSLL: Table Relationships10CONSTANTText 60 Characters Longnvarchar600
TOPLegacy System Migration Workbench
38/SAPDMC/LSORULRule Category11CONSTANTConstantnvarchar300
39/SAPDMC/LSRATTCentral Rules: Definition and Attributes13CONSTANTConstantnvarchar300
TOPLocalization
40J_3RFTAX_LINKDTax Accounting: Table link details6CONSTANTConstant value in foreign keynvarchar300
TOPProfitability Analysis
41TKEDRSFCharacteristic Derivation: Steps, Fields18CONSTANTConstantnvarchar320
TOPProvisioning
42SPCIPCLSIFInterface IP Data - Master Data6CONSTANTConstant value for the target fieldnvarchar700
43SPCIPINTERFACEInterface IP Data - Master Data5CONSTANTConstant value for the target fieldnvarchar400
TOPPublic Sector Contract Accounts Receivable and Payable
44TFMCA_BRF236BRF: Check Rules for Form Fields14CONSTANTName of Constantsnvarchar500
TOPRecycling Administration Core Functions
45J_7LC34REA DME: Field Mapping and Rule Set10CONSTANTValuenvarchar300
TOPRisk Analysis
46AFWCH_DRSF_SAMPSample Customizing for Derivation (Fields for Steps)17CONSTANTConstantnvarchar320
TOPServices
47FINB_PR_TJOINSJoin conditions13CONSTANTCharacteristic Valuenvarchar450
TOPSmart Forms
48STXFSTDPARSmart Forms: Default Parameters9CONSTANTSAP Smart Forms: General Indicatornvarchar10
TOPSpecification 2
49SPCINMAPRules for linking src field and trg field12CONSTANTConstant value for the target fieldnvarchar700
50SPCMINMAPRules for linking src field and trg field (AECMA)12CONSTANTConstant value for the target fieldnvarchar700
TOPSyntax, Compiler, Runtime
51BADI_FILTERFilter Table4CONSTANTnvarchar10