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

141 columns | Print definition?ERP 6.0  | CH_USER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVMBTGLBVARINFOPIFD Global Variant header table5CH_USERChanged bynvarchar120
2FDT_BRS_CC_0000BRS Managed System: Meta data of generate code8CH_USERUser Namenvarchar120
3FDT_BRS_CC_0010BRS DSM: ID for the generated code (Function)6CH_USERUser Namenvarchar120
4FDT_BRS_CC_0010SBRS DSM: ID for the generated code (Function)5CH_USERUser Namenvarchar120
5FDT_CI_SETTINGFDT: Client Ind. Settings Parameter Table for Boolean Values4CH_USERUser Namenvarchar120
6FDT_CI_TEXT_SETFDT: Client Independent Settings Parameter Table4CH_USERUser Namenvarchar120
7FDT_TRANS_Q_0011FDT: Transport Activation Queue - Merge Transport10CH_USERUser Namenvarchar120
8GDV_T_SNAP_DATASerialized Expected Values6CH_USERUser Namenvarchar120
9J_3RF_CTS_HCurrency Transaction Statement Document Header23CH_USERName of Person Who Changed the Documentnvarchar120
10LTR_ANYHeader Table for any LTR Object12CH_USERUser Namenvarchar120
11LTR_ANY_BACKUPHeader Table for any LTR Object12CH_USERUser Namenvarchar120
12LXE_CSN_LOGLog Data for Notes5CH_USERUser Namenvarchar120
13TRANSL_ASSIGNMNTAssignments6CH_USERLast Changed bynvarchar120
14TRANSL_GRAPHTranslation Graph Header Data3CH_USERLast Changed bynvarchar120
15TSCON_T_CONProject creation connection4CH_USERLast Changed bynvarchar120
TOPBRFplus - ABAP-Based Business Rules
16FDT_ADMN_0000FDT: Central Administrative Data10CH_USERUser Namenvarchar120
17FDT_ADMN_0000AFDT: Central Administrative Data10CH_USERUser Namenvarchar120
18FDT_ADMN_0000SFDT: Central Administrative Data9CH_USERUser Namenvarchar120
19FDT_ADMN_0000TFDT: Central Administrative Data9CH_USERUser Namenvarchar120
20FDT_SETTINGFDT: Settings Parameter Table for Boolean Values5CH_USERUser Namenvarchar120
21FDT_TEXT_SETTINGFDT: Settings Parameter Table5CH_USERUser Namenvarchar120
22FDT_TRANS_Q_0001FDT: Transport Activation Queue - Merge Transport9CH_USERUser Namenvarchar120
TOPClient Copy
23CCPROFClient copy profiles19CH_USERUser of last changenvarchar120
TOPDocument Management System
24DRZAODDS: task-specific data for recipient list6CH_USERLast Changed Bynvarchar120
25DRZOCDDS: partial order22CH_USERLast Changed Bynvarchar120
TOPIntercompany Data Exchange
26TINV_INV_TMPLTBill Document: Template11CH_USERName of Person Who Changed Objectnvarchar120
TOPRemote Logistics Management
27OIO_MX_INDEXRLM material tracking extract index13CH_USERName of Person Who Changed Objectnvarchar120
28OIO_RT_RTDOCRLM returns document - header16CH_USERName of Person Who Changed Objectnvarchar120
29OIO_SH_VOYAGEVoyages20CH_USERName of Person Who Changed Objectnvarchar120
TOPTranslation Tools
30LXEPROFTranslation Authorization Profiles3CH_USERLast Changed bynvarchar120
31LXEPROFVValues for Translation Authorization Profiles4CH_USERLast Changed bynvarchar120
32LXE_COLLList of all Collections with their Attributes6CH_USERLast Changed bynvarchar120
33LXE_COLLTLTarget Languages for a Collection7CH_USERLast Changed bynvarchar120
34LXE_COPYObjects4CH_USERLast Changed bynvarchar120
35LXE_CO_GRAssignments6CH_USERLast Changed bynvarchar120
36LXE_CO_LKLocks6CH_USERLast Changed bynvarchar120
37LXE_CSN_BKNotes8CH_USERLast Changed bynvarchar120
38LXE_CSN_HDNotes12CH_USERLast Changed bynvarchar120
39LXE_CSN_TXLNotes8CH_USERLast Changed bynvarchar120
40LXE_CSN_TXSNotes7CH_USERLast Changed bynvarchar120
41LXE_CUSTTranslation Areas7CH_USERLast Changed bynvarchar120
42LXE_CUSTMNRTranslation Areas7CH_USERLast Changed bynvarchar120
43LXE_DEMODemonstration Table5CH_USERLast Changed bynvarchar120
44LXE_DOMADomains5CH_USERLast Changed bynvarchar120
45LXE_DOMA_2Package Assignment to Domains5CH_USERLast Changed bynvarchar120
46LXE_DOMA_PDomains4CH_USERLast Changed bynvarchar120
47LXE_FIPRCheck Sum9CH_USERLast Changed bynvarchar120
48LXE_GRAPHTranslation Graph Header Data3CH_USERLast Changed bynvarchar120
49LXE_GRAPH2Translation graph7CH_USERLast Changed bynvarchar120
50LXE_KTP_COLLCollections11CH_USERLast Changed bynvarchar120
51LXE_LANGTranslation Environment: Target Languages and Attributes 12CH_USERLast Changed bynvarchar120
52LXE_LANGTR2Translation exclusions6CH_USERLast Changed bynvarchar120
53LXE_LANG_PRESETSDefault Settings per Language5CH_USERLast Changed bynvarchar120
54LXE_LA_CLTranslation Environment: Target Languages and Attributes 23CH_USERLast Changed bynvarchar120
55LXE_LA_DRSecondary Status Selection for Languages6CH_USERLast Changed bynvarchar120
56LXE_LA_OBAssignment: Language - Object Type6CH_USERLast Changed bynvarchar120
57LXE_LISTLocal Lists4CH_USERLast Changed bynvarchar120
58LXE_LIST_DLocal Lists5CH_USERLast Changed bynvarchar120
59LXE_LIST_SRLocal Lists4CH_USERLast Changed bynvarchar120
60LXE_LIST_SXLocal Lists4CH_USERLast Changed bynvarchar120
61LXE_MAILMail addresses4CH_USERUser Namenvarchar120
62LXE_NUMBERNumber5CH_USERLast Changed bynvarchar120
63LXE_OBJLNumber5CH_USERLast Changed bynvarchar120
64LXE_PARAM_BDLTranslation3CH_USERLast Changed bynvarchar120
65LXE_PARAM_JTranslation3CH_USERLast Changed bynvarchar120
66LXE_PARAM_KTPTranslation3CH_USERLast Changed bynvarchar120
67LXE_PARAM_NWTranslation3CH_USERLast Changed bynvarchar120
68LXE_PARAM_P4Translation3CH_USERLast Changed bynvarchar120
69LXE_PARAM_S2XTranslation3CH_USERLast Changed bynvarchar120
70LXE_PARAM_XITranslation3CH_USERLast Changed bynvarchar120
71LXE_PARAM_ZTYPETranslation3CH_USERLast Changed bynvarchar120
72LXE_PC2_HDHeader Data for PC* Objects5CH_USERLast Changed bynvarchar120
73LXE_PC2_XI_HDHeader Data for PC* Objects8CH_USERLast Changed bynvarchar120
74LXE_PCX_HDPCX Objects: Header Data7CH_USERLast Changed bynvarchar120
75LXE_PCX_HD_APCX Objects: Header Data7CH_USERLast Changed bynvarchar120
76LXE_PCX_HD_BPCX Objects: Header Data7CH_USERLast Changed bynvarchar120
77LXE_PCX_HD_CPCX Objects: Header Data7CH_USERLast Changed bynvarchar120
78LXE_PCX_HD_DPCX Objects: Header Data7CH_USERLast Changed bynvarchar120
79LXE_PCX_HD_FPCX Objects: Header Data7CH_USERLast Changed bynvarchar120
80LXE_PCX_HD_GPCX Objects: Header Data7CH_USERLast Changed bynvarchar120
81LXE_PCX_HD_HPCX Objects: Header Data7CH_USERLast Changed bynvarchar120
82LXE_PCX_HD_LPCX Objects: Header Data7CH_USERLast Changed bynvarchar120
83LXE_PCX_HD_MPCX Objects: Header Data7CH_USERLast Changed bynvarchar120
84LXE_PCX_HD_RPCX Objects: Header Data7CH_USERLast Changed bynvarchar120
85LXE_PCX_HD_SPCX Objects: Header Data7CH_USERLast Changed bynvarchar120
86LXE_PCX_HD_TPCX Objects: Header Data7CH_USERLast Changed bynvarchar120
87LXE_PCX_HD_UPCX Objects: Header Data7CH_USERLast Changed bynvarchar120
88LXE_PCY_HDPCY Objects: Header Data7CH_USERLast Changed bynvarchar120
89LXE_PCY_HD_APCY Objects: Header Data7CH_USERLast Changed bynvarchar120
90LXE_PCY_HD_BPCY Objects: Header Data7CH_USERLast Changed bynvarchar120
91LXE_PCY_HD_DPCY Objects: Header Data7CH_USERLast Changed bynvarchar120
92LXE_PCY_HD_FPCY Objects: Header Data7CH_USERLast Changed bynvarchar120
93LXE_PCY_HD_GPCY Objects: Header Data7CH_USERLast Changed bynvarchar120
94LXE_PCY_HD_IPCY Objects: Header Data7CH_USERLast Changed bynvarchar120
95LXE_PCY_HD_LPCY Objects: Header Data7CH_USERLast Changed bynvarchar120
96LXE_PCY_HD_MPCY Objects: Header Data7CH_USERLast Changed bynvarchar120
97LXE_PCY_HD_TPCY Objects: Header Data7CH_USERLast Changed bynvarchar120
98LXE_PCY_VNVersion Numbers of PCY Objects11CH_USERLast Changed bynvarchar120
99LXE_PCY_VN_AVersion Numbers of PCY Objects11CH_USERLast Changed bynvarchar120
100LXE_PCY_VN_BVersion Numbers of PCY Objects11CH_USERLast Changed bynvarchar120
101LXE_PCY_VN_DVersion Numbers of PCY Objects11CH_USERLast Changed bynvarchar120
102LXE_PCY_VN_FVersion Numbers of PCY Objects11CH_USERLast Changed bynvarchar120
103LXE_PCY_VN_GVersion Numbers of PCY Objects11CH_USERLast Changed bynvarchar120
104LXE_PCY_VN_IVersion Numbers of PCY Objects11CH_USERLast Changed bynvarchar120
105LXE_PCY_VN_LVersion Numbers of PCY Objects11CH_USERLast Changed bynvarchar120
106LXE_PCY_VN_MVersion Numbers of PCY Objects11CH_USERLast Changed bynvarchar120
107LXE_PCY_VN_TVersion Numbers of PCY Objects11CH_USERLast Changed bynvarchar120
108LXE_PCZ_HDPCZ Objects: Header Data7CH_USERLast Changed bynvarchar120
109LXE_PCZ_HD_APCZ Objects: Header Data7CH_USERLast Changed bynvarchar120
110LXE_PCZ_HD_FPCZ Objects: Header Data7CH_USERLast Changed bynvarchar120
111LXE_PCZ_HD_HPCZ Objects: Header Data7CH_USERLast Changed bynvarchar120
112LXE_PCZ_HD_IHeader Data of PCZ Objects7CH_USERLast Changed bynvarchar120
113LXE_PCZ_HD_SHeader Data of PCZ Objects7CH_USERLast Changed bynvarchar120
114LXE_PCZ_HD_ZPCZ Objects: Header Data7CH_USERLast Changed bynvarchar120
115LXE_PCZ_VNVersion Numbers of PCZ Objects11CH_USERLast Changed bynvarchar120
116LXE_PCZ_VN_AVersion Numbers of PCZ Objects11CH_USERLast Changed bynvarchar120
117LXE_PCZ_VN_FVersion Numbers of PCZ Objects11CH_USERLast Changed bynvarchar120
118LXE_PCZ_VN_HVersion Numbers of PCZ Objects11CH_USERLast Changed bynvarchar120
119LXE_PCZ_VN_IVersion Numbers of PCZ Objects11CH_USERLast Changed bynvarchar120
120LXE_PCZ_VN_SVersion Numbers of PCZ Objects11CH_USERLast Changed bynvarchar120
121LXE_PCZ_VN_ZVersion Numbers of PCZ Objects11CH_USERLast Changed bynvarchar120
122LXE_PC_FIPCheck Sum9CH_USERLast Changed bynvarchar120
123LXE_PC_FIP_ONEChecksum for Single Object9CH_USERLast Changed bynvarchar120
124LXE_PC_HDPC* Objects: Header Data11CH_USERLast Changed bynvarchar120
125LXE_PC_TTXHBinary Data for Objects13CH_USERLast Changed bynvarchar120
126LXE_TAMO_ABORTTable to Deactivate Hard Termination After TAMO Errors3CH_USERLast Changed bynvarchar120
127LXE_TEAMTranslator Team2CH_USERLast Changed bynvarchar120
128LXE_TGROUPTranslator Group2CH_USERLast Changed bynvarchar120
129LXE_TMTranslation3CH_USERLast Changed bynvarchar120
130LXE_TM9Translation5CH_USERLast Changed bynvarchar120
131LXE_TMP_STLocal Temporary Storage9CH_USERLast Changed bynvarchar120
132LXE_TRDELTADates for Delta Transports of Translations5CH_USERUser Namenvarchar120
133LXE_TTXBinary Data for Objects11CH_USERLast Changed bynvarchar120
134LXE_USERAssignments6CH_USERLast Changed bynvarchar120
135LXE_US_COAssignments6CH_USERLast Changed bynvarchar120
136LXE_US_COLAssignments (Backup)6CH_USERLast Changed bynvarchar120
137LXE_WLTranslation Environment: Target Languages and Attributes 12CH_USERLast Changed bynvarchar120
138LXE_WRK_1Number4CH_USERLast Changed bynvarchar120
139LXE_XT_HEADERObject Headers10CH_USERLast Changed bynvarchar120
140LXE_XT_HEAD_LANGLanguage Headers6CH_USERLast Changed bynvarchar120
TOPTransport Management System
141TMSQASTEPSTMS QA: Request Approval Steps14CH_USERLast Changed bynvarchar120