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

38 columns | Print definition?ERP 6.0  | BNFPO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000189000PSA for 2LIS_02_SCL T90CLNT090 Purch.Data Sch.Line55BNFPOnvarchar50
2ZARIXMM1MM_EBAN : Indextabelle zur Selektion von Datenobjekten3BNFPOPositionsnummer der Bestellanforderungnvarchar50
3ZEIM_VBEPSales Document: Schedule Line Data47BNFPOItem Number of Purchase Requisitionnvarchar50
TOPBasic Functions
4FDM2Cash management line items from MM purchase requisition6BNFPOItem Number of Purchase Requisitionnvarchar50
TOPCommand and Support Relationships
5/ISDFPS/ORTOB1Technical Object Relationships (PM) - Additional Data5BNFPOItem Number of Purchase Requisitionnvarchar50
TOPCross-Application Components
6VVBEPSales Document: Schedule Line Data47BNFPOItem Number of Purchase Requisitionnvarchar50
TOPDefense Forces and Public Security
7/ISDFPS/ZEBANCopy of EBAN3BNFPOItem Number of Purchase Requisitionnvarchar50
TOPExternal Services
8ESSRService Entry Sheet Header Data41BNFPOItem number of purchase requisitionnvarchar50
TOPForce Element
9/ISDFPS/FORTOBAttributes of Relationship to Technical Objects23BNFPOItem Number of Purchase Requisitionnvarchar50
TOPGoods Issue Process
10/SPE/CRMD_PR_MAPMapping Table Purchase Requisition <-> CRM Sales Order3BNFPOItem Number of Purchase Requisitionnvarchar50
TOPInventory Management
11RESBReservation/dependent requirements30BNFPOItem Number of Purchase Requisitionnvarchar50
TOPMaster Data
12RSDBIndex of the RESB for the Direct Procurement Element8BNFPOItem Number of Purchase Requisitionnvarchar50
TOPMaterial
13RSDBSIndex of purchasing documents for individual customer stock7BNFPOItem Number of Purchase Requisitionnvarchar50
TOPMaterials Management
14/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions8BNFPOItem Number of Purchase Requisitionnvarchar50
15/ISDFPS/LOSSMANLoss Management9BNFPOItem Number of Purchase Requisitionnvarchar50
16EPRTRANSTransfer Table for Purch. Requistions in Ext. Purch System3BNFPOItem Number of Purchase Requisitionnvarchar50
TOPProduction Orders
17AFVCOperation within an order86BNFPOItem number of the purchase requisition in the ordernvarchar50
TOPPurchasing
18CRS_PURCHITM_MAPMapping of CRM purchase assignments to preq items5BNFPOItem Number of Purchase Requisitionnvarchar50
19EBANPurchase Requisition3BNFPOItem Number of Purchase Requisitionnvarchar50
20EBAN_TECHPurchase Requisition for External Sourcing3BNFPOItem Number of Purchase Requisitionnvarchar50
21EBKNPurchase Requisition Account Assignment3BNFPOItem Number of Purchase Requisitionnvarchar50
22EBUBIndex for Stock Transport Requisitions for Material5BNFPOItem Number of Purchase Requisitionnvarchar50
23EKETScheduling Agreement Schedule Lines14BNFPOItem Number of Purchase Requisitionnvarchar50
24EKETHScheduling Agreement Schedules: History Tables14BNFPOItem Number of Purchase Requisitionnvarchar50
25EKPOPurchasing Document Item151BNFPOItem Number of Purchase Requisitionnvarchar50
26MEREQXPurchase Requisition Change Parameter3BNFPOItem Number of Purchase Requisitionnvarchar50
27MEREQ_BADI_EXAMPBAdI ME51N: Example of Customer's Own Data3BNFPOItem Number of Purchase Requisitionnvarchar50
28PREXTEnhancement Fields for Purchase Requisition3BNFPOItem Number of Purchase Requisitionnvarchar50
TOPSales
29VBEPSales Document: Schedule Line Data47BNFPOItem Number of Purchase Requisitionnvarchar50
TOPSelf-Service Procurement
30/SRMERP/D_SC_ITMShopping Cart Item66BNFPOItem Number of Purchase Requisitionnvarchar50
TOPSerial Numbers
31SER09Doc. Header for Serial Numbers for Purchase Requisition Item4BNFPOItem Number of Purchase Requisitionnvarchar50
TOPSimulation
32VSAFVC_CNVersion: Operation in order87BNFPOItem number of the purchase requisition in the ordernvarchar50
33VSEBAN_CNVersion: Purchase requisition4BNFPOItem Number of Purchase Requisitionnvarchar50
34VSEBKN_CNVersion: Purchase requisition account assignment4BNFPOItem Number of Purchase Requisitionnvarchar50
35VSRESB_CNVersion: Reservation/Dependent requirements31BNFPOItem Number of Purchase Requisitionnvarchar50
36VSRSDB_CNVersion: Index of RESB for direct procurement elements9BNFPOItem Number of Purchase Requisitionnvarchar50
37VSVBEP_CNVersion: Sales document: Schedule line data48BNFPOItem Number of Purchase Requisitionnvarchar50
TOPTreasury
38FLQITEMPR_FCLiquidity Calc. Forecast - Line Items, Purchase Requisitions3BNFPOItem Number of Purchase Requisitionnvarchar50