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

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

79 columns | Print definition?ERP 6.0  | DABRZ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items134DABRZnvarchar80
2/OPT/VIM_1ITEM_SDocument Item97DABRZReference Date for Settlementnvarchar80
3/OPT/VIM_TITEMDocument Item97DABRZReference Date for Settlementnvarchar80
4AUAASettlement Document: Receiver Segment38DABRZReference Date for Settlementnvarchar80
5BSAD_BAKAccounting: Secondary index for customers (cleared items)131DABRZReference Date for Settlementnvarchar80
6BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)134DABRZReference Date for Settlementnvarchar80
7BSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)61DABRZReference Date for Settlementnvarchar80
8BSEGAccounting Document Segment219DABRZReference Date for Settlementnvarchar80
9BSID_BAKAccounting: Secondary Index for Customers131DABRZReference Date for Settlementnvarchar80
10BSIK_BAKAccounting: Secondary index for vendors134DABRZReference Date for Settlementnvarchar80
11BSIS_BAKAccounting: Secondary Index for G/L Accounts61DABRZReference Date for Settlementnvarchar80
12BSSEGAccounting Document Segment208DABRZReference Date for Settlementnvarchar80
13FAGLBSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)61DABRZReference Date for Settlementnvarchar80
14FAGLBSIS_BAKAccounting: Secondary Index for G/L Accounts61DABRZReference Date for Settlementnvarchar80
15FUDT_VDOCBSEGVerification Document Item with Additional Info208DABRZReference Date for Settlementnvarchar80
16FUDT_VDOCBSEGEVVerification Document Item in the Entry View208DABRZReference Date for Settlementnvarchar80
17FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)208DABRZReference Date for Settlementnvarchar80
18GLPCA_CTProfit Center Documents61DABRZReference Date for Settlementnvarchar80
19GLPCA_T_CTProfit Center Documents77DABRZReference Date for Settlementnvarchar80
20GLPOS_C_CTFI Document: Entry View83DABRZReference Date for Settlementnvarchar80
21GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items83DABRZReference Date for Settlementnvarchar80
22GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items83DABRZReference Date for Settlementnvarchar80
23GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items83DABRZReference Date for Settlementnvarchar80
24GLPOS_N_CTNew General Ledger: Line Item with Currency Type83DABRZReference Date for Settlementnvarchar80
25GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type83DABRZReference Date for Settlementnvarchar80
26REGUPProcessed items from payment program136DABRZReference Date for Settlementnvarchar80
27YVIM_1ITEMDocument Item97DABRZReference Date for Settlementnvarchar80
TOPAccounting Interface
28GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)286DABRZReference Date for Settlementnvarchar80
29GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)286DABRZReference Date for Settlementnvarchar80
TOPAlternative Valuation Run
30CKMLAVRDOCITLines for Cumulation Posting Document61DABRZReference Date for Settlementnvarchar80
TOPCross-Application Components
31BBSIDAccounting: Secondary index for customers131DABRZReference Date for Settlementnvarchar80
TOPData Retention Tool
32TXW_S_BSEGRetrieve BSEG from archive104DABRZReference Date for Settlementnvarchar80
TOPElectronic Bank Statement
33FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)82DABRZReference Date for Settlementnvarchar80
34FEB_ACTAcct Assignment Templates82DABRZReference Date for Settlementnvarchar80
TOPExternal Services
35ESKNAccount Assignment in Service Package55DABRZReference Date for Settlementnvarchar80
TOPFinancial Accounting
36/OPT/VIM_1ITEMDocument Item97DABRZReference Date for Settlementnvarchar80
37ACCTITCompressed Data from FI/CO Document140DABRZReference Date for Settlementnvarchar80
38BSADAccounting: Secondary Index for Customers (Cleared Items)131DABRZReference Date for Settlementnvarchar80
39BSAKAccounting: Secondary Index for Vendors (Cleared Items)134DABRZReference Date for Settlementnvarchar80
40BSASAccounting: Secondary Index for G/L Accounts (Cleared Items)61DABRZReference Date for Settlementnvarchar80
41BSIDAccounting: Secondary Index for Customers131DABRZReference Date for Settlementnvarchar80
42BSIKAccounting: Secondary Index for Vendors134DABRZReference Date for Settlementnvarchar80
43BSISAccounting: Secondary Index for G/L Accounts61DABRZReference Date for Settlementnvarchar80
44EBSEGDoc.Segment of Fin.Accntng External Documents44DABRZReference Date for Settlementnvarchar80
45KMZEIFI: Account Assignment Model Item Information29DABRZReference Date for Settlementnvarchar80
46KOMUAccount Assignment Templates for G/L Account Items29DABRZReference Date for Settlementnvarchar80
47VBSEGKDocument Segment for Vendor Document Parking98DABRZReference Date for Settlementnvarchar80
48VBSEGSDocument Segment for Document Parking - G/L Account Database74DABRZReference Date for Settlementnvarchar80
TOPFreight Processing
49VFKNAccount Determination in Shipment Costs Item39DABRZReference Date for Settlementnvarchar80
TOPFunds Management
50KBLPDocument Item: Manual Document Entry94DABRZReference Date for Settlementnvarchar80
TOPFunds Management-Specific Postings
51FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years73DABRZReference Date for Settlementnvarchar80
52PSOSEGKRecurring Request Document Segment, Vendors99DABRZReference Date for Settlementnvarchar80
53PSOSEGSRecurring Request Document Segment, G/L Accounts72DABRZReference Date for Settlementnvarchar80
TOPGeneral Ledger Accounting
54FAGLBSASAccounting: Secondary Index for G/L Accounts (Cleared Items)61DABRZReference Date for Settlementnvarchar80
55FAGLBSISAccounting: Secondary Index for G/L Accounts61DABRZReference Date for Settlementnvarchar80
56FAGL_SPLINFOSplittling Information of Open Items19DABRZReference Date for Settlementnvarchar80
TOPGL Account Posting
57TCJ_POSITIONSCash Journal Document Items89DABRZReference Date for Settlementnvarchar80
TOPInformation System, iViews
58COOI_PIBW CO-OM: Commitment Management: Deleted Line Items50DABRZReference Date for Settlementnvarchar80
TOPInventory Management
59MSEGDocument Segment: Material160DABRZReference Date for Settlementnvarchar80
60MWXMSEGZMSEG: Interface for Posting of Value160DABRZReference Date for Settlementnvarchar80
61MWZMSEGZMSEG:Interface for Posting of Value160DABRZReference Date for Settlementnvarchar80
62RKPFDocument Header: Reservation50DABRZReference Date for Settlementnvarchar80
TOPInvoice Verification
63RBCODocument Item, Incoming Invoice, Account Assignment11DABRZReference Date for Settlementnvarchar80
TOPOverhead Cost Controlling
64COEPCO Object: Line Items (by Period)65DABRZReference Date for Settlementnvarchar80
65COEPRCO Object: Line Items for Stat. Key Figs (by Period)21DABRZReference Date for Settlementnvarchar80
66COVP_DELTA_LOGLog of COVP Delta Queue for Error Analysis67DABRZReference Date for Settlementnvarchar80
TOPOverhead Cost Orders
67COOICommitments Management: Line Items50DABRZReference Date for Settlementnvarchar80
TOPProfit Center Accounting
68GLPCAEC-PCA: Actual Line Items96DABRZReference Date for Settlementnvarchar80
69GLPCPEC-PCA: Plan Line Items149DABRZReference Date for Settlementnvarchar80
TOPProfitability Analysis
70CECOEPCO-PA Account Based Line Items67DABRZReference Date for Settlementnvarchar80
TOPPurchasing
71EBKNPurchase Requisition Account Assignment52DABRZReference Date for Settlementnvarchar80
72EKKNAccount Assignment in Purchasing Document55DABRZReference Date for Settlementnvarchar80
TOPQuality Inspection
73QALSInspection lot record193DABRZReference Date for Settlementnvarchar80
TOPReal Estate Management
74VIAKBSEGDocument Line Item from SCS for Interface96DABRZReference Date for Settlementnvarchar80
75VITAXDTax Shares per Real Estate Account Assignment36DABRZReference Date for Settlementnvarchar80
TOPRemaining Beverage - Obsolete Objects
76/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1210DABRZReference Date for Settlementnvarchar80
TOPRepetitive Manufacturing
77COMPMOVEGoods Movement of Components156DABRZReference Date for Settlementnvarchar80
TOPSelf-Service Procurement
78/SRMERP/D_ACC_ITAccount assignment item38DABRZReference Date for Settlementnvarchar80
TOPSimulation
79VSEBKN_CNVersion: Purchase requisition account assignment53DABRZReference Date for Settlementnvarchar80