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

147 columns | Print definition?ERP 6.0  | COUNTRYISO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBPD_SUS_BP_DUPLSUS/BP: Staging Table for Duplicate Check7COUNTRYISOCountry ISO codenvarchar20
2BBP_PCPOSProcurement Card Statement: Position Data53COUNTRYISOCountry ISO codenvarchar20
3BBP_SUS_STG_ADRStaging address table33COUNTRYISOCountry ISO codenvarchar20
4BBP_SUS_STG_FAXStaging address table5COUNTRYISOCountry ISO codenvarchar20
5BBP_SUS_STG_TELStaging table for telephone5COUNTRYISOCountry ISO codenvarchar20
6BBP_TMP_ZA_ASPTemporary: Request 'Bidder', Contact Addresses34COUNTRYISOCountry ISO codenvarchar20
7BBP_TMP_ZA_ORGTemporary: Request 'Bidder', Company Address34COUNTRYISOCountry ISO codenvarchar20
8REQADDRESSDelivery Address for Requirement Coverage Request Lines74COUNTRYISOCountry ISO codenvarchar20
9PIQDB_NL_ADDRMaintain GBA Address36COUNTRYISOCountry ISO codenvarchar20
TOPTransaction Tax Engine
10TTE2C_AGGREGCountry Specific Rule Assignments2COUNTRYISOCountrynvarchar20
11TTE2C_AUTHIDTax Authority2COUNTRYISOCountrynvarchar20
12TTE2C_AUTHID_TTax Authority Description3COUNTRYISOCountrynvarchar20
13TTE2C_BPPRPTYPBusiness Partner Property Type2COUNTRYISOCountrynvarchar20
14TTE2C_BPPRPTYP_TProduct Property Type Description3COUNTRYISOCountrynvarchar20
15TTE2C_BPPRPVALBusiness Partner Properties2COUNTRYISOCountrynvarchar20
16TTE2C_BPPRPVAL_TBusiness Partner Properties3COUNTRYISOCountrynvarchar20
17TTE2C_BPTXGRPBusiness Partner Tax Group2COUNTRYISOCountrynvarchar20
18TTE2C_BPTXGRP_TDescription for Business Partner Tax Group3COUNTRYISOCountrynvarchar20
19TTE2C_CHECKTTE Entity Checking Master Table3COUNTRYISOCountrynvarchar20
20TTE2C_CNTY_COMMCountry / Community Assignment2COUNTRYISOCountrynvarchar20
21TTE2C_DEDREASDeductibility Reason2COUNTRYISOCountrynvarchar20
22TTE2C_DEDREAS_TDescription for Deductibility Reason3COUNTRYISOCountrynvarchar20
23TTE2C_EXPREAExemption Reason2COUNTRYISOCountrynvarchar20
24TTE2C_EXPREA_TExemption Reason Description3COUNTRYISOCountrynvarchar20
25TTE2C_FISCCDFiscal Code2COUNTRYISOCountrynvarchar20
26TTE2C_FISCCD_TFiscal Code Description3COUNTRYISOCountrynvarchar20
27TTE2C_PROCEDValid Tax Calculation Procedures for Country2COUNTRYISOCountrynvarchar20
28TTE2C_PROCED_DETTax Calculation Procedure Determination2COUNTRYISOCountrynvarchar20
29TTE2C_PRPRPTYPProduct Property Type2COUNTRYISOCountrynvarchar20
30TTE2C_PRPRPTYP_TProduct Property Type Description3COUNTRYISOCountrynvarchar20
31TTE2C_PRPRPVALProduct Properties2COUNTRYISOCountrynvarchar20
32TTE2C_PRPRPVAL_TProduct Properties3COUNTRYISOCountrynvarchar20
33TTE2C_PRTXGRPProduct Tax Group2COUNTRYISOCountrynvarchar20
34TTE2C_PRTXGRP_TProduct Tax Group Description3COUNTRYISOCountrynvarchar20
35TTE2C_RETLVLJurisdiction Level2COUNTRYISOCountrynvarchar20
36TTE2C_RETLVL_TJurisdiction Level Description3COUNTRYISOCountrynvarchar20
37TTE2C_ROUNDINGRounding Decimals: Exceptions2COUNTRYISOCountrynvarchar20
38TTE2C_TAXEVENTTax Event2COUNTRYISOCountrynvarchar20
39TTE2C_TAXEVENT_TTax Event Description3COUNTRYISOCountrynvarchar20
40TTE2C_TAXTYP_DETTax Type Determination2COUNTRYISOCountrynvarchar20
41TTE2C_TAXTYP_TTax Type Description3COUNTRYISOCountrynvarchar20
42TTE2C_TAX_MAPMapping between Tax Type and Procedure7COUNTRYISOCountrynvarchar20
43TTE2C_USAGEProduct Usage Indicator2COUNTRYISOCountrynvarchar20
44TTE2C_USAGE_TProduct Usage Indicator Description3COUNTRYISOCountrynvarchar20
45TTEC_ACCUM_PERAccumulation Period2COUNTRYISOCountrynvarchar20
46TTEC_AGGREG[Obsolete] Aggregation Rule For Tax Amounts2COUNTRYISOCountrynvarchar20
47TTEC_AUTHORITYTax Authority2COUNTRYISOCountrynvarchar20
48TTEC_AUTHORITY_TTax Authority3COUNTRYISOCountrynvarchar20
49TTEC_BUSTRANS[Obsolete] Business Transactions2COUNTRYISOCountrynvarchar20
50TTEC_BUSTRANS_T[Obsolete] Business Transactions3COUNTRYISOCountrynvarchar20
51TTEC_CHECKINGTTE Entity Checking Master Table4COUNTRYISOCountrynvarchar20
52TTEC_COUNTRIESCountry codes (2 char ISO codes)2COUNTRYISOCountrynvarchar20
53TTEC_COUNTRIES_TCountry Text Table3COUNTRYISOCountrynvarchar20
54TTEC_COUNTRYCountry to Community Assignment2COUNTRYISOCountrynvarchar20
55TTEC_COUNTRY_TCountry name3COUNTRYISOCountrynvarchar20
56TTEC_CURRTax Currencies per Country2COUNTRYISOCountrynvarchar20
57TTEC_CURR_HDLTax Currency Handling2COUNTRYISOCountrynvarchar20
58TTEC_CURR_HDL3Tax Currency Handling2COUNTRYISOCountrynvarchar20
59TTEC_DECTR_DETDecision Tree Determination2COUNTRYISOCountrynvarchar20
60TTEC_DEDREAS[Obsolete] Deductibility Reason3COUNTRYISOCountrynvarchar20
61TTEC_DEDREAS_T[Obsolete] Description for Deductibility Reason4COUNTRYISOCountrynvarchar20
62TTEC_EXEMPREASExemption reason2COUNTRYISOCountrynvarchar20
63TTEC_EXEMPREAS_TExemption reason3COUNTRYISOCountrynvarchar20
64TTEC_EXEMP_CNDExemption condition types for tax types2COUNTRYISOCountrynvarchar20
65TTEC_FISCCODEFiscal Code2COUNTRYISOCountrynvarchar20
66TTEC_FISCCODE_TDescription Fiscal Code3COUNTRYISOCountrynvarchar20
67TTEC_FISCOVERSFiscal Code Version2COUNTRYISOCountrynvarchar20
68TTEC_FISCOVERS_TFiscal Code Version Description3COUNTRYISOCountrynvarchar20
69TTEC_INCIDENCETax Incidence2COUNTRYISOCountrynvarchar20
70TTEC_INCIDENCE_TTax Incidence in Tax Transaction Engine3COUNTRYISOCountrynvarchar20
71TTEC_LEGTXTLegal Text2COUNTRYISOCountrynvarchar20
72TTEC_LEGTXT_TLegal Text3COUNTRYISOCountrynvarchar20
73TTEC_MAPACCVALMapping Accumulated Values2COUNTRYISOCountrynvarchar20
74TTEC_NEXUSTTE: Nexus Data3COUNTRYISOCountrynvarchar20
75TTEC_NONDD_CNDCondition Type for Non-deductibility2COUNTRYISOCountrynvarchar20
76TTEC_ORIGINProduct Origin2COUNTRYISOCountrynvarchar20
77TTEC_ORIGIN_TDescription for Tax Origin3COUNTRYISOCountrynvarchar20
78TTEC_PATXGRPPartner Tax Group3COUNTRYISOCountrynvarchar20
79TTEC_PATXGRP_TDescription for Partner Tax Group4COUNTRYISOCountrynvarchar20
80TTEC_PRC_TAX_MAP[3.x only] Mapping between Tax Type and Procedure2COUNTRYISOCountrynvarchar20
81TTEC_PROCEDURETax Procedure3COUNTRYISOCountrynvarchar20
82TTEC_PRTXGRPProduct Tax Group3COUNTRYISOCountrynvarchar20
83TTEC_PRTXGRP_TProduct Tax Group Description4COUNTRYISOCountrynvarchar20
84TTEC_RATES_CNDCondition type for tax rates2COUNTRYISOCountrynvarchar20
85TTEC_RATE_IDRate IDs2COUNTRYISOCountrynvarchar20
86TTEC_RATE_ID_TRate IDs3COUNTRYISOCountrynvarchar20
87TTEC_RNDRULERounding Rules2COUNTRYISOCountrynvarchar20
88TTEC_ROUNDINGRounding Decimals: Exceptions2COUNTRYISOCountrynvarchar20
89TTEC_SPREGExempted Region2COUNTRYISOCountrynvarchar20
90TTEC_SPREG_JSDDetermine Exempted Region from Tax Jurisdiction Code2COUNTRYISOCountrynvarchar20
91TTEC_SPREG_PCDDetermine Exempted Region from Postal Code2COUNTRYISOCountrynvarchar20
92TTEC_SPREG_REGDetermine Exempted Region from Region2COUNTRYISOCountrynvarchar20
93TTEC_SPREG_TExempted Region Description3COUNTRYISOCountrynvarchar20
94TTEC_TAXBASECALAggregation rules2COUNTRYISOCountrynvarchar20
95TTEC_TAXCATAGGRAggregation rules2COUNTRYISOCountrynvarchar20
96TTEC_TAXCATPARTax Category Parameters2COUNTRYISOCountrynvarchar20
97TTEC_TAXCODETax Code2COUNTRYISOCountrynvarchar20
98TTEC_TAXCODE_2Assign Tax Events to Tax Code2COUNTRYISOCountrynvarchar20
99TTEC_TAXCODE_3Assign TTE Entities to Tax Code2COUNTRYISOCountrynvarchar20
100TTEC_TAXCODE_TTax Code3COUNTRYISOCountrynvarchar20
101TTEC_TAXDETTax Determination Default3COUNTRYISOCountrynvarchar20
102TTEC_TAXDET_EUTax Determination Intra-EU2COUNTRYISOCountrynvarchar20
103TTEC_TAXEVENT[Obsolete] Tax Event3COUNTRYISOCountrynvarchar20
104TTEC_TAXEVENT_T[Obsolete] Tax Event Description4COUNTRYISOCountrynvarchar20
105TTEC_TAXFRTO_DETPartner Role determination: Tax from/Tax to2COUNTRYISOCountrynvarchar20
106TTEC_TAXTYPTax Type2COUNTRYISOCountrynvarchar20
107TTEC_TAXTYP_DET[Obsolete] Tax Types by Tax Event3COUNTRYISOCountrynvarchar20
108TTEC_TAXTYP_T[Obsolete] Tax Type Description3COUNTRYISOCountrynvarchar20
109TTEC_TAX_REGTax Region2COUNTRYISOCountrynvarchar20
110TTEC_TAX_REG_TTax Region Name3COUNTRYISOCountrynvarchar20
111TTEC_TAX_TCODETax Tariff Code2COUNTRYISOCountrynvarchar20
112TTEC_TAX_TCODE_TTax Tariff Code Description3COUNTRYISOCountrynvarchar20
113TTEC_USAGE[Obsolete] Usage2COUNTRYISOCountrynvarchar20
114TTEC_USAGE_T[Obsolete] Usage Description3COUNTRYISOCountrynvarchar20
115TTEM_BPTXGRP2Mapping: Business Partner Tax Group4COUNTRYISOCountrynvarchar20
116TTEM_PRTXGRP2Mapping: Product Tax Group4COUNTRYISOCountrynvarchar20
117TTEM_TAXCODEMapping: Tax Code4COUNTRYISOCountrynvarchar20
118TTEM_TAXTYPE2Mapping: Tax Type4COUNTRYISOCountrynvarchar20
119TTEM_TAXTYPEC[TTE 3.0 only] Mapping: Tax Type1COUNTRYISOCountrynvarchar20
120TTEM_TAXTYP_EXTMapping TTE Tax Types to External Tax Types2COUNTRYISOCountrynvarchar20
121TTEPDT_COUNTRIESPersistency TTE Document COUNTRY spez.3COUNTRYISOCountrynvarchar20
122TTEPDT_EXEMPVALUPersistency TTE Document Item Exemption Value4COUNTRYISOCountrynvarchar20
123TTEPDT_ITEMPARTPersistency TTE Document item partner6COUNTRYISOCountrynvarchar20
124TTEPDT_PAPROPPersistency TTE Document business partner property4COUNTRYISOCountrynvarchar20
125TTEPDT_PARTNERPersistency TTE Document business partner4COUNTRYISOCountrynvarchar20
126TTEPDT_PATAXCLPersistency TTE Document business partner tax class.4COUNTRYISOCountrynvarchar20
127TTEPDT_PATAXNUMPersistency TTE Document business partner tax number4COUNTRYISOCountrynvarchar20
128TTEPDT_PRPROPPersistency TTE Document product property4COUNTRYISOCountrynvarchar20
129TTEPDT_PRTAXCLPersistency TTE Document product tax class.4COUNTRYISOCountrynvarchar20
130TTEPDT_TAXELPersistency TTE Document / Item tax element5COUNTRYISOCountrynvarchar20
131TTEPDT_TAXEVENTPersistency TTE Document / Item tax event5COUNTRYISOCountrynvarchar20
132TTEPDT_TAXVALUEPersistency TTE Document / Item tax value5COUNTRYISOCountrynvarchar20
133TTESDT_ACCUMVALUDocument business partner accum. values of with. tax.4COUNTRYISOCountrynvarchar20
134TTESDT_COUNTRIESDocument COUNTRY spez.3COUNTRYISOCountrynvarchar20
135TTESDT_DOCUMENTTTE Simulaton Document2COUNTRYISOCountrynvarchar20
136TTESDT_EXEMPVALUDocument business partner exemption values for with. tax.4COUNTRYISOCountrynvarchar20
137TTESDT_ITEMPARTDocument item partner6COUNTRYISOCountrynvarchar20
138TTESDT_PAPROPDocument business partner property4COUNTRYISOCountrynvarchar20
139TTESDT_PARTNERDocument business partner4COUNTRYISOCountrynvarchar20
140TTESDT_PATAXCLDocument business partner tax class.4COUNTRYISOCountrynvarchar20
141TTESDT_PATAXNUMDocument business partner tax number4COUNTRYISOCountrynvarchar20
142TTESDT_PRPROPDocument product property4COUNTRYISOCountrynvarchar20
143TTESDT_PRTAXCLDocument product tax class.4COUNTRYISOCountrynvarchar20
144TTESDT_TAXELDocument / Item tax element5COUNTRYISOCountrynvarchar20
145TTESDT_TAXEVENTDocument / Item tax event5COUNTRYISOCountrynvarchar20
146TTESDT_TAXVALUEDocument / Item tax value5COUNTRYISOCountrynvarchar20
147TTE_WT_ACCUMVALUAP-TTE accumulated base amounts and withholding tax amounts4COUNTRYISOCountrynvarchar20