SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
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

TableColumnsDescription
1OINV386A/R Invoice
2OITM299Items
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

TableColumnsDescription
1OITM249Items
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
PHPRef.com - the webs number one PHP Function reference tool

61 columns | Print definition?ERP 6.0  | UMSKS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000165000PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta67UMSKSnvarchar10
2/BIC/B0000166000PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta67UMSKSnvarchar10
3/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items50UMSKSnvarchar10
4/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact50UMSKSnvarchar10
5/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items58UMSKSnvarchar10
6/CEECV/BVFI_PVNDocuments for VAT Declaration27UMSKSSpecial G/L Transaction Typenvarchar10
7BSAD_BAKAccounting: Secondary index for customers (cleared items)4UMSKSSpecial G/L Transaction Typenvarchar10
8BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)4UMSKSSpecial G/L Transaction Typenvarchar10
9BSEGAccounting Document Segment13UMSKSSpecial G/L Transaction Typenvarchar10
10BSID_BAKAccounting: Secondary Index for Customers4UMSKSSpecial G/L Transaction Typenvarchar10
11BSIK_BAKAccounting: Secondary index for vendors4UMSKSSpecial G/L Transaction Typenvarchar10
12BSSEGAccounting Document Segment13UMSKSSpecial G/L Transaction Typenvarchar10
13CNVTDMS_05_BSADHeader table for BSAD5UMSKSAKTBO for CNVTDMS_05_CEnvarchar10
14CNVTDMS_05_BSAD1Header table for BSAD5UMSKSAKTBO for CNVTDMS_05_CEnvarchar10
15CNVTDMS_05_BSAKHeader table for BSAK5UMSKSAKTBO for CNVTDMS_05_CEnvarchar10
16CNVTDMS_05_BSAK1Header table for BSAK5UMSKSAKTBO for CNVTDMS_05_CEnvarchar10
17FIEUD_FIDOC_ISAFT: FI Transaction Document Item63UMSKSSpecial G/L Transaction Typenvarchar10
18FUDT_VDOCBSEGVerification Document Item with Additional Info13UMSKSSpecial G/L Transaction Typenvarchar10
19FUDT_VDOCBSEGEVVerification Document Item in the Entry View13UMSKSSpecial G/L Transaction Typenvarchar10
20FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)13UMSKSSpecial G/L Transaction Typenvarchar10
21GLPOS_C_CTFI Document: Entry View246UMSKSSpecial G/L Transaction Typenvarchar10
22GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items246UMSKSSpecial G/L Transaction Typenvarchar10
23GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items246UMSKSSpecial G/L Transaction Typenvarchar10
24GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items246UMSKSSpecial G/L Transaction Typenvarchar10
25GLPOS_N_CTNew General Ledger: Line Item with Currency Type255UMSKSSpecial G/L Transaction Typenvarchar10
26GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type255UMSKSSpecial G/L Transaction Typenvarchar10
27MHNDDunning Data37UMSKSSpecial G/L Transaction Typenvarchar10
28REGUPProcessed items from payment program29UMSKSSpecial G/L Transaction Typenvarchar10
29T074ASpecial G/L Transaction Type Names3UMSKSSpecial G/L Transaction Typenvarchar10
30TFB06Financial Transaction Reporting5UMSKSSpecial G/L Transaction Typenvarchar10
TOPBasic Functions
31BSIWIndex table for customer bills of exchange used11UMSKSSpecial G/L Transaction Typenvarchar10
32BSIXIndex table for customer bills of exchange used11UMSKSSpecial G/L Transaction Typenvarchar10
TOPCross-Application Components
33BBSIDAccounting: Secondary index for customers4UMSKSSpecial G/L Transaction Typenvarchar10
TOPFinancial Accounting
34BSADAccounting: Secondary Index for Customers (Cleared Items)4UMSKSSpecial G/L Transaction Typenvarchar10
35BSAKAccounting: Secondary Index for Vendors (Cleared Items)4UMSKSSpecial G/L Transaction Typenvarchar10
36BSIDAccounting: Secondary Index for Customers4UMSKSSpecial G/L Transaction Typenvarchar10
37BSIKAccounting: Secondary Index for Vendors4UMSKSSpecial G/L Transaction Typenvarchar10
38T074USpecial G/L Indicator Properties4UMSKSSpecial G/L Transaction Typenvarchar10
39TBAERRules for Changing Documents3UMSKSSpecial G/L Transaction Typenvarchar10
40TMODUCross Reference Field Name - MODIF16UMSKSSpecial G/L Transaction Typenvarchar10
41VBSEGDDocument Segment for Customer Document Parking10UMSKSSpecial G/L Transaction Typenvarchar10
42VBSEGKDocument Segment for Vendor Document Parking10UMSKSSpecial G/L Transaction Typenvarchar10
TOPFunds Management-Specific Postings
43PAYAC10Posting Key per DR/CR Indicator3UMSKSSpecial G/L Transaction Typenvarchar10
44PSOSEGDDocument Segment: Recurring Request, Customer11UMSKSSpecial G/L Transaction Typenvarchar10
45PSOSEGKRecurring Request Document Segment, Vendors11UMSKSSpecial G/L Transaction Typenvarchar10
TOPGeneral Ledger Reorganization
46FAGL_R_APARReorganization: Object List for Receivables and Payables22UMSKSSpecial G/L Transaction Typenvarchar10
TOPInformation System
47BWPOSValuations for Open Items31UMSKSSpecial G/L Transaction Typenvarchar10
48DKKOPBalance Audit Trail8UMSKSSpecial G/L Transaction Typenvarchar10
49DKOKPOpen Item Account Balance Audit Trail9UMSKSSpecial G/L Transaction Typenvarchar10
50DSKOPBalance Audit Trail8UMSKSSpecial G/L Transaction Typenvarchar10
TOPLocal Currency Changeover
51EWUFI_SCAEMU conversion: Table of the clearings to be adjusted37UMSKSSpecial G/L Transaction Typenvarchar10
52EWUFI_SOPEMU conversion: Table for open items total10UMSKSSpecial G/L Transaction Typenvarchar10
TOPLocalization
53J_3RFTAX_EXTRDTax Extract Detail Lines60UMSKSSpecial G/L Transaction Typenvarchar10
54RFITEMAP_NO_ITEMItem wise detail for the Vendor Transactions59UMSKSSpecial G/L Transaction Typenvarchar10
55RFITEMAR_NO_ITEMItem wise detail for the Customer Transactions59UMSKSSpecial G/L Transaction Typenvarchar10
56RFITEMGL_NO_ITEMItem wise detail for the GL Account Transactions59UMSKSSpecial G/L Transaction Typenvarchar10
TOPPegging, Grouping, and Distribution
57TBLP_MODUCross Reference Field Name - MODIF16UMSKSSpecial G/L Transaction Typenvarchar10
TOPReal Estate Management
58VIMIIPInvoice Items9UMSKSSpecial G/L Transaction Typenvarchar10
TOPRemaining Beverage - Obsolete Objects
59/BEV3/CH1030BSG1Document Segment CH Event Ledger Part115UMSKSSpecial G/L Transaction Typenvarchar10
TOPTechnical Application Support
60CNV_20425_SCAEMU conversion: Table of the clearings to be adjusted34UMSKSSpecial G/L Transaction Typenvarchar10
61CNV_20425_SOPEMU conversion: Table for open items total9UMSKSSpecial G/L Transaction Typenvarchar10