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

83 columns | Print definition?ERP 6.0  | PARGB

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items105PARGBnvarchar40
2/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact105PARGBnvarchar40
3/BIC/B0000170000PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta32PARGBnvarchar40
4/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items148PARGBnvarchar40
5/OPT/VIM_1ITEM_SDocument Item42PARGBTrading partner's business areanvarchar40
6/OPT/VIM_TITEMDocument Item42PARGBTrading partner's business areanvarchar40
7BSEGAccounting Document Segment17PARGBTrading partner's business areanvarchar40
8BSSEGAccounting Document Segment17PARGBTrading partner's business areanvarchar40
9FUDT_VDOCBSEGVerification Document Item with Additional Info17PARGBTrading partner's business areanvarchar40
10FUDT_VDOCBSEGEVVerification Document Item in the Entry View17PARGBTrading partner's business areanvarchar40
11FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)17PARGBTrading partner's business areanvarchar40
12GLPOS_C_CTFI Document: Entry View184PARGBTrading partner's business areanvarchar40
13GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items184PARGBTrading partner's business areanvarchar40
14GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items184PARGBTrading partner's business areanvarchar40
15GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items184PARGBTrading partner's business areanvarchar40
16GLPOS_N_CTNew General Ledger: Line Item with Currency Type187PARGBTrading partner's business areanvarchar40
17GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type187PARGBTrading partner's business areanvarchar40
18TKMGBBusiness area consolidation: SD assignments8PARGBassumed business area of the business partnernvarchar40
19TLMGBBusiness area consolidation: MM assignments8PARGBassumed business area of the business partnernvarchar40
20YVIM_1ITEMDocument Item42PARGBTrading partner's business areanvarchar40
21ZEIM_VBAPSales Document: Item Data348PARGBTrading partner's business areanvarchar40
TOPAccounting Interface
22GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)161PARGBTrading partner's business areanvarchar40
23GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)161PARGBTrading partner's business areanvarchar40
TOPActual CostingMaterial Ledger
24MLCOMaterial valuation document account assignment information15PARGBTrading partner's business areanvarchar40
TOPBasic Functions
25ANEKDocument Header Asset Posting28PARGBTrading partner's business areanvarchar40
26GSBLCABusiness area consolidation: deviating records16PARGBTrading partner's business areanvarchar40
TOPBilling
27VBRPBilling Document: Item Data216PARGBTrading partner's business areanvarchar40
TOPCost Center Accounting
28COSPRCO Objekt: Enhancement to COSP for Dependency Planning11PARGBTrading partner's business areanvarchar40
TOPData Retention Tool
29TXW_S_ANEKRetrieve ANEP from archive28PARGBTrading partner's business areanvarchar40
30TXW_S_BSEGRetrieve BSEG from archive70PARGBTrading partner's business areanvarchar40
31TXW_S_COEPRetrieve COEP from archive30PARGBTrading partner's business areanvarchar40
32TXW_S_MSEGRetrieve MSEG from archive42PARGBTrading partner's business areanvarchar40
TOPElectronic Bank Statement
33FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)17PARGBTrading partner's business areanvarchar40
34FEB_ACTAcct Assignment Templates17PARGBTrading partner's business areanvarchar40
TOPFinancial Accounting
35/OPT/VIM_1ITEMDocument Item42PARGBTrading partner's business areanvarchar40
36ACCTITCompressed Data from FI/CO Document55PARGBTrading partner's business areanvarchar40
37BFIT_AFI Subsequent BA/PC Adjustment: G/L Account Items19PARGBTrading partner's business areanvarchar40
38BFOD_AFI Subsequent BA/PC Adjustment: Customer Items22PARGBTrading partner's business areanvarchar40
39BFOK_AFI subsequent BA/PC adjustment: Vendor items22PARGBTrading partner's business areanvarchar40
40EBSEGDoc.Segment of Fin.Accntng External Documents13PARGBReceiving Business Area of Customer/Vendornvarchar40
41KMZEIFI: Account Assignment Model Item Information9PARGBTrading partner's business areanvarchar40
42KOMUAccount Assignment Templates for G/L Account Items9PARGBTrading partner's business areanvarchar40
43RF048Subseq.BA/PC Adjustmnt: Index/Distributn Vector (Calculate)7PARGBTrading partner's business areanvarchar40
44VBKPFDocument Header for Document Parking42PARGBPartner Business Area Default Valuenvarchar40
45VBSEGADocument Segment for Document Parking - Asset Database10PARGBTrading partner's business areanvarchar40
46VBSEGDDocument Segment for Customer Document Parking13PARGBTrading partner's business areanvarchar40
47VBSEGKDocument Segment for Vendor Document Parking13PARGBTrading partner's business areanvarchar40
48VBSEGSDocument Segment for Document Parking - G/L Account Database11PARGBTrading partner's business areanvarchar40
TOPFunds Management-Specific Postings
49FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years13PARGBTrading partner's business areanvarchar40
50PSOKPFRecurring Request Document Header43PARGBPartner Business Area Default Valuenvarchar40
51PSOSEGADocument Segment for Assets Document Parking11PARGBTrading partner's business areanvarchar40
52PSOSEGDDocument Segment: Recurring Request, Customer14PARGBTrading partner's business areanvarchar40
53PSOSEGKRecurring Request Document Segment, Vendors14PARGBTrading partner's business areanvarchar40
54PSOSEGSRecurring Request Document Segment, G/L Accounts12PARGBTrading partner's business areanvarchar40
TOPGeneral Ledger Accounting
55BSEG_ADDEntry View of Accounting Document for Additional Ledgers110PARGBTrading partner's business areanvarchar40
56FAGL_SPLINFOSplittling Information of Open Items14PARGBTrading partner's business areanvarchar40
TOPGeneral Ledger Reorganization
57FAGL_R_SPLReorganization: Splitting Information of the Open Items13PARGBTrading partner's business areanvarchar40
TOPGL Account Posting
58TCJ_POSITIONSCash Journal Document Items24PARGBTrading partner's business areanvarchar40
TOPInformation System, iViews
59COOI_PIBW CO-OM: Commitment Management: Deleted Line Items21PARGBTrading partner's business areanvarchar40
TOPInventory Management
60MSEGDocument Segment: Material54PARGBTrading partner's business areanvarchar40
61MWXMSEGZMSEG: Interface for Posting of Value54PARGBTrading partner's business areanvarchar40
62MWZMSEGZMSEG:Interface for Posting of Value54PARGBTrading partner's business areanvarchar40
63RKPFDocument Header: Reservation25PARGBTrading partner's business areanvarchar40
TOPInvoice Verification
64RBCODocument Item, Incoming Invoice, Account Assignment61PARGBTrading partner's business areanvarchar40
TOPJoint Venture und Production Sharing Accounting
65T8J_POST_ERROR_CDocuments with errors in JV posting (Open Items)16PARGBTrading partner's business areanvarchar40
TOPLocal Currency Changeover
66EWUCOKException table for TWAER conversion12PARGBTrading partner's business areanvarchar40
TOPLocalization
67VIXCFRBUDGETBudget Seasonality Data11PARGBTrading partner's business areanvarchar40
TOPOrders for Projects
68COSPPTransfer of the Order in the COSP Table to the Project12PARGBTrading partner's business areanvarchar40
TOPOverhead Cost Controlling
69COEJCO Object: Line Items (by Fiscal Year)178PARGBTrading partner's business areanvarchar40
70COEPCO Object: Line Items (by Period)28PARGBTrading partner's business areanvarchar40
71COKPCO Object: Control Data for Primary Planning11PARGBTrading partner's business areanvarchar40
72COSPCO Object: Cost Totals for External Postings11PARGBTrading partner's business areanvarchar40
73COVP_DELTA_LOGLog of COVP Delta Queue for Error Analysis30PARGBTrading partner's business areanvarchar40
TOPOverhead Cost Orders
74COOICommitments Management: Line Items21PARGBTrading partner's business areanvarchar40
75COSPDCO Object: Settled Primary Cost Totals11PARGBTrading partner's business areanvarchar40
TOPProfitability Analysis
76CECOEJCO-PA Account Based Line Items180PARGBTrading partner's business areanvarchar40
77CECOEPCO-PA Account Based Line Items30PARGBTrading partner's business areanvarchar40
TOPRemaining Beverage - Obsolete Objects
78/BEV3/CH1030BSG1Document Segment CH Event Ledger Part119PARGBTrading partner's business areanvarchar40
TOPRepetitive Manufacturing
79COMPMOVEGoods Movement of Components238PARGBTrading partner's business areanvarchar40
TOPRevenues and Earnings
80AD01DLIDynamic items (DI)36PARGBTrading partner's business areanvarchar40
TOPSales
81VBAPSales Document: Item Data355PARGBTrading partner's business areanvarchar40
TOPShipping
82LIPSPOLIPS Reference Data Purchase Order26PARGBTrading partner's business areanvarchar40
83LIPSRFLIPS Reference Data29PARGBTrading partner's business areanvarchar40