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

73 columns | Print definition?ERP 6.0  | KBLNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VIM_1ITEM_SDocument Item29KBLNRDocument Number for Earmarked Fundsnvarchar100
2/OPT/VIM_TITEMDocument Item29KBLNRDocument Number for Earmarked Fundsnvarchar100
3BSAD_BAKAccounting: Secondary index for customers (cleared items)157KBLNRDocument Number for Earmarked Fundsnvarchar100
4BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)161KBLNRDocument Number for Earmarked Fundsnvarchar100
5BSEGAccounting Document Segment265KBLNRDocument Number for Earmarked Fundsnvarchar100
6BSID_BAKAccounting: Secondary Index for Customers157KBLNRDocument Number for Earmarked Fundsnvarchar100
7BSIK_BAKAccounting: Secondary index for vendors161KBLNRDocument Number for Earmarked Fundsnvarchar100
8BSSEGAccounting Document Segment254KBLNRDocument Number for Earmarked Fundsnvarchar100
9FIAPSAD_ADP_LTAdvance Payment Request Line Items Details10KBLNRDocument Number for Earmarked Fundsnvarchar100
10FIAPSAD_ORDR_LTLine Item for Order Number KSA23KBLNRDocument Number for Earmarked Fundsnvarchar100
11FUDT_VDOCBSEGVerification Document Item with Additional Info254KBLNRDocument Number for Earmarked Fundsnvarchar100
12FUDT_VDOCBSEGEVVerification Document Item in the Entry View254KBLNRDocument Number for Earmarked Fundsnvarchar100
13FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)254KBLNRDocument Number for Earmarked Fundsnvarchar100
14GLPOS_C_CTFI Document: Entry View141KBLNRDocument Number for Earmarked Fundsnvarchar100
15GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items141KBLNRDocument Number for Earmarked Fundsnvarchar100
16GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items141KBLNRDocument Number for Earmarked Fundsnvarchar100
17GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items141KBLNRDocument Number for Earmarked Fundsnvarchar100
18GLPOS_N_CTNew General Ledger: Line Item with Currency Type143KBLNRDocument Number for Earmarked Fundsnvarchar100
19GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type143KBLNRDocument Number for Earmarked Fundsnvarchar100
20REGUPProcessed items from payment program164KBLNRDocument Number for Earmarked Fundsnvarchar100
21YVIM_1ITEMDocument Item29KBLNRDocument Number for Earmarked Fundsnvarchar100
TOPAccounting Interface
22GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)184KBLNRDocument Number for Earmarked Fundsnvarchar100
23GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)184KBLNRDocument Number for Earmarked Fundsnvarchar100
TOPActual Payments and Forecast
24COFPDocument Lines (project cash management)47KBLNRDocument Number for Earmarked Fundsnvarchar100
TOPElectronic Bank Statement
25FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)60KBLNRDocument Number for Earmarked Fundsnvarchar100
26FEB_ACTAcct Assignment Templates60KBLNRDocument Number for Earmarked Fundsnvarchar100
TOPExternal Services
27ESKNAccount Assignment in Service Package53KBLNRDocument Number for Earmarked Fundsnvarchar100
TOPFinancial Accounting
28/OPT/VIM_1ITEMDocument Item29KBLNRDocument Number for Earmarked Fundsnvarchar100
29ACCTITCompressed Data from FI/CO Document105KBLNRDocument Number for Earmarked Fundsnvarchar100
30BSADAccounting: Secondary Index for Customers (Cleared Items)157KBLNRDocument Number for Earmarked Fundsnvarchar100
31BSAKAccounting: Secondary Index for Vendors (Cleared Items)161KBLNRDocument Number for Earmarked Fundsnvarchar100
32BSIDAccounting: Secondary Index for Customers157KBLNRDocument Number for Earmarked Fundsnvarchar100
33BSIKAccounting: Secondary Index for Vendors161KBLNRDocument Number for Earmarked Fundsnvarchar100
34KMZEIFI: Account Assignment Model Item Information64KBLNRDocument Number for Earmarked Fundsnvarchar100
35KOMUAccount Assignment Templates for G/L Account Items64KBLNRDocument Number for Earmarked Fundsnvarchar100
36VBSEGADocument Segment for Document Parking - Asset Database36KBLNRDocument Number for Earmarked Fundsnvarchar100
37VBSEGDDocument Segment for Customer Document Parking121KBLNRDocument Number for Earmarked Fundsnvarchar100
38VBSEGKDocument Segment for Vendor Document Parking133KBLNRDocument Number for Earmarked Fundsnvarchar100
39VBSEGSDocument Segment for Document Parking - G/L Account Database97KBLNRDocument Number for Earmarked Fundsnvarchar100
TOPFunds Management
40FCABPFI-CA: Document Item42KBLNRDocument Number for Earmarked Fundsnvarchar100
41FMEPFI-FM Line Items54KBLNRDocument Number for Earmarked Fundsnvarchar100
42FMLGD_H_VG_01_01Budget Type 01: Customer Down Payment7KBLNRDocument Number for Earmarked Fundsnvarchar100
43FMLGD_H_VG_02_01Posting Type 02: Vendor Down Payment7KBLNRDocument Number for Earmarked Fundsnvarchar100
44FMLGD_H_VG_05_01Posting Type 05: Down Payment with General Request (01)5KBLNRDocument Number for Earmarked Fundsnvarchar100
45FMLGD_H_VG_05_02Posting Type 05:Vendor Down Payment with General Request(02)7KBLNRDocument Number for Earmarked Fundsnvarchar100
46FMLGD_H_VG_06_01Posting Type 06:Customer Down Payment with General Request5KBLNRDocument Number for Earmarked Fundsnvarchar100
TOPFunds Management-Specific Postings
47FMCJIS-PS: Documents in Cash Desk Subsidiary Ledger23KBLNRDocument Number for Earmarked Fundsnvarchar100
48FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years96KBLNRDocument Number for Earmarked Fundsnvarchar100
49PSOSEGADocument Segment for Assets Document Parking37KBLNRDocument Number for Earmarked Fundsnvarchar100
50PSOSEGSRecurring Request Document Segment, G/L Accounts95KBLNRDocument Number for Earmarked Fundsnvarchar100
TOPGeneral Ledger Accounting
51BSEG_ADDEntry View of Accounting Document for Additional Ledgers59KBLNRDocument Number for Earmarked Fundsnvarchar100
TOPGL Account Posting
52TCJ_POSITIONSCash Journal Document Items67KBLNRDocument Number for Earmarked Fundsnvarchar100
TOPInventory Management
53MSEGDocument Segment: Material187KBLNRDocument Number for Earmarked Fundsnvarchar100
54RESBReservation/dependent requirements186KBLNRDocument Number for Earmarked Fundsnvarchar100
TOPInvoice Verification
55RBCODocument Item, Incoming Invoice, Account Assignment59KBLNRDocument Number for Earmarked Fundsnvarchar100
TOPMaterials Management
56/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions137KBLNRDocument Number for Earmarked Fundsnvarchar100
TOPPayment Transactions
57CRACCPayment Cards: Account Assignments in Card Master Record17KBLNRDocument Number for Earmarked Fundsnvarchar100
58CRFILESTATPayment Card File: Status Information for Individual Records16KBLNRDocument Number: Card Documentnvarchar100
59CRNUMPayment cards: Card master record38KBLNRDocument Number for Earmarked Fundsnvarchar100
60FPCR_CESSGarnishment Register Attributes20KBLNRDocument Number for Earmarked Fundsnvarchar100
61FPRL_ITEMItem Data104KBLNRDocument Number for Earmarked Fundsnvarchar100
TOPPurchasing
62EBANPurchase Requisition129KBLNRDocument Number for Earmarked Fundsnvarchar100
63EBKNPurchase Requisition Account Assignment56KBLNRDocument Number for Earmarked Fundsnvarchar100
64EKCPAPurchasing Contract Commitment Plan Account Assignment Data6KBLNRDocument Number for Earmarked Fundsnvarchar100
65EKCPIPurchasing Contract Commitment Plan Item Information9KBLNRDocument Number for Earmarked Fundsnvarchar100
66EKKNAccount Assignment in Purchasing Document61KBLNRDocument Number for Earmarked Fundsnvarchar100
67EKPOPurchasing Document Item207KBLNRDocument Number for Earmarked Fundsnvarchar100
68MEREQXPurchase Requisition Change Parameter129KBLNRUpdated information in related user data fieldnvarchar10
TOPRemaining Beverage - Obsolete Objects
69/BEV3/CH1030BSG2Document Segment CH Event Ledger Part221KBLNRDocument Number for Earmarked Fundsnvarchar100
TOPRepetitive Manufacturing
70COMPMOVEGoods Movement of Components150KBLNRDocument Number for Earmarked Fundsnvarchar100
TOPSelf-Service Procurement
71/SRMERP/D_ACC_ITAccount assignment item49KBLNRDocument Number for Earmarked Fundsnvarchar100
TOPSimulation
72VSEBKN_CNVersion: Purchase requisition account assignment57KBLNRDocument Number for Earmarked Fundsnvarchar100
73VSRESB_CNVersion: Reservation/Dependent requirements194KBLNRDocument Number for Earmarked Fundsnvarchar100