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

113 columns | Print definition?ERP 6.0  | FDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/GL1VIndex Values3FDATEDate As of Which the Exchange Rate Is Effectivenvarchar80
2DFKKBPLOCKFI-CA: Business Partner Locks5FDATELock valid fromnvarchar80
3DFKKBPLOCKHFI-CA: Business Partner Locks - History7FDATELock valid fromnvarchar80
4ETALLPAIRS_HEADHeader Data of AllPairs Objects6FDATECreated onnvarchar80
5PA0429HR Master Record, Infotype 042928FDATEnvarchar80
6PA0432HR Master Record, Infotype 043226FDATEnvarchar80
7PB0432HR Master Record, Infotype 043226FDATEnvarchar80
8REFXCN_CD_ADJCondition Adjustment8FDATEPosting Datenvarchar80
9HRP1707Database Table for Infotype 170719FDATECreated Onnvarchar80
TOPASAP AcceleratedSAP
10IATNODE01Node Table for Implementation Assistant31FDATECreated onnvarchar80
11TCUSTEMPCustomizing templates entity table4FDATEDate creatednvarchar80
12TNODEREVStructure Item Table for Review Structures31FDATECreated onnvarchar80
TOPASAP Tools and Contents
13SMAPTNODESolution Map: Node table31FDATECreated onnvarchar80
TOPAuthoring Tools
14QMM_NODEQMM: Node Table for General Structure Storage31FDATECreated onnvarchar80
TOPBasic Functions
15T830AFI-SL Master Record Table4FDATEValid from date (inverted: 99999999 - YYYYMMDD)nvarchar80
16T830BFI-SL Master Record Table4FDATEValid from date (inverted: 99999999 - YYYYMMDD)nvarchar80
17T830DFI-SL Master Record Table4FDATEValid from date (inverted: 99999999 - YYYYMMDD)nvarchar80
18T831AFI-SL Master data text5FDATEValid from date (inverted: 99999999 - YYYYMMDD)nvarchar80
19T831BFI-SL Master Record Table5FDATEValid from date (inverted: 99999999 - YYYYMMDD)nvarchar80
20T831DFI-SL Master data text5FDATEValid from date (inverted: 99999999 - YYYYMMDD)nvarchar80
21T884HHistorical currency translation7FDATEDelimitation datenvarchar80
TOPBusiness Navigator
22BMTNODE01Structure repository for process model objects: Node table31FDATECreated onnvarchar80
23DFTNODE01Structure repository for process model objects: Node table31FDATECreated onnvarchar80
TOPCanada
24T5KSNROE Serial Number10FDATEDate of first day workednvarchar80
TOPCollectionsDisbursements
25DIMACOPASTReversal of Contracts in CO-PA4FDATEPosting Date in the Documentnvarchar80
TOPContract Accounts Receivable and Payable
26DFKKCFCSLOCKSFI-CA Locks11FDATELock valid fromnvarchar80
27DFKKLOCKSFI-CA: Business Locks6FDATELock valid fromnvarchar80
28DFKKLOCKSHBusiness Lock Histories7FDATELock valid fromnvarchar80
29DFKKOPLLocks for Open Items (Change Document Interface)7FDATELock valid fromnvarchar80
30DFKKORDERLOCKSRequests: Processing Locks7FDATELock valid fromnvarchar80
31DFKKORDERLOCKS_SRequest Templates: Processing Locks7FDATELock valid fromnvarchar80
32DFKKPNBKAPrenotification data (latest)22FDATEPrenotification Valid-From Datenvarchar80
33DFKKPNBKHPrenotification data (history)22FDATEPrenotification Valid-From Datenvarchar80
34DFKKUREUpdate Run: Defective Data Records21FDATEValid-From Date of Processing Locknvarchar80
35DFKK_IPL_CTRLControl Entries for Installment Plan Key Date Recording4FDATEInstallment Due Dates Beginning Fromnvarchar80
TOPCross-System Tools
36MCSTATLISTMultiple Client Analysis: Status List11FDATEDatenvarchar80
TOPCustomizing Tools Techniques
37TCTM_ATTRTable of Attributes for Context Management5FDATECreation Datenvarchar80
38TCTM_COTYCentral Context Management Context Object Types8FDATECreation Datenvarchar80
TOPDenmark
39T5MY0HR-DK: Year-End Activities for PBS6FDATEDate of Closing Year-End Activities for PBSnvarchar80
TOPDocument Management Framework
40KDS_NODENode Table for General Structure Storage31FDATECreated onnvarchar80
TOPDocument Management Services
41SDOKNODESDOK: Node table for general structure repository31FDATECreated onnvarchar80
TOPeCATT Extended Computer Aided Test Tool
42ECATT_VERTable for Storing Versions of eCATTs8FDATECreated onnvarchar80
43ECBR_NODESHI3 ECBR/ECBO - Node Table for eCATT Browser Nodes31FDATECreated onnvarchar80
44ECRP_DEFOBSOLETE -3FDATECreated onnvarchar80
45ECSD_DEFTable for Defining System Data Containers3FDATECreated onnvarchar80
46ECSP_DEFTable for eCATT Start Profiles (eCATT Core)3FDATECreated onnvarchar80
47ECTC_ATTACHExternal Documents linked to eCATT Objects12FDATECreated onnvarchar80
48ECTC_VERTable for Storing Versions of Test Configurations8FDATECreated onnvarchar80
49ECTD_VERTable for Storing Versions of Test Data Containers8FDATECreated onnvarchar80
50ECTP_JOB_LISTForeground Scheduler: List of test executions10FDATETest Proxy: Finish date of job entry for executionnvarchar80
51ECVO_VEReCATT Table for Versions of Validation Objects8FDATECreated onnvarchar80
TOPEnvironment, Health and Safety
52T7EHS00_FKATALOGAdministration Data EH&S Question Catalog13FDATECreated Onnvarchar80
53T7EHS00_QUESTQuestionnaire Definition10FDATECreated Onnvarchar80
54T7EHS00_QUESTQIndividual Questions in Questionnaire15FDATECreated Onnvarchar80
TOPGRC Access Control Plug-In
55/VIRSA/ZFFARCHArchival Data File Information3FDATEDate in user master recordnvarchar80
TOPHierarchy Storage
56TARCH01Node Table for General Structure Storage31FDATECreated onnvarchar80
57TNODE01Node Table for General Structure Storage31FDATECreated onnvarchar80
58TNODEHList of valid node types4FDATECreated onnvarchar80
59TRTYPEHList of valid link types11FDATECreated onnvarchar80
60TTREEDefinition table for structures15FDATECreated onnvarchar80
61TTREETYPEList of valid structure types10FDATECreated onnvarchar80
62TTREVVersions: Header Data14FDATECreated onnvarchar80
63TTREV_NODEHierarchy Tool: Structure Versioning Node Table27FDATECreated onnvarchar80
64TTREV_VLNKHierarchy Tool: Link Original/Version4FDATECreated onnvarchar80
TOPImplementation Guide
65CUS_ATRVSEAttribute Variant Sequence7FDATESystem Datenvarchar80
66CUS_IMGACHIMG Activities7FDATECreated onnvarchar80
67DSYAHStructures: Header Data8FDATEDate documentation was creatednvarchar80
68DSYAVStructures: Directory of Views on Books6FDATEDate documentation was creatednvarchar80
69DSYOHHypertext: Version Management Structure9FDATEDate creatednvarchar80
70DSYOIDSYS Grouping - Aspect, Status, Version, Processed by8FDATEDate creatednvarchar80
71EXCEPT1IMG Activity-Specific BC Set Error Exception Table19FDATEDatenvarchar80
72EXCEPT2Object-Specific BC Set Error Case Exception Table16FDATEDatenvarchar80
73TCUSPCustomizing: Implementation project profile12FDATEDate creatednvarchar80
74TCUSP40Customizing: Implementation project profile12FDATEDate creatednvarchar80
75TDOKUIMGNode Table for General Structure Storage31FDATECreated onnvarchar80
76TNODEIMGNode table for the new IMG31FDATECreated onnvarchar80
77TNODEPRNode Table for General Structure Storage31FDATECreated onnvarchar80
78TNODERELNNode Table for General Structure Storage31FDATECreated onnvarchar80
79TPRCLASSProject Management Project Classes3FDATEDate creatednvarchar80
80TPROJECTSPROJECT: Project Table22FDATEDate creatednvarchar80
81TSTAHPRStatus: Project Status Information18FDATEDate creatednvarchar80
82TSTAHTWTWB Status Management: Status Information22FDATEDate creatednvarchar80
83TSTATHStatus fields for an activity in a project22FDATEDate creatednvarchar80
84TSTATH4Status information for Test Workbench10FDATEDate creatednvarchar80
85TVARHHeader entries for screen variants6FDATEDate documentation was creatednvarchar80
TOPInvoicing
86EABPJVL_CORRCorrespondence Print: Bud. Bill. Plan Header and YAP Info.25FDATELock valid fromnvarchar80
87EJVLYearly Advance Payment22FDATELock valid fromnvarchar80
TOPJoint Venture und Production Sharing Accounting
88T8JGValid Investment Group5FDATEValid from date (inverted: 99999999 - YYYYMMDD)nvarchar80
TOPKnowledge Warehouse
89CUSTNODENode Table for General Structure Storage31FDATECreated onnvarchar80
90IWB0NODENode Table for General Structure Storage31FDATECreated onnvarchar80
91IWB1NODENode Table for General Structure Storage31FDATECreated onnvarchar80
92IWB2NODENode Table for General Structure Storage31FDATECreated onnvarchar80
93IWB7NODENode Table for General Structure Storage31FDATECreated onnvarchar80
94KWN_NODENode Table for General Structure Storage31FDATECreated onnvarchar80
95TXML_NODEXML: table of nodes31FDATECreated onnvarchar80
TOPPackage Tools
96APAUSEDBasis Objects Used in Other Packages12FDATEDate creatednvarchar80
97APAUSED_TESTBasis Objects Used in Other Packages12FDATEDate creatednvarchar80
TOPPerformance Assessment Workbench
98KWPWNODENode Table for General Structure Storage31FDATECreated onnvarchar80
TOPProduct Cost Planning
99TCWB_TESTDATATestdaten13FDATEErstellungsdatumnvarchar80
100TDATASETCATT-Daten14FDATEErstellungsdatumnvarchar80
TOPProfitability Analysis
101TKENODE01CO-PA: Node Table for General Structure Repository31FDATECreated onnvarchar80
TOPSAPscript
102TFORM01Node Table for SAPscript Form Tree31FDATECreated onnvarchar80
TOPService
103DVS1NODENode Table for General Structure Storage31FDATECreated onnvarchar80
TOPSession Manager
104BMENTTREEDefinition Table for Structures12FDATECreated onnvarchar80
105TMENU01Node Table for General Structure Storage31FDATECreated onnvarchar80
106TMENUBK01Node Table for General Structure Storage31FDATECreated onnvarchar80
TOPSwitch Framework Tools
107SFW_BFC_CTCLink Business Function - Customer Test Catalog5FDATECreated onnvarchar80
108SFW_BFC_CUSTTCCustomer's Test Catalog of Business Functions5FDATECreated onnvarchar80
TOPTest Organizer
109TNODE02Test Organizer, Node Table31FDATECreated onnvarchar80
110TNODE02ATest Organizer, Test Catalog, Plan, Package Attributes25FDATEDate of last status analysisnvarchar80
111TNODE02_ATest case attributes: Management3FDATECreated onnvarchar80
TOPUser Administration
112SPERS_REGPersonalization registration table19FDATEDatenvarchar80
TOPWorkbench Utilities
113RLB_DB_TRReuse Library: Structure Repository: Nodes31FDATECreated onnvarchar80