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

105 columns | Print definition?ERP 6.0  | TAXTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBP_SUS_STG_TAXstaging tax table4TAXTYPETax Number Categorynvarchar40
2BBP_TAXTYPE_FAVUser-Specific Favorites for Tax Types per Country4TAXTYPETax Typenvarchar40
3DFKKHUREPDSRecording Data for Domestic Sales Hungary27TAXTYPEType of Tax Numbernvarchar10
4DFKKSAFTINV_ISAF-T Source Document: Item23TAXTYPEPortugal: SAF-T Tax typenvarchar30
5DFKKSAFTPAY_ISAF-T Payment Source Document: Item12TAXTYPEPortugal: SAF-T Tax typenvarchar30
6J_1BDF_STAT_TAXSet Tax Type as Statistical for Specific Scenarios4TAXTYPETax Typenvarchar40
7T011_XBRLFinancial Statement Versions10TAXTYPEType of XBRL Taxonomynvarchar50
8TFK_TAXTYPE_HUDefine Tax category for Domestic Sales2TAXTYPEType of Tax Numbernvarchar10
9TIVXCESCORRINVCorrection Invocie Settings for Spain3TAXTYPETax Typenvarchar40
10TIVXCITCRMEMOTax group for credit memo over one year3TAXTYPETax Typenvarchar40
11VIYCADVPAYAdvance Payments68TAXTYPETax Typenvarchar40
12VIYCRECEIVABLEReceivables from Settlement12TAXTYPETax Typenvarchar40
TOPBSI
13BTXBGRPBSI: Group Block Data2TAXTYPEBSI: Tax categorynvarchar20
14BTXBLOKBSI: Tax Formula Block Data2TAXTYPEBSI: Tax categorynvarchar20
15BTXBRAKBSI: Tax Formula Bracket Data2TAXTYPEBSI: Tax categorynvarchar20
16BTXFDOCBSI: Tax Formula Documentation2TAXTYPEBSI: Tax categorynvarchar20
17BTXFORMBSI Tax Formulas2TAXTYPEBSI: Tax categorynvarchar20
18BTXOVERBSI: Higher Level Tax Formula6TAXTYPEBSI: Tax categorynvarchar20
19BTXOVER_OBSI: Higher Level Tax Formula5TAXTYPEBSI: Tax categorynvarchar20
20BTXOVFRBSI: Higher Level Formulas for Employees6TAXTYPEBSI: Tax categorynvarchar20
21BTXOVFR_OBSI: Higher Level Formulas for Employees5TAXTYPEBSI: Tax categorynvarchar20
22BTXPLNXBSI: Benefit Plan2TAXTYPEBSI: Tax categorynvarchar20
23BTXRATEBSI: Tax Rates per Company Based on Degree of Experience6TAXTYPEBSI: Tax categorynvarchar20
24BTXRATE_OBSI: Tax Rates per Company Based on Degree of Experience5TAXTYPEBSI: Tax categorynvarchar20
25BTXRCPTBSI: Tax Formula Reciprocal Data2TAXTYPEBSI: Tax categorynvarchar20
26BTXTAXBSI: Grouping Tax Authority Tax Category2TAXTYPEBSI: Tax categorynvarchar20
27BTXTAXTBSI: Tax Category1TAXTYPEBSI: Tax categorynvarchar20
TOPClaims Management
28ICL_CTAXBENTYPMaintenance: Assignment of Tax Type to Benefit Type3TAXTYPETax Type to Be Calculatednvarchar50
29ICL_TAX_ITMTax Item10TAXTYPETax Type to Be Calculatednvarchar50
30ICS_TAX_ITMTax Item (Shadow Table)10TAXTYPETax Type to Be Calculatednvarchar50
TOPContract Accounts Receivable and Payable
31BPPAN_IDTYP_INMaintain Taxtype/ID type for PAN number3TAXTYPETax Number Categorynvarchar40
TOPCountry-Specific Objects
32DFKKBPTAXNUMTax Numbers for Business Partner3TAXTYPETax Number Categorynvarchar40
TOPFlexible Real Estate Management
33TIVITTCTXCDMAPObsolete3TAXTYPETax Typenvarchar40
34TIVXCFCSCKEYPROPService Charge Key: Properties for Fuel Management7TAXTYPETax Typenvarchar40
35TIVXCOTCONDCOA, Tax Information for Condition Type3TAXTYPETax Typenvarchar40
36TIVXCOTPARAMParameter for VAT on Expense for Service Charge Key3TAXTYPETax Typenvarchar40
37VISCS_RECEIVEOBSOLETE: Receivables (Replaced by VISCRECEIVABLE)10TAXTYPETax Typenvarchar40
38VIXCOTDSCOA, Distribution of VAT11TAXTYPETax Typenvarchar40
TOPInput Tax Treatment
39VIITTAXDSBASETax Document Item to Be Broken Down (VIITTAXDSBASE)19TAXTYPETax Typenvarchar40
TOPLocalization
40PTDART_TAX_DATATax Code Data3TAXTYPETax Typenvarchar100
41SAFT_PT_TAX_DATATax Details for SAFT-PT2TAXTYPETax Typenvarchar30
42VIXCJPFXDUNPRICEFixed Unit Prices for Service Charge Settlement17TAXTYPETax Typenvarchar40
43VIXCJPSCCOSTSEXTCosts per Object - Legacy Data Transfer8TAXTYPETax Typenvarchar40
TOPReal Estate Contract
44TIVCNCCTADDAttribute for Contract16TAXTYPEDefault Value for Tax Typenvarchar40
45VICDCFOBJObject-Related Cash Flow64TAXTYPETax Typenvarchar40
46VICDCFPAYPayment-Related Cash Flow64TAXTYPETax Typenvarchar40
TOPRental Accounting
47TIVEXFITAXMAPTax Code Assignment per RE Tax Type/Group3TAXTYPETax Typenvarchar40
48TIVEXFITAXTRKEYAssignment of Tax Transaction Key3TAXTYPETax Typenvarchar40
49TIVEXTAXCODEMAPAssignment of RE Tax Type/Group per Tax Code6TAXTYPETax Typenvarchar40
50TIVRAALTAXAssignment of Accrual Type to Tax Code3TAXTYPETax Typenvarchar40
51TIVRATAXTYPETax Types3TAXTYPETax Typenvarchar40
52TIVRATAXTYPETTax Type (Text)4TAXTYPETax Typenvarchar40
53VIRAADVPAYOBSOLETE: Advance Payment13TAXTYPETax Typenvarchar40
54VIRAADVPAYEXTAdvance Payment - Legacy Data Transfer13TAXTYPETax Typenvarchar40
55VIRAADVPAYPROCAdvance Payments per Settlement20TAXTYPETax Typenvarchar40
56VIRAADVPAYSPLITSplit Advance Payments19TAXTYPETax Typenvarchar40
57VIRADOCITEMRE Document Item52TAXTYPETax Typenvarchar40
58VIRAINVITEMRE Invoice Item17TAXTYPETax Typenvarchar40
59VITMPYTerm: Posting Rule19TAXTYPETax Typenvarchar40
TOPRevenue
60OIUH_PTR_REP_LOGProduction, Tax and Royalty Reporting Execution Log20TAXTYPESeverance Tax Typenvarchar20
TOPSales-Based Rent and Settlement
61VISRCALCCTFCAmounts in Foreign Currency7TAXTYPETax Typenvarchar40
62VISRCALCDETAILResults of Sales Grading Calculation16TAXTYPETax Typenvarchar40
63VISRCALCSBInterim Result14TAXTYPETax Typenvarchar40
64VISRCALCSUMCalculation Results per Sales Rule18TAXTYPETax Typenvarchar40
65VISRCRSPLITSplit Receivable9TAXTYPETax Typenvarchar40
66VISRMODIRESULTChanged Sales-Based Settlement Results5TAXTYPETax Typenvarchar40
67VISRMOSPLITSplit Receivable9TAXTYPETax Typenvarchar40
TOPSAP Business Partner
68TFKTAXNUMTYPETax Number Categories of Business Partner2TAXTYPETax Number Categorynvarchar40
69TFKTAXNUMTYPE_CCustomer Selection: Business Partner Tax Number Categories2TAXTYPETax Number Categorynvarchar40
70TFKTAXNUMTYPE_TName: Business Partner Tax Number Categories3TAXTYPETax Number Categorynvarchar40
TOPService Charge Settlement
71TIVSCCHRGCNCalculation of Surcharges Dependent on Contract7TAXTYPETax Typenvarchar40
72TIVSCEXTRACHRGSurcharge Schema for Surcharges in SCS11TAXTYPETax Typenvarchar40
73VISCCOSTSEXTCosts per Object - Legacy Data Transfer8TAXTYPETax Typenvarchar40
74VISCCRSPLITSplit Receivable9TAXTYPETax Typenvarchar40
75VISCRECEIVABLEReceivables from Settlement13TAXTYPETax Typenvarchar40
76VISCSCOSTSDetermined Costs7TAXTYPETax Typenvarchar40
TOPTariffs, Duties and Permits
77OIH2M_J1BCheck table for material tax group11TAXTYPEGeneral taxation type for sub. trib.nvarchar10
78OIH_J1B_INCBrazil: Incoming taxation table15TAXTYPEIncoming taxation type (Brazil)nvarchar10
79OIH_J1B_PICBrazil: Printing exceptions for ICMS7TAXTYPEGeneral taxation type for sub. trib.nvarchar10
80OIH_J1B_TOUBrazil: Check table for tax codes in Transfer Outgoing12TAXTYPEIncoming taxation type (Brazil)nvarchar10
TOPTransaction Tax Engine
81TTEC_MAPACCVALMapping Accumulated Values3TAXTYPETax Typenvarchar40
82TTED_ATAXELE_COMAcquisition: TaxElement7TAXTYPETax Typenvarchar40
83TTED_INEXEMP_COMExemptions7TAXTYPETax Typenvarchar40
84TTED_OEXEMP_COMOutput Exemptions7TAXTYPETax Typenvarchar40
85TTED_OTAXELE_COMOutput TaxElement7TAXTYPETax Typenvarchar40
86TTED_TAXCLAO_COMTaxClassification in OutputDocument7TAXTYPETax Typenvarchar40
87TTED_TAXCLAS_COMTaxClassification7TAXTYPETax Typenvarchar40
88TTED_TAXELES_COMInput document tax elements information8TAXTYPETax Typenvarchar40
89TTEM_BPTXGRP2Mapping: Business Partner Tax Group8TAXTYPETax Typenvarchar40
90TTEM_PRTXGRP2Mapping: Product Tax Group8TAXTYPETax Typenvarchar40
91TTEM_TAXTYPE[Obsolete] Mapping: Tax Type4TAXTYPETax Typenvarchar40
92TTEM_TAXTYPE2Mapping: Tax Type6TAXTYPETax Typenvarchar40
93TTEM_TAXTYPEC[TTE 3.0 only] Mapping: Tax Type5TAXTYPETax Typenvarchar40
94TTEPD3_EXEMPExemptions7TAXTYPETax Typenvarchar40
95TTEPD3_TAXCLASTaxClassification7TAXTYPETax Typenvarchar40
96TTEPD3_TAXELETaxElement7TAXTYPETax Typenvarchar40
97TTEPDT_EXEMPTPersistency TTE Document Output Exemptions4TAXTYPETax Typenvarchar40
98TTESDT_EXEMPTOutput Exemptions4TAXTYPETax Typenvarchar40
TOPUSA
99BRCDTABSI-TAX 4.0 BRCDTA2TAXTYPEBSI: Tax categorynvarchar20
100BRCGDTABSI-TAX 4.0 BRCGDTA2TAXTYPEBSI: Tax categorynvarchar20
101BRCGENBSI-TAX 4.0 BRCGEN2TAXTYPEBSI: Tax categorynvarchar20
102BRCRCPBSI-TAX 4.0 BRCRCP2TAXTYPEBSI: Tax categorynvarchar20
103BTXTERRBSI: Employee Payroll Error Message Grouping6TAXTYPEBSI: Tax categorynvarchar20
104BTXTRESBSI: Tax Results6TAXTYPEBSI: Tax categorynvarchar20
105BTXTTAXBSI: Test Taxes6TAXTYPEBSI: Tax categorynvarchar20