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

110 columns | Print definition?ERP 6.0  | REC_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/XFT/CM_001Contract: head2REC_IDRecord IDnvarchar320
2/XFT/CM_002Contract: Dsitributor automatic notification2REC_IDRecord IDnvarchar320
3/XFT/CM_100Contract: Order table for autom. sending of notifications2REC_IDRecord IDnvarchar320
4/XFT/CM_100_AContract: Order table autom. sending of notification (arch.)2REC_IDRecord IDnvarchar320
5/XFT/QMPPAPT001QM Sampling Header Table2REC_IDRecord IDnvarchar320
6/XFT/QMPPAPT002QM Sampling Multivalue Attribute: Customer Number2REC_IDRecord IDnvarchar320
7/XFT/SOP_001SOP: head2REC_IDRecord IDnvarchar320
8/XFT/SOP_050SOP: Effective SOPs2REC_IDRecord IDnvarchar320
9/XFT/SOP_050ASOP: Effective SOPs2REC_IDRecord IDnvarchar320
10/XFT/SOP_051SOP: Effective SOPs - User2REC_IDRecord IDnvarchar320
11/XFT/SOP_051ASOP: Effective SOPs - User (Archive)2REC_IDRecord IDnvarchar320
12/XFT/SOP_100SOP: node2REC_IDRecord IDnvarchar320
13/XFT/SOP_101SOP: Released Documents of a Major Version2REC_IDRecord IDnvarchar320
14/XFT/SOP_200SOP: Cycle minor version release3REC_IDRecord IDnvarchar320
15/XFT/SOP_ORG001SOP Organizer: History for User3REC_IDRecord IDnvarchar320
16/XFT/SOP_ORG002SOP Organizer: Favorites3REC_IDRecord IDnvarchar320
17/XFT/SRMDOCTT001Properties: Admin Records Document Templates (Record)2REC_IDRecord IDnvarchar320
18/XFT/SRMDOCTT002Document Template Content Versions by Language2REC_IDRecord IDnvarchar320
19/XFT/SRMDOCTT003Form Fields: Catalogs2REC_IDRecord IDnvarchar320
20/XFT/SRMDOCTT004Short Description: Form Fields2REC_IDRecord IDnvarchar320
21/XFT/SRMDOCTT005Document Template Language Version: Node ID2REC_IDRecord IDnvarchar320
22/XFT/SRMDPDISPCircular3REC_IDRecord IDnvarchar320
23/XFT/SRMPS001WBS Element Records: Link to WBS Element (No Change)2REC_IDRecord IDnvarchar320
24/XFT/SRMPS100WBS Records: Link WBS (No Change)2REC_IDRecord IDnvarchar320
25/XFT/SRM_CAN01Structure Component Maintenance: Header2REC_IDRecord IDnvarchar320
26/XFT/SRM_CAN02Component Structure: Components2REC_IDRecord IDnvarchar320
27/XFT/SRM_CAN10CAN: Classification and Navigation2REC_IDRecord IDnvarchar320
28/XFT/SRM_DEMO_10Patent6REC_IDRecord IDnvarchar320
29/XFT/SRM_REC02Record: Header2REC_IDRecord IDnvarchar320
30/XFT/SRM_REC03Record: Short Description3REC_IDRecord IDnvarchar320
31/XFT/SRM_REC04Record: Agents2REC_IDRecord IDnvarchar320
32/XFT/SRM_REC04ARecord: Roles - Visibility2REC_IDRecord IDnvarchar320
33/XFT/SRM_REC05Record Node: Header2REC_IDRecord IDnvarchar320
34/XFT/SRM_REC06Record Node: Short Description3REC_IDRecord IDnvarchar320
35/XFT/SRM_REC07Record Node: Agents2REC_IDRecord IDnvarchar320
36/XFT/SRM_REC08Record Node: Serialized Data2REC_IDRecord IDnvarchar320
37/XFT/SRM_REC09Record Node: Roles - Visibility2REC_IDRecord IDnvarchar320
38/XFT/SRM_REC10Record node: CHAR80 data (SP POID, context, ..)2REC_IDRecord IDnvarchar320
39/XFT/SRM_REC11Record Node: STRING data (SP POID, context, ..)2REC_IDRecord IDnvarchar320
40/XFT/SRM_REC15Record node: User groups2REC_IDRecord IDnvarchar320
41/XFT/SRM_REC20Node Log: Record and templates2REC_IDRecord IDnvarchar320
42/XFT/SRM_REC20ANode Log: Record and Template: Values of Category2REC_IDRecord IDnvarchar320
43/XFT/SRM_REC20BNode Log: Record and Template: Values of Category2REC_IDRecord IDnvarchar320
44/XFT/SRM_REC21Log: Record and Template2REC_IDRecord IDnvarchar320
45/XFT/SRM_REC21ALog: Record and Template: Category Values2REC_IDRecord IDnvarchar320
46/XFT/SRM_REC33Process instance: Header2REC_IDRecord IDnvarchar320
47/XFT/SRM_REC34Process instance: Node2REC_IDRecord IDnvarchar320
48/XFT/SRM_REC35Process instance: Messages2REC_IDRecord IDnvarchar320
49/XFT/SRM_REC36Process instance: Short description2REC_IDRecord IDnvarchar320
50/XFT/SRM_REC37Process instance: Agent2REC_IDRecord IDnvarchar320
51/XFT/SRM_REC50Record node: POIN directory ID2REC_IDRecord IDnvarchar320
52/XFT/SRM_REC60Clipboard: Record Node2REC_IDRecord IDnvarchar320
53/XFT/SRM_REC61Clipboard: Record Node Note2REC_IDRecord IDnvarchar320
54/XFT/SRM_REC65Preview: Record node2REC_IDRecord IDnvarchar320
55/XFT/SRM_REC66Preview: Record node conversion requests2REC_IDRecord IDnvarchar320
56/XFT/SRM_REC90Cycle3REC_IDRecord IDnvarchar320
57/XFT/SRM_REC99Record: Synchronization OPEN - SAVE in Update Task2REC_IDRecord IDnvarchar320
58/XFT/SRM_RECT02Template: Header2REC_IDRecord IDnvarchar320
59/XFT/SRM_RECT02ATemplate: Header - specific properties2REC_IDRecord IDnvarchar320
60/XFT/SRM_RECT03Template: Short Description3REC_IDRecord IDnvarchar320
61/XFT/SRM_RECT04Template: Agents2REC_IDRecord IDnvarchar320
62/XFT/SRM_RECT05Template Node: Header2REC_IDRecord IDnvarchar320
63/XFT/SRM_RECT05ATemplate Nodes: Header - Specific Properties2REC_IDRecord IDnvarchar320
64/XFT/SRM_RECT06Template Node: Short Description3REC_IDRecord IDnvarchar320
65/XFT/SRM_RECT07Template Node: Agents2REC_IDRecord IDnvarchar320
66/XFT/SRM_RECT08Template Node: Serialized Data2REC_IDRecord IDnvarchar320
67/XFT/SRM_RECT09Template Node: Roles - Visibility2REC_IDRecord IDnvarchar320
68/XFT/SRM_RECT10Template node: CHAR80 data (SP POID, context, ..)2REC_IDRecord IDnvarchar320
69/XFT/SRM_RECT11Template node: STRING data (SP POID, context, ..)2REC_IDRecord IDnvarchar320
70/XFT/SRM_RECT50Template: Process settings2REC_IDRecord IDnvarchar320
71/XFT/SRM_RECT51Template: Process settings, short description3REC_IDRecord IDnvarchar320
72/XFT/SRM_RECT55Template: Sort profile2REC_IDRecord IDnvarchar320
73/XFT/SRM_RECT99Template: Synchronization OPEN - SAVE in Update Task2REC_IDRecord IDnvarchar320
74BKKPOMNDPayment order Enriched with Mandate details43REC_IDSEPA Mandate: Recipient IDnvarchar700
75ZXFT_LS_CHMT01Change Request Properties2REC_IDRecord IDnvarchar320
TOPBank
76SEPA_MANDATESEPA Mandate46REC_IDSEPA Mandate: Recipient IDnvarchar700
TOPCollaborative Cross Applications
77/POA/D_CLM_IOBUFInput/Output Buffer2REC_IDNatural Numberint100
TOPeCATT Extended Computer Aided Test Tool
78ECTRACEeCATT Recordings2REC_IDeCATT Recorder Recording Session IDvarbinary160
79ECTRACE_CONTENTeCATT Trace - Recordings in the Test Content System2REC_IDeCATT Recorder Recording Session IDvarbinary160
80ECTR_ACTIVATEeCATT Activation Cross-Session Recording5REC_IDeCATT Recorder Recording Session IDvarbinary160
81ECTR_ACTIVATE_CSeCATT Activation Cross-Session Recording - 23REC_IDeCATT Recorder Recording Session IDvarbinary160
82ECTR_ACTIVATE_ESeCATT Activation Cross-Session Recording - 23REC_IDeCATT Recorder Recording Session IDvarbinary160
TOPIncident Recording
83EHHSSD_INC_PSTATIncident - Person Statement12REC_IDStatement Recordernvarchar130
TOPMaster Data
84JST_KGS_CONSIS-M: Table for DMK Consolidation1REC_IDnvarchar100
85JST_KGS_RAWPDU Raw Data for District Mun. Key1REC_IDnvarchar100
86JST_KGS_STATEStatus of DMK Checks1REC_IDnvarchar100
87JST_ORT_CONSIS-M: Table for City Consolidation1REC_IDnvarchar100
88JST_ORT_RAWPDU Raw Data for Cities1REC_IDnvarchar100
89JST_ORT_STATEStatus of City Checks1REC_IDnvarchar100
90JST_OTL_CONSIS-M: Table for City District Consolidation1REC_IDnvarchar100
91JST_OTL_RAWPDU Raw Data for City Districts1REC_IDnvarchar100
92JST_OTL_STATEStatus of CDT Checks1REC_IDnvarchar100
93JST_PLZ_CONSIS-M: Table for Postal Code Consolidation1REC_IDnvarchar100
94JST_PLZ_RAWPDU Raw Data for Postal Codes1REC_IDnvarchar100
95JST_PLZ_STATEStatus of Postal Code Checks1REC_IDnvarchar100
96JST_POF_CONSIS-M: Table for PO Box Consolidation1REC_IDnvarchar100
97JST_POF_RAWPDU Raw Data for PO Boxes1REC_IDnvarchar100
98JST_POF_STATEStatus of PO Box Checks1REC_IDnvarchar100
99JST_STR_CONSIS-M: Table for Street Consolidation1REC_IDnvarchar100
100JST_STR_RAWPDU Raw Data for Streets1REC_IDnvarchar100
101JST_STR_STATEStatus of Street Checks1REC_IDnvarchar100
TOPPeriodical Sales and Distribution
102JST_PLO_CONSIS-M: Table for Consolidating Postal Code-City1REC_IDnvarchar100
103JST_PLO_STATEStatus of Postal Code Checks1REC_IDnvarchar100
TOPQuality Management
104ZPH_ENH_SRMT01Change Request Properties2REC_IDRecord IDnvarchar320
TOPRevenue
105OIUH_RV_CW_BATCHCheckwrite Parms for the batch execution process3REC_ID2-Digit Numeric Valuenvarchar20
TOPSAP Records Management
106SRMALATTRLDSAttribute Memrory, Language-Dependent, Single-Value2REC_IDAttribute Record IDnvarchar320
107SRMALATTRLIMSRM SP AL: Table for Multi-Value Attributes - PU2REC_IDAttribute Record IDnvarchar320
108SRMALATTRLISAttribute Memory, Language-Independent, Single-Value2REC_IDAttribute Record IDnvarchar320
TOPUser and Authorization Management
109TUL_ENG_RESULTSystem Measurement: Engine Use Logs6REC_IDNatural Numberint100
110TUL_ENG_RESULT_1System Measurement: Engine Use Logs6REC_IDNatural Numberint100