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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

34 columns | Print definition?ERP 6.0  | ABTNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CADMC/00000492TSABT6ABTNRnvarchar40
2/1RA/0SD010MIItems for Class SD01 - Raw Data52ABTNRDepartment numbernvarchar40
3/SMD/MD_____00RNSID-Tabelle fuer Department3ABTNRDepartmentnvarchar40
4BBPT_T023Material groups7ABTNRDepartment numbernvarchar40
5CNV_20800_KNVKCNV backup copy: Customer master contact person11ABTNRDepartment numbernvarchar40
6ZEIM_LIPSSD document: Delivery: Item data149ABTNRDepartment numbernvarchar40
TOPAdvertising Management
7JJTAMIS-M/AM: Media Contact Person30ABTNRContact person departmentnvarchar40
TOPAssortment List
8WBBLAssort. list control break13ABTNRDepartment numbernvarchar40
TOPBasic Functions
9TSABContact persons: standard departments2ABTNRDepartment numbernvarchar40
TOPBusiness Partner Enhancements for Financial Services
10TP16Business Partner: Department3ABTNRDepartmentnvarchar40
TOPCross-Application Components
11SKNVKCustomer Master Contact table for BC417 Course10ABTNRContact person departmentnvarchar40
12VVBKDSales Document: Business Data39ABTNRDepartment numbernvarchar40
TOPCustomer Master
13KNVKCustomer Master Contact Partner10ABTNRContact person departmentnvarchar40
TOPData Collection
14S160Perishables69ABTNRDepartment numbernvarchar40
15S200Inventory Controlling Stores41ABTNRDepartment numbernvarchar40
TOPMaster Data Synchronization
16CVIC_CP1_LINKDepartment Nos of Contact Persons (Customer/Vendor-->BP)2ABTNRDepartment numbernvarchar40
TOPMaterial Groups
17T023Material Groups7ABTNRDepartment numbernvarchar40
TOPMaterial Maintenance
18TSABTContact Person Departments: Texts3ABTNRDepartment numbernvarchar40
TOPPlant Master
19WRF4Plant/ Departments3ABTNRDepartment numbernvarchar40
20WRF6Plant / material group6ABTNRDepartment numbernvarchar40
TOPProfitability Analysis
21CE1R300Operating Concern IDES57ABTNRDepartment numbernvarchar40
22CE2R300Operating Concern IDES41ABTNRDepartment numbernvarchar40
23CE4R300Operating Concern IDES26ABTNRDepartment numbernvarchar40
24CE4R300_ACCTErgebnisbereich IDES27ABTNRAbteilungsnummernvarchar40
25CE4R300_FLAGErgebnisbereich IDES23ABTNRFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
26CE4R300_KENCOperating Concern IDES25ABTNRDepartment numbernvarchar40
TOPSales
27VBKDSales Document: Business Data39ABTNRDepartment numbernvarchar40
TOPSales Promotions
28SADLSTRECBDynamic Part of Address List (Record Body)80ABTNRDepartment numbernvarchar40
TOPShipping
29LIPSSD document: Delivery: Item data149ABTNRDepartment numbernvarchar40
TOPSimulation
30VSVBKD_CNVersion: Sales document - commercial data40ABTNRDepartment numbernvarchar40
TOPUse AP-MD-BP Components
31BUT051BP Relationship: Contact Person Relationship11ABTNRDepartmentnvarchar40
32BUT051SShadow Table BP Relationship: Contact Person Relationship12ABTNRDepartmentnvarchar40
33TB910Contact Person Departments2ABTNRDepartmentnvarchar40
34TB911Contact person in standard departments: Texts3ABTNRDepartmentnvarchar40