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

115 columns | Print definition?ERP 6.0  | TEXTKEY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DXLFT_DEV_CMNTXLIFF Developer Comments3TEXTKEYA "short" textkey (using only 26 characters instead of 32)nvarchar260
2LXE_REVIEW_FLAGQuery Flag4TEXTKEYText Keynvarchar320
3TEXT_T_CATALOGTraceable text catalog6TEXTKEYTextntext10737418230
4TSCON_SDLXLIFFSDLXLIFF object data (binary)6TEXTKEYText Keynvarchar320
TOPLocalization
5J_1BAANota Fiscal type12TEXTKEYMM: Text key for automatic text determinationnvarchar40
6J_1BIV02Nota Fiscal type determination10TEXTKEYMM: Text key for automatic text determinationnvarchar40
7J_1BIV04Goods Receipts Passed to Notas Fiscais via Inv. Verification5TEXTKEYMM: Text key for automatic text determinationnvarchar40
8J_1BMMNFTTMM: Allowed automatic texts2TEXTKEYMM: Text key for automatic text determinationnvarchar40
9J_1BMMNFTUMM: Allowed automatic text key description3TEXTKEYMM: Text key for automatic text determinationnvarchar40
10J_1BMMNFXMM: Argument used in automatic creation of NF header texts2TEXTKEYMM: Text key for automatic text determinationnvarchar40
11J_1BMMNFXTMM:Text used in automatic creation of NF header texts?3TEXTKEYMM: Text key for automatic text determinationnvarchar40
TOPTranslation Tools
12DXLFT_COMMENTHolds translator comments on text level3TEXTKEYA "short" textkey (using only 26 characters instead of 32)nvarchar260
13DXLFT_FIPRLong Text Fingerprints4TEXTKEYA "short" textkey (using only 26 characters instead of 32)nvarchar260
14DXLFT_LTEXTXLIFF Long Texts4TEXTKEYA "short" textkey (using only 26 characters instead of 32)nvarchar260
15DXLFT_STEXTXLIFF Short Texts4TEXTKEYA "short" textkey (using only 26 characters instead of 32)nvarchar260
16DXLFT_TTX_SNIPTTX snippets of translation units4TEXTKEYA "short" textkey (using only 26 characters instead of 32)nvarchar260
17LXE_DEMOTDemonstration Table3TEXTKEYText Keynvarchar320
18LXE_DEMO_FLAGDEMS object flag4TEXTKEYText Keynvarchar320
19LXE_PC2_KEYHeader Data for PC* Objects4TEXTKEYText Keynvarchar320
20LXE_PCT_TYDummy Table for PCT Translation3TEXTKEYText Keynvarchar320
21LXE_PCX_TXPCX Objects: Texts5TEXTKEYText Keynvarchar320
22LXE_PCX_TX_APCX Objects: Texts5TEXTKEYText Keynvarchar320
23LXE_PCX_TX_BPCX Objects: Texts5TEXTKEYText Keynvarchar320
24LXE_PCX_TX_CPCX Objects: Texts5TEXTKEYText Keynvarchar320
25LXE_PCX_TX_DPCX Objects: Texts5TEXTKEYText Keynvarchar320
26LXE_PCX_TX_FPCX Objects: Texts5TEXTKEYText Keynvarchar320
27LXE_PCX_TX_GPCX Objects: Texts5TEXTKEYText Keynvarchar320
28LXE_PCX_TX_HPCX Objects: Texts5TEXTKEYText Keynvarchar320
29LXE_PCX_TX_LPCX Objects: Texts5TEXTKEYText Keynvarchar320
30LXE_PCX_TX_MPCX Objects: Texts5TEXTKEYText Keynvarchar320
31LXE_PCX_TX_RPCX Objects: Texts5TEXTKEYText Keynvarchar320
32LXE_PCX_TX_SPCX Objects: Texts5TEXTKEYText Keynvarchar320
33LXE_PCX_TX_TTexts for PCX Objects5TEXTKEYText Keynvarchar320
34LXE_PCX_TX_UPCX Objects: Texts5TEXTKEYText Keynvarchar320
35LXE_PCY_TXPCY Objects: Texts5TEXTKEYText Keynvarchar320
36LXE_PCY_TX_APCY Objects: Texts5TEXTKEYText Keynvarchar320
37LXE_PCY_TX_BPCY Objects: Texts5TEXTKEYText Keynvarchar320
38LXE_PCY_TX_DPCY Objects: Texts5TEXTKEYText Keynvarchar320
39LXE_PCY_TX_FPCY Objects: Texts5TEXTKEYText Keynvarchar320
40LXE_PCY_TX_GPCY Objects: Texts5TEXTKEYText Keynvarchar320
41LXE_PCY_TX_IPCY Objects: Texts5TEXTKEYText Keynvarchar320
42LXE_PCY_TX_LPCY Objects: Texts5TEXTKEYText Keynvarchar320
43LXE_PCY_TX_MTexts for PCY Objects5TEXTKEYText Keynvarchar320
44LXE_PCY_TX_TTexts for PCY Objects5TEXTKEYText Keynvarchar320
45LXE_PCY_VNVersion Numbers of PCY Objects5TEXTKEYText Keynvarchar320
46LXE_PCY_VN_AVersion Numbers of PCY Objects5TEXTKEYText Keynvarchar320
47LXE_PCY_VN_BVersion Numbers of PCY Objects5TEXTKEYText Keynvarchar320
48LXE_PCY_VN_DVersion Numbers of PCY Objects5TEXTKEYText Keynvarchar320
49LXE_PCY_VN_FVersion Numbers of PCY Objects5TEXTKEYText Keynvarchar320
50LXE_PCY_VN_GVersion Numbers of PCY Objects5TEXTKEYText Keynvarchar320
51LXE_PCY_VN_IVersion Numbers of PCY Objects5TEXTKEYText Keynvarchar320
52LXE_PCY_VN_LVersion Numbers of PCY Objects5TEXTKEYText Keynvarchar320
53LXE_PCY_VN_MVersion Numbers of PCY Objects5TEXTKEYText Keynvarchar320
54LXE_PCY_VN_TVersion Numbers of PCY Objects5TEXTKEYText Keynvarchar320
55LXE_PCZ_TTBinary Data for PCZ Objects4TEXTKEYText Keynvarchar320
56LXE_PCZ_TT_ABinary Data for PCZ Objects4TEXTKEYText Keynvarchar320
57LXE_PCZ_TT_FBinary Data for PCZ Objects4TEXTKEYText Keynvarchar320
58LXE_PCZ_TT_HBinary Data for PCZ Objects4TEXTKEYText Keynvarchar320
59LXE_PCZ_TT_IBinary Data for PCZ Objects4TEXTKEYText Keynvarchar320
60LXE_PCZ_TT_SBinary Data for PCZ Objects4TEXTKEYText Keynvarchar320
61LXE_PCZ_TT_ZBinary Data for PCZ Objects4TEXTKEYText Keynvarchar320
62LXE_PCZ_TXPCZ Objects: Texts5TEXTKEYText Keynvarchar320
63LXE_PCZ_TX_APCZ Objects: Texts5TEXTKEYText Keynvarchar320
64LXE_PCZ_TX_FPCZ Objects: Texts5TEXTKEYText Keynvarchar320
65LXE_PCZ_TX_HPCZ Objects: Texts5TEXTKEYText Keynvarchar320
66LXE_PCZ_TX_ITexts of PCZ Objects5TEXTKEYText Keynvarchar320
67LXE_PCZ_TX_STexts of PCZ Objects5TEXTKEYText Keynvarchar320
68LXE_PCZ_TX_ZPCZ Objects: Texts5TEXTKEYText Keynvarchar320
69LXE_PCZ_VNVersion Numbers of PCZ Objects5TEXTKEYText Keynvarchar320
70LXE_PCZ_VN_AVersion Numbers of PCZ Objects5TEXTKEYText Keynvarchar320
71LXE_PCZ_VN_FVersion Numbers of PCZ Objects5TEXTKEYText Keynvarchar320
72LXE_PCZ_VN_HVersion Numbers of PCZ Objects5TEXTKEYText Keynvarchar320
73LXE_PCZ_VN_IVersion Numbers of PCZ Objects5TEXTKEYText Keynvarchar320
74LXE_PCZ_VN_SVersion Numbers of PCZ Objects5TEXTKEYText Keynvarchar320
75LXE_PCZ_VN_ZVersion Numbers of PCZ Objects5TEXTKEYText Keynvarchar320
76LXE_PC_APPC* Objects: Texts3TEXTKEYText Keynvarchar320
77LXE_PC_TTXBinary Data for Objects6TEXTKEYText Keynvarchar320
78LXE_PC_TTXHBinary Data for Objects6TEXTKEYText Keynvarchar320
79LXE_PC_TTX_ABinary Data for Objects6TEXTKEYText Keynvarchar320
80LXE_PC_TTX_BBinary Data for Objects6TEXTKEYText Keynvarchar320
81LXE_PC_TTX_CBinary Data for Objects6TEXTKEYText Keynvarchar320
82LXE_PC_TTX_DBinary Data for Objects6TEXTKEYText Keynvarchar320
83LXE_PC_TTX_EBinary Data for Objects6TEXTKEYText Keynvarchar320
84LXE_PC_TTX_FBinary Data for Objects6TEXTKEYText Keynvarchar320
85LXE_PC_TTX_GBinary Data for Objects6TEXTKEYText Keynvarchar320
86LXE_PC_TTX_HBinary Data for Objects6TEXTKEYText Keynvarchar320
87LXE_PC_TTX_IBinary Data for Objects6TEXTKEYText Keynvarchar320
88LXE_PC_TTX_LBinary Data for Objects6TEXTKEYText Keynvarchar320
89LXE_PC_TTX_MBinary Data for Objects6TEXTKEYText Keynvarchar320
90LXE_PC_TTX_NBinary Data for Objects6TEXTKEYText Keynvarchar320
91LXE_PC_TTX_OBinary Data for Objects6TEXTKEYText Keynvarchar320
92LXE_PC_TTX_PBinary Data for Objects6TEXTKEYText Keynvarchar320
93LXE_PC_TTX_QBinary Data for Objects6TEXTKEYText Keynvarchar320
94LXE_PC_TTX_RBinary Data for Objects6TEXTKEYText Keynvarchar320
95LXE_PC_TTX_SBinary Data for Objects6TEXTKEYText Keynvarchar320
96LXE_PC_TTX_TBinary Data for Objects6TEXTKEYText Keynvarchar320
97LXE_PC_TTX_UBinary Data for Objects6TEXTKEYText Keynvarchar320
98LXE_PC_TTX_VBinary Data for Objects6TEXTKEYText Keynvarchar320
99LXE_PC_TTX_WBinary Data for Objects6TEXTKEYText Keynvarchar320
100LXE_PC_TTX_XBinary Data for Objects6TEXTKEYText Keynvarchar320
101LXE_PC_TTX_YBinary Data for Objects6TEXTKEYText Keynvarchar320
102LXE_PC_TTX_ZBinary Data for Objects6TEXTKEYText Keynvarchar320
103LXE_PERF_LOGLXE Performance Tracing Table10TEXTKEYText Keynvarchar320
104LXE_PERF_LOG_AGGAggregated Performance Log Data9TEXTKEYText Keynvarchar320
105LXE_TCS_TTX_REGHolds information on invalid TTXs6TEXTKEYText Keynvarchar320
106LXE_TMP_STLocal Temporary Storage5TEXTKEYText Keynvarchar320
107LXE_TTXBinary Data for Objects6TEXTKEYText Keynvarchar320
108LXE_XT_TKEY_MAPTextkey Mapping3TEXTKEYText Keynvarchar320
109LXE_XT_TXT_ATTRText Attributes3TEXTKEYText Keynvarchar320
110LXE_XT_XTEXTShort Texts4TEXTKEYText Keynvarchar320
111LXE_XT_YTEXTLong Texts4TEXTKEYText Keynvarchar320
112LXE_XT_ZBINSpecial Texts (Binary)5TEXTKEYText Keynvarchar320
113LXE_XT_ZTEXTSpecial Texts5TEXTKEYText Keynvarchar320
114NR3TEXTTranslation: PC Components Texts4TEXTKEYTranslation: Text line keynvarchar800
115NR3XTEXTTranslation: PC Components Texts4TEXTKEYTranslation: Text line keynvarchar800