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

56 columns | Print definition?ERP 6.0  | TAXCODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CN/CTXSAPD0201Country/Tax Code4TAXCODETax Codenvarchar40
2/1CN/CTXSAPR0201Country/Tax Code4TAXCODETax Codenvarchar40
3/1CN/CTXSAPW0201Country/Tax Code4TAXCODETax Codenvarchar40
4DFKKSAFTINV_ISAF-T Source Document: Item25TAXCODEPortugal: SAF-T Tax codenvarchar100
5DFKKSAFTPAY_ISAF-T Payment Source Document: Item14TAXCODEPortugal: SAF-T Tax codenvarchar100
6FIEUD_SBINV_ISAFT: Self Billing Invoices ( Line Items)26TAXCODETax on sales/purchases codenvarchar20
7FIEUD_SDINV_ISAFT: Invoices from SD module(Item)25TAXCODETax on sales/purchases codenvarchar20
8J_1GMYF0_MMYF data6TAXCODEMYF: TAX code/cashreg_idnvarchar200
9J_1GWTR0Vendor Tax Data4TAXCODETax Identification Number (AFM)nvarchar110
10J_1UFDI_SPTXCODETax Codes Relevant for Types of Reasons5TAXCODETax on sales/purchases codenvarchar20
11TIVXCITIREFTMapping of IRE Status to Contract-Flow type-Taxcode6TAXCODEIRE Tax Codenvarchar40
TOPBasic Functions
12RF07Withholding tax in Italy : Modello 770 - additional data21TAXCODETax codenvarchar160
TOPBSI
13BTXCUTXBSI: Customer Tax Formula4TAXCODEBSI: Tax Codenvarchar110
14BTXCUTX_OBSI: Customer Tax Formula3TAXCODEBSI: Tax Codenvarchar110
15BTXOVERBSI: Higher Level Tax Formula5TAXCODEBSI: Tax Codenvarchar110
16BTXOVER_OBSI: Higher Level Tax Formula4TAXCODEBSI: Tax Codenvarchar110
17BTXOVFRBSI: Higher Level Formulas for Employees5TAXCODEBSI: Tax Codenvarchar110
18BTXOVFR_OBSI: Higher Level Formulas for Employees4TAXCODEBSI: Tax Codenvarchar110
19BTXRATEBSI: Tax Rates per Company Based on Degree of Experience5TAXCODEBSI: Tax Codenvarchar110
20BTXRATE_OBSI: Tax Rates per Company Based on Degree of Experience4TAXCODEBSI: Tax Codenvarchar110
21BTXTAXCTax Authority Mapping4TAXCODEBSI: Tax Codenvarchar110
TOPContract Accounts Receivable and Payable
22TFK_MAP_KOFIZ_SDFld Value Alloc. of Tax Features for Acct Determination IDs2TAXCODECRM: Tax Feature for Business Agreementnvarchar20
TOPFinancial Accounting
23J_1GMYF0MYF data5TAXCODETax Identification Number (AFM)nvarchar110
24J_1GWTC0Withholding tax certificates data4TAXCODETax Identification Number (AFM)nvarchar110
TOPFinancial Services Localization
25/GSINS/BRBPWHTTax Details - Brazil Insurance3TAXCODEWithholding Tax Codenvarchar20
TOPFlexible Real Estate Management
26TIVITTCACCTXCDAssignment of Tax Code for Correction Posting3TAXCODETax Codenvarchar20
27VIITTCBASEBasis for Input Tax Correction4TAXCODETax Codenvarchar20
28VIITTCCALCRESInput Tax Correction: Line Item7TAXCODETax Codenvarchar20
TOPGeneric Contract Accounts Receivable and Payable
29TFSC_MAP_KOFIZFld Value Assgt. of Tax Features for Acct Determin. Features2TAXCODECRM: Tax Feature for Business Agreementnvarchar20
TOPIntegration Customer Relationship Management
30EPPSIMRESULTTXProduct Proposal Simulation Tax Results5TAXCODETax on sales/purchases codenvarchar20
TOPJoint Venture und Production Sharing Accounting
31T8J0FBilling method Posting Rule7TAXCODETax on sales/purchases codenvarchar20
32T8JOPartner10TAXCODETax on sales/purchases codenvarchar20
33T8JVJoint Venture8TAXCODETax on sales/purchases codenvarchar20
TOPLocalization
34J_1BPOSCOUPONSPOS-Database Coupons (Brazilian)15TAXCODETax codenvarchar50
35J_1BPOSREDUCTIONPOS-Database Reduction (Brazilian)18TAXCODETax codenvarchar50
36J_1BTXSDCSD tax codes2TAXCODESD tax codenvarchar20
37J_1BTXSDCTSD tax codes - description3TAXCODESD tax codenvarchar20
38PTDART_TAX_DATATax Code Data2TAXCODETax on sales/purchases codenvarchar20
39SAFT_PT_TAX_DATATax Details for SAFT-PT4TAXCODETax on sales/purchases codenvarchar20
TOPProduction and Revenue Accounting
40OIUCM_T8JVPRA Joint Venture Master Data8TAXCODETax on sales/purchases codenvarchar20
TOPRental Accounting
41TIVEXFIDEEPTAXRows for Multilevel Tax Code3TAXCODEMultilevel Tax Codenvarchar20
42TIVEXFITAXMAPTax Code Assignment per RE Tax Type/Group7TAXCODETax on sales/purchases codenvarchar20
TOPTransaction Tax Engine
43TTEC_TAXCODETax Code3TAXCODETax Codenvarchar40
44TTEC_TAXCODE_2Assign Tax Events to Tax Code3TAXCODETax Codenvarchar40
45TTEC_TAXCODE_3Assign TTE Entities to Tax Code3TAXCODETax Codenvarchar40
46TTEC_TAXCODE_TTax Code4TAXCODETax Codenvarchar40
47TTEM_TAXCODEMapping: Tax Code8TAXCODETax Codenvarchar40
48TTEPDT_TAXCODVADocument / Item TaxCode Value6TAXCODETaxCodenvarchar40
49TTEPDT_TAXELPersistency TTE Document / Item tax element25TAXCODETaxCodenvarchar40
50TTEPDT_TAXEVENTPersistency TTE Document / Item tax event17TAXCODETaxCodenvarchar40
51TTESDT_TAXCODVADocument / Item pricing element6TAXCODETaxCodenvarchar40
52TTESDT_TAXELDocument / Item tax element25TAXCODETaxCodenvarchar40
53TTESDT_TAXEVENTDocument / Item tax event17TAXCODETaxCodenvarchar40
TOPUSA
54BTXTERRBSI: Employee Payroll Error Message Grouping5TAXCODEBSI: Tax Codenvarchar110
55BTXTRESBSI: Tax Results5TAXCODEBSI: Tax Codenvarchar110
56BTXTTAXBSI: Test Taxes5TAXCODEBSI: Tax Codenvarchar110