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
8AUDLORIPR7KPro: Logical Information Object Attribute Values
9/OPT/Z1344Reporting table: Text table for exception definitions
10FCO_DOC_HEAD61Failure Cost Document Header

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

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
9PA0042HR Master Record: Infotype 0042 (Fiscal Data - Austria)29STAKZIndicator: Tax Card Submitted?nvarchar10
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
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
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
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