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

32 columns | Print definition?ERP 6.0  | QSZNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VIM_CWHTAXClassic Withholding tax data for document14QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
2BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)96QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
3BSEGAccounting Document Segment164QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
4BSIK_BAKAccounting: Secondary index for vendors96QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
5BSSEGAccounting Document Segment153QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
6FUDT_VDOCBSEGVerification Document Item with Additional Info153QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
7FUDT_VDOCBSEGEVVerification Document Item in the Entry View153QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
8FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)153QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
9GLPOS_C_CTFI Document: Entry View206QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
10GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items206QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
11GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items206QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
12GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items206QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
13GLPOS_N_CTNew General Ledger: Line Item with Currency Type211QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
14GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type211QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
15REGUPProcessed items from payment program93QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
TOPBusiness Partner
16TIVBPVENDORCMPVendor Preassignment (CoCd Data)33QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
TOPContract Accounts Receivable and Payable
17DFKKMOPItems in contract account document112QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
18DFKKOPItems in contract account document112QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
19DFKKOP_REPOpen Items from FPO4117QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
20DFKKQSRIndividual Records for Withholding Tax Report12QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
21FKKVKPContract Account Partner-Specific66QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
TOPFinancial Accounting
22BSAKAccounting: Secondary Index for Vendors (Cleared Items)96QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
23BSIKAccounting: Secondary Index for Vendors96QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
24LFB1Vendor Master (Company Code)34QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
25VBSEGKDocument Segment for Vendor Document Parking29QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
TOPFunds Management-Specific Postings
26PSOSEGKRecurring Request Document Segment, Vendors30QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
TOPInformation System
27DKKOSBalance Audit Trail83QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
28DKOKSOpen Item Account Balance Audit Trail Master Record85QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
29QSTREFI/HR Withholding Tax Report for Spain28QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
TOPInvoicing
30DEABPSCustomer change table: Logical view of BB amounts102QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
TOPPublic Sector Contract Accounts Receivable and Payable
31TFICA_DEFSamples for Contract Account Types40QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100
TOPRemaining Beverage - Obsolete Objects
32/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1155QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100