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

45 columns | Print definition?ERP 6.0  | STAKZ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items49STAKZnvarchar10
2/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact49STAKZnvarchar10
3/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items57STAKZnvarchar10
4DFKKEPRTLog for Inconsistent FI-CA Documents20STAKZType of statistical itemnvarchar10
5DFKK_TRIGX_CLOutbound Interface: New Trigger Table of Cleared Items12STAKZType of statistical itemnvarchar10
6DFKK_TRIGX_RCLOI: New Trigger Table for Reopened Items14STAKZType of statistical itemnvarchar10
7P2RA_STPayroll Result: Tax (Austria)8STAKZIndicator: Tax Card Submitted?nvarchar10
8TCMAC06DDerivation of ISR Scenario Related Data14STAKZType of statistical itemnvarchar10
TOPAustria
9PA0042HR Master Record: Infotype 0042 (Fiscal Data - Austria)29STAKZIndicator: Tax Card Submitted?nvarchar10
TOPCollectionsDisbursements
10TKKVHVTVFS-CD Transactions10STAKZType of statistical itemnvarchar10
11VVKKFOPSingle Doc in Posting Data Interface42STAKZType of statistical itemnvarchar10
12VVKKFOPTTable for FS-CD Test Data of Structure VKKKFOP36STAKZType of statistical itemnvarchar10
13VVSCITEMBill Scheduling: Scheduling Document46STAKZType of statistical itemnvarchar10
14VVSCITEM_MANScheduling Items: Temp. Storage for Manual -> Auto Change46STAKZType of statistical itemnvarchar10
TOPContract Accounts Receivable and Payable
15DFKKMOPItems in contract account document29STAKZType of statistical itemnvarchar10
16DFKKOPItems in contract account document29STAKZType of statistical itemnvarchar10
17DFKKOPCOLLCollection: Log of Receivables Submitted18STAKZType of statistical itemnvarchar10
18DFKKOP_REPOpen Items from FPO433STAKZType of statistical itemnvarchar10
19DFKKORDERPOSRequests: Items74STAKZType of statistical itemnvarchar10
20DFKKWLIWork Items46STAKZType of statistical itemnvarchar10
21DFKKWLIAWork Items (Work Item Type)46STAKZType of statistical itemnvarchar10
22DFKKWOHWrite-Off History14STAKZType of statistical itemnvarchar10
23DFKKWOHTMPTemporary Write-Off History14STAKZType of statistical itemnvarchar10
24DFKKWO_PROTLine Items Written Off from Mass Run21STAKZType of statistical itemnvarchar10
25DFKK_TRIGGER_CLOutbound Interface: Trigger Table of Cleared Items11STAKZType of statistical itemnvarchar10
26DFKK_TRIGGER_RCLOutbound Interface: Trigger Table for Reopened Items13STAKZType of statistical itemnvarchar10
27DPAYPPayment program - data on paid item58STAKZType of statistical itemnvarchar10
28FKKMAKODunning History Header66STAKZType of statistical itemnvarchar10
29FKKMAZEDunning history of line items26STAKZType of statistical itemnvarchar10
30TE305Transactions for Company Code and Division8STAKZType of statistical itemnvarchar10
31TFK021LAccount balance: List types15STAKZDisplay Payment Requestnvarchar10
32TFK113GClearing: Write-Off Statistical Items5STAKZType of statistical itemnvarchar10
TOPControlling
33CSKSCost Center Master Data58STAKZIndicator. object is statisticalnvarchar10
TOPGeneric Contract Accounts Receivable and Payable
34TFSCHVTVTransactions for Company Code and Division8STAKZType of statistical itemnvarchar10
TOPInformation System
35DKKOPBalance Audit Trail24STAKZIndicator. object is statisticalnvarchar10
36DKOKPOpen Item Account Balance Audit Trail25STAKZIndicator. object is statisticalnvarchar10
37DSKOPBalance Audit Trail23STAKZIndicator. object is statisticalnvarchar10
TOPInvoicing
38DEABPSCustomer change table: Logical view of BB amounts24STAKZType of statistical itemnvarchar10
TOPInvoicing in Contract Accounts Receivable and Payable
39DFKKINVBILL_IBilling Document Items41STAKZType of statistical itemnvarchar10
40DFKKINVDOC_IItems of Invoicing Document46STAKZType of statistical itemnvarchar10
TOPLocalization
41J_3RFTAX_EXTRDTax Extract Detail Lines59STAKZIndicator: Statistical document ?nvarchar10
42RFITEMAP_NO_ITEMItem wise detail for the Vendor Transactions58STAKZIndicator: Statistical document ?nvarchar10
43RFITEMAR_NO_ITEMItem wise detail for the Customer Transactions58STAKZIndicator: Statistical document ?nvarchar10
44RFITEMGL_NO_ITEMItem wise detail for the GL Account Transactions58STAKZIndicator: Statistical document ?nvarchar10
TOPPublic Sector Contract Accounts Receivable and Payable
45TFMCA004Parameters for Main/Sub-Transactions7STAKZType of Statistical Itemnvarchar10