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

81 columns | Print definition?ERP 6.0  | TAX_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/VAT_TRANKEYvat transaction keys input or output2TAX_TYPETax Typenvarchar10
2BBP_TAXTax Codes for Enterprise Buyer5TAX_TYPETax Category (Only USA/Canada/Brazil)nvarchar10
3BBP_TAXGROUP_FAVUser-Specific Favorites: Tax Groups for Tax Type5TAX_TYPETax Typenvarchar40
4CBP_TAXCLASSObsolete...3TAX_TYPETax Typenvarchar40
5CTCET_TAXCLASSAssign Tax Group/Tax Type to SAP ECC Tax Classification-TCET3TAX_TYPETax Typenvarchar40
6IDSAU_SHAREHOLDForeign Shareholders Percentages5TAX_TYPETax Type for Company Activitynvarchar40
7IDSAU_TAXRATESTax Rates valid for fiscal year3TAX_TYPETax Type for Company Activitynvarchar40
8OIUX8_NM_TAXDTLTax 2.0 - New Mexico Tax Details6TAX_TYPESeverance Tax Typenvarchar20
9TCM_C_BPTAXCLASSAssign Tax Group/Tax Type to SAP ECC Tax Classification BP3TAX_TYPETax Typenvarchar40
TOPBasic Functions
10ETXDCIExternal tax document: line item info18TAX_TYPEIndicator: Sales/use/rental/service/taxnvarchar10
11TTXYExternal tax interface: tax information29TAX_TYPEIndicator: Sales/use/rental/service/taxnvarchar10
TOPBSI
12BSIUDTTHR-US: BSI test data (tax record)6TAX_TYPETax Typenvarchar20
TOPCentral Part of Product Master
13CRMC_TAX_GROUPSales Taxes: Customizing4TAX_TYPETax Typenvarchar40
14CRMC_TAX_GROUP_TSales Taxes: Customizing5TAX_TYPETax Typenvarchar40
15CRMC_TAX_MAPR/3 to CRM Assignment Table for Taxes4TAX_TYPETax Typenvarchar40
16CRMC_TAX_MAP_BPBP Tax Classification of Conditions: Mapping R/3 <-> CRM4TAX_TYPETax Typenvarchar40
17CRMC_TAX_TEXTSales Taxes: Customizing2TAX_TYPETax Typenvarchar40
18CRMM_PR_TAXProduct Sales Tax5TAX_TYPETax Typenvarchar40
19CRMM_PR_TAXHProduct Sales Tax - History6TAX_TYPETax Typenvarchar40
TOPCountry-Specific Objects
20COMC_R3_FIELDSAssignment of R/3 material master fields to CFOP tax classif4TAX_TYPETax Typenvarchar40
TOPCustomer Master
21TB070T_CMTax Classification: Tax Types per Country, Names4TAX_TYPETax Classification: Tax Typenvarchar40
22TB070_CMTax Classification: Tax Types per Country3TAX_TYPETax Classification: Tax Typenvarchar40
23TB071_CMTax Classification: Assignment of Tax Groups to Tax Types4TAX_TYPETax Classification: Tax Typenvarchar40
24TB072_CMTax Classification: Mapping R/3 <-> CRM4TAX_TYPETax Classification: Tax Typenvarchar40
25TB077_CMAssignment of R/3 Field to CRM Tax Type3TAX_TYPETax Classification: Tax Typenvarchar40
26TB078_CMAssignment of R/3 Field Value to CRM Tax Group3TAX_TYPETax Classification: Tax Typenvarchar40
TOPElectronic Data Interchange
27PRICAT_K003ZPRICAT: Catalog item basic data extras31TAX_TYPETax category (sales tax, federal sales tax,...)nvarchar40
28WRF_PRICAT_TAXPrice Catalog Conversion Percent -> Classification6TAX_TYPETax category (sales tax, federal sales tax,...)nvarchar40
TOPGlobal Trade Services
29/SAPSLL/PRTAXLegal and Logistics Services: Product Master - Tax Groups6TAX_TYPETax Typenvarchar40
30/SAPSLL/TLC_VATImport Turnover Tax Rates for Europe4TAX_TYPETax Typenvarchar40
31/SAPSLL/TPRGPGMapping: Feeder System Product Tax Classification for Group7TAX_TYPETax Typenvarchar40
32/SAPSLL/TPRVPGMapping: Feeder System Tax Classification Product7TAX_TYPETax Typenvarchar40
TOPLocalization
33J_3R_FATAXTransport Tax Data2TAX_TYPETax Typenvarchar10
34J_3R_FATAX_DECLHDeclaration Header (Transport, Property Tax)2TAX_TYPETax Typenvarchar10
TOPProduction and Revenue Accounting
35OIUREP_TAXBACKUPBackup tax table for old tax reporting SOL34TAX_TYPESeverance Tax Typenvarchar20
36OIUREP_TAX_SOLOld tax reporting SOL configuration table3TAX_TYPETax typenvarchar20
TOPPublic Sector Contract Accounts Receivable and Payable
37DFMCA_BRF910BRF: Create Tax Number7TAX_TYPEBRF: Expressionnvarchar200
TOPRevenue
38OIURV03_FRMTAXValuation Transactions Level 3 - Formula Tax Detail6TAX_TYPESeverance Tax Typenvarchar20
39OIURV03_TAXDTLValuation Tax Master Detail6TAX_TYPESeverance Tax Typenvarchar20
40OIURV03_TAXEMPValuation Tax Exempt Detail6TAX_TYPESeverance Tax Typenvarchar20
41OIURV03_TAXMKTValuation Tax Marketing Detail6TAX_TYPESeverance Tax Typenvarchar20
TOPSAP Business Partner
42BUT_FRG0011Business Partner: Tax Classification5TAX_TYPETax Typenvarchar40
43TB070Tax Classification: Tax Types per Country3TAX_TYPETax Typenvarchar40
44TB070TTax Classification: Tax Types per Country, Descriptions4TAX_TYPETax Typenvarchar40
45TB071Define Business Partner Tax Groups4TAX_TYPETax Typenvarchar40
46TB071_TDefine Business Partner Tax Groups5TAX_TYPETax Typenvarchar40
TOPTariffs, Duties and Permits
47OIH_ETAX_GRPDefinition of Oil-Specific Product Tax Groups4TAX_TYPETax Classification: Tax Typenvarchar40
48OIH_ETAX_TB070Definition of Excise Tax Type per Country3TAX_TYPETax Classification: Tax Typenvarchar40
49OIH_ETAX_TB070TDescription of Excise Tax Type per Country4TAX_TYPETax Classification: Tax Typenvarchar40
TOPTax Reporting
50OIUX1_ADJ_MKTCTax adjustments marketing costs for reporting3TAX_TYPESeverance Tax Typenvarchar20
51OIUX1_ADJ_TAXDCTax adjustments detail for reporting3TAX_TYPESeverance Tax Typenvarchar20
52OIUX1_ADJ_XMPCTax adjustment exemptions for reporting3TAX_TYPESeverance Tax Typenvarchar20
53OIUX1_AGY_DEFNAgency definition4TAX_TYPESeverance Tax Typenvarchar20
54OIUX1_TRN_MKTCTax transaction marketing costs for reporting3TAX_TYPESeverance Tax Typenvarchar20
55OIUX1_TRN_MKTLTax transaction marketing costs for reporting3TAX_TYPESeverance Tax Typenvarchar20
56OIUX1_TRN_TAXDCTax transaction detail for reporting3TAX_TYPESeverance Tax Typenvarchar20
57OIUX1_TRN_TAXDLTax transaction detail for reporting3TAX_TYPESeverance Tax Typenvarchar20
58OIUX1_TRN_XMPCTax transaction exemptions for reporting3TAX_TYPESeverance Tax Typenvarchar20
59OIUX1_TRN_XMPLTax transaction exemptions for reporting3TAX_TYPESeverance Tax Typenvarchar20
60OIUX1_TXCD_XREFCross reference between state tax codes and PRA entities5TAX_TYPESeverance Tax Typenvarchar20
61OIUX3_TX_OOSHSTTax Reporting - Texas Out Of Statute Transaction History14TAX_TYPESeverance Tax Typenvarchar20
62OIUX3_TX_OOSTXNTax Reporting - Texas Out Of Statute Transactions14TAX_TYPESeverance Tax Typenvarchar20
63OIUX3_TX_PRDTBTax Reporting - Texas PRA Detail Txns-Tier Tax Below15TAX_TYPESeverance Tax Typenvarchar20
64OIUX3_TX_PRDTITax Reporting - Texas PRA Detail Txns-Tier Tax Incremental15TAX_TYPESeverance Tax Typenvarchar20
65OIUX3_TX_PRDTNTax Reporting - Texas PRA Detail Txns - No Tier Tax15TAX_TYPESeverance Tax Typenvarchar20
66OIUX3_TX_TAXHSTTax Reporting - Texas Tax History Transactions14TAX_TYPESeverance Tax Typenvarchar20
67OIUX3_TX_TAXSTGTax Reporting - Texas Tax Transaction Staging14TAX_TYPESeverance Tax Typenvarchar20
68OIUX3_TX_TAXTXNTax Reporting - Texas Tax Transactions14TAX_TYPESeverance Tax Typenvarchar20
69OIUX5_OK_TAX_RTTax 2.0 - Oklahoma Tax Rates2TAX_TYPESeverance Tax Typenvarchar20
TOPTransaction Tax Engine
70TTEPD3_USITEMPersistency TTE Document UsItem24TAX_TYPEIndicator: Tax Category (Sales/Rental/Use/Lease)nvarchar10
71TTEPDT_USITEMPersistency TTE Document UsItem24TAX_TYPEIndicator: Tax Category (Sales/Rental/Use/Lease)nvarchar10
72TTESDT_USITEMOutput Exemptions24TAX_TYPEIndicator: Tax Category (Sales/Rental/Use/Lease)nvarchar10
TOPValuation
73OIURV_DOC_FRMTAXValuation Transactions Level 3 - Formula Tax Detail6TAX_TYPESeverance Tax Typenvarchar20
74OIURV_DOC_TAXDTLValuation Tax Master Detail6TAX_TYPESeverance Tax Typenvarchar20
75OIURV_DOC_TAXEMPValuation Tax Exempt Detail6TAX_TYPESeverance Tax Typenvarchar20
76OIURV_DOC_TAXMKTValuation Tax Marketing Detail6TAX_TYPESeverance Tax Typenvarchar20
77OIURV_DO_DPSEVTDOI Accounting Severance Tax Types Table5TAX_TYPESeverance Tax Typenvarchar20
78OIURV_STSSeverance tax statistics3TAX_TYPESeverance Tax Typenvarchar20
79OIURV_STS_EMPSeverance Tax Statistics - Exempt3TAX_TYPESeverance Tax Typenvarchar20
80OIURV_STS_MKTSeverance Tax Statistics - Marketing3TAX_TYPESeverance Tax Typenvarchar20
81OIUVL_STSSeverance tax statistics3TAX_TYPESeverance Tax Typenvarchar20