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

63 columns | Print definition?ERP 6.0  | KZVBR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000183000PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item52KZVBRnvarchar10
2ZEIM_AFPOOrder item55KZVBRConsumption Postingnvarchar10
3ZEIM_LIPSSD document: Delivery: Item data116KZVBRConsumption Postingnvarchar10
4ZEIM_VBAPSales Document: Item Data141KZVBRConsumption Postingnvarchar10
TOPAccounting Interface
5GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)199KZVBRConsumption Postingnvarchar10
6GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)199KZVBRConsumption Postingnvarchar10
TOPActual CostingMaterial Ledger
7MLITMBMaterial valuation document row information11KZVBRConsumption Postingnvarchar10
TOPBalance Sheet Valuation Procedures
8MYSEG_EXTRACTDocument Segment: Material28KZVBRConsumption Postingnvarchar10
TOPBasic Functions
9VBBESales Requirements: Individual Records33KZVBRConsumption Postingnvarchar10
10VBBSSales Requirement Totals Record21KZVBRConsumption Postingnvarchar10
TOPConfirmations
11AFFWGoods Movements with Errors from Confirmations14KZVBRConsumption Postingnvarchar10
TOPCross-Application Components
12VVBAPSales Document: Item Data141KZVBRConsumption Postingnvarchar10
TOPData Collection
13S008Communications Table SD -> CO/Projects96KZVBRConsumption Postingnvarchar10
14S261SD - Delivery note81KZVBRConsumption Postingnvarchar10
15S261BIW1SD - Delivery note81KZVBRConsumption Postingnvarchar10
16S261BIW2SD - Delivery note81KZVBRConsumption Postingnvarchar10
TOPData Retention Tool
17TXW_S_MSEGRetrieve MSEG from archive63KZVBRConsumption Postingnvarchar10
TOPDefense Forces and Public Security
18/ISDFPS/ZEBANCopy of EBAN37KZVBRConsumption Postingnvarchar10
TOPDemand Management
19PBICInd. reqmts index for customer requirements (without RV)12KZVBRConsumption Postingnvarchar10
20PBIDPlanned independent requirements index: MRP area30KZVBRConsumption Postingnvarchar10
21PBIMIndependent Requirements for Material28KZVBRConsumption Postingnvarchar10
TOPExternal Services
22ESSRService Entry Sheet Header Data38KZVBRConsumption Postingnvarchar10
TOPFinancial Accounting
23ACCTITCompressed Data from FI/CO Document72KZVBRConsumption Postingnvarchar10
TOPInventory Management
24MSEGDocument Segment: Material87KZVBRConsumption Postingnvarchar10
25MWXMSEGZMSEG: Interface for Posting of Value87KZVBRConsumption Postingnvarchar10
26MWZMSEGZMSEG:Interface for Posting of Value87KZVBRConsumption Postingnvarchar10
27RESBReservation/dependent requirements95KZVBRConsumption Postingnvarchar10
28T156SMovement Type: Quantities/Value Posting (Until Rel. 4.5B)8KZVBRConsumption Postingnvarchar10
29T156SCMvt Type: Qty/Value Posting: Customer Table; as of Rel. 4.6A8KZVBRConsumption Postingnvarchar10
30T156SYMvt Type: Qty/Value Update: System Table; Rel. 4.6A7KZVBRConsumption Postingnvarchar10
31T156TMovement Type Text7KZVBRConsumption Postingnvarchar10
32T156XTrans./Event Key Modification7KZVBRConsumption Postingnvarchar10
TOPJoint Venture und Production Sharing Accounting
33T8J156SJV Appendix for T1156S8KZVBRConsumption Postingnvarchar10
34T8J156XJV Appendix for T156X7KZVBRConsumption Postingnvarchar10
TOPMaster Data
35MDSMSimulative dependent requirements89KZVBRConsumption Postingnvarchar10
36PLAFPlanned Order35KZVBRConsumption Postingnvarchar10
37PSPLIndex project -> planned order5KZVBRConsumption Postingnvarchar10
TOPMaterials Management
38/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions42KZVBRConsumption Postingnvarchar10
39J_1GVL_MLMaterial Ledger20KZVBRConsumption Postingnvarchar10
40J_1GVL_WHB005Valid Document Types / Movement Types7KZVBRConsumption Postingnvarchar10
TOPProduction Backflush
41PPC_MATSuper BOM for Backflushed Materials10KZVBRConsumption Postingnvarchar10
42PPC_STEP2Goods Movements Table for New PPCGO Logic (2 Steps)17KZVBRConsumption Postingnvarchar10
TOPProduction Orders
43AFPOOrder item55KZVBRConsumption Postingnvarchar10
TOPPurchasing
44EBANPurchase Requisition37KZVBRConsumption Postingnvarchar10
45EKPOPurchasing Document Item52KZVBRConsumption Postingnvarchar10
46MEREQXPurchase Requisition Change Parameter37KZVBRUpdated information in related user data fieldnvarchar10
47T163KAccount Assignment Categories in Purchasing Document3KZVBRIndicator: Consumption posting (Purchasing)nvarchar10
TOPQuality Inspection
48QALSInspection lot record179KZVBRConsumption Postingnvarchar10
49T156QMovement Type: Material-Independent Control6KZVBRConsumption Postingnvarchar10
TOPRemaining Beverage - Obsolete Objects
50/BEV1/RBVBAPSales Document: Item Data141KZVBRConsumption Postingnvarchar10
TOPRepetitive Manufacturing
51COMPMOVEGoods Movement of Components170KZVBRConsumption Postingnvarchar10
TOPSales
52VBAPSales Document: Item Data141KZVBRConsumption Postingnvarchar10
TOPSelf-Service Procurement
53/SRMERP/D_SC_ITMShopping Cart Item36KZVBRConsumption Postingnvarchar10
TOPShipping
54LIPSSD document: Delivery: Item data116KZVBRConsumption Postingnvarchar10
TOPSimulation
55VSAFPO_CNVersion: Order items in PP orders56KZVBRConsumption Postingnvarchar10
56VSEBAN_CNVersion: Purchase requisition38KZVBRConsumption Postingnvarchar10
57VSPLAF_CNVersion: Planned order36KZVBRConsumption Postingnvarchar10
58VSRESB_CNVersion: Reservation/Dependent requirements96KZVBRConsumption Postingnvarchar10
59VSVBAP_CNVersion: Sales document: Item data142KZVBRConsumption Postingnvarchar10
TOPSpare Part Sharing and Stock Providede by Customer
60DICS_T156QMovement Type: Material-Independent Control6KZVBRConsumption Postingnvarchar10
61DICS_T156SCMvt Type: Qty/Value Posting: Customer Table; as of Rel. 4.6A8KZVBRConsumption Postingnvarchar10
62DICS_T156SYBack Up - Movement Type Quantity/Value Posting: Sys7KZVBRConsumption Postingnvarchar10
63DICS_T156TMovement Type Text7KZVBRConsumption Postingnvarchar10