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_CODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/AT_APPR_HISApproval History for Level Based Approvals39TAX_CODETax on sales/purchases codenvarchar20
2/OPT/AT_LBA_LOGApproval History for Level Based Approvals40TAX_CODETax on sales/purchases codenvarchar20
3/OPT/CT_IDH_HEADInbound Document Handler: Registration table with header inf43TAX_CODETax Codenvarchar20
4/OPT/VIM_CA_TAXTax Code Determination Configuration for Canada11TAX_CODETax Codenvarchar20
5/OPT/X110Tax Code Determination Configuration7TAX_CODETax Codenvarchar20
6/OPT/Y110Tax Code Determination Configuration7TAX_CODETax Codenvarchar20
7/OPT/Z110Tax Code Determination Configuration7TAX_CODETax Codenvarchar20
8/ORS/INV_ADDInvoice Add7TAX_CODETax on sales/purchases codenvarchar20
9ARBERP_C_TAXCODEIncoming Invoice: Map Tax Codes for Logistics Invoice Verif.6TAX_CODETax on sales/purchases codenvarchar20
10ARBERP_C_TAXCTGYMap ERP tax code to cXML tax category3TAX_CODETax on sales/purchases codenvarchar20
11ARBERP_C_TAXC_SDMap ERP tax code to cXML tax category for SD outbound msg3TAX_CODETax on sales/purchases codenvarchar20
12BBPC_PRES_UNPLTemplates for Items in the Confirmation12TAX_CODETax on sales/purchases codenvarchar20
13BBP_DET_TAX_CODETax Code Determination6TAX_CODETax on Sales/Purchases Codenvarchar20
14BBP_PCACCProcurement Card: Accounting Data10TAX_CODETax on sales/purchases codenvarchar20
15BBP_PCIACAccounting Data for Procurement Card Company7TAX_CODEInput Tax Code for Non-Taxable Transactionsnvarchar20
16BBP_PCLOGProcurement Card Statement: Logistic data19TAX_CODETax on sales/purchases codenvarchar20
17BBP_PCMODProcurement Card: Modified Statement Data12TAX_CODETax on sales/purchases codenvarchar20
18BBP_PCTAXProcurement Card: Tax Data6TAX_CODETax on sales/purchases codenvarchar20
19BBP_PDFRTShipment Costs5TAX_CODETax on Sales/Purchases Codenvarchar20
20BBP_PDIGPBusiness Transaction Item-Purchasing Information29TAX_CODETax on Sales/Purchases Codenvarchar20
21BBP_PDTAXTax5TAX_CODETax on Sales/Purchases Codenvarchar20
22BBP_TAXTax Codes for Enterprise Buyer2TAX_CODETax on Sales/Purchases Codenvarchar20
23BBP_TAXCODE_FAVUser-Specific Favorites for Tax Types per Country3TAX_CODETax on Sales/Purchases Codenvarchar20
24BBP_TAXTEnterprise Buyer: Tax Code Description3TAX_CODETax on Sales/Purchases Codenvarchar20
25DCFLC_TAXCODE_TVTax Code8TAX_CODETax on sales/purchases codenvarchar20
26DCFLC_TXCD_TJ_TVTax Code8TAX_CODETax on sales/purchases codenvarchar20
27IDPL_II_TAXPolish internal invoice - Tax exemptions3TAX_CODETax on sales/purchases codenvarchar20
28IDPL_II_TAX_EXEMPolish internal invoice - Tax exemptions2TAX_CODETax on sales/purchases codenvarchar20
29REQLINEMATemporary Line Data: Requirement Coverage Request(MRO Lines)97TAX_CODETax on Sales/Purchases Codenvarchar20
30REQLINESRTemporary Line Data: Requirement Coverage Request (Services)46TAX_CODETax on sales/purchases codenvarchar20
31T5ITF24BGModule group table8TAX_CODEF24: Compensated tax payer's reference numbernvarchar40
32TCM_C_TCTXC_MAPMap transportation charge type to Tax code5TAX_CODETax on sales/purchases codenvarchar20
TOPBasis Components
33/XFT/INV_Q_1Invoice receipt queue: Items11TAX_CODESales Tax Codenvarchar20
34/XFT/INV_Q_11Account assignment data7TAX_CODESales Tax Codenvarchar20
35/XFT/INV_Q_11_SAccount assignment data7TAX_CODESales Tax Codenvarchar20
36/XFT/INV_Q_1_SInvoice receipt queue: Items11TAX_CODESales Tax Codenvarchar20
37/XFT/INV_Q_7Tax data3TAX_CODETax on sales/purchases codenvarchar20
38/XFT/INV_Q_7_STax data3TAX_CODETax on sales/purchases codenvarchar20
TOPClaims Management
39TICL553Relationship of Payment Type to Main/Sub-Transaction4TAX_CODEGovernment Type Code / Tax Authorities Payment Typenvarchar20
40TICL557Combination of Tax Role and Participant6TAX_CODEGovernment Type Code / Tax Authorities Payment Typenvarchar20
TOPDown Payment Chains
41/SAPPCE/TDPC20Down Payment Chain: Document Header14TAX_CODETax on sales/purchases codenvarchar20
42/SAPPCE/TDPC21Down Payment Chain: Document Segments10TAX_CODETax on sales/purchases codenvarchar20
TOPFinancial Accounting
43/OPT/VIM_1HEADDocument Header98TAX_CODETax Codenvarchar20
44/OPT/VIM_TAX_CFGTax Code Determination Configuration7TAX_CODETax Codenvarchar20
TOPGL Account Posting
45TCJ_POSITIONSCash Journal Document Items17TAX_CODETax on sales/purchases codenvarchar20
46TCJ_TRANSACTIONSCash Journal Business Transactions6TAX_CODETax on sales/purchases codenvarchar20
TOPIncentive and Commission Management ICM
47CACS00_DOCFI_PData Transfer: FI Documents (Items)12TAX_CODETax on sales/purchases codenvarchar20
48CACSCD_DOCCD_PDSettlement to FS-CD: Reference Document Line Items17TAX_CODETax on sales/purchases codenvarchar20
49CACSCD_DOCCD_TXSettlement to FS-CD: Reference Document Tax5TAX_CODETax on sales/purchases codenvarchar20
50CACSFI_DOCFI_COSettlement to FI: Reference Document Costs8TAX_CODETax on sales/purchases codenvarchar20
51CACSFI_DOCFI_PDSettlement to FI: Reference Line Item11TAX_CODETax on sales/purchases codenvarchar20
52CACSFI_DOCFI_TXSettlement to FI: Reference Document Tax6TAX_CODETax on sales/purchases codenvarchar20
53CACSHR_DOCHR_TXSettlement to PY: Reference Document Tax6TAX_CODETax on sales/purchases codenvarchar20
54YCRM01_ACCASAccount Assignment Type/Cost Information for Remuneration5TAX_CODETax on sales/purchases codenvarchar20
55YCRM01_ACCSTAccount Assignment Type/Cost Info for Settlement Types5TAX_CODETax on sales/purchases codenvarchar20
56YCRM01_DOCFI_HData Transfer: FI Documents Header Data4TAX_CODETax on sales/purchases codenvarchar20
57YCRM01_DOCFI_PData Transfer: FI Documents Item14TAX_CODETax on sales/purchases codenvarchar20
58YHITEC_DOCFI_PData Transfer: FI Documents Item12TAX_CODETax on sales/purchases codenvarchar20
59YSVMA_ACCASAccount Assignment Type/Cost Information for Remuneration7TAX_CODETax on sales/purchases codenvarchar20
60YSVMA_ACCSTAccount Assignment Type/Cost Info for Settlement Types11TAX_CODETax on sales/purchases codenvarchar20
61YSVMA_DOCFI_PData Transfer: FI Documents (Items)12TAX_CODETax on sales/purchases codenvarchar20
62YTEL01_ACCASAccount Assignment Type/Cost Information for Remuneration13TAX_CODETax on sales/purchases codenvarchar20
63YTEL01_ACCSTAccount Assignment Type/Cost Info for Settlement Types6TAX_CODETax on sales/purchases codenvarchar20
64YTEL01_DOCFI_PData Transfer: FI Documents Item12TAX_CODETax on sales/purchases codenvarchar20
65YTEL05_ACCASAccount Assignment Type/Cost Information for Remuneration11TAX_CODETax on sales/purchases codenvarchar20
66YTEL05_ACCSTAccount Assignment Type/Cost Info for Settlement Types11TAX_CODETax on sales/purchases codenvarchar20
67YTEL05_DOCFI_PData Transfer: FI Documents (Items)12TAX_CODETax on sales/purchases codenvarchar20
68ZICMAG_DOCFI_PData Transfer: FI Documents (Items)12TAX_CODETax on sales/purchases codenvarchar20
TOPPeriodical Sales and Distribution
69JITCIRCBOOKIS-M/SD: Circulation Book with Delivery Quantities19TAX_CODETax on sales/purchases codenvarchar20
TOPSAP Retail Store
70WOSCR_EXI_003Tax Code Lines for Expense Invoice3TAX_CODETax on sales/purchases codenvarchar20
71WOSCR_EXI_003TText Table - Tax Code Lines for Expense Invoice4TAX_CODETax on sales/purchases codenvarchar20
TOPTariffs, Duties and Permits
72OIH_J1B_PCKBrazil: Check table for tax codes in Purchasing13TAX_CODETax on sales/purchases codenvarchar20
73OIH_J1B_SALBrazil: Check table for tax codes in sales process15TAX_CODESD tax codenvarchar20
74OIH_J1B_SAL_2Brazil: ICMS Deferment14TAX_CODESD tax codenvarchar20
75OIH_J1B_SDTXCDSD tax code for ICMS ST calculation2TAX_CODESD tax codenvarchar20
76OIH_J1B_TINBrazil: Check table for tax codes in Transfer Incoming9TAX_CODETax code for Brazil localizationnvarchar10
77OIH_J1B_TOUBrazil: Check table for tax codes in Transfer Outgoing13TAX_CODETax on sales/purchases codenvarchar20
TOPTransaction Manager
78TRXT_FLOWTRM Tax Transaction Flows6TAX_CODETax Codenvarchar20
TOPTravel Expenses
79PTRV_SRECTrip Statistics - Receipts15TAX_CODETax on sales/purchases codenvarchar20
TOPVehicle Management System
80VLCBATCHACTVELO : Variant for Action Execution in Batch27TAX_CODETax on sales/purchases codenvarchar20
TOPWarranty Claim Processing
81PVWTYWarranty Claim Item (PPE Variant)28TAX_CODETax on Sales/Purchases Codenvarchar20