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

44 columns | Print definition?ERP 6.0  | BANFN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000189000PSA for 2LIS_02_SCL T90CLNT090 Purch.Data Sch.Line54BANFNnvarchar100
2CNVTDMS_05_EBANCollect Table for EBAN in TDTIM3BANFNBELNR for CNVTDMS_05_*nvarchar100
3S520ES520 - Strukturinformationen9BANFNBestellanforderungsnummernvarchar100
4ZARIXMM1MM_EBAN : Indextabelle zur Selektion von Datenobjekten2BANFNBestellanforderungsnummernvarchar100
5ZEIM_VBEPSales Document: Schedule Line Data22BANFNPurchase Requisition Numbernvarchar100
TOPBasic Functions
6FDM2Cash management line items from MM purchase requisition3BANFNPurchase Requisition Numbernvarchar100
TOPCommand and Support Relationships
7/ISDFPS/ORTOB1Technical Object Relationships (PM) - Additional Data4BANFNPurchase Requisition Numbernvarchar100
TOPCross-Application Components
8VVBEPSales Document: Schedule Line Data22BANFNPurchase Requisition Numbernvarchar100
TOPData Collection
9S520Test14BANFNPurchase Requisition Numbernvarchar100
TOPDefense Forces and Public Security
10/ISDFPS/ZEBANCopy of EBAN2BANFNPurchase Requisition Numbernvarchar100
TOPExternal Services
11ESSRService Entry Sheet Header Data40BANFNPurchase Requisition Numbernvarchar100
TOPForce Element
12/ISDFPS/FORTOBAttributes of Relationship to Technical Objects22BANFNPurchase Requisition Numbernvarchar100
TOPGoods Issue Process
13/SPE/CRMD_PR_MAPMapping Table Purchase Requisition <-> CRM Sales Order2BANFNPurchase Requisition Numbernvarchar100
TOPInventory Management
14RESBReservation/dependent requirements29BANFNPurchase Requisition Numbernvarchar100
TOPMaster Data
15RSDBIndex of the RESB for the Direct Procurement Element7BANFNPurchase Requisition Numbernvarchar100
TOPMaterial
16RSDBSIndex of purchasing documents for individual customer stock6BANFNPurchase Requisition Numbernvarchar100
TOPMaterials Management
17/ISDFPS/LOSSMANLoss Management8BANFNPurchase Requisition Numbernvarchar100
18/ISDFPS/LOSTMANObsolete6BANFNPurchase Requisition Numbernvarchar100
19EPRTRANSTransfer Table for Purch. Requistions in Ext. Purch System2BANFNPurchase Requisition Numbernvarchar100
TOPProduction Orders
20AFVCOperation within an order85BANFNPurchase requisition numbernvarchar100
TOPPurchasing
21CRS_PURCHITM_MAPMapping of CRM purchase assignments to preq items4BANFNPurchase Requisition Numbernvarchar100
22EBANPurchase Requisition2BANFNPurchase Requisition Numbernvarchar100
23EBAN_ARCHIVEArchiving Index MM_EBAN2BANFNPurchase Requisition Numbernvarchar100
24EBAN_TECHPurchase Requisition for External Sourcing2BANFNPurchase Requisition Numbernvarchar100
25EBKNPurchase Requisition Account Assignment2BANFNPurchase Requisition Numbernvarchar100
26EBUBIndex for Stock Transport Requisitions for Material4BANFNPurchase Requisition Numbernvarchar100
27EKETScheduling Agreement Schedule Lines13BANFNPurchase Requisition Numbernvarchar100
28EKETHScheduling Agreement Schedules: History Tables13BANFNPurchase Requisition Numbernvarchar100
29EKPOPurchasing Document Item150BANFNPurchase Requisition Numbernvarchar100
30MEREQXPurchase Requisition Change Parameter2BANFNPurchase Requisition Numbernvarchar100
31MEREQ_BADI_EXAMPBAdI ME51N: Example of Customer's Own Data2BANFNPurchase Requisition Numbernvarchar100
32PREXTEnhancement Fields for Purchase Requisition2BANFNPurchase Requisition Numbernvarchar100
TOPSales
33VBEPSales Document: Schedule Line Data22BANFNPurchase Requisition Numbernvarchar100
TOPSelf-Service Procurement
34/SRMERP/D_SC_ITMShopping Cart Item65BANFNPurchase Requisition Numbernvarchar100
TOPSerial Numbers
35SER09Doc. Header for Serial Numbers for Purchase Requisition Item3BANFNPurchase Requisition Numbernvarchar100
TOPSimulation
36VSAFVC_CNVersion: Operation in order86BANFNPurchase requisition numbernvarchar100
37VSEBAN_CNVersion: Purchase requisition3BANFNPurchase Requisition Numbernvarchar100
38VSEBKN_CNVersion: Purchase requisition account assignment3BANFNPurchase Requisition Numbernvarchar100
39VSRESB_CNVersion: Reservation/Dependent requirements30BANFNPurchase Requisition Numbernvarchar100
40VSRSDB_CNVersion: Index of RESB for direct procurement elements8BANFNPurchase Requisition Numbernvarchar100
41VSVBEP_CNVersion: Sales document: Schedule line data23BANFNPurchase Requisition Numbernvarchar100
TOPStructures
42PSPR_GRP_IND_PRGrouping Indicators and purchase requisition numbers3BANFNPurchase Requisition Numbernvarchar100
43PSPR_GR_IND_RELAssignment of group indicator data3BANFNPurchase Requisition Numbernvarchar100
TOPTreasury
44FLQITEMPR_FCLiquidity Calc. Forecast - Line Items, Purchase Requisitions2BANFNPurchase Requisition Numbernvarchar100