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

109 columns | Print definition?ERP 6.0  | ORD

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CCGLC_MPDP_NEWEHS: Manual Print Dialog for User Entry for Print Request8ORDSort Sequencenvarchar40
2CCGLT_PRTREQ_PAREHS: Print Request Parameters6ORDOutput Sequence for Report Symbol Valuesnvarchar40
3CCGLT_PR_PAR_UTEHS: Print Request Parameters Test Data for Unit Tests10ORDOutput Sequence for Report Symbol Valuesnvarchar40
4EHPRCC_ENVDCP: language dependent description of environment parameter4ORDSort Sequencenvarchar40
5EHPRCC_ENV_CPCP: General environment parameter3ORDSort Sequencenvarchar40
6EHPRCC_EXIMDDCP: language dep. descriptor for IMDS MDS variables4ORDSort Sequencenvarchar40
7EHPRCC_EXIMDSCP: IMDS MDS variables3ORDSort Sequencenvarchar40
8EHPRCC_IMDSMATCLConfiguration for IMDS MatClass Check3ORDSort Sequencenvarchar40
9EHPRCC_IMIDCP: Import identification3ORDSort Sequencenvarchar40
10EHPRCC_IMIDNACP: Import identification description3ORDSort Sequencenvarchar40
11EHPRCC_IMMAPMapping table5ORDSort Sequencenvarchar40
12EHPRCC_IMSEGFImport segment fields5ORDSort Sequencenvarchar40
13EHPRCC_NORPCP: Define normalization variant additional parameters4ORDSort Sequencenvarchar40
14EHPRCC_UEFUCP: Link User-Exits with Function Modules6ORDSort Sequencenvarchar40
15EHPRCD_IMDSMATCLConfiguration for matclass check3ORDSort Sequencenvarchar40
16EHPRCI_MIGRATEDefinition of data migration (source table -> dest table)2ORDSerial Numberint100
17ESEESCC_RSBASICBasic Settings for ESComXML Report Shipping2ORDSort Sequencenvarchar40
18ESEESCC_XMLBASICEHS: Basic Settings for ESComXML Generation2ORDSort Sequencenvarchar40
19TCGLABBCPAREHS: Assignment Bar Code - Parameter4ORDSort Sequencenvarchar40
20TCGLABSQNPAREHS: Assignment of Sequence Number - Parameter4ORDSort Sequencenvarchar40
TOPBasic Data and Tools
21EHSBC_ST02EHS-BAS: System Status Profiles3ORDStatus Order Numbernvarchar20
22EHSBC_ST03EHS-BAS: Illegal Transitions to the System Status Profiles2ORDStatus Order Numbernvarchar20
TOPBusiness Information Collection
23UIDOCResults Document of a Research Run (SEM-BIC)4ORDGlobal ID number for data sourcesnvarchar220
TOPDangerous Goods Management
24TDG81Dynamic Tab Titles for Dangerous Goods Master3ORDSequence of Tab Pages in Dangerous Goods Masternvarchar30
TOPEnvironment, Health and Safety
25/TDAG/CPC_ENVCP: General environment parameter3ORDSort Sequencenvarchar40
26/TDAG/CPC_ENVDCP: language dependent description of environment parameter4ORDSort Sequencenvarchar40
27/TDAG/CPC_EXIMDDCP: language dep. descriptor for IMDS MDS variables4ORDSort Sequencenvarchar40
28/TDAG/CPC_EXIMDSCP: IMDS MDS variables3ORDSort Sequencenvarchar40
29/TDAG/CPC_IMIDCP: Import identification3ORDSort Sequencenvarchar40
30/TDAG/CPC_IMIDNACP: Import identification description3ORDSort Sequencenvarchar40
31/TDAG/CPC_IMMAPMapping table5ORDSort Sequencenvarchar40
32/TDAG/CPC_IMSEGFImport segment fields5ORDSort Sequencenvarchar40
33/TDAG/CPC_NORPCP: Define normalization variant additional parameters4ORDSort Sequencenvarchar40
34/TDAG/CPC_UEENSpecify User Exit Parameters5ORDSort Sequencenvarchar40
35/TDAG/CPC_UEFUCP: Link User-Exits with Function Modules6ORDSort Sequencenvarchar40
36/TDAG/CPC_WLPARMCP: Parameter table for CfP Worklist Management4ORDSort Sequencenvarchar40
37/TDAG/RCSC_ENVEHS: General Environment Parameters3ORDSort Sequencenvarchar40
38/TDAG/RCSC_ENVNAEHS: Language-Dependent Desc. for Environment Parameters4ORDSort Sequencenvarchar40
39EHQMT_BASIC_DATAEH&S-QM: Basic Data for Inspection Plans3ORD5 Character Numeric NUMCnvarchar50
40TCGL3EHS: Report Applications19ORDSort Sequencenvarchar40
TOPEnvironment, Health and Safety Master Data
41ESTPJEHS: Phrase set - phrase header assignment18ORDSort Sequencenvarchar40
42TCG65EHS: Phrase language (languages supported by phrase library)3ORDSort Sequencenvarchar40
43TCGENVEHS: General Environment Parameters3ORDSort Sequencenvarchar40
44TCGENVEXTEHS: Customizing - Conditions for Parameters3ORDSort Sequencenvarchar40
45TCGENVNAEHS: Language-Dependent Desc. for Environment Parameters4ORDSort Sequencenvarchar40
46TCGUEFUEHS: User Exits in User Exit Management with FM Assignment6ORDSort Sequencenvarchar40
47THM063DG: Dangerous Goods Regulation7ORDSort Sequencenvarchar40
TOPFSCM In-House Cash
48IHC_DB_RT_NODEIHC: Routing Node16ORDIHC: Sequence in Route Determinationnvarchar40
TOPProduct Safety
49CCGLC_BASICEHS: Basic Data2ORDSort Sequencenvarchar40
50CCGLC_MPDPEHS: Manual Print Dialog for User Entry8ORDSort Sequencenvarchar40
51CCGLC_SECCEHS: Sec. Value Determination for Report Symbols - Rules4ORDSort Sequencenvarchar40
52CCGLT_OEDLEHS: User Entry for Label Data Layout11ORDSort Sequencenvarchar40
53CCRCC_CDEHS: Rules for Country Determination5ORDSequencenvarchar40
54CCRCC_CHCK_SALESEHS: Activate Check of Sales Orders2ORDSort Sequencenvarchar40
55CCRCC_FILTEREHS: Data Filtering6ORDSequencenvarchar40
56CVDDCSPEHS: Control Structure Parameters (Report Shipping)17ORDPartial key: sort sequence of objectsnvarchar40
57CVDDPEHS: Parameter Values for Report Shipping18ORDPartial key: sort sequence of objectsnvarchar40
58ESTAHEHS: Application-dependent data for report generation5ORDPartial key: sort sequence of objectsnvarchar40
59ESTDCSPEHS: Parameter Control Structure17ORDPartial key: sort sequence of objectsnvarchar40
60ESTDFAdditional Information - User-Defined Text19ORDSort Sequencenvarchar40
61ESTLPEHS: Report Variant20ORDSort Sequencenvarchar40
62ESTLVEHS: Report Variant Language (Labels Only)16ORDSort Sequencenvarchar40
63ESTRIEHS: Identifier (Numbers, Names, Chemical Formulas)23ORDSort Sequencenvarchar40
64ESTVAEHS: Value Assignment17ORDSort Sequencenvarchar40
65ESTVPEHS: Value Assignment Item25ORDSort Sequencenvarchar40
66TCG78OBJCONEHS: Object-Parameter-Exception Value Assignment6ORDSort Sequencenvarchar40
67TCGBAEHS: BOMBOS - Selection of BOM and BOM Items3ORDSort Sequencenvarchar40
68TCGC0EHS: Import/Export - Key Transfer Table3ORD5 Character Numeric NUMCnvarchar50
69TCGC2EHS: Import/Export - File - Table3ORD5 Character Numeric NUMCnvarchar50
70TCGES01EHS: Worklist for Enterprise Search PS Background Process8ORDSequential Number of Data Recordnvarchar200
71TCGGRPTREEEHS: Group tree - group - assignment5ORDSort Sequencenvarchar40
72TCGHITEHS: No. of hits14ORDSort Sequencenvarchar40
73TCGHITNAEHS: Language-Dependent Description of Sets of Hits5ORDSort Sequencenvarchar40
74TCGOUTVAREHS: Output variants14ORDSort Sequencenvarchar40
75TCGOUTVARNAEHS: Language-Dependent Description of Output Variant5ORDSort Sequencenvarchar40
76TCGQUEEHS: Queries14ORDSort Sequencenvarchar40
77TCGQUENAEHS: Language-Dependent Description of Queries5ORDSort Sequencenvarchar40
78TCGQUESTEPNAEHS: Language-Dependent Description of Query Steps6ORDSort Sequencenvarchar40
79TCGREL01EHS: Worklist for Inheritance Background Process8ORDSequential Number of Data Recordnvarchar200
80TCGRLEHS: Assignment of languages and lead times to countries4ORDSort Sequencenvarchar40
81TCGRULEHS: Easy Expert Set of Rules14ORDSort Sequencenvarchar40
82TCGRULNAEHS: Language-Dependent Desc. for Easy Expert Sets of Rules5ORDSort Sequencenvarchar40
83TCGTPLHEHS: Inheritance Template Header14ORDSort Sequencenvarchar40
84TCGTPLHDEHS: Inheritance Templates - Descriptions5ORDSort Sequencenvarchar40
85TCGTPLIEHS: Inheritance Templates - Identifiers20ORDSort Sequencenvarchar40
86TCGTPLPEHS: Inheritance Templates - Properties18ORDSort Sequencenvarchar40
87TCGTPLUEHS: Inheritance Templates - Usages19ORDSort Sequencenvarchar40
88TCG_LOG_FIELDSEHS: Customizing: Contexts Fields for Change Doc. Creation4ORDSort Sequencenvarchar40
TOPResourcen Management
89FRMLC03RMS-FRM: Screen Assignment/Visible Formula Levels3ORDSort Sequencenvarchar40
90FRMLC09RMS-FRM: General Environment Parameters3ORDSort Sequencenvarchar40
91FRMLC10RMS-FRM: Language-Depend. Description for Environment Params3ORDSort Sequencenvarchar40
92FRMLC11RMS-FRM: Permitted Substance Types per Formula View4ORDSort Sequencenvarchar40
93FRMLC21RMS-FRM: API Entity Types - Structural Part3ORDSort Sequencenvarchar40
94FRMLC25RMS-FRM: Status Codes and Messages3ORDSort Sequencenvarchar40
95FRMLC27RMS-FRM: API Entity Types - Attribute Part2ORDSort Sequencenvarchar40
96FRMLC43Structure for Views - Customizing3ORDSort Sequencenvarchar40
97RMSAC_PPDEFRMS-ATL: Definition of Process Parameters4ORDSort Sequencenvarchar40
98RMSAC_PP_DEFRMS-ATL: (Obsolete)3ORDSort Sequencenvarchar40
99RMXTT_TRIAL_PPTrial: Process Parameter Result11ORDItem in Process Parameter Value Assignmentnvarchar40
TOPRuntime Analysis
100SATR_HIT_HIEREvent Hierarchy for SE30 and Hit List Compare10ORDnvarchar30
TOPSales
101ERP_SLS_LINKWorklist Subset Link14ORDSequential Numbers - Sequencenvarchar30
102ERP_SLS_SUBSETWorklist Subset9ORDSequential Numbers - Sequencenvarchar30
TOPWaste Management
103EHSWAC_EAFOFCATFunctions per Document Category in Disposal Processing5ORDSort Sequence for the Functionnvarchar40
104EHSWAC_EAOPTCATApplication Functions per Doc. Categ. in Disposal Processing4ORDSort Sequence for the Application Toolbar Functionsnvarchar40
105EHSWAC_MNFOFFunctions for Disposal Processing5ORDSequence of Functions in the Application Toolbarnvarchar20
106EHSWAC_MNSTATUSCustomizing Table Status Waste Manifests3ORDSequence in which the Status Nodes Are Displayed in the Treenvarchar20
107EHSWAC_MNTABSCustomizing Tab Pages4ORDSort Sequencenvarchar40
108EHSWAC_MN_CATSTADocument Type and Status Assignment4ORDSequence in which the Status Nodes Are Displayed in the Treenvarchar20
109EHSWAT003MD (BDT): Disposal Channel20ORDSort Sequencenvarchar40