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

50 columns | Print definition?ERP 6.0  | ABGRU

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CADMC/00000506TVAG5ABGRUnvarchar20
2/1CADMC/00000507TVAGT6ABGRUnvarchar20
3/BIC/B0000177000PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item26ABGRUnvarchar20
4/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item36ABGRUnvarchar20
5/BIC/B0000179000PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule49ABGRUnvarchar20
6/BIC/B0000181000PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond.30ABGRUnvarchar20
7ZEIM_VBAPSales Document: Item Data16ABGRUReason for rejection of quotations and sales ordersnvarchar20
TOPAdvanced Returns Management
8MSR_C_ABGRURejection Reasons2ABGRURejection Reason for Supplier Returnsnvarchar20
9MSR_C_ABGRUTMulti-step returns - Rejection reason3ABGRUReason for rejection of quotations and sales ordersnvarchar20
10MSR_D_EXECUTEDAdvanced Returns Management # Tracking of Executed Steps40ABGRUReason for rejection of quotations and sales ordersnvarchar20
11MSR_D_FIN_DETAILAdvanced Returns Management - Next Financial Steps - Details26ABGRUReason for rejection of quotations and sales ordersnvarchar20
TOPBasic Functions
12TVAGSales Documents: Rejection Reasons2ABGRUReason for rejection of quotations and sales ordersnvarchar20
13TVAGTRejection Reasons for Sales Documents: Texts3ABGRUReason for rejection of quotations and sales ordersnvarchar20
TOPBasis Components
14ZDS400_VBAPTabelle für Beispielprogramm des ZDS40016ABGRUAbsagegrund für Angebote und Aufträgenvarchar20
TOPControlling
15CRMC_SRV_BILL_ITCRM Service: Mapping item categories6ABGRUReason for rejection of quotations and sales ordersnvarchar20
TOPCross-Application Components
16VVBAPSales Document: Item Data16ABGRUReason for rejection of quotations and sales ordersnvarchar20
TOPData Collection
17S260SD - Sales order56ABGRUReason for rejection of quotations and sales ordersnvarchar20
18S260BIW1SD - Sales order56ABGRUReason for rejection of quotations and sales ordersnvarchar20
19S260BIW2SD - Sales order56ABGRUReason for rejection of quotations and sales ordersnvarchar20
20S264SD- Offer58ABGRUReason for rejection of quotations and sales ordersnvarchar20
21S264BIW1S264BIW1 * SD - Quotation58ABGRUReason for rejection of quotations and sales ordersnvarchar20
22S264BIW2S264BIW2 * SD - Quotation58ABGRUReason for rejection of quotations and sales ordersnvarchar20
23S272Do not use!46ABGRUReason for rejection of quotations and sales ordersnvarchar20
24S272BIW1Do not use!46ABGRUReason for rejection of quotations and sales ordersnvarchar20
25S272BIW2Do not use!46ABGRUReason for rejection of quotations and sales ordersnvarchar20
26S276Transfer BW: Vertriebsdaten33ABGRUAfzeggingsreden voor offertes en ordersnvarchar20
27S276BIW1S276BIW1 * Transfer to BW: Sales and Distribution Data33ABGRUReason for rejection of quotations and sales ordersnvarchar20
28S276BIW2S276BIW2 * BW Transfer: Sales and Distribution Data33ABGRUReason for rejection of quotations and sales ordersnvarchar20
TOPDistributor-Reseller-Management
29/SAPHT/DRMBUDLBill Up Due List60ABGRUReason for rejection of quotations and sales ordersnvarchar20
30/SAPHT/DRMCORJNMapping of ERP Rejection Reason to DRM SD rejection reason2ABGRUReason for rejection of quotations and sales ordersnvarchar20
31/SAPHT/DRMPPDLPrice Protection Due List52ABGRUReason for rejection of quotations and sales ordersnvarchar20
32/SAPHT/DRMR3XNDRM relevant ERP Transactions12ABGRUReason for rejection of quotations and sales ordersnvarchar20
33/SAPHT/DRMSDDLShip and Debit Due List76ABGRUReason for rejection of quotations and sales ordersnvarchar20
TOPExpense-Related Billing
34PRSC_CTRLEngagement mgmt: Process Control4ABGRUReason for rejection of quotations and sales ordersnvarchar20
TOPLogistics - General
35CHBSINTCRE-SCM - "sold to interal party" for canceled sales!4ABGRUReason for rejection of quotations and sales ordersnvarchar20
36WBHITrading Contract: Item Data37ABGRUReason for rejection of quotations and sales ordersnvarchar20
TOPMedia Product Sales and Distribution
37JKSDT_SD_CON_GENIS-M: Table for Generating Contracts10ABGRUReason for rejection of quotations and sales ordersnvarchar20
38JKSECONTRINDEXIndex Table for IS-M Contracts12ABGRUReason for rejection of quotations and sales ordersnvarchar20
39TJKSDCICORDPSTYVDetermine Allowed Item Categories in CIC8ABGRUReason for rejection of quotations and sales ordersnvarchar20
TOPPurchasing
40EKKOPurchasing Document Header42ABGRUField Not Usednvarchar20
TOPRemaining Beverage - Obsolete Objects
41/BEV1/RBVBAPSales Document: Item Data16ABGRUReason for rejection of quotations and sales ordersnvarchar20
42/BEV1/REABGRURental Item: Reasons for Rejection2ABGRUReason for rejection of quotations and sales ordersnvarchar20
43/BEV1/REWARTRental Items: Delivery Schedule Items17ABGRUReason for rejection of quotations and sales ordersnvarchar20
44/BEV1/RSCPYRLSRoute Settlement - Settings to Copy Returns Loading Note5ABGRUReason for rejection of quotations and sales ordersnvarchar20
TOPRevenues and Earnings
45VPKHEADSales Pricing Header Data23ABGRUReason for rejection of quotations and sales ordersnvarchar20
TOPSales
46VBAPSales Document: Item Data16ABGRUReason for rejection of quotations and sales ordersnvarchar20
47VLPKMScheduling agreements by customer material13ABGRUReason for rejection of quotations and sales ordersnvarchar20
TOPSimulation
48VSVBAP_CNVersion: Sales document: Item data17ABGRUReason for rejection of quotations and sales ordersnvarchar20
TOPSoftware Management
49TOGM3SMP 'push' material list3ABGRUReason for rejection of quotations and sales ordersnvarchar20
TOPVehicle Management System
50VLCBATCHACTVELO : Variant for Action Execution in Batch76ABGRUReason for rejection of quotations and sales ordersnvarchar20