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

55 columns | Print definition?ERP 6.0  | EAN11

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000177000PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item28EAN11nvarchar180
2/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item44EAN11nvarchar180
3/BIC/B0000179000PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule54EAN11nvarchar180
4/BIC/B0000180000PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch.40EAN11nvarchar180
5/BIC/B0000181000PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond.34EAN11nvarchar180
6/BIC/B0000183000PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item39EAN11nvarchar180
7/BIC/B0000185000PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item35EAN11nvarchar180
8/BIC/B0000186000PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond.30EAN11nvarchar180
9/SMERP/STG_MM001Data staging - Material master plant view complex table50EAN11International Article Number (EAN/UPC)nvarchar180
10/SMERP/STG_MM002Data staging - Material storage location view complex table50EAN11International Article Number (EAN/UPC)nvarchar180
11/SMERP/STG_MM003Data staging - Material UoM view complex table51EAN11International Article Number (EAN/UPC)nvarchar180
12/SMERP/STG_MM004Data staging - Material warehouse view complex table50EAN11International Article Number (EAN/UPC)nvarchar180
13/SMERP/STG_MM005Data staging - Material batch view complex table50EAN11International Article Number (EAN/UPC)nvarchar180
14ZEIMMARAUSING FOR STORING EIM MARA DATAS51EAN11International Article Number (EAN/UPC)nvarchar180
15ZEIM_LIPSSD document: Delivery: Item data88EAN11International Article Number (EAN/UPC)nvarchar180
16ZEIM_VBAPSales Document: Item Data121EAN11International Article Number (EAN/UPC)nvarchar180
TOPAdvertising Management
17JHTFPIS-M/AM: Billing/Settlement Documents - Item40EAN11International Article Number (EAN/UPC)nvarchar180
TOPAssortment
18WRF_APC_PAUOMPlanned Article Units of Measure6EAN11International Article Number (EAN/UPC)nvarchar180
TOPAssortment List
19WBBPAssortment list item7EAN11International Article Number (EAN/UPC)nvarchar180
TOPAustralia
20PA0701HR Terminations Data Container : Infotype 0701227EAN11Numberdecimal72
TOPBilling
21VBRPBilling Document: Item Data87EAN11International Article Number (EAN/UPC)nvarchar180
TOPConditions
22A070EAN per Plant8EAN11International Article Number (EAN/UPC)nvarchar180
23A072EAN per SOrg/DstCh7EAN11International Article Number (EAN/UPC)nvarchar180
TOPCross-Application Components
24MMARAGeneral material data51EAN11International Article Number (EAN/UPC)nvarchar180
25VVBAPSales Document: Item Data121EAN11International Article Number (EAN/UPC)nvarchar180
TOPDSD Connector
26/DSD/ME_MAT_HDDSD CN: Material Data for Downloading to HH9EAN11DSD Connector: International article numbernvarchar180
27/DSD/ME_MAT_UOMDSD CN: Material Alternative Units of Measure7EAN11DSD Connector: International article numbernvarchar180
TOPExternal Services
28ASMDService Master: Basic Data12EAN11International Article Number (EAN/UPC)nvarchar180
TOPInventory Management
29MWZDM07M2ZDM07M250EAN11International Article Number (EAN/UPC)nvarchar180
TOPInvoice Verification
30RBDIFFMEBatch Invoice Verification - Quantity Differences5EAN11International Article Number (EAN/UPC)nvarchar180
31RBDRSEGBatch IV: Invoice Document Items80EAN11International Article Number (EAN/UPC)nvarchar180
TOPLocalization
32J_1IRAINDTLArticle Inward Note Detail15EAN11International Article Number (EAN/UPC)nvarchar180
33SAFTPT_IMATSAFT PT : Tax Like materials5EAN11International Article Number (EAN/UPC)nvarchar180
TOPLogistics - General
34WBHITrading Contract: Item Data56EAN11International Article Number (EAN/UPC)nvarchar180
TOPMaterial Master
35MARAGeneral Material Data51EAN11International Article Number (EAN/UPC)nvarchar180
36MARA_TMPFile for Incorrect Data in Direct Input58EAN11International Article Number (EAN/UPC)nvarchar180
37MARMUnits of Measure for Material7EAN11International Article Number (EAN/UPC)nvarchar180
38MARM_TMPFile for Incorrect Data in Direct Input10EAN11International Article Number (EAN/UPC)nvarchar180
39MEA1_TMPFile for Incorrect Data in Direct Input7EAN11International Article Number (EAN/UPC)nvarchar180
40MEANInternational Article Numbers (EANs) for Material5EAN11International Article Number (EAN/UPC)nvarchar180
41MLEAVendor-Specific EANs6EAN11International Article Number (EAN/UPC)nvarchar180
42MVRACross-version fields for MARA51EAN11International Article Number (EAN/UPC)nvarchar180
43MVRMUnits of Measure for Material7EAN11International Article Number (EAN/UPC)nvarchar180
TOPMedia Product Sales and Distribution
44JKSDUNSOLDITEMIS-M: Item Data on Unsold Copies/Credit Memos77EAN11International Article Number (EAN/UPC)nvarchar180
45JPTMG0IS-M: Media Product Issue Sequence17EAN11International Article Number (EAN/UPC)nvarchar180
TOPMerchandise and Assortment Planning
46TWISPC_MARARetail Planning: Materials for Provisional Planning15EAN11International Article Number (EAN/UPC)nvarchar180
TOPPendulum List Indirect Sales
47/BEV4/PLDANFKONConverted Request Table with Reporting Period28EAN11EAN/UPC CODEnvarchar180
TOPPOS Interface
48WVFBDRS Interface, Intermediate Buffer, Order Item FM30EAN11International Article Number (EAN/UPC)nvarchar180
TOPPurchasing
49EKPOPurchasing Document Item94EAN11International Article Number (EAN/UPC)nvarchar180
TOPRemaining Beverage - Obsolete Objects
50/BEV1/RBVBAPSales Document: Item Data121EAN11International Article Number (EAN/UPC)nvarchar180
TOPRetail Pricing
51WKBPPricing document: item17EAN11International Article Number (EAN/UPC)nvarchar180
TOPSales
52SLS_TMPL_ITEMSales: Template Item8EAN11International Article Number (EAN/UPC)nvarchar180
53VBAPSales Document: Item Data121EAN11International Article Number (EAN/UPC)nvarchar180
TOPShipping
54LIPSSD document: Delivery: Item data88EAN11International Article Number (EAN/UPC)nvarchar180
TOPSimulation
55VSVBAP_CNVersion: Sales document: Item data122EAN11International Article Number (EAN/UPC)nvarchar180