SAP Tables - SAP Business One/ERP Table Definition reference

 Module:  Table: 

icon of database logic symbol SAP  TABLESv1Made in Britain - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8BSEG345Accounting Document Segment
9AUDLORIPR7KPro: Logical Information Object Attribute Values
10/OPT/Z1344Reporting table: Text table for exception definitions

B1 9.2: Top 10 requests

1OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OPOR386Purchase Order
9JDT1124Journal Entry - Rows
10OACT114G/L Accounts

B1 8.8: Top 10 requests

2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OPCH268A/P Invoice
6OIVL77Whse Journal
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction - the webs number one PHP Function reference tool

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
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
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
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
80DFKKBOPBoleto: Item Data16QSSKZWithholding Tax Codenvarchar20
TOPRemaining Beverage - Obsolete Objects
81/BEV3/CH1030BSG1Document Segment CH Event Ledger Part121QSSKZWithholding Tax Codenvarchar20