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

204 columns | Print definition?ERP 6.0  | VRKME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000177000PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item57VRKMEnvarchar30
2/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item109VRKMEnvarchar30
3/BIC/B0000179000PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule24VRKMEnvarchar30
4/BIC/B0000180000PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch.18VRKMEnvarchar30
5/BIC/B0000181000PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond.58VRKMEnvarchar30
6/BIC/B0000183000PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item90VRKMEnvarchar30
7/BIC/B0000185000PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item96VRKMEnvarchar30
8/BIC/B0000186000PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond.69VRKMEnvarchar30
9CMM_MTM_POMtM per Purchase Order49VRKMESales unitnvarchar30
10CMM_MTM_SOMtM per Sales Order46VRKMESales unitnvarchar30
11J_1ILOCDOCEXIM : Reference Documents for Letter of Credit10VRKMESales unitnvarchar30
12S685ES685 - Strukturinformationen8VRKMEVerkaufsmengeneinheitnvarchar30
13S844ES844 - Strukturinformationen5VRKMEVerkaufsmengeneinheitnvarchar30
14S953ES953 - Strukturinformationen13VRKMEVerkaufsmengeneinheitnvarchar30
15S954ES954 - Strukturinformationen11VRKMEVerkaufsmengeneinheitnvarchar30
16S955ES955 - Strukturinformationen14VRKMEVerkaufsmengeneinheitnvarchar30
17S958ES958 - Structural information14VRKMESales unitnvarchar30
18S989TEST HIERARCHIE13VRKMEUnité de ventenvarchar30
19S989ES989 - Info structurelles6VRKMEUnité de ventenvarchar30
20WB2B_CMM_MTM_TCMtM per Trading Contract56VRKMESales unitnvarchar30
21ZCATT_DEMAND1Input Data for CATT PC_TPVS_TA_DEMAND15VRKMESales unitnvarchar30
22ZCATT_DEMAND1CP1Input Data for CATT PC_TPVS_TA_DEMAND15VRKMESales unitnvarchar30
23ZCATT_DEMAND1CP3Input Data for CATT PC_TPVS_TA_DEMAND15VRKMESales unitnvarchar30
24ZCATT_DEMAND1PMPInput Data for CATT PC_TPVS_TA_DEMAND15VRKMESales unitnvarchar30
25ZCATT_DEMANDTP41Input Data for CATT PC_TPVS_TA_DEMAND17VRKMESales unitnvarchar30
26ZCATT_DEMANDVSWMInput Data for CATT PC_TPVS_TA_DEMAND15VRKMESales unitnvarchar30
27ZCATT_DEM_LSP1Input Data for CATT PC_TPVS_TA_DEMAND15VRKMESales unitnvarchar30
28ZCATT_SCEM_ICE01Input Data for CATT PC_TPVS_TA_DEMAND15VRKMESales unitnvarchar30
29ZCATT_VMI_STKSLSInput Data for CATT PC_TPVS_TA_DEMAND19VRKMESales unitnvarchar30
30ZCAT_RACE_CTM_01Input Data for CATT PC_TPVS_TA_DEMAND15VRKMESales unitnvarchar30
31ZCMM_MTM_01MtM Persistency per Transaction56VRKMESales unitnvarchar30
32ZCMM_MTM_TCMtM per TC55VRKMESales unitnvarchar30
33ZEIM_LIPSSD document: Delivery: Item data19VRKMESales unitnvarchar30
34ZEIM_VBAPSales Document: Item Data53VRKMESales unitnvarchar30
35ZEIM_VBEPSales Document: Schedule Line Data11VRKMESales unitnvarchar30
TOPAccounting Interface
36GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)256VRKMESales unitnvarchar30
37GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)256VRKMESales unitnvarchar30
TOPAdvertising Management
38JHTFPIS-M/AM: Billing/Settlement Documents - Item65VRKMESales unitnvarchar30
TOPAllocation
39AUFIAllocation Table, Document Sub-item, Stores49VRKMESales unitnvarchar30
40AUKAIWorklist for Sales Orders (FBG)10VRKMESales unitnvarchar30
41AULWDelivery Phases17VRKMESales unitnvarchar30
42AUVDIWorklist for Deliveries (Follow-on Doc. Generation)41VRKMESales unitnvarchar30
43AUVWDelivery Phase for Distribution Center16VRKMESales unitnvarchar30
44AUVZDistribution Center24VRKMESales unitnvarchar30
TOPAssortment Maintenance
45WLK1Listing Conditions SAP Retail Assortments4VRKMESales unitnvarchar30
46WLK11Listing Conditions SAP Retail / Folder per Distrib. Chain5VRKMESales unitnvarchar30
TOPBasic Functions
47VBFASales Document Flow32VRKMESales unitnvarchar30
TOPBasis Components
48ZDS400_VBEPTabelle für Beispielprogramm des ZDS4009VRKMEVerkaufsmengeneinheitnvarchar30
49ZSALES_ORD_ITEMSales Order Item(IDES Demo)11VRKMESales unitnvarchar30
TOPBilling
50VBRPBilling Document: Item Data6VRKMESales unitnvarchar30
TOPConditions
51A071Material per Plant8VRKMESales unitnvarchar30
52A073Material per SOrg/DstCh7VRKMESales unitnvarchar30
53KONDNConditions: Free goods - Data section37VRKMESales unitnvarchar30
TOPCosting
54COERSales Order Value Revenue77VRKMESales unitnvarchar30
TOPCross-Application Components
55VVBAPSales Document: Item Data53VRKMESales unitnvarchar30
56VVBEPSales Document: Schedule Line Data11VRKMESales unitnvarchar30
57VVBFASales Document Flow32VRKMESales unitnvarchar30
TOPData Collection
58S008Communications Table SD -> CO/Projects80VRKMESales unitnvarchar30
59S117Receipt/article20VRKMESales unitnvarchar30
60S117ES117 - Structural Information13VRKMESales unitnvarchar30
61S119Transaction Number (Till Receipt)18VRKMESales unitnvarchar30
62S119ES119 - Structural Information11VRKMESales unitnvarchar30
63S120Sales as per receipts19VRKMESales unitnvarchar30
64S120BIW1S120BIW1 * Sales as Per Receipts19VRKMESales unitnvarchar30
65S120BIW2S120BIW2 * Sales as Per Receipts19VRKMESales unitnvarchar30
66S120ES120 - Structural Information12VRKMESales unitnvarchar30
67S260SD - Sales order73VRKMESales unitnvarchar30
68S260BIW1SD - Sales order73VRKMESales unitnvarchar30
69S260BIW2SD - Sales order73VRKMESales unitnvarchar30
70S261SD - Delivery note37VRKMESales unitnvarchar30
71S261BIW1SD - Delivery note37VRKMESales unitnvarchar30
72S261BIW2SD - Delivery note37VRKMESales unitnvarchar30
73S262SD - Billing document31VRKMESales unitnvarchar30
74S262BIW1SD - Billing document31VRKMESales unitnvarchar30
75S262BIW2SD - Billing document31VRKMESales unitnvarchar30
76S263SD - Sales order/delivery note58VRKMESales unitnvarchar30
77S263BIW1SD - Sales order/delivery note58VRKMESales unitnvarchar30
78S263BIW2SD - Sales order/delivery note58VRKMESales unitnvarchar30
79S264SD- Offer75VRKMESales unitnvarchar30
80S264BIW1S264BIW1 * SD - Quotation75VRKMESales unitnvarchar30
81S264BIW2S264BIW2 * SD - Quotation75VRKMESales unitnvarchar30
82S272Do not use!17VRKMESales unitnvarchar30
83S272BIW1Do not use!17VRKMESales unitnvarchar30
84S272BIW2Do not use!17VRKMESales unitnvarchar30
85S272ES272 - Structural Information10VRKMESales unitnvarchar30
86S273Do not use!15VRKMESales unitnvarchar30
87S273BIW1Do not use!15VRKMESales unitnvarchar30
88S273BIW2Do not use!15VRKMESales unitnvarchar30
89S273ES273 - Structure information8VRKMESales unitnvarchar30
90S276Transfer BW: Vertriebsdaten16VRKMEVerkoophoeveelheidseenheidnvarchar30
91S276BIW1S276BIW1 * Transfer to BW: Sales and Distribution Data16VRKMESales unitnvarchar30
92S276BIW2S276BIW2 * BW Transfer: Sales and Distribution Data16VRKMESales unitnvarchar30
93S277Transfer BW: VP-Umbewertung15VRKMEVerkoophoeveelheidseenheidnvarchar30
94S277BIW1S277BIW1 * Transfer to BW: Revaluation at Retail15VRKMESales unitnvarchar30
95S277BIW2S277BIW2 * Transfer to BW: Revaluation at Retail15VRKMESales unitnvarchar30
96S409Contract & Billing13VRKMESales unitnvarchar30
97S409ES409 - Structure Information8VRKMESales unitnvarchar30
98S685MAP IRT35015VRKMEVerkaufsmengeneinheitnvarchar30
99S844RIS/ABC: VerrAnteile Beschaffg12VRKME????????? ??nvarchar30
100S953BW Vorl.für BON/Artikel S11720VRKMEVerkaufsmengeneinheitnvarchar30
101S954BW Vorl.für BON S11918VRKMEVerkaufsmengeneinheitnvarchar30
102S955Istdatenspeicher MAP - BW21VRKMEVerkaufsmengeneinheitnvarchar30
103S958Reference Structure for Generating Info Structures21VRKMESales unitnvarchar30
TOPData Retention Tool
104TXW_S_LIPSRetrieve LIPS from archive17VRKMESales unitnvarchar30
105TXW_S_VBAPRetrieve VBAP from archive13VRKMESales unitnvarchar30
106TXW_S_VBRPRetrieve VBRP from archive34VRKMESales Unit of Measurenvarchar30
TOPDownstream
107S414BIW1S414BIW1 * SSR DTF statistics19VRKMESales unitnvarchar30
108S414BIW2S414BIW2 * SSR DTF statistics19VRKMESales unitnvarchar30
TOPEmpties Management
109/BEV1/EMLGBWDPEmpties Movement Account Customer21VRKMESales unitnvarchar30
TOPExchanges
110OIA11Exchange assignment for deliveries9VRKMESales unitnvarchar30
TOPFinancial Accounting
111/CCEE/SIFIPE7Pro forma invoice for temporary export of goods12VRKMESales unitnvarchar30
TOPFree Goods
112KOTN201Sales Org./Distr.Channel/Bonus Buy/Material/Sales Unit8VRKMESales unitnvarchar30
113KOTN202SalesOrg./SalesChan/PriceList/BonusBuy/Material/SalesUnit9VRKMESales unitnvarchar30
114KOTN203SalesOrg./SalesChan/Plant/BonusBuy/Material/SalesUnit9VRKMESales unitnvarchar30
TOPGeneral Ledger Accounting
115FAGL_SPLINFOSplittling Information of Open Items63VRKMESales unitnvarchar30
TOPIncentive and Commission Management ICM
116YCRM01_B_VAR_OBJVariants for Commission Case Object Data7VRKMESales unitnvarchar30
117YCRM01_DOCRECommission Document, Remuneration and Liability23VRKMESales unitnvarchar30
118YCRM01_DOCVACommission Document, Valuation18VRKMESales unitnvarchar30
119YCRM01_OBJCommission Case Object Data45VRKMESales unitnvarchar30
TOPIntegration
120FKK_VBRP_SHORTItem Data for SD Billing Document - Extracts30VRKMESales Unit of Measurenvarchar30
TOPInventory Management
121ORIG_PR_MBEWSales Price Origin of Last Total Revaluation at Retail13VRKMESales unitnvarchar30
122USEGRetail Revaluation Document: Revaluation Segment19VRKMESales unitnvarchar30
TOPLocalization
123J_1AOUMDefine Official unit of measure3VRKMESales unitnvarchar30
124J_3RSCCDITEMCargo Customs Declaration Item25VRKMESales unitnvarchar30
125J_3RSCCDSUBITMCargo Customs Declaration Subitems7VRKMESales unitnvarchar30
TOPLogistics - General
126WBHETrading Contract: Schedule Lines10VRKMESales unitnvarchar30
127WBHITrading Contract: Item Data9VRKMESales unitnvarchar30
TOPMarketing, Accounting and Pricing
128OICPLCustomer price list6VRKMESales unitnvarchar30
TOPMaterial Master
129MVKESales Data for Material17VRKMESales unitnvarchar30
130MVKE_TMPFile for Incorrect Data in Direct Input20VRKMESales unitnvarchar30
131MVVESales Data for Material17VRKMESales unitnvarchar30
TOPMedia Product Sales and Distribution
132JKSDORDERINDEXIndex Table for IS-M Orders29VRKMESales unitnvarchar30
133S485IS-M: Sales Figures17VRKMESales unitnvarchar30
134S485ES485 - Structure Information10VRKMESales unitnvarchar30
135S487IS-M: Delivery Figures17VRKMESales unitnvarchar30
136S487ES487 - Structure Information10VRKMESales unitnvarchar30
137S488Return Quantity Check19VRKMESales unitnvarchar30
138S488ES488 - Structure Information12VRKMESales unitnvarchar30
TOPMerchandise and Assortment Planning
139S216MAP: Average Retail WOC16VRKMESales unitnvarchar30
140S216ES216 - Structural Information9VRKMESales unitnvarchar30
141S217MAP: AvgRetail MON16VRKMESales unitnvarchar30
142S217ES217 - Structural Information9VRKMESales unitnvarchar30
143S218MAP: AvgRetail BUP16VRKMESales unitnvarchar30
144S218ES218 - Structural Information9VRKMESales unitnvarchar30
TOPPatient Accounting
145NVBRPIS-H: Billing document item data5VRKMESales unitnvarchar30
TOPPeriodical Sales and Distribution
146JFRPIS-M/SD: Billing Document - Item Data5VRKMESales unitnvarchar30
TOPPrice Planning Workbench
147WRF_PPW_PPDARTPPD Material Item9VRKMESales unitnvarchar30
TOPProfitability Analysis
148CEERRORCO-PA: Incorrect records from SD20VRKMESales unitnvarchar30
TOPPromotion
149WMFPMarkdown Planning - item data (materials)5VRKMESales unitnvarchar30
150WMFUMarkdown planning - price phases per material/un5VRKMESales unitnvarchar30
TOPPurchasing
151WDFR1Requirements Planning for Perishables26VRKMESales unitnvarchar30
152WDFR_POSPerishables Planninng Item99VRKMESales unitnvarchar30
TOPRecycling Administration Core Functions
153J_7LBDCMSGREA Conditions: Error Messages BDC Condition Adjustment11VRKMESales unitnvarchar30
154J_7LL01REA: Lock Management for Accruals Corrections5VRKMESales unitnvarchar30
155J_7LM03REA Article Master: Sales Units5VRKMESales unitnvarchar30
156J_7LM04REA Article Master: Packaging Assignments5VRKMESales unitnvarchar30
157J_7LM05REA Article Master: Recycling Partner Assignment5VRKMESales unitnvarchar30
158J_7LM06REA Article Master: Bills of Material5VRKMESales unitnvarchar30
159J_7LM09REA Article Master: R.Partner-Depend.Data Assign.Packaging5VRKMESales unitnvarchar30
160J_7LM10REA Article Master: Filters for Regional Processing5VRKMESales unitnvarchar30
161J_7LM11REA Article Master: Declaration Key4VRKMESales unitnvarchar30
162J_7LS990Pseudo Info Structure Similar to S990 for Extern.Data w/o SD16VRKMESales unitnvarchar30
163J_7LV1MREA Document: Quantity Flow on Article Level4VRKMESales unitnvarchar30
164J_7LV1PREA Document: Item Data75VRKMESales unitnvarchar30
165J_7LVBRPOSNON-SD Interface: Billing: Item Data6VRKMESales unitnvarchar30
TOPRemaining Beverage - Obsolete Objects
166/BEV1/CLCONT1Container Information20VRKMEUnit of Measure from Ordernvarchar30
167/BEV1/RBVBAPSales Document: Item Data53VRKMESales unitnvarchar30
168/BEV1/REWARTRental Items: Delivery Schedule Items15VRKMESales unitnvarchar30
169/BEV1/RSCOERFCOCIS: Check-Out Entry8VRKMESales unitnvarchar30
170/BEV1/RSFFRCHGeneral Information About Collection8VRKMESales unitnvarchar30
TOPRetail Pricing
171A152Sales Org./Dist. Channel/Plant/Material/Sales Unit/Customer8VRKMESales unitnvarchar30
172A153Sales Org./Distribution Channel/Plant/Sales Unit/Customer7VRKMESales unitnvarchar30
173A154SalesOrg./Dist.Channel/PriceList/Material/SalesUnit/Customer8VRKMESales unitnvarchar30
174A155Sales Org./Dist. Channel/Price List/Material/Sales Unit8VRKMESales unitnvarchar30
175WELPCompetitor: Price Entry Document (Item)17VRKMESales unitnvarchar30
176WKBPPricing document: item16VRKMESales unitnvarchar30
177WPFAMFamily Pricing: Definition of Families4VRKMESales Unitnvarchar30
178WPFGAFamily Pricing: Assignment of Articles to Family Groups5VRKMESales Unitnvarchar30
179WPFGRFamily Pricing: Defintion of Family Groups5VRKMESales Unitnvarchar30
180WWKPMarket-Basket Pricing Document: Item6VRKMESales unitnvarchar30
TOPSales
181SLS_TMPL_ITEMSales: Template Item10VRKMESales unitnvarchar30
182VBAPSales Document: Item Data53VRKMESales unitnvarchar30
183VBEPSales Document: Schedule Line Data11VRKMESales unitnvarchar30
TOPSales Returns
184/BEV1/SRRUE02Sales Returns12VRKMESales unitnvarchar30
TOPService Station Retailing
185OIRADBTDocument base table22VRKMESales unitnvarchar30
186OIRC_FUELS_PRSSR - Processing profile48VRKMESales unitnvarchar30
187OIREUPLPXXXXSSR PC: DTF table for item information8VRKMESales unitnvarchar30
188S412SSR Margin Report14VRKMESales unitnvarchar30
189S412ES412 - Structural information7VRKMESales unitnvarchar30
190S413SSR - Monthly/Daily Loc.Inv.13VRKMESales unitnvarchar30
191S413ES413 - Structural information6VRKMESales unitnvarchar30
192S414SSR DTF statistics19VRKMESales unitnvarchar30
193S414ES414 - Structural information12VRKMESales unitnvarchar30
TOPShipping
194DVK02R/2-R/3 Link: Delivery Item Data R2 -> R316VRKMESales unitnvarchar30
195DVM01R/2-R/3 Link: R/3 Input Data for Material Master19VRKMESales unitnvarchar30
196LIPSSD document: Delivery: Item data19VRKMESales unitnvarchar30
197TVPODSales Document: Delivery: POD Data9VRKMESales unitnvarchar30
TOPSimulation
198VSVBAP_CNVersion: Sales document: Item data54VRKMESales unitnvarchar30
199VSVBEP_CNVersion: Sales document: Schedule line data12VRKMESales unitnvarchar30
TOPSupplier Managed Inventory
200SMI_ITEMSMI Item Data38VRKMESales unitnvarchar30
201SMI_TIMESERIESSMI Time Series10VRKMESales unitnvarchar30
TOPTraders and Schedulers Workbench
202OIJ_EL_DOC_I_REFDocument item reference to nomination8VRKMESales unitnvarchar30
203OIJ_EL_DOC_MOTOil TSW: TSW Relevance of order item6VRKMESales unitnvarchar30
TOPTransportation
204VTFAShipment Document Flow16VRKMESales unitnvarchar30