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

65 columns | Print definition?ERP 6.0  | WITHT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/VFI00003Withholding Tax Return parameters3WITHTIndicator for withholding tax typenvarchar20
2/ATL/VFI00004Withholding tax (extended) to percentage group from Shaam3WITHTIndicator for withholding tax typenvarchar20
3/OPT/VIM_WHTAXWithholding tax data for document3WITHTIndicator for withholding tax typenvarchar20
4/SMD/MD_____00OXSID-Tabelle fuer Withholding tax code4WITHTIndicator for withholding tax typenvarchar20
5/SMD/MD_____00P4SID-Tabelle fuer Recipient type4WITHTIndicator for withholding tax typenvarchar20
6/SMD/MD_____00P7SID-Tabelle fuer Withholding tax type4WITHTIndicator for withholding tax typenvarchar20
7BBP_PDTAXTax41WITHTIndicator for Withholding Tax Typenvarchar20
8FIWTIN_ACC_EXEMCumulative values for accounts payable/ account receivable4WITHTIndicator for withholding tax typenvarchar20
9FIWTIN_TAN_EXEMTable for mapping TAN and Exemption Number7WITHTIndicator for withholding tax typenvarchar20
10FIWTQAC_SCCService Category Classification5WITHTIndicator for withholding tax typenvarchar20
11J_1AWTH_TAX_TAXTConditions per Tax Type for Applying WithholdingTax3WITHTIndicator for withholding tax typenvarchar20
12J_1ICO_VENDDETColumbia: Monthly data for freelancers/vendors6WITHTIndicator for withholding tax typenvarchar20
TOPBasic Functions
13KNBWCustomer master record (withholding tax types) X4WITHTIndicator for withholding tax typenvarchar20
14LFBWVendor master record (withholding tax types) X4WITHTIndicator for withholding tax typenvarchar20
15REGUPWW/tax information per w/tax type/FI line item in pmnt run8WITHTIndicator for withholding tax typenvarchar20
16T001RWTRounding rules for company code, withhold.tax type and curr.3WITHTIndicator for withholding tax typenvarchar20
17T001WTCompany code-specific information per withholding tax type3WITHTIndicator for withholding tax typenvarchar20
18T059CTypes of Recipient: Vendors per Withholding Tax Type3WITHTIndicator for withholding tax typenvarchar20
19T059DTypes of Recipient: Vendors per Withholding Tax Type4WITHTIndicator for withholding tax typenvarchar20
20T059FBFormulae for calculating withholding tax (new functions)4WITHTIndicator for withholding tax typenvarchar20
21T059FBHW/tax formulae: Header4WITHTIndicator for withholding tax typenvarchar20
22T059KWithholding tax code and processing key3WITHTIndicator for withholding tax typenvarchar20
23T059MINMAXMinimum and maximum amounts for withholding tax3WITHTIndicator for withholding tax typenvarchar20
24T059PWithholding tax types3WITHTIndicator for withholding tax typenvarchar20
25T059REXTReporting key (new withholding tax)3WITHTIndicator for withholding tax typenvarchar20
26T059UText Table: Withholding Tax Types4WITHTIndicator for withholding tax typenvarchar20
27T059ZWithholding tax code (enhanced functions)3WITHTIndicator for withholding tax typenvarchar20
28T059ZTText table: Withholding tax codes4WITHTIndicator for withholding tax typenvarchar20
29T059ZZINSWithholding tax code for interest calculation3WITHTIndicator for withholding tax typenvarchar20
30WITH_CTNCO2Withholding tax certificate numbering concept 23WITHTIndicator for withholding tax typenvarchar20
31WITH_CTNCO3Withholding tax certificate numbering concept 34WITHTIndicator for withholding tax typenvarchar20
32WITH_EXCL_WITHTAssignment to Withholding Tax Type6WITHTIndicator for withholding tax typenvarchar20
33WITH_ITEMWitholding tax info per W/tax type and FI line item6WITHTIndicator for withholding tax typenvarchar20
34WITH_ITEM_EXCLWithholding Tax Info per WTax Type (Exclusion)6WITHTIndicator for withholding tax typenvarchar20
35WTADCumulative values for accounts receivable5WITHTIndicator for withholding tax typenvarchar20
36WTADPCumulative values for accounts receivable (payment proposal)5WITHTIndicator for withholding tax typenvarchar20
37WTADPNCumulative values for accounts receivable (payment proposal)8WITHTIndicator for withholding tax typenvarchar20
38WTAKCumulative values for accounts payable5WITHTIndicator for withholding tax typenvarchar20
39WTAKPCumulative values for accounts payable (payment proposal)5WITHTIndicator for withholding tax typenvarchar20
40WTAKPNCumulative values for accounts payable (payment proposal)8WITHTIndicator for withholding tax typenvarchar20
41WTMIGMATCHWithholding Tax Changeover: Creation of Code -> Type/Code5WITHTIndicator for withholding tax typenvarchar20
42WTMIGTCChangeover - Assgt of Classic W/Tax Code to Ext.Type/Code7WITHTIndicator for withholding tax typenvarchar20
43WTMIG_PROT1Withholding Tax Changeover: Global Log Data7WITHTIndicator for withholding tax typenvarchar20
44WTMIG_PROT2Withholding Tax Changeover: Detailed Log Data8WITHTIndicator for withholding tax typenvarchar20
TOPDown Payment Chains
45/SAPPCE/TDPC23Down Payment Chain: Withholding Tax Information9WITHTIndicator for withholding tax typenvarchar20
TOPFinancial Accounting
46VSPLTWTFI Document Parking (Enjoy): W/Tax Data Amount Split6WITHTIndicator for withholding tax typenvarchar20
TOPFunds Management
47FMRPWTCUSTDefine Withholding Tax Codes5WITHTIndicator for withholding tax typenvarchar20
TOPGL Account Posting
48TCJ_WTAX_ITEMSWithholding Tax Items for Cash Journal Document Items11WITHTIndicator for withholding tax typenvarchar20
TOPInvoice Verification
49RBWSWithholding Tax Data, Incoming Invoice5WITHTIndicator for withholding tax typenvarchar20
50RBWTWithholding Tax Data, Incoming Invoice4WITHTIndicator for withholding tax typenvarchar20
TOPLocalization
51IDWT_COND_CHKCondition check table for WT generic tool4WITHTWithholding tax type for determining base amountnvarchar20
52J_1AWITHWithholding transaction data4WITHTIndicator for withholding tax typenvarchar20
53J_1AWITNRNumber determination for withholding certificates4WITHTIndicator for withholding tax typenvarchar20
54J_1IEWTECESSEducation Cess Codes3WITHTIndicator for withholding tax typenvarchar20
55J_1IEWTHKONTTable for for TDS provisions Accounts / Loss Accounts4WITHTIndicator for withholding tax typenvarchar20
56J_1IEWTPROVTable for TDS provisions21WITHTIndicator for withholding tax typenvarchar20
57J_1IEWTSURCSurcharge Tax Codes3WITHTIndicator for withholding tax typenvarchar20
58J_1IEWT_ECESS1Education Cess Rates3WITHTIndicator for withholding tax typenvarchar20
59J_1IEWT_MAPEXMPTTable for Vendor type/exemption indicators in Annual Returns3WITHTIndicator for withholding tax typenvarchar20
60J_1IEWT_MIGRATEMap Classic tax code to EWT Tax type - Tax codes4WITHTIndicator for withholding tax typenvarchar20
61J_1IEWT_SURC1Surcharge Rates3WITHTIndicator for withholding tax typenvarchar20
62J_1IEWT_TT_COLLMapping tax types to collection codes for TCS3WITHTIndicator for withholding tax typenvarchar20
63J_1I_WTH_SER_GTATable to determine withholding line for GTA2WITHTIndicator for withholding tax typenvarchar20
64J_1I_WTH_SER_MMTable to determine withholding line for GTA and Imports3WITHTIndicator for withholding tax typenvarchar20
65J_KR_T059CTypes of Recipient: Vendors per Withholding Tax Type(Korea)3WITHTIndicator for withholding tax typenvarchar20