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

76 columns | Print definition?ERP 6.0  | TTEDOCUMENTID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPTransaction Tax Engine
1TTED_INHEAD_COMInput document header data10TTEDOCUMENTIDTTE Document IDnvarchar320
2TTED_OUTHEAD_COMOutput document header data9TTEDOCUMENTIDTTE Document IDnvarchar320
3TTEPD3_CURRCONCurrencyConversions2TTEDOCUMENTIDTTE Document IDvarbinary160
4TTEPD3_DOCCLfor 3.0 TTE Document Clustering3TTEDOCUMENTIDTTE Document IDnvarchar320
5TTEPD3_DOCUMENT3.0 TTE Persistency Document2TTEDOCUMENTIDTTE Document IDvarbinary160
6TTEPD3_EXEMPExemptions2TTEDOCUMENTIDTTE Document IDvarbinary160
7TTEPD3_HEADERHeader2TTEDOCUMENTIDTTE Document IDvarbinary160
8TTEPD3_ITEMItem2TTEDOCUMENTIDTTE Document IDvarbinary160
9TTEPD3_PARTNERPartner2TTEDOCUMENTIDTTE Document IDvarbinary160
10TTEPD3_PATAXNOPartnerTaxNumber2TTEDOCUMENTIDTTE Document IDvarbinary160
11TTEPD3_PRIELESPricing Element2TTEDOCUMENTIDTTE Document IDvarbinary160
12TTEPD3_PRODUCTProduct2TTEDOCUMENTIDTTE Document IDvarbinary160
13TTEPD3_PROUSAGProductUsage2TTEDOCUMENTIDTTE Document IDvarbinary160
14TTEPD3_REPFLDSReporting Field2TTEDOCUMENTIDTTE Document IDvarbinary160
15TTEPD3_TAXCLASTaxClassification2TTEDOCUMENTIDTTE Document IDvarbinary160
16TTEPD3_TAXDETETaxDetermination2TTEDOCUMENTIDTTE Document IDvarbinary160
17TTEPD3_TAXELETaxElement2TTEDOCUMENTIDTTE Document IDvarbinary160
18TTEPD3_TAXSITUTaxSituation2TTEDOCUMENTIDTTE Document IDvarbinary160
19TTEPD3_TAXVALTaxValue2TTEDOCUMENTIDTTE Document IDvarbinary160
20TTEPD3_TRACEOutput Trace Entries2TTEDOCUMENTIDTTE Document IDvarbinary160
21TTEPD3_USITEMPersistency TTE Document UsItem2TTEDOCUMENTIDTTE Document IDvarbinary160
22TTEPDT_COUNTRIESPersistency TTE Document COUNTRY spez.2TTEDOCUMENTIDTTE Document IDvarbinary160
23TTEPDT_CURRCONVDocument curruncy conversion2TTEDOCUMENTIDTTE Document IDvarbinary160
24TTEPDT_DOCCLfor 4.0 TTE Document Clustering3TTEDOCUMENTIDTTE Document IDnvarchar320
25TTEPDT_DOCUMENTTTE Persistency Document2TTEDOCUMENTIDTTE Document IDvarbinary160
26TTEPDT_EXEMPTPersistency TTE Document Output Exemptions2TTEDOCUMENTIDTTE Document IDvarbinary160
27TTEPDT_EXEMPVALUPersistency TTE Document Item Exemption Value2TTEDOCUMENTIDTTE Document IDvarbinary160
28TTEPDT_HEADERPersistency TTE Document Header2TTEDOCUMENTIDTTE Document IDvarbinary160
29TTEPDT_ITEMPersistency TTE Document Item2TTEDOCUMENTIDTTE Document IDvarbinary160
30TTEPDT_ITEMPARTPersistency TTE Document item partner2TTEDOCUMENTIDTTE Document IDvarbinary160
31TTEPDT_ORGUNITPersistency TTE Document org unit2TTEDOCUMENTIDTTE Document IDvarbinary160
32TTEPDT_OTRACEOutput Trace Entries2TTEDOCUMENTIDTTE Document IDvarbinary160
33TTEPDT_PAPROPPersistency TTE Document business partner property2TTEDOCUMENTIDTTE Document IDvarbinary160
34TTEPDT_PARTNERPersistency TTE Document business partner2TTEDOCUMENTIDTTE Document IDvarbinary160
35TTEPDT_PATAXCLPersistency TTE Document business partner tax class.2TTEDOCUMENTIDTTE Document IDvarbinary160
36TTEPDT_PATAXNUMPersistency TTE Document business partner tax number2TTEDOCUMENTIDTTE Document IDvarbinary160
37TTEPDT_PRICELPersistency TTE Document / Item pricing element2TTEDOCUMENTIDTTE Document IDvarbinary160
38TTEPDT_PRODUCTPersitency TTE Document product2TTEDOCUMENTIDTTE Document IDvarbinary160
39TTEPDT_PRPROPPersistency TTE Document product property2TTEDOCUMENTIDTTE Document IDvarbinary160
40TTEPDT_PRTAXCLPersistency TTE Document product tax class.2TTEDOCUMENTIDTTE Document IDvarbinary160
41TTEPDT_TAXCODVADocument / Item TaxCode Value2TTEDOCUMENTIDTTE Document IDvarbinary160
42TTEPDT_TAXDATEPersistemcy TTE Document tax date2TTEDOCUMENTIDTTE Document IDvarbinary160
43TTEPDT_TAXELPersistency TTE Document / Item tax element2TTEDOCUMENTIDTTE Document IDvarbinary160
44TTEPDT_TAXEVENTPersistency TTE Document / Item tax event2TTEDOCUMENTIDTTE Document IDvarbinary160
45TTEPDT_TAXVALUEPersistency TTE Document / Item tax value2TTEDOCUMENTIDTTE Document IDvarbinary160
46TTEPDT_TEXTPersistency TTE Document document textes2TTEDOCUMENTIDTTE Document IDvarbinary160
47TTEPDT_TRANPROPPersistency TTE Document transaction property2TTEDOCUMENTIDTTE Document IDvarbinary160
48TTEPDT_USITEMPersistency TTE Document UsItem2TTEDOCUMENTIDTTE Document IDvarbinary160
49TTESDT_ACCUMVALUDocument business partner accum. values of with. tax.2TTEDOCUMENTIDTTE Document IDvarbinary160
50TTESDT_ANALYSYSPricing Trace from Tax Calculation2TTEDOCUMENTIDTTE Document IDvarbinary160
51TTESDT_COUNTRIESDocument COUNTRY spez.2TTEDOCUMENTIDTTE Document IDvarbinary160
52TTESDT_CURRCONVDocument curruncy conversion2TTEDOCUMENTIDTTE Document IDvarbinary160
53TTESDT_DOCUMENTTTE Simulaton Document4TTEDOCUMENTIDTTE Document IDvarbinary160
54TTESDT_EXEMPTOutput Exemptions2TTEDOCUMENTIDTTE Document IDvarbinary160
55TTESDT_EXEMPVALUDocument business partner exemption values for with. tax.2TTEDOCUMENTIDTTE Document IDvarbinary160
56TTESDT_HEADERDocument header2TTEDOCUMENTIDTTE Document IDvarbinary160
57TTESDT_ITEMItem2TTEDOCUMENTIDTTE Document IDvarbinary160
58TTESDT_ITEMPARTDocument item partner2TTEDOCUMENTIDTTE Document IDvarbinary160
59TTESDT_ORGUNITDocument org unit2TTEDOCUMENTIDTTE Document IDvarbinary160
60TTESDT_PAPROPDocument business partner property2TTEDOCUMENTIDTTE Document IDvarbinary160
61TTESDT_PARTNERDocument business partner2TTEDOCUMENTIDTTE Document IDvarbinary160
62TTESDT_PATAXCLDocument business partner tax class.2TTEDOCUMENTIDTTE Document IDvarbinary160
63TTESDT_PATAXNUMDocument business partner tax number2TTEDOCUMENTIDTTE Document IDvarbinary160
64TTESDT_PRICELDocument / Item pricing element2TTEDOCUMENTIDTTE Document IDvarbinary160
65TTESDT_PRODUCTDocument product2TTEDOCUMENTIDTTE Document IDvarbinary160
66TTESDT_PRPROPDocument product property2TTEDOCUMENTIDTTE Document IDvarbinary160
67TTESDT_PRTAXCLDocument product tax class.2TTEDOCUMENTIDTTE Document IDvarbinary160
68TTESDT_TAXCODVADocument / Item pricing element2TTEDOCUMENTIDTTE Document IDvarbinary160
69TTESDT_TAXDATEDocument tax date2TTEDOCUMENTIDTTE Document IDvarbinary160
70TTESDT_TAXELDocument / Item tax element2TTEDOCUMENTIDTTE Document IDvarbinary160
71TTESDT_TAXEVENTDocument / Item tax event2TTEDOCUMENTIDTTE Document IDvarbinary160
72TTESDT_TAXVALUEDocument / Item tax value2TTEDOCUMENTIDTTE Document IDvarbinary160
73TTESDT_TEXTDocument document textes2TTEDOCUMENTIDTTE Document IDvarbinary160
74TTESDT_TRACEOutput Trace Entries2TTEDOCUMENTIDTTE Document IDvarbinary160
75TTESDT_TRANPROPDocument transaction property2TTEDOCUMENTIDTTE Document IDvarbinary160
76TTESDT_USITEMOutput Exemptions2TTEDOCUMENTIDTTE Document IDvarbinary160