SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

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
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

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