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  | QSSKZ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/VFI00002Localization: Witholding tax (recipient type)4QSSKZWithholding Tax Codenvarchar20
2/SMD/MD_____00HPSID-Tabelle fuer Withholding Tax Code4QSSKZWithholding Tax Codenvarchar20
3BBP_RBKPDocument Header: Invoice Receipt57QSSKZWithholding Tax Codenvarchar20
4BSAD_BAKAccounting: Secondary index for customers (cleared items)139QSSKZWithholding Tax Codenvarchar20
5BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)84QSSKZWithholding Tax Codenvarchar20
6BSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)81QSSKZWithholding Tax Codenvarchar20
7BSEGAccounting Document Segment19QSSKZWithholding Tax Codenvarchar20
8BSID_BAKAccounting: Secondary Index for Customers139QSSKZWithholding Tax Codenvarchar20
9BSIK_BAKAccounting: Secondary index for vendors84QSSKZWithholding Tax Codenvarchar20
10BSIS_BAKAccounting: Secondary Index for G/L Accounts81QSSKZWithholding Tax Codenvarchar20
11BSSEGAccounting Document Segment19QSSKZWithholding Tax Codenvarchar20
12FAGLBSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)75QSSKZWithholding Tax Codenvarchar20
13FAGLBSIS_BAKAccounting: Secondary Index for G/L Accounts75QSSKZWithholding Tax Codenvarchar20
14FUDT_VDOCBSEGVerification Document Item with Additional Info19QSSKZWithholding Tax Codenvarchar20
15FUDT_VDOCBSEGEVVerification Document Item in the Entry View19QSSKZWithholding Tax Codenvarchar20
16FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)19QSSKZWithholding Tax Codenvarchar20
17GLPOS_C_CTFI Document: Entry View205QSSKZWithholding Tax Codenvarchar20
18GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items205QSSKZWithholding Tax Codenvarchar20
19GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items205QSSKZWithholding Tax Codenvarchar20
20GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items205QSSKZWithholding Tax Codenvarchar20
21GLPOS_N_CTNew General Ledger: Line Item with Currency Type210QSSKZWithholding Tax Codenvarchar20
22GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type210QSSKZWithholding Tax Codenvarchar20
23REGUPProcessed items from payment program68QSSKZWithholding Tax Codenvarchar20
24T059FFormulas for Calculating Withholding Tax4QSSKZWithholding Tax Codenvarchar20
25TFK059QEBRSRDefinition of tax calculation per Service3QSSKZWithholding Tax Codenvarchar20
TOPAccounting Interface
26GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)234QSSKZWithholding Tax Codenvarchar20
27GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)234QSSKZWithholding Tax Codenvarchar20
TOPBasic Functions
28WTMIGMATCHWithholding Tax Changeover: Creation of Code -> Type/Code4QSSKZWithholding Tax Codenvarchar20
29WTMIGTCChangeover - Assgt of Classic W/Tax Code to Ext.Type/Code4QSSKZWithholding Tax Codenvarchar20
30WTMIG_PROT1Withholding Tax Changeover: Global Log Data6QSSKZWithholding Tax Codenvarchar20
31WTMIG_PROT2Withholding Tax Changeover: Detailed Log Data7QSSKZWithholding Tax Codenvarchar20
TOPBusiness Partner
32TIVBPVENDORCMPVendor Preassignment (CoCd Data)35QSSKZWithholding Tax Codenvarchar20
TOPCollectionsDisbursements
33DIMAPARWHVValid Variable Withholding Tax Supplements for IO-BP Rel.4QSSKZWithholding Tax Codenvarchar20
34ITAGCYSUBCOMMCommission to Subagencies (Main and Subtransactions)5QSSKZWithholding Tax Codenvarchar20
35VVSCPOSPayment Plan Item98QSSKZWithholding Tax Codenvarchar20
TOPContract Accounts Receivable and Payable
36DFKK10991099 Statutory Reporting Data14QSSKZWithholding Tax Codenvarchar20
37DFKKMOPItems in contract account document106QSSKZWithholding Tax Codenvarchar20
38DFKKOPItems in contract account document106QSSKZWithholding Tax Codenvarchar20
39DFKKOP_REPOpen Items from FPO4111QSSKZWithholding Tax Codenvarchar20
40DFKKPOPPayment Order: Item Data16QSSKZWithholding Tax Codenvarchar20
41DFKKQSRIndividual Records for Withholding Tax Report10QSSKZWithholding Tax Codenvarchar20
42DPAYPPayment program - data on paid item57QSSKZWithholding Tax Codenvarchar20
43FKKBRGPHelp structure for lock object : Brazil Insurance invoice po3QSSKZWithholding Tax Codenvarchar20
44T059Q_TRATE_INDTax Rates of the TDS On Security Deposits FI-CA3QSSKZWithholding Tax Codenvarchar20
45TFK059BRACThreshold Limits for Withholding Tax Code & Suppl. Tax Code3QSSKZWithholding Tax Codenvarchar20
46TFK059BRFSFormulas for Withholding Tax Calculation4QSSKZWithholding Tax Codenvarchar20
47TFK059BRFSHFormulas for Withholding Tax: Header4QSSKZWithholding Tax Codenvarchar20
48TFK059BRISWithholding tax rate maintenance for ISS3QSSKZWithholding Tax Codenvarchar20
49TFK059BRRCWithholding Tax Rates for PIS/COFINS/CSLL & Collection Codes3QSSKZWithholding Tax Codenvarchar20
50TFK059BRTXAssign Tax Calculation Method to Tax codes3QSSKZWithholding Tax Codenvarchar20
51TFK059QAdditional Specifications for Vendor Withholding Tax3QSSKZWithholding Tax Codenvarchar20
52TFK059QEAdditional Withholding Tax : Characteristics3QSSKZWithholding Tax Codenvarchar20
TOPCross-Application Components
53BBSIDAccounting: Secondary index for customers139QSSKZWithholding Tax Codenvarchar20
TOPData Retention Tool
54TXW_S_BSEGRetrieve BSEG from archive72QSSKZWithholding Tax Codenvarchar20
TOPFinancial Accounting
55BSADAccounting: Secondary Index for Customers (Cleared Items)139QSSKZWithholding Tax Codenvarchar20
56BSAKAccounting: Secondary Index for Vendors (Cleared Items)84QSSKZWithholding Tax Codenvarchar20
57BSASAccounting: Secondary Index for G/L Accounts (Cleared Items)82QSSKZWithholding Tax Codenvarchar20
58BSIDAccounting: Secondary Index for Customers139QSSKZWithholding Tax Codenvarchar20
59BSIKAccounting: Secondary Index for Vendors84QSSKZWithholding Tax Codenvarchar20
60BSISAccounting: Secondary Index for G/L Accounts82QSSKZWithholding Tax Codenvarchar20
61LFB1Vendor Master (Company Code)36QSSKZWithholding Tax Codenvarchar20
62T059QWithholding Tax3QSSKZWithholding Tax Codenvarchar20
63VBSEGKDocument Segment for Vendor Document Parking27QSSKZWithholding Tax Codenvarchar20
TOPFunds Management-Specific Postings
64PSOSEGKRecurring Request Document Segment, Vendors28QSSKZWithholding Tax Codenvarchar20
TOPGeneral Ledger Accounting
65FAGLBSASAccounting: Secondary Index for G/L Accounts (Cleared Items)75QSSKZWithholding Tax Codenvarchar20
66FAGLBSISAccounting: Secondary Index for G/L Accounts75QSSKZWithholding Tax Codenvarchar20
TOPInformation System
67DKOKPOpen Item Account Balance Audit Trail70QSSKZWithholding Tax Codenvarchar20
68QSTREFI/HR Withholding Tax Report for Spain27QSSKZWithholding Tax Codenvarchar20
TOPInvoice Verification
69RBKPDocument Header: Invoice Receipt57QSSKZWithholding Tax Codenvarchar20
70RBKPBInvoice Document Header (Batch Invoice Verification)52QSSKZObsolete: Withholding tax indicator: do NOT usenvarchar20
TOPInvoicing
71DEABPSCustomer change table: Logical view of BB amounts97QSSKZWithholding Tax Codenvarchar20
TOPInvoicing in Contract Accounts Receivable and Payable
72DFKKINVBILL_IBilling Document Items39QSSKZWithholding Tax Codenvarchar20
73DFKKINVDOC_IItems of Invoicing Document44QSSKZWithholding Tax Codenvarchar20
TOPJoint Venture und Production Sharing Accounting
74T8J_POST_ERROR_CDocuments with errors in JV posting (Open Items)45QSSKZWithholding Tax Codenvarchar20
TOPLocalization
75IDWT_COND_CHKCondition check table for WT generic tool5QSSKZWithholding Tax Codenvarchar20
76J_1IEWT_MIGRATEMap Classic tax code to EWT Tax type - Tax codes3QSSKZWithholding Tax Codenvarchar20
77J_1ITDSClassic TDS - reference table13QSSKZWithholding Tax Codenvarchar20
78J_1ITDSTXCTDS - Withholding taxcode and section relationship2QSSKZWithholding Tax Codenvarchar20
TOPPayment Transactions
79FPRL_ITEMItem Data39QSSKZWithholding Tax Codenvarchar20
TOPPayments
80DFKKBOPBoleto: Item Data16QSSKZWithholding Tax Codenvarchar20
TOPRemaining Beverage - Obsolete Objects
81/BEV3/CH1030BSG1Document Segment CH Event Ledger Part121QSSKZWithholding Tax Codenvarchar20