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

50 columns | Print definition?ERP 6.0  | PS_POSID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items124PS_POSIDnvarchar240
2/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact124PS_POSIDnvarchar240
3/BIC/B0000170000PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta60PS_POSIDnvarchar240
4/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items176PS_POSIDnvarchar240
5/BIC/B0000177000PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item69PS_POSIDnvarchar240
6/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item132PS_POSIDnvarchar240
7/BIC/B0000179000PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule110PS_POSIDnvarchar240
8/BIC/B0000180000PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch.76PS_POSIDnvarchar240
9/BIC/B0000181000PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond.88PS_POSIDnvarchar240
10/BIC/B0000183000PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item95PS_POSIDnvarchar240
11/BIC/B0000185000PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item100PS_POSIDnvarchar240
12/BIC/B0000186000PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond.83PS_POSIDnvarchar240
13/OPT/VIM_1ITEM_SDocument Item58PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
14/OPT/VIM_TITEMDocument Item58PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
15/XFT/QMPPAPT001QM Sampling Header Table22PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
16/XFT/SRMPS001WBS Element Records: Link to WBS Element (No Change)3PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
17STERM_COMP_WEBCustomer-Defined Components for Terminology Maintenance2PS_POSIDApplication component IDnvarchar240
18YVIM_1ITEMDocument Item58PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
TOPBusiness Navigator
19DF14LApplication Components12PS_POSIDApplication component IDnvarchar240
TOPData Collection
20S260SD - Sales order89PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
21S260BIW1SD - Sales order89PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
22S260BIW2SD - Sales order89PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
23S261SD - Delivery note84PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
24S261BIW1SD - Delivery note84PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
25S261BIW2SD - Delivery note84PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
26S262SD - Billing document77PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
27S262BIW1SD - Billing document77PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
28S262BIW2SD - Billing document77PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
29S263SD - Sales order/delivery note68PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
30S263BIW1SD - Sales order/delivery note68PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
31S263BIW2SD - Sales order/delivery note68PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
32S264SD- Offer92PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
33S264BIW1S264BIW1 * SD - Quotation92PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
34S264BIW2S264BIW2 * SD - Quotation92PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
35S279Transfer BW: Bestandsführung39PS_POSIDWork Breakdown Structure-element (WBS-element)nvarchar240
36S279BIW1S279BIW1 * BW Transfer: Inventory Management39PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
37S279BIW2S279BIW2 * BW Transfer: Inventory Management39PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
TOPFinancial Accounting
38/OPT/VIM_1ITEMDocument Item58PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
TOPPersonnel Time Management
39PTEX2000Interface Table for Attendances/Absences Infotype(2001/2002)52PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
40PTEX2003GENInterface Table for IT 2003: General Information51PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
41PTEX2003SPECInterface Table for IT 2003: Interval Information27PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
42PTEX2010Interface Table for EE Remuneration Info. Infotype (2010)51PS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
TOPSAP Healthcare - Industry-Specific Components for Hospitals
43TN2BITYPBase Items: Base Item Types16PS_POSIDApplication component IDnvarchar240
TOPTerminologyGlossary
44STERM_ADDCCustomer-Defined Components for Terminology Maintenance2PS_POSIDApplication component IDnvarchar240
45STERM_ADDTCustomer Components for Terminology Maintenance - Text Table3PS_POSIDApplication component IDnvarchar240
TOPTest Organizer
46TWBMAN_COMPTWBM: Application Components1PS_POSIDApplication component IDnvarchar240
TOPTranslation Tools
47APP_FCTRApplication ID Node Number1PS_POSIDText/Icon/Symbolnvarchar750
48DEVC_APPDevelopment Class Within the Application Hierarchy3PS_POSIDText/Icon/Symbolnvarchar750
49LXE_COLLXCollections5PS_POSIDText Line With 255 Charactersnvarchar2550
50LXE_DOMA_2Package Assignment to Domains4PS_POSIDText Line with 80 Charactersnvarchar800