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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

109 columns | Print definition?ERP 6.0  | BUPLA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items86BUPLAnvarchar40
2/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact86BUPLAnvarchar40
3/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items115BUPLAnvarchar40
4/OPT/VIM_1ITEM_SDocument Item70BUPLABusiness Placenvarchar40
5/OPT/VIM_TITEMDocument Item70BUPLABusiness Placenvarchar40
6BSAD_BAKAccounting: Secondary index for customers (cleared items)151BUPLABusiness Placenvarchar40
7BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)147BUPLABusiness Placenvarchar40
8BSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)55BUPLABusiness Placenvarchar40
9BSEDBill of Exchange Fields Document Segment29BUPLABusiness Placenvarchar40
10BSEGAccounting Document Segment294BUPLABusiness Placenvarchar40
11BSETTax Data Document Segment34BUPLABusiness Placenvarchar40
12BSID_BAKAccounting: Secondary Index for Customers151BUPLABusiness Placenvarchar40
13BSIK_BAKAccounting: Secondary index for vendors147BUPLABusiness Placenvarchar40
14BSIS_BAKAccounting: Secondary Index for G/L Accounts55BUPLABusiness Placenvarchar40
15BSSEGAccounting Document Segment283BUPLABusiness Placenvarchar40
16DFKKEPRTLog for Inconsistent FI-CA Documents9BUPLABusiness Placenvarchar40
17FAGLBSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)55BUPLABusiness Placenvarchar40
18FAGLBSIS_BAKAccounting: Secondary Index for G/L Accounts55BUPLABusiness Placenvarchar40
19FIKZD_CONTR_MAPPSubsoil use contracts mapping19BUPLABusiness Placenvarchar40
20FUDT_VDOCBSEDBill of Exchange Fields Document Seg. of Verif. Doc29BUPLABusiness Placenvarchar40
21FUDT_VDOCBSEDHBill of Exchange Fields Segment of Verification Doc(History)29BUPLABusiness Placenvarchar40
22FUDT_VDOCBSEGVerification Document Item with Additional Info283BUPLABusiness Placenvarchar40
23FUDT_VDOCBSEGEVVerification Document Item in the Entry View283BUPLABusiness Placenvarchar40
24FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)283BUPLABusiness Placenvarchar40
25FUDT_VDOCBSETTax Data Document Segment of Verification Document34BUPLABusiness Placenvarchar40
26FUDT_VDOCBSETHTax Data Document Segment of Verification Document(History)34BUPLABusiness Placenvarchar40
27GLPOS_C_CTFI Document: Entry View68BUPLABusiness Placenvarchar40
28GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items68BUPLABusiness Placenvarchar40
29GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items68BUPLABusiness Placenvarchar40
30GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items68BUPLABusiness Placenvarchar40
31GLPOS_N_CTNew General Ledger: Line Item with Currency Type68BUPLABusiness Placenvarchar40
32GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type68BUPLABusiness Placenvarchar40
33P2KR_KRTAXPayroll Result Korea : Tax8BUPLABusiness Placenvarchar40
34REGUPProcessed items from payment program161BUPLABusiness Placenvarchar40
35TFK_ODNNR_DETAssign Number Range Numbers to Document Classes4BUPLABusiness Placenvarchar40
36YVIM_1ITEMDocument Item70BUPLABusiness Placenvarchar40
TOPAccounting Interface
37GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)74BUPLABusiness Placenvarchar40
38GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)74BUPLABusiness Placenvarchar40
TOPBasic Data
39VIBDBEBusiness Entity41BUPLABusiness Placenvarchar40
40VIBDBUBuilding88BUPLABusiness Placenvarchar40
41VIBDPRLand63BUPLABusiness Placenvarchar40
TOPBasic Functions
42BSIXIndex table for customer bills of exchange used24BUPLABusiness Placenvarchar40
TOPBilling
43VBRKBilling Document: Header Data94BUPLABusiness Placenvarchar40
TOPBusiness transactions
44DFKKTXINVTax Invoices5BUPLABusiness Placenvarchar40
TOPContract Accounts Receivable and Payable
45DFKKDEFREV_POSLine Item Table (Event-Based Deferred Revenues)40BUPLABusiness Placenvarchar40
46DFKKMOPItems in contract account document8BUPLABusiness Placenvarchar40
47DFKKMOPKItems in contract account document7BUPLABusiness Placenvarchar40
48DFKKOPItems in contract account document8BUPLABusiness Placenvarchar40
49DFKKOPKItems in contract account document7BUPLABusiness Placenvarchar40
50DFKKOP_REPOpen Items from FPO412BUPLABusiness Placenvarchar40
51DFKKQSRIndividual Records for Withholding Tax Report8BUPLABusiness Placenvarchar40
52DFKKREP06Tax Report Data (Invoicing Time or Triggered)9BUPLABusiness Placenvarchar40
53DFKKREP06_STax Report Data - Shadow Table for Posting Date9BUPLABusiness Placenvarchar40
54DFKKREP07Tax Report Data (Clearing Time)9BUPLABusiness Placenvarchar40
55DFKKSUMPosting totals from FI-CA15BUPLABusiness Placenvarchar40
56DFKKZKPayment lot: Header data55BUPLABusiness Placenvarchar40
57FKKDEFREVTrigger Table for Deferred Revenue Postings42BUPLABusiness Placenvarchar40
58FKKVKPContract Account Partner-Specific74BUPLABusiness Placenvarchar40
TOPContract Billing
59DBERCHZ3Individual line items (amount and price data)33BUPLABusiness Placenvarchar40
60DBERCHZ7Document line items (amount/price data, unimportant rows)33BUPLABusiness Placenvarchar40
TOPCross-Application Components
61BBSIDAccounting: Secondary index for customers151BUPLABusiness Placenvarchar40
TOPFinancial Accounting
62/OPT/VIM_1HEADDocument Header147BUPLABusiness Placenvarchar40
63/OPT/VIM_1ITEMDocument Item70BUPLABusiness Placenvarchar40
64ACCTITCompressed Data from FI/CO Document142BUPLABusiness Placenvarchar40
65BSADAccounting: Secondary Index for Customers (Cleared Items)151BUPLABusiness Placenvarchar40
66BSAKAccounting: Secondary Index for Vendors (Cleared Items)147BUPLABusiness Placenvarchar40
67BSASAccounting: Secondary Index for G/L Accounts (Cleared Items)55BUPLABusiness Placenvarchar40
68BSIDAccounting: Secondary Index for Customers151BUPLABusiness Placenvarchar40
69BSIKAccounting: Secondary Index for Vendors147BUPLABusiness Placenvarchar40
70BSISAccounting: Secondary Index for G/L Accounts55BUPLABusiness Placenvarchar40
71T058BNumber Range Assignment for Receipts6BUPLABusiness Placenvarchar40
72VBSEGADocument Segment for Document Parking - Asset Database65BUPLABusiness Placenvarchar40
73VBSEGDDocument Segment for Customer Document Parking113BUPLABusiness Placenvarchar40
74VBSEGKDocument Segment for Vendor Document Parking124BUPLABusiness Placenvarchar40
75VBSEGSDocument Segment for Document Parking - G/L Account Database118BUPLABusiness Placenvarchar40
TOPGeneral Ledger Accounting
76BSEG_ADDEntry View of Accounting Document for Additional Ledgers66BUPLABusiness Placenvarchar40
77FAGLBSASAccounting: Secondary Index for G/L Accounts (Cleared Items)55BUPLABusiness Placenvarchar40
78FAGLBSISAccounting: Secondary Index for G/L Accounts55BUPLABusiness Placenvarchar40
TOPGL Account Posting
79TCJ_DOCUMENTSCash Journal Documents (Header Data)33BUPLABusiness Placenvarchar40
TOPInvoice Verification
80RBKPDocument Header: Invoice Receipt125BUPLABusiness Placenvarchar40
TOPInvoicing in Contract Accounts Receivable and Payable
81DFKKINVBILL_IBilling Document Items21BUPLABusiness Placenvarchar40
82DFKKINVDOC_HInvoicing Document Header46BUPLABusiness Placenvarchar40
83DFKKINVDOC_IItems of Invoicing Document28BUPLABusiness Placenvarchar40
84DFKKINV_TRIGInvoicing Order21BUPLABusiness Placenvarchar40
TOPKorea
85T7KR0PHR Personnel area/subarea (KOR)4BUPLABusiness Placenvarchar40
86T7KRBPBusiness Place KR3BUPLABusiness Placenvarchar40
TOPLocalization
87IDTW_VATVAT (Taiwan): Current Values3BUPLABusiness Placenvarchar40
88J_1HWTCTNCO4Withholding tax certificate numbering concept 44BUPLABusiness Placenvarchar40
89J_1IEWTCALIDCalendar for Payment Due date-EWT India3BUPLABusiness Placenvarchar40
90J_1IEWTNUMGRNumber Groups For Internal Challan Numbers- EWT India.3BUPLABusiness Placenvarchar40
91J_1IEWT_CERTSAPscript Forms/section indicators for E WT Certificates3BUPLABusiness Placenvarchar40
92J_1IEWT_CERTIFCertificate Issued Details-EWT India4BUPLABusiness Placenvarchar40
93J_1ISER_BSEGTransaction table having the Invoices with Service Category30BUPLABusiness Placenvarchar40
94J_1IT030KIndia Tax account determination ( T030K + BWMOD )5BUPLABusiness Placenvarchar40
95J_1I_BUPLA_SECCOMaps Business Place to Section code for TCS3BUPLABusiness Placenvarchar40
96J_3RFTAX_EXTRDTax Extract Detail Lines118BUPLABusiness Placenvarchar40
97OFF_NUM_IDSettings for Official Document Numbering Indonesia3BUPLABusiness Placenvarchar40
98OFNUM_TW_2Official Numbering by Business Places-enabled ranges(TW)3BUPLABusiness Placenvarchar40
99RFITEMAP_NO_ITEMItem wise detail for the Vendor Transactions117BUPLABusiness Placenvarchar40
100RFITEMAR_NO_ITEMItem wise detail for the Customer Transactions117BUPLABusiness Placenvarchar40
101RFITEMGL_NO_ITEMItem wise detail for the GL Account Transactions117BUPLABusiness Placenvarchar40
TOPMaster Data
102EVERIS-U Cont.66BUPLABusiness Placenvarchar40
103T012House Banks10BUPLABusiness Placenvarchar40
TOPPayment Transactions
104FPRL_ITEMItem Data77BUPLABusiness Placenvarchar40
105REGUVControl records for the payment program14BUPLABusiness Placenvarchar40
TOPPublic Sector Contract Accounts Receivable and Payable
106TFICA_DEFSamples for Contract Account Types49BUPLABusiness Placenvarchar40
TOPSales and Distribution
107IDVKBUR_BUPLAAssignment of Business Place to Sales Office4BUPLABusiness Placenvarchar40
TOPTransfer to Financial Accounting
108TRACT_DOCUMENTTreasury: Accounting Adaptor Document31BUPLABusiness Placenvarchar40
109TRACT_POSCONTEXTTreasury: Position Context Table8BUPLABusiness Placenvarchar40