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

130 columns | Print definition?ERP 6.0  | UMSKZ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/KPFI00003cashier system - checks concentration21UMSKZSpecial G/L Indicatornvarchar10
2/ATL/KPFI00003DLcashier system - checks concentration deleted21UMSKZSpecial G/L Indicatornvarchar10
3/ATL/KPFI00003KPCashier system - checks concentration - Temporary21UMSKZSpecial G/L Indicatornvarchar10
4/ATL/KPFI00004Cashier system - Credit card concentration73UMSKZSpecial G/L Indicatornvarchar10
5/ATL/KPFI00004KPCashier system - Credit card concentration - Temporary74UMSKZSpecial G/L Indicatornvarchar10
6/ATL/KPFI00006Cashier system - Cash payments concentration18UMSKZSpecial G/L Indicatornvarchar10
7/ATL/KPFI00006KPCashier system - Cash payments concentration - Temporary19UMSKZSpecial G/L Indicatornvarchar10
8/BIC/B0000165000PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta15UMSKZnvarchar10
9/BIC/B0000166000PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta15UMSKZnvarchar10
10/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items51UMSKZnvarchar10
11/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact51UMSKZnvarchar10
12/BIC/B0000170000PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta13UMSKZnvarchar10
13/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items59UMSKZnvarchar10
14BOE_REF_DOCReference documnet for BoE28UMSKZSpecial G/L Indicatornvarchar10
15BSAD_BAKAccounting: Secondary index for customers (cleared items)5UMSKZSpecial G/L Indicatornvarchar10
16BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)5UMSKZSpecial G/L Indicatornvarchar10
17BSEGAccounting Document Segment12UMSKZSpecial G/L Indicatornvarchar10
18BSID_BAKAccounting: Secondary Index for Customers5UMSKZSpecial G/L Indicatornvarchar10
19BSIK_BAKAccounting: Secondary index for vendors5UMSKZSpecial G/L Indicatornvarchar10
20BSSEGAccounting Document Segment12UMSKZSpecial G/L Indicatornvarchar10
21CNVTDMS_05_BSADHeader table for BSAD6UMSKZAKTBO for CNVTDMS_05_CEnvarchar10
22CNVTDMS_05_BSAD1Header table for BSAD6UMSKZAKTBO for CNVTDMS_05_CEnvarchar10
23CNVTDMS_05_BSAKHeader table for BSAK6UMSKZAKTBO for CNVTDMS_05_CEnvarchar10
24CNVTDMS_05_BSAK1Header table for BSAK6UMSKZAKTBO for CNVTDMS_05_CEnvarchar10
25FIAPSAC_CC_DOCTYSettings for Document Order Types5UMSKZSpecial G/L Indicatornvarchar10
26FIAPSAD_ORDR_HDOrder Number Header KSA16UMSKZSpecial G/L Indicatornvarchar10
27FIEUD_FIDOC_ISAFT: FI Transaction Document Item62UMSKZSpecial G/L Indicatornvarchar10
28FIPDCOMC_SGLPDC special G/L indicator3UMSKZSpecial G/L Indicatornvarchar10
29FIPTC_BD_SPLGLMaintain Special GL Indicator for Bad Debts (Portugal)5UMSKZSpecial G/L Indicatornvarchar10
30FISUBSTKW_RETCustomize Retention for Statement of Subcontractor Report2UMSKZSpecial G/L Indicatornvarchar10
31FUCNBUSTRANAssign Document Type to Entry Layout7UMSKZSpecial G/L Indicatornvarchar10
32FUDT_VDOCBSECLRHAdditional Data for Document Segment: Clearing Information34UMSKZSpecial G/L Indicatornvarchar10
33FUDT_VDOCBSEGVerification Document Item with Additional Info12UMSKZSpecial G/L Indicatornvarchar10
34FUDT_VDOCBSEGEVVerification Document Item in the Entry View12UMSKZSpecial G/L Indicatornvarchar10
35FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)12UMSKZSpecial G/L Indicatornvarchar10
36FUDT_VDOCBSE_CLRAdditional Data for Document Segment: Clearing Information34UMSKZSpecial G/L Indicatornvarchar10
37GLPOS_C_CTFI Document: Entry View247UMSKZSpecial G/L Indicatornvarchar10
38GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items247UMSKZSpecial G/L Indicatornvarchar10
39GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items247UMSKZSpecial G/L Indicatornvarchar10
40GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items247UMSKZSpecial G/L Indicatornvarchar10
41GLPOS_N_CTNew General Ledger: Line Item with Currency Type256UMSKZSpecial G/L Indicatornvarchar10
42GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type256UMSKZSpecial G/L Indicatornvarchar10
43J_1ILOCCLREXIM : Letter of Credit Clearing Documents8UMSKZSpecial G/L Indicatornvarchar10
44LWM_CFS_UMSKZEXCFinFactSheet - Excluded Special G/L Indicators3UMSKZSpecial G/L Indicatornvarchar10
45MHNDDunning Data38UMSKZSpecial G/L Indicatornvarchar10
46REGUPProcessed items from payment program28UMSKZSpecial G/L Indicatornvarchar10
47T019Financial Accounting Screen Selection3UMSKZSpecial G/L Transaction Type for Table T019nvarchar10
48T030BStandard Posting Keys5UMSKZSpecial G/L Indicatornvarchar10
49T056YAssign special G/L indicator to interest indicator4UMSKZSpecial G/L Indicatornvarchar10
50T074Special G/L Accounts4UMSKZSpecial G/L Indicatornvarchar10
51TBSLTPosting Key Names4UMSKZSpecial G/L Indicatornvarchar10
52VIYCEXPITEMExpense Items17UMSKZSpecial G/L Indicatornvarchar10
TOPAccounting Interface
53GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)78UMSKZSpecial G/L Indicatornvarchar10
54GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)78UMSKZSpecial G/L Indicatornvarchar10
TOPAccounts Receivable Accounting Process Integration
55FDM_AR_UMSKZFSCM: Integration of Special GL Indicator line items3UMSKZSpecial G/L Indicatornvarchar10
56TFDM_UMSKZSpecial G/L Indicator for CCM Process3UMSKZSpecial G/L Indicatornvarchar10
TOPAdaptor
57UKM_TRANSFER_ARData from AR for SAP Credit Management7UMSKZSpecial G/L Indicatornvarchar10
TOPAdvertising Management
58TJH05IS-M/AM: Billing: Document Types9UMSKZSpecial G/L Indicatornvarchar10
TOPAgency Business Global Trade
59TMPRAB: Posting Rules5UMSKZAB: Special G/L Indicator for Posting Typenvarchar10
TOPBasic Functions
60BSIWIndex table for customer bills of exchange used10UMSKZSpecial G/L Indicatornvarchar10
61BSIXIndex table for customer bills of exchange used10UMSKZSpecial G/L Indicatornvarchar10
62GLOO1Object Table for FI-SL Table GLTO15UMSKZSpecial G/L Indicatornvarchar10
63GLOO3Object Table for FI-SL Table GLTO35UMSKZSpecial G/L Indicatornvarchar10
TOPCross-Application Components
64BBSIDAccounting: Secondary index for customers5UMSKZSpecial G/L Indicatornvarchar10
65J_2GLPFILogical Papers for FI7UMSKZSpecial G/L Indicatornvarchar10
TOPData Retention Tool
66TXW_S_BSEGRetrieve BSEG from archive15UMSKZSpecial G/L Indicatornvarchar10
TOPElectronic Bank Statement
67FEB_ITEM_SAVESaving of Posting Items for Postprocessing (On Account)20UMSKZSpecial G/L Indicatornvarchar10
TOPExchanges
68TOIABIS-OIL Exchange - Posting keys5UMSKZSpecial G/L Indicatornvarchar10
TOPFinancial Accounting
69ACCTITCompressed Data from FI/CO Document23UMSKZSpecial G/L Indicatornvarchar10
70BSADAccounting: Secondary Index for Customers (Cleared Items)5UMSKZSpecial G/L Indicatornvarchar10
71BSAKAccounting: Secondary Index for Vendors (Cleared Items)5UMSKZSpecial G/L Indicatornvarchar10
72BSE_CLRAdditional Data for Document Segment: Clearing Information34UMSKZSpecial G/L Indicatornvarchar10
73BSIDAccounting: Secondary Index for Customers5UMSKZSpecial G/L Indicatornvarchar10
74BSIKAccounting: Secondary Index for Vendors5UMSKZSpecial G/L Indicatornvarchar10
75DEFTAX_ITEMData for Deferred Taxes45UMSKZSpecial G/L Indicatornvarchar10
76ICRCAICRC: Items to be Reconciled9UMSKZSpecial G/L Indicatornvarchar10
77ICRCUICRC: Potentially Differing Document Groups9UMSKZSpecial G/L Indicatornvarchar10
78ICRCZICRC: Reconciled, Completed Items9UMSKZSpecial G/L Indicatornvarchar10
79J_1UF_MR_CUSTExch.diff.accounting customizing2UMSKZSpecial G/L Indicatornvarchar10
80J_5KFH_CADVTYPEAdvance accounting control settings4UMSKZSpecial G/L Indicatornvarchar10
81PARCTReceipt Log Table15UMSKZSpecial G/L Indicatornvarchar10
82T001UClearing Between Company Codes9UMSKZSpecial G/L Indicatornvarchar10
83T007BEBill of exchange customizing for deferred tax(RFUMSV50)4UMSKZSpecial G/L Indicatornvarchar10
84T045WBank Subaccounts for Bill of Exchange Usage5UMSKZSpecial G/L Indicatornvarchar10
85T074USpecial G/L Indicator Properties3UMSKZSpecial G/L Indicatornvarchar10
86VBSEGDDocument Segment for Customer Document Parking9UMSKZSpecial G/L Indicatornvarchar10
87VBSEGKDocument Segment for Vendor Document Parking9UMSKZSpecial G/L Indicatornvarchar10
TOPFunds Management-Specific Postings
88FMITPOCTCustomizing: Payment Transfer (new in Release 4.61A )6UMSKZSpecial G/L indicator for payment transfernvarchar10
89FMPYIS-PS: Payment Transactions7UMSKZSpecial G/L Indicatornvarchar10
90PSOSEGDDocument Segment: Recurring Request, Customer10UMSKZSpecial G/L Indicatornvarchar10
91PSOSEGKRecurring Request Document Segment, Vendors10UMSKZSpecial G/L Indicatornvarchar10
TOPGL Account Posting
92TCJ_POSITIONSCash Journal Document Items99UMSKZSpecial G/L Indicatornvarchar10
93TCJ_TRANSACTIONSCash Journal Business Transactions8UMSKZSpecial G/L Indicatornvarchar10
TOPInformation System
94BWPOSValuations for Open Items32UMSKZSpecial G/L Indicatornvarchar10
95DKKOPBalance Audit Trail19UMSKZSpecial G/L Indicatornvarchar10
96DKOKPOpen Item Account Balance Audit Trail33UMSKZSpecial G/L Indicatornvarchar10
97DSKOPBalance Audit Trail18UMSKZSpecial G/L Indicatornvarchar10
98TABKTAutomatic Accounts for End-Year Closing/Opening Postings ITA7UMSKZSpecial G/L Indicatornvarchar10
TOPJoint Venture und Production Sharing Accounting
99T8J_POST_ERROR_CDocuments with errors in JV posting (Open Items)12UMSKZSpecial G/L Indicatornvarchar10
TOPLoans Management
100TTONFTVZZBEPPTest neue FIMA: VZZBEPP187UMSKZSonderhauptbuch-Kennzeichennvarchar10
101VDBEPIPosted line items for document header24UMSKZSpecial G/L Indicatornvarchar10
102VDBEPI_SHADOWShadow Table for VDBEPI (Restrictions)24UMSKZSpecial G/L Indicatornvarchar10
103VDBEPPFlow Data - Planned Item55UMSKZSpecial G/L Indicatornvarchar10
104VDBOBEPPBusiness Operation: Entered and Activated Flow Data55UMSKZSpecial G/L Indicatornvarchar10
105VZFZE_VDBEPPCentral Entry Table for Release Procedure58UMSKZSpecial G/L Indicatornvarchar10
TOPLocal Currency Changeover
106EWUFI_SCAEMU conversion: Table of the clearings to be adjusted36UMSKZSpecial G/L Indicatornvarchar10
107EWUFI_SOPEMU conversion: Table for open items total9UMSKZSpecial G/L Indicatornvarchar10
TOPLocalization
108ISJPSELECTIONSelection of line items for Invoice Summary5UMSKZSpecial G/L Indicatornvarchar10
109J_3RFSEC_ITEMData for Secondary events for deferred tax32UMSKZSpecial G/L Indicatornvarchar10
110J_3RFTAX_EXTRDTax Extract Detail Lines61UMSKZSpecial G/L Indicatornvarchar10
111RFITEMAP_NO_ITEMItem wise detail for the Vendor Transactions60UMSKZSpecial G/L Indicatornvarchar10
112RFITEMAR_NO_ITEMItem wise detail for the Customer Transactions60UMSKZSpecial G/L Indicatornvarchar10
113RFITEMGL_NO_ITEMItem wise detail for the GL Account Transactions60UMSKZSpecial G/L Indicatornvarchar10
TOPMaster Data
114MDTBMRP Table27UMSKZSpecial G/L Indicatornvarchar10
115PLAFPlanned Order18UMSKZConversion indicator for planned ordernvarchar10
TOPPayment Transactions
116FPCL_ACC_PARAParameter for the Posting7UMSKZSpecial G/L Indicatornvarchar10
117FPRL_ITEMItem Data36UMSKZSpecial G/L Indicatornvarchar10
118T042ZPayment Methods for Automatic Payment23UMSKZSpecial G/L Indicicator for Bill/Exch. / Bill/Exch.Pmnt Req.nvarchar10
TOPPeriodical Sales and Distribution
119JFXBPOSDLIS-M: Backup Transfer Internal Table XBPOS18UMSKZSpecial G/L Indicatornvarchar10
120JLRKIS-M/SD: Settlement Header Data53UMSKZSpecial G/L Indicatornvarchar10
121TJFKIS-M/SD: Billing Document Types34UMSKZSpecial G/L Indicatornvarchar10
122TJL07IS-M/SD: Doc.Type Determ.for Settlement Transfer to FI/RF4UMSKZSpecial G/L Indicatornvarchar10
123TJL11IS-M/SD: Object Types for Document Flow etc.34UMSKZSpecial G/L Indicatornvarchar10
TOPReal Estate Management
124VIAKBSEGDocument Line Item from SCS for Interface27UMSKZSpecial G/L Indicatornvarchar10
125VIMIIPInvoice Items10UMSKZSpecial G/L Indicatornvarchar10
TOPRemaining Beverage - Obsolete Objects
126/BEV3/CH1030BSG1Document Segment CH Event Ledger Part114UMSKZSpecial G/L Indicatornvarchar10
TOPSimulation
127VSPLAF_CNVersion: Planned order19UMSKZConversion indicator for planned ordernvarchar10
TOPTechnical Application Support
128CNV_20425_SCAEMU conversion: Table of the clearings to be adjusted33UMSKZSpecial G/L Indicatornvarchar10
129CNV_20425_SOPEMU conversion: Table for open items total8UMSKZSpecial G/L Indicatornvarchar10
TOPTraders and Schedulers Workbench
130OIJ_RU_FI_POSTDefine posting parameters4UMSKZSpecial G/L Indicatornvarchar10