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

118 columns | Print definition?ERP 6.0  | CH_TIME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1EBILLPRGIS-U: Billing Programs15CH_TIMETime last change was madenvarchar60
2ECONDIPROCINTFIS-U: Processing Interface for Conditions15CH_TIMETime last change was madenvarchar60
3ESCHEXTBilling Schema Extension (Administrative Data)7CH_TIMETime last change was madenvarchar60
4ETOUEXCEPTIONTOU Exception17CH_TIMETime last change was madenvarchar60
5ETOUEXCEPTRESPTOU Exception Response10CH_TIMETime last change was madenvarchar60
6ETOUEXCPTPRGTOU Exception Program16CH_TIMETime last change was madenvarchar60
7GDV_T_SNAP_DATASerialized Expected Values5CH_TIMESystem Timenvarchar60
8LOP_D_LIST_HDOption list header40CH_TIMETime of Changenvarchar60
9LOP_D_LIST_ITOption list items13CH_TIMETime of Changenvarchar60
10LOP_D_MASTER_HDOption list header as master data16CH_TIMETime of Changenvarchar60
11LOP_D_MASTER_ITOption List items as master data13CH_TIMETime of Changenvarchar60
12TRANSL_GRAPHTranslation Graph Header Data5CH_TIMELast changed atnvarchar60
13TSCON_T_CONProject creation connection6CH_TIMELast changed atnvarchar60
TOPAMI Event Management
14TEAMI_EM_EVTRESResults for AMI Events14CH_TIMETime last change was madenvarchar60
15TEAMI_EM_EVTSIS-U AMI Event Management AMI Events18CH_TIMETime last change was madenvarchar60
TOPChargeback
16WCOCOHCondition Contract: Header45CH_TIMETime of Changenvarchar60
TOPCross-Application Components
17SDEPMENT_CHDepartments: Enhance with Dept. Head and Time in Incl. (2)8CH_TIMETime last change was madenvarchar60
18SEMPLOYES_APPEmployees: Enhancement by Append (4)13CH_TIMETime last change was madenvarchar60
19SEMPLOYES_TIEmployees: Enhancement by Time Field in Include (3)13CH_TIMETime last change was madenvarchar60
TOPGlobal Trade
20WB2_D_ASGT_DISTAssignment distributions13CH_TIMETime of Changenvarchar60
21WB2_D_ASSGMTAssignments23CH_TIMETime of Changenvarchar60
22WB2_D_COMSUBTrading Contract: commodity sub items17CH_TIMETime of Changenvarchar60
23WB2_D_PRASPTrading Contract: pricing aspects23CH_TIMETime of Changenvarchar60
24WB2_D_SHD_ITEMShadow Items27CH_TIMETime of Changenvarchar60
25WB2_D_SHD_PRASPPricing aspects of shadow items20CH_TIMETime of Changenvarchar60
TOPSAP Note Assistant
26CWB_HIST_HCorrection Workbench: History Header9CH_TIMESystem Timenvarchar60
27SCWB_HISTHistory of Delta Copies in the Correction Workbench5CH_TIMESystem Timenvarchar60
TOPSAP Retail Store
28IVIEW_CO_GRCustomer order good receipt IView - Sales orders11CH_TIMETime last change was madenvarchar60
TOPSAP Utilities
29ISU_WUI_DOC_FLTRDocument filter criteria for user14CH_TIMETime last change was madenvarchar60
30TEAMI_LOG_DATALog for Service Communication in AMI Environment24CH_TIMETime last change was madenvarchar60
TOPTrading Contract
31PPE_D_ITEM_LISTEvents21CH_TIMETime of Changenvarchar60
TOPTranslation Tools
32LXE_CSN_BKNotes7CH_TIMELast changed atnvarchar60
33LXE_CSN_HDNotes11CH_TIMELast changed atnvarchar60
34LXE_CSN_TXLNotes7CH_TIMELast changed atnvarchar60
35LXE_CSN_TXSNotes6CH_TIMELast changed atnvarchar60
36LXE_DEMODemonstration Table7CH_TIMELast changed atnvarchar60
37LXE_DOMADomains7CH_TIMELast changed atnvarchar60
38LXE_DOMA_2Package Assignment to Domains7CH_TIMELast changed atnvarchar60
39LXE_DOMA_PDomains6CH_TIMELast changed atnvarchar60
40LXE_FIPRCheck Sum8CH_TIMELast changed atnvarchar60
41LXE_GENFLTranslation6CH_TIMELast changed atnvarchar60
42LXE_GRAPHTranslation Graph Header Data5CH_TIMELast changed atnvarchar60
43LXE_LEXPTTranslation exception7CH_TIMELast changed atnvarchar60
44LXE_LISTLocal Lists6CH_TIMELast changed atnvarchar60
45LXE_LIST_DLocal Lists7CH_TIMELast changed atnvarchar60
46LXE_LIST_SRLocal Lists6CH_TIMELast changed atnvarchar60
47LXE_LIST_SXLocal Lists6CH_TIMELast changed atnvarchar60
48LXE_PARAM_BDLTranslation5CH_TIMELast changed atnvarchar60
49LXE_PARAM_JTranslation5CH_TIMELast changed atnvarchar60
50LXE_PARAM_KTPTranslation5CH_TIMELast changed atnvarchar60
51LXE_PARAM_NWTranslation5CH_TIMELast changed atnvarchar60
52LXE_PARAM_P4Translation5CH_TIMELast changed atnvarchar60
53LXE_PARAM_S2XTranslation5CH_TIMELast changed atnvarchar60
54LXE_PARAM_XITranslation5CH_TIMELast changed atnvarchar60
55LXE_PARAM_ZTYPETranslation5CH_TIMELast changed atnvarchar60
56LXE_PC2_HDHeader Data for PC* Objects4CH_TIMELast changed atnvarchar60
57LXE_PC2_XI_HDHeader Data for PC* Objects7CH_TIMELast changed atnvarchar60
58LXE_PCX_HDPCX Objects: Header Data6CH_TIMELast changed atnvarchar60
59LXE_PCX_HD_APCX Objects: Header Data6CH_TIMELast changed atnvarchar60
60LXE_PCX_HD_BPCX Objects: Header Data6CH_TIMELast changed atnvarchar60
61LXE_PCX_HD_CPCX Objects: Header Data6CH_TIMELast changed atnvarchar60
62LXE_PCX_HD_DPCX Objects: Header Data6CH_TIMELast changed atnvarchar60
63LXE_PCX_HD_FPCX Objects: Header Data6CH_TIMELast changed atnvarchar60
64LXE_PCX_HD_GPCX Objects: Header Data6CH_TIMELast changed atnvarchar60
65LXE_PCX_HD_HPCX Objects: Header Data6CH_TIMELast changed atnvarchar60
66LXE_PCX_HD_LPCX Objects: Header Data6CH_TIMELast changed atnvarchar60
67LXE_PCX_HD_MPCX Objects: Header Data6CH_TIMELast changed atnvarchar60
68LXE_PCX_HD_RPCX Objects: Header Data6CH_TIMELast changed atnvarchar60
69LXE_PCX_HD_SPCX Objects: Header Data6CH_TIMELast changed atnvarchar60
70LXE_PCX_HD_TPCX Objects: Header Data6CH_TIMELast changed atnvarchar60
71LXE_PCX_HD_UPCX Objects: Header Data6CH_TIMELast changed atnvarchar60
72LXE_PCY_HDPCY Objects: Header Data6CH_TIMELast changed atnvarchar60
73LXE_PCY_HD_APCY Objects: Header Data6CH_TIMELast changed atnvarchar60
74LXE_PCY_HD_BPCY Objects: Header Data6CH_TIMELast changed atnvarchar60
75LXE_PCY_HD_DPCY Objects: Header Data6CH_TIMELast changed atnvarchar60
76LXE_PCY_HD_FPCY Objects: Header Data6CH_TIMELast changed atnvarchar60
77LXE_PCY_HD_GPCY Objects: Header Data6CH_TIMELast changed atnvarchar60
78LXE_PCY_HD_IPCY Objects: Header Data6CH_TIMELast changed atnvarchar60
79LXE_PCY_HD_LPCY Objects: Header Data6CH_TIMELast changed atnvarchar60
80LXE_PCY_HD_MPCY Objects: Header Data6CH_TIMELast changed atnvarchar60
81LXE_PCY_HD_TPCY Objects: Header Data6CH_TIMELast changed atnvarchar60
82LXE_PCY_VNVersion Numbers of PCY Objects10CH_TIMELast changed atnvarchar60
83LXE_PCY_VN_AVersion Numbers of PCY Objects10CH_TIMELast changed atnvarchar60
84LXE_PCY_VN_BVersion Numbers of PCY Objects10CH_TIMELast changed atnvarchar60
85LXE_PCY_VN_DVersion Numbers of PCY Objects10CH_TIMELast changed atnvarchar60
86LXE_PCY_VN_FVersion Numbers of PCY Objects10CH_TIMELast changed atnvarchar60
87LXE_PCY_VN_GVersion Numbers of PCY Objects10CH_TIMELast changed atnvarchar60
88LXE_PCY_VN_IVersion Numbers of PCY Objects10CH_TIMELast changed atnvarchar60
89LXE_PCY_VN_LVersion Numbers of PCY Objects10CH_TIMELast changed atnvarchar60
90LXE_PCY_VN_MVersion Numbers of PCY Objects10CH_TIMELast changed atnvarchar60
91LXE_PCY_VN_TVersion Numbers of PCY Objects10CH_TIMELast changed atnvarchar60
92LXE_PCZ_HDPCZ Objects: Header Data6CH_TIMELast changed atnvarchar60
93LXE_PCZ_HD_APCZ Objects: Header Data6CH_TIMELast changed atnvarchar60
94LXE_PCZ_HD_FPCZ Objects: Header Data6CH_TIMELast changed atnvarchar60
95LXE_PCZ_HD_HPCZ Objects: Header Data6CH_TIMELast changed atnvarchar60
96LXE_PCZ_HD_IHeader Data of PCZ Objects6CH_TIMELast changed atnvarchar60
97LXE_PCZ_HD_SHeader Data of PCZ Objects6CH_TIMELast changed atnvarchar60
98LXE_PCZ_HD_ZPCZ Objects: Header Data6CH_TIMELast changed atnvarchar60
99LXE_PCZ_VNVersion Numbers of PCZ Objects10CH_TIMELast changed atnvarchar60
100LXE_PCZ_VN_AVersion Numbers of PCZ Objects10CH_TIMELast changed atnvarchar60
101LXE_PCZ_VN_FVersion Numbers of PCZ Objects10CH_TIMELast changed atnvarchar60
102LXE_PCZ_VN_HVersion Numbers of PCZ Objects10CH_TIMELast changed atnvarchar60
103LXE_PCZ_VN_IVersion Numbers of PCZ Objects10CH_TIMELast changed atnvarchar60
104LXE_PCZ_VN_SVersion Numbers of PCZ Objects10CH_TIMELast changed atnvarchar60
105LXE_PCZ_VN_ZVersion Numbers of PCZ Objects10CH_TIMELast changed atnvarchar60
106LXE_PC_FIPCheck Sum8CH_TIMELast changed atnvarchar60
107LXE_PC_FIP_ONEChecksum for Single Object8CH_TIMELast changed atnvarchar60
108LXE_PC_HDPC* Objects: Header Data10CH_TIMELast changed atnvarchar60
109LXE_PC_TTXHBinary Data for Objects12CH_TIMELast changed atnvarchar60
110LXE_PEXPTTranslation exception7CH_TIMELast changed atnvarchar60
111LXE_PP_MAPConversion During Remote Copy10CH_TIMELast changed atnvarchar60
112LXE_TMTranslation5CH_TIMELast changed atnvarchar60
113LXE_TM9Translation7CH_TIMELast changed atnvarchar60
114LXE_TMP_STLocal Temporary Storage11CH_TIMELast changed atnvarchar60
115LXE_TTXBinary Data for Objects10CH_TIMELast changed atnvarchar60
116LXE_WL2Translation Environment: Target Languages and Attributes 17CH_TIMELast changed atnvarchar60
117LXE_XT_HEADERObject Headers9CH_TIMELast changed atnvarchar60
118LXE_XT_HEAD_LANGLanguage Headers5CH_TIMELast changed atnvarchar60