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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

156 columns | Print definition?ERP 6.0  | CH_DATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1EBILLPRGIS-U: Billing Programs14CH_DATEChanged Onnvarchar80
2ECONDIPROCINTFIS-U: Processing Interface for Conditions14CH_DATEChanged Onnvarchar80
3ESCHEXTBilling Schema Extension (Administrative Data)6CH_DATEChanged Onnvarchar80
4ETOUEXCEPTIONTOU Exception16CH_DATEChanged Onnvarchar80
5ETOUEXCEPTRESPTOU Exception Response9CH_DATEChanged Onnvarchar80
6ETOUEXCPTPRGTOU Exception Program15CH_DATEChanged Onnvarchar80
7GDV_T_SNAP_DATASerialized Expected Values4CH_DATESystem Datenvarchar80
8LOP_D_LIST_HDOption list header39CH_DATELast Changed Onnvarchar80
9LOP_D_LIST_ITOption list items12CH_DATELast Changed Onnvarchar80
10LOP_D_MASTER_HDOption list header as master data15CH_DATELast Changed Onnvarchar80
11LOP_D_MASTER_ITOption List items as master data12CH_DATELast Changed Onnvarchar80
12TRANSL_ASSIGNMNTAssignments7CH_DATEDate of Last Changenvarchar80
13TRANSL_GRAPHTranslation Graph Header Data4CH_DATEDate of Last Changenvarchar80
14TSCON_T_CONProject creation connection5CH_DATEDate of Last Changenvarchar80
TOPAMI Event Management
15TEAMI_EM_EVTRESResults for AMI Events13CH_DATEChanged Onnvarchar80
16TEAMI_EM_EVTSIS-U AMI Event Management AMI Events17CH_DATEChanged Onnvarchar80
TOPChargeback
17WCOCOHCondition Contract: Header44CH_DATEChanged Onnvarchar80
TOPClient Copy
18CCPROFClient copy profiles20CH_DATEDate of Last Changenvarchar80
TOPCross-Application Components
19SDEPMENTDepartments: Starting Situation7CH_DATELast changed onnvarchar80
20SDEPMENT_CHDepartments: Enhance with Dept. Head and Time in Incl. (2)7CH_DATELast changed onnvarchar80
21SDEPMENT_CSHDepartments: Collective Search Help7CH_DATELast changed onnvarchar80
22SDEPMENT_SEARCHDepartments: Search Help7CH_DATELast changed onnvarchar80
23SEMPLOYESEmployee Table: Starting Version11CH_DATELast changed onnvarchar80
24SEMPLOYES_APPEmployees: Enhancement by Append (4)12CH_DATELast changed onnvarchar80
25SEMPLOYES_RBEmployees: Enhancement by No. of Agency (2)12CH_DATELast changed onnvarchar80
26SEMPLOYES_TIEmployees: Enhancement by Time Field in Include (3)12CH_DATELast changed onnvarchar80
27SEMPLOY_CSHEmployee table: Collective Search Help11CH_DATELast changed onnvarchar80
28SEMPLOY_SEARCHEmployee Table: Search Help Attachment to Table11CH_DATELast changed onnvarchar80
TOPGlobal Trade
29WB2_D_ASGT_DISTAssignment distributions12CH_DATEChanged Onnvarchar80
30WB2_D_ASSGMTAssignments22CH_DATEChanged Onnvarchar80
31WB2_D_COMSUBTrading Contract: commodity sub items16CH_DATEChanged Onnvarchar80
32WB2_D_PRASPTrading Contract: pricing aspects22CH_DATEChanged Onnvarchar80
33WB2_D_SHD_ITEMShadow Items26CH_DATEChanged Onnvarchar80
34WB2_D_SHD_PRASPPricing aspects of shadow items19CH_DATEChanged Onnvarchar80
TOPIntercompany Data Exchange
35TINV_INV_TMPLTBill Document: Template10CH_DATEChanged Onnvarchar80
TOPSAP Note Assistant
36CWB_HIST_HCorrection Workbench: History Header8CH_DATESystem Datenvarchar80
37SCWB_HISTHistory of Delta Copies in the Correction Workbench4CH_DATESystem Datenvarchar80
TOPSAP Utilities
38ISU_WUI_DOC_FLTRDocument filter criteria for user13CH_DATEChanged Onnvarchar80
39TEAMI_LOG_DATALog for Service Communication in AMI Environment23CH_DATEChanged Onnvarchar80
TOPTrading Contract
40PPE_D_ITEM_LISTEvents20CH_DATEChanged Onnvarchar80
TOPTranslation Tools
41LXEPROFTranslation Authorization Profiles4CH_DATEDate of Last Changenvarchar80
42LXEPROFVValues for Translation Authorization Profiles5CH_DATEDate of Last Changenvarchar80
43LXE_COLLList of all Collections with their Attributes5CH_DATEDate of Last Changenvarchar80
44LXE_COLLTLTarget Languages for a Collection6CH_DATEDate of Last Changenvarchar80
45LXE_COPYObjects5CH_DATEDate of Last Changenvarchar80
46LXE_CO_GRAssignments7CH_DATEDate of Last Changenvarchar80
47LXE_CO_LKLocks7CH_DATEDate of Last Changenvarchar80
48LXE_CSN_BKNotes6CH_DATEDate of Last Changenvarchar80
49LXE_CSN_HDNotes10CH_DATEDate of Last Changenvarchar80
50LXE_CSN_TXLNotes6CH_DATEDate of Last Changenvarchar80
51LXE_CSN_TXSNotes5CH_DATEDate of Last Changenvarchar80
52LXE_CUSTTranslation Areas6CH_DATEDate of Last Changenvarchar80
53LXE_CUSTMNRTranslation Areas6CH_DATEDate of Last Changenvarchar80
54LXE_DEMODemonstration Table6CH_DATEDate of Last Changenvarchar80
55LXE_DOMADomains6CH_DATEDate of Last Changenvarchar80
56LXE_DOMA_2Package Assignment to Domains6CH_DATEDate of Last Changenvarchar80
57LXE_DOMA_PDomains5CH_DATEDate of Last Changenvarchar80
58LXE_FIPRCheck Sum7CH_DATEDate of Last Changenvarchar80
59LXE_GENFLTranslation5CH_DATEDate of Last Changenvarchar80
60LXE_GRAPHTranslation Graph Header Data4CH_DATEDate of Last Changenvarchar80
61LXE_GRAPH2Translation graph8CH_DATEDate of Last Changenvarchar80
62LXE_KTP_COLLCollections10CH_DATEDate of Last Changenvarchar80
63LXE_LANGTranslation Environment: Target Languages and Attributes 13CH_DATEDate of Last Changenvarchar80
64LXE_LANGTR2Translation exclusions7CH_DATEDate of Last Changenvarchar80
65LXE_LANG_PRESETSDefault Settings per Language6CH_DATEDate of Last Changenvarchar80
66LXE_LA_CLTranslation Environment: Target Languages and Attributes 24CH_DATEDate of Last Changenvarchar80
67LXE_LA_DRSecondary Status Selection for Languages7CH_DATEDate of Last Changenvarchar80
68LXE_LA_OBAssignment: Language - Object Type7CH_DATEDate of Last Changenvarchar80
69LXE_LEXPTTranslation exception6CH_DATEDate of Last Changenvarchar80
70LXE_LISTLocal Lists5CH_DATEDate of Last Changenvarchar80
71LXE_LIST_DLocal Lists6CH_DATEDate of Last Changenvarchar80
72LXE_LIST_SRLocal Lists5CH_DATEDate of Last Changenvarchar80
73LXE_LIST_SXLocal Lists5CH_DATEDate of Last Changenvarchar80
74LXE_MAILMail addresses5CH_DATESystem Datenvarchar80
75LXE_NUMBERNumber6CH_DATEDate of Last Changenvarchar80
76LXE_OBJLNumber6CH_DATEDate of Last Changenvarchar80
77LXE_PARAM_BDLTranslation4CH_DATEDate of Last Changenvarchar80
78LXE_PARAM_JTranslation4CH_DATEDate of Last Changenvarchar80
79LXE_PARAM_KTPTranslation4CH_DATEDate of Last Changenvarchar80
80LXE_PARAM_NWTranslation4CH_DATEDate of Last Changenvarchar80
81LXE_PARAM_P4Translation4CH_DATEDate of Last Changenvarchar80
82LXE_PARAM_S2XTranslation4CH_DATEDate of Last Changenvarchar80
83LXE_PARAM_XITranslation4CH_DATEDate of Last Changenvarchar80
84LXE_PARAM_ZTYPETranslation4CH_DATEDate of Last Changenvarchar80
85LXE_PC2_HDHeader Data for PC* Objects3CH_DATEDate of Last Changenvarchar80
86LXE_PC2_XI_HDHeader Data for PC* Objects6CH_DATEDate of Last Changenvarchar80
87LXE_PCX_HDPCX Objects: Header Data5CH_DATEDate of Last Changenvarchar80
88LXE_PCX_HD_APCX Objects: Header Data5CH_DATEDate of Last Changenvarchar80
89LXE_PCX_HD_BPCX Objects: Header Data5CH_DATEDate of Last Changenvarchar80
90LXE_PCX_HD_CPCX Objects: Header Data5CH_DATEDate of Last Changenvarchar80
91LXE_PCX_HD_DPCX Objects: Header Data5CH_DATEDate of Last Changenvarchar80
92LXE_PCX_HD_FPCX Objects: Header Data5CH_DATEDate of Last Changenvarchar80
93LXE_PCX_HD_GPCX Objects: Header Data5CH_DATEDate of Last Changenvarchar80
94LXE_PCX_HD_HPCX Objects: Header Data5CH_DATEDate of Last Changenvarchar80
95LXE_PCX_HD_LPCX Objects: Header Data5CH_DATEDate of Last Changenvarchar80
96LXE_PCX_HD_MPCX Objects: Header Data5CH_DATEDate of Last Changenvarchar80
97LXE_PCX_HD_RPCX Objects: Header Data5CH_DATEDate of Last Changenvarchar80
98LXE_PCX_HD_SPCX Objects: Header Data5CH_DATEDate of Last Changenvarchar80
99LXE_PCX_HD_TPCX Objects: Header Data5CH_DATEDate of Last Changenvarchar80
100LXE_PCX_HD_UPCX Objects: Header Data5CH_DATEDate of Last Changenvarchar80
101LXE_PCY_HDPCY Objects: Header Data5CH_DATEDate of Last Changenvarchar80
102LXE_PCY_HD_APCY Objects: Header Data5CH_DATEDate of Last Changenvarchar80
103LXE_PCY_HD_BPCY Objects: Header Data5CH_DATEDate of Last Changenvarchar80
104LXE_PCY_HD_DPCY Objects: Header Data5CH_DATEDate of Last Changenvarchar80
105LXE_PCY_HD_FPCY Objects: Header Data5CH_DATEDate of Last Changenvarchar80
106LXE_PCY_HD_GPCY Objects: Header Data5CH_DATEDate of Last Changenvarchar80
107LXE_PCY_HD_IPCY Objects: Header Data5CH_DATEDate of Last Changenvarchar80
108LXE_PCY_HD_LPCY Objects: Header Data5CH_DATEDate of Last Changenvarchar80
109LXE_PCY_HD_MPCY Objects: Header Data5CH_DATEDate of Last Changenvarchar80
110LXE_PCY_HD_TPCY Objects: Header Data5CH_DATEDate of Last Changenvarchar80
111LXE_PCY_VNVersion Numbers of PCY Objects9CH_DATEDate of Last Changenvarchar80
112LXE_PCY_VN_AVersion Numbers of PCY Objects9CH_DATEDate of Last Changenvarchar80
113LXE_PCY_VN_BVersion Numbers of PCY Objects9CH_DATEDate of Last Changenvarchar80
114LXE_PCY_VN_DVersion Numbers of PCY Objects9CH_DATEDate of Last Changenvarchar80
115LXE_PCY_VN_FVersion Numbers of PCY Objects9CH_DATEDate of Last Changenvarchar80
116LXE_PCY_VN_GVersion Numbers of PCY Objects9CH_DATEDate of Last Changenvarchar80
117LXE_PCY_VN_IVersion Numbers of PCY Objects9CH_DATEDate of Last Changenvarchar80
118LXE_PCY_VN_LVersion Numbers of PCY Objects9CH_DATEDate of Last Changenvarchar80
119LXE_PCY_VN_MVersion Numbers of PCY Objects9CH_DATEDate of Last Changenvarchar80
120LXE_PCY_VN_TVersion Numbers of PCY Objects9CH_DATEDate of Last Changenvarchar80
121LXE_PCZ_HDPCZ Objects: Header Data5CH_DATEDate of Last Changenvarchar80
122LXE_PCZ_HD_APCZ Objects: Header Data5CH_DATEDate of Last Changenvarchar80
123LXE_PCZ_HD_FPCZ Objects: Header Data5CH_DATEDate of Last Changenvarchar80
124LXE_PCZ_HD_HPCZ Objects: Header Data5CH_DATEDate of Last Changenvarchar80
125LXE_PCZ_HD_IHeader Data of PCZ Objects5CH_DATEDate of Last Changenvarchar80
126LXE_PCZ_HD_SHeader Data of PCZ Objects5CH_DATEDate of Last Changenvarchar80
127LXE_PCZ_HD_ZPCZ Objects: Header Data5CH_DATEDate of Last Changenvarchar80
128LXE_PCZ_VNVersion Numbers of PCZ Objects9CH_DATEDate of Last Changenvarchar80
129LXE_PCZ_VN_AVersion Numbers of PCZ Objects9CH_DATEDate of Last Changenvarchar80
130LXE_PCZ_VN_FVersion Numbers of PCZ Objects9CH_DATEDate of Last Changenvarchar80
131LXE_PCZ_VN_HVersion Numbers of PCZ Objects9CH_DATEDate of Last Changenvarchar80
132LXE_PCZ_VN_IVersion Numbers of PCZ Objects9CH_DATEDate of Last Changenvarchar80
133LXE_PCZ_VN_SVersion Numbers of PCZ Objects9CH_DATEDate of Last Changenvarchar80
134LXE_PCZ_VN_ZVersion Numbers of PCZ Objects9CH_DATEDate of Last Changenvarchar80
135LXE_PC_FIPCheck Sum7CH_DATEDate of Last Changenvarchar80
136LXE_PC_FIP_ONEChecksum for Single Object7CH_DATEDate of Last Changenvarchar80
137LXE_PC_HDPC* Objects: Header Data9CH_DATEDate of Last Changenvarchar80
138LXE_PC_TTXHBinary Data for Objects11CH_DATEDate of Last Changenvarchar80
139LXE_PEXPTTranslation exception6CH_DATEDate of Last Changenvarchar80
140LXE_PP_MAPConversion During Remote Copy9CH_DATEDate of Last Changenvarchar80
141LXE_TAMO_ABORTTable to Deactivate Hard Termination After TAMO Errors4CH_DATEDate of Last Changenvarchar80
142LXE_TAXXTable Segmentation6CH_DATEDate of Last Changenvarchar80
143LXE_TEAMTranslator Team3CH_DATEDate of Last Changenvarchar80
144LXE_TGROUPTranslator Group3CH_DATEDate of Last Changenvarchar80
145LXE_TMTranslation4CH_DATEDate of Last Changenvarchar80
146LXE_TM9Translation6CH_DATEDate of Last Changenvarchar80
147LXE_TMP_STLocal Temporary Storage10CH_DATEDate of Last Changenvarchar80
148LXE_TTXBinary Data for Objects9CH_DATEDate of Last Changenvarchar80
149LXE_USERAssignments7CH_DATEDate of Last Changenvarchar80
150LXE_US_COAssignments7CH_DATEDate of Last Changenvarchar80
151LXE_US_COLAssignments (Backup)7CH_DATEDate of Last Changenvarchar80
152LXE_WLTranslation Environment: Target Languages and Attributes 13CH_DATEDate of Last Changenvarchar80
153LXE_WL2Translation Environment: Target Languages and Attributes 16CH_DATEDate of Last Changenvarchar80
154LXE_WRK_1Number5CH_DATEDate of Last Changenvarchar80
155LXE_XT_HEADERObject Headers8CH_DATEDate of Last Changenvarchar80
156LXE_XT_HEAD_LANGLanguage Headers4CH_DATEDate of Last Changenvarchar80