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

49 columns | Print definition?ERP 6.0  | PACKNO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VIM_1ITEM_SDocument Item114PACKNOPackage Number of Servicenvarchar100
2/OPT/VIM_TITEMDocument Item114PACKNOPackage Number of Servicenvarchar100
3DVM_BOF_PACKSBusiness Object Footprint packages for PPF6PACKNOnvarchar40
4YVIM_1ITEMDocument Item114PACKNOPackage Number of Servicenvarchar100
TOPConditions
5A076Master Conditions for Activities in Contract4PACKNOPackage numbernvarchar100
6A077Cost Split for Activities in Contract5PACKNOPackage numbernvarchar100
TOPConfirmations
7AFRDDefault values for collective confirmation109PACKNOPackage numbernvarchar100
8AFRUOrder Confirmations131PACKNOPackage numbernvarchar100
9AFRVConfirmation pool179PACKNOPackage numbernvarchar100
10AFRV_DELBackup Copy for Confirmation Pool179PACKNOPackage numbernvarchar100
TOPCross-Application Components
11PLLPOTask list - operation/activity195PACKNOPackage numbernvarchar100
TOPCustomer Bill of Services
12/SAPBOQ/HD_SESQTO header table8PACKNOPackage numbernvarchar100
13/SAPBOQ/HEADERHeader of service package BOQ2PACKNOPackage numbernvarchar100
TOPData Basis
14RSSEM_RFCPACKTemporary Storage of Selected InfoProvider Data4PACKNONumeric Character Field, Length 10nvarchar100
TOPDefense Forces and Public Security
15/ISDFPS/ZEBANCopy of EBAN75PACKNOPackage numbernvarchar100
TOPExternal Services
16ESKLAccount Assignment Specification: Service Line2PACKNOPackage numbernvarchar100
17ESKNAccount Assignment in Service Package2PACKNOPackage numbernvarchar100
18ESLHService Package Header Data2PACKNOPackage numbernvarchar100
19ESLLLines of Service Package2PACKNOPackage numbernvarchar100
20ESLPService Item8PACKNOPackage numbernvarchar100
21ESSRService Entry Sheet Header Data18PACKNOPackage numbernvarchar100
22ESUCExt. Services Management: Unplanned Limits on Contract Item2PACKNOPackage numbernvarchar100
23ESUHExt. Services Management: Unpl. Service Limits: Header Data2PACKNOPackage numbernvarchar100
24ESUH_MAExt. Services Management: Unpl. Service Limits: Account Dist2PACKNOPackage numbernvarchar100
25ESUPExt. Services Management: Unpl. Limits on Service Package2PACKNOPackage numbernvarchar100
26ESUSServices Management: Unplanned Limits on Service Types2PACKNOPackage numbernvarchar100
27ESVCVendor confirmation for service lines2PACKNOPackage numbernvarchar100
28TMP_SPECModel Service Specifications11PACKNOPackage numbernvarchar100
TOPFinancial Accounting
29/OPT/VIM_1ITEMDocument Item114PACKNOPackage Number of Servicenvarchar100
TOPInvoice Verification
30RBDRSEGBatch IV: Invoice Document Items87PACKNOPackage Number of Servicenvarchar100
31RSEGDocument Item: Incoming Invoice59PACKNOPackage Number of Servicenvarchar100
TOPMaintenance Task Lists
32MPOSMaintenance item44PACKNOPackage numbernvarchar100
TOPMaster Data Distribution
33/ISDFPS/TL1Task List - Operation/Activity195PACKNOPackage numbernvarchar100
TOPMaterials Management
34/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions80PACKNOPackage numbernvarchar100
TOPProduction Orders
35AFVCOperation within an order121PACKNOPackage numbernvarchar100
TOPPurchasing
36EBANPurchase Requisition75PACKNOPackage numbernvarchar100
37EKBEHistory per Purchasing Document51PACKNOPackage Number of Servicenvarchar100
38EKBEHRemoved PO History Records51PACKNOPackage Number of Servicenvarchar100
39EKBEH_MARemoved PO History Records at Account Assignment Level12PACKNOPackage Number of Servicenvarchar100
40EKBE_MAHistory of Purchasing Document at Account Assignment Level12PACKNOPackage Number of Servicenvarchar100
41EKBE_SRV_SUMTotals History for SRV Documents6PACKNOPackage Number of Servicenvarchar100
42EKDFDocument Flow for Logistics Differential Invoice10PACKNOPackage Number of Servicenvarchar100
43EKPOPurchasing Document Item113PACKNOPackage numbernvarchar100
44MEREQXPurchase Requisition Change Parameter75PACKNOUpdated information in related user data fieldnvarchar10
TOPRouting
45PLPOTask list - operation/activity195PACKNOPackage numbernvarchar100
TOPSelf-Service Procurement
46/SRMERP/D_SC_ITMShopping Cart Item46PACKNOPackage numbernvarchar100
TOPSimulation
47VSAFVC_CNVersion: Operation in order122PACKNOPackage numbernvarchar100
48VSEBAN_CNVersion: Purchase requisition75PACKNOPackage numbernvarchar100
TOPWithout Description
49RSBAIPROVTemporary Storage of Selected InfoProvider Data4PACKNOnvarchar100