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

170 columns | Print definition?ERP 6.0  | NETWR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000176000PSA for 2LIS_11_VAHDR T90CLNT090 Sales Doc. Header30NETWRdecimal150
2/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item76NETWRdecimal150
3/BIC/B0000184000PSA for 2LIS_13_VDHDR T90CLNT090 Bill.Doc.Header Data24NETWRdecimal150
4/BIC/B0000185000PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item70NETWRdecimal150
5/BIC/B0000187000PSA for 2LIS_02_ITM T90CLNT090 Purch. Data (Item)54NETWRdecimal130
6IDGT_GTDHGT Document Header9NETWRNet Valuedecimal172
7IDGT_GTDIGT Document Item9NETWRNet Valuedecimal172
8IDGT_MERGE_INFOItem Merge Info6NETWRNet Valuedecimal172
9IDGT_VATHVAT Invoice Header6NETWRNet Valuedecimal172
10IDGT_VATIVAT Invoice Item11NETWRNet Valuedecimal172
11J_1ILOCDOCEXIM : Reference Documents for Letter of Credit7NETWRNet Value in Document Currencydecimal152
12J_3RFGTD_ITEMImport Customs Declaration Items27NETWRInvoice Costdecimal152
13S870BIW1S870BIW1 * Reference Structure for Generating Info Structure21NETWREffective order valuedecimal152
14S870BIW2S870BIW2 * Reference Structure for Generating Info Structure21NETWREffective order valuedecimal152
15ZEIM_LIPSSD document: Delivery: Item data169NETWRNet Value in Document Currencydecimal152
16ZEIM_VBAKSales Document: Header Data17NETWRNet Value of the Sales Order in Document Currencydecimal152
17ZEIM_VBAPSales Document: Item Data44NETWRNet value of the order item in document currencydecimal152
TOPAgency Business Global Trade
18WBRKAgency business: Header43NETWRAgency Business: Net value in document currencydecimal152
19WBRLAgency business: Item in document list5NETWRAgency business: New value of item in a listdecimal152
20WBRPAgency business: Item27NETWRNet value of the item in document currencydecimal152
21WLFD_IVRHDRAgency Bus.: DB table for Invoice Request Header9NETWRAgency Business: Net value in document currencydecimal152
22WLFD_IVRITMAgency Bus.: DB table for Invoice Request Item9NETWRNet value of the item in document currencydecimal152
TOPBasic Functions
23FPLTBilling Plan: Dates37NETWRNet value of the order item in document currencydecimal152
24FPLTPOBilling Plan: Dates37NETWRNet value of the order item in document currencydecimal152
25VFPLTBilling Plan: Dates37NETWRNet value of the order item in document currencydecimal152
TOPBasis Components
26ZSALES_ORD_ITEMSales Order Item(IDES Demo)8NETWRNet value of the order item in document currencydecimal152
TOPBilling
27VBRKBilling Document: Header Data46NETWRNet Value in Document Currencydecimal152
28VBRLSales Document: Invoice List5NETWRNet Value in Document Currencydecimal152
29VBRPBilling Document: Item Data22NETWRNet value of the billing item in document currencydecimal152
TOPChargeback
30WB2_D_BUSVOLRebates: Business Volume9NETWRNet Value in Document Currencydecimal152
TOPContract Accounts Receivable and Payable
31FKK_JFRK_SHORTHeader Data for IS-M/SD Billing Document - Extracts19NETWRValue of invoicenvarchar160
32FKK_JFRP_SHORTItem Data for IS-M/SD Billing Document - Extracts15NETWRIS-M/SD: Net Value of Item in Document Currencynvarchar170
33FKK_JLRK_SHORTHeader Data for IS-M/SD Service Settlement - Extracts17NETWRValue of invoicenvarchar160
34FKK_JLRPCM_SHORTItem Data for IS-M/SD Commission Settlement - Extracts12NETWRIS-M/SD: Net Value of Item in Document Currencynvarchar170
35FKK_JLRPHD_SHORTItem Data for IS-M/SD Home Delivery Settlement - Extracts8NETWRIS-M/SD: Net Value of Item in Document Currencynvarchar170
TOPContract Handling
36S462IS-BEV-CH: Sales in BUn21NETWRNet value of the billing item in document currencydecimal152
37S463IS-BEV-CH: Sales in Stat. UoM21NETWRNet value of the billing item in document currencydecimal152
TOPCross-Application Components
38VVBAKSales Document: Header Data17NETWRNet Value of the Sales Order in Document Currencydecimal152
39VVBAPSales Document: Item Data44NETWRNet value of the order item in document currencydecimal152
TOPData Collection
40S011PURCHIS: Purchasing Group Statistics14NETWREffective order valuedecimal152
41S011BIW1S011BIW1 * PURCHIS: Purchasing Group Statistics14NETWREffective order valuedecimal152
42S011BIW2S011BIW2 * PURCHIS: Purchasing Group Statistics14NETWREffective order valuedecimal152
43S012Purchasing25NETWREffective order valuedecimal152
44S012BIW1S012BIW1 * Purchasing25NETWREffective order valuedecimal152
45S012BIW2S012BIW2 * Purchasing25NETWREffective order valuedecimal152
46S260SD - Sales order90NETWRNet value of the order item in document currencydecimal152
47S260BIW1SD - Sales order90NETWRNet value of the order item in document currencydecimal152
48S260BIW2SD - Sales order90NETWRNet value of the order item in document currencydecimal152
49S262SD - Billing document85NETWRNet value of the billing item in document currencydecimal152
50S262BIW1SD - Billing document85NETWRNet value of the billing item in document currencydecimal152
51S262BIW2SD - Billing document85NETWRNet value of the billing item in document currencydecimal152
52S264SD- Offer93NETWRNet value of the order item in document currencydecimal152
53S264BIW1S264BIW1 * SD - Quotation93NETWRNet value of the order item in document currencydecimal152
54S264BIW2S264BIW2 * SD - Quotation93NETWRNet value of the order item in document currencydecimal152
55S270Do not use!27NETWRNet order value in order currencydecimal132
56S270BIW1Do not use!27NETWRNet order value in order currencydecimal132
57S270BIW2Do not use!27NETWRNet order value in order currencydecimal132
58S272Do not use!34NETWRNet value of the billing item in document currencydecimal152
59S272BIW1Do not use!34NETWRNet value of the billing item in document currencydecimal152
60S272BIW2Do not use!34NETWRNet value of the billing item in document currencydecimal152
61S850BW220: Connecting LIS-IS to BW21NETWREffective order valuedecimal152
62S851Reference Structure for Generating Info Structures21NETWREffective order valuedecimal152
63S852Reference Structure for Generating Info Structures21NETWREffective order valuedecimal152
64S853Reference Structure for Generating Info Structures21NETWREffective order valuedecimal152
65S854Reference Structure for Generating Info Structures21NETWREffective order valuedecimal152
66S855Reference Structure for Generating Info Structures21NETWREffective order valuedecimal152
67S856Reference Structure for Generating Info Structures21NETWREffective order valuedecimal152
68S857Reference Structure for Generating Info Structures21NETWREffective order valuedecimal152
69S858Reference Structure for Generating Info Structures21NETWREffective order valuedecimal152
70S859Reference Structure for Generating Info Structures21NETWREffective order valuedecimal152
71S860Reference Structure for Generating Info Structures21NETWREffective order valuedecimal152
72S861Reference Structure for Generating Info Structures21NETWREffective order valuedecimal152
73S862Reference Structure for Generating Info Structures21NETWREffective order valuedecimal152
74S863Reference Structure for Generating Info Structures21NETWREffective order valuedecimal152
75S864Reference Structure for Generating Info Structures21NETWREffective order valuedecimal152
76S865Reference Structure for Generating Info Structures21NETWREffective order valuedecimal152
77S866Reference Structure for Generating Info Structures21NETWREffective order valuedecimal152
78S867Reference Structure for Generating Info Structures21NETWREffective order valuedecimal152
79S868Reference Structure for Generating Info Structures21NETWREffective order valuedecimal152
80S869Reference Structure for Generating Info Structures21NETWREffective order valuedecimal152
81S870Reference Structure for Generating Info Structures21NETWREffective order valuedecimal152
82S913LIS: Purchasing (cons. Planng)20NETWREffective order valuedecimal152
83S930BW220: Connect LIS-IS to BW(2)21NETWREffective order valuedecimal152
84S931BW220: Connect LIS-IS to BW(2)21NETWREffective order valuedecimal152
85S932BW220: Connect LIS-IS to BW(2)21NETWREffective order valuedecimal152
86S933BW220: Connect LIS-IS to BW(2)21NETWREffective order valuedecimal152
87S934BW220: Connect LIS-IS to BW(2)21NETWREffective order valuedecimal152
88S935BW220: Connect LIS-IS to BW(2)21NETWREffective order valuedecimal152
89S936BW220: Connect LIS-IS to BW(2)21NETWREffective order valuedecimal152
90S937BW220: Connect LIS-IS to BW(2)21NETWREffective order valuedecimal152
91S938BW220: Connect LIS-IS to BW(2)21NETWREffective order valuedecimal152
92S939BW220: Connect LIS-IS to BW(2)21NETWREffective order valuedecimal152
93S940BW220: Connect LIS-IS to BW(2)21NETWREffective order valuedecimal152
94S941BW220: Connect LIS-IS to BW(2)21NETWREffective order valuedecimal152
95S942BW220: Connect LIS-IS to BW(2)21NETWREffective order valuedecimal152
96S943BW220: Connect LIS-IS to BW(2)21NETWREffective order valuedecimal152
97S944BW220: Connect LIS-IS to BW(2)21NETWREffective order valuedecimal152
98S945BW220: Connect LIS-IS to BW(2)21NETWREffective order valuedecimal152
99S946BW220: Connect LIS-IS to BW(2)21NETWREffective order valuedecimal152
100S947BW220: Connect LIS-IS to BW(2)21NETWREffective order valuedecimal152
101S948BW220: Connect LIS-IS to BW(2)21NETWREffective order valuedecimal152
102S949BW220: Connect LIS-IS to BW(2)21NETWREffective order valuedecimal152
TOPData Retention Tool
103TXW_S_EKPORetrieve EKPO from archive21NETWRPurchase order net valuenvarchar160
104TXW_S_VBAPRetrieve VBAP from archive16NETWRNet value of the order item in document currencynvarchar160
105TXW_S_VBRKRetrieve VBRK from archive23NETWRValue of invoicenvarchar160
106TXW_S_VBRPRetrieve VBRP from archive29NETWRNet value of the billing item in document currencynvarchar170
TOPExternal Services
107ESKLAccount Assignment Specification: Service Line10NETWRNet Value of Itemdecimal112
108ESKNAccount Assignment in Service Package9NETWRAccount Assignment Valuedecimal112
109ESLLLines of Service Package23NETWRNet Value of Itemdecimal112
110ESSRService Entry Sheet Header Data39NETWRNet Value of Entry Sheetdecimal112
111TMP_SPECModel Service Specifications21NETWRNet Value in Document Currencydecimal152
TOPFinancial Accounting
112/CCEE/SIFIPE7Pro forma invoice for temporary export of goods9NETWRNet value of the billing item in document currencydecimal152
TOPFreight Processing
113VFKNAccount Determination in Shipment Costs Item8NETWRNet value in currency of shipment cost itemdecimal152
114VFKPShipment Costs: Item Data6NETWRNet value in currency of shipment cost itemdecimal152
115VFSIShipment Costs: Sub-item Data9NETWRNet value of sub-item in currency of shipment cost itemdecimal152
TOPIntegration
116FKK_VBRK_SHORTHeader Data for SD Billing Document - Extracts20NETWRValue of invoicenvarchar160
117FKK_VBRP_SHORTItem Data for SD Billing Document - Extracts25NETWRNet value of the billing item in document currencydecimal152
TOPInventory Management
118MWXVM07MFields: Update Control of Module Pool SAPMM07M45NETWRNet order value in document currencydecimal132
119MWZVM07MFields: Update Control of Module Pool SAPMM07M45NETWRNet order value in document currencydecimal132
TOPInvoice Verification
120RBDRSEGBatch IV: Invoice Document Items34NETWRNet order value in document currencydecimal132
121RBEXPersistent Key Figures Header and Item8NETWRNet Value in Document Currencydecimal152
TOPLocalization
122IDGT_INFOGTI China: Data sent to GT33NETWRNet Valuedecimal172
123J_1BNFLINNota Fiscal line items25NETWRNet Valuedecimal152
124J_3RSCCDITEMCargo Customs Declaration Item9NETWRNet Value in Document Currencydecimal112
TOPMarketing Retail Network
125OIFORCPRTransfer customer expected price into sales condition record4NETWRValue expected by customer (item value)nvarchar40
TOPPatient Accounting
126NVBRKIS-H: Billing document header data36NETWRNet Value in Document Currencydecimal152
127NVBRPIS-H: Billing document item data11NETWRNet value of the billing item in document currencydecimal152
TOPPeriodical Sales and Distribution
128JFRKIS-M/SD: Billing - Header Data36NETWRNet Value in Document Currencydecimal152
129JFRPIS-M/SD: Billing Document - Item Data11NETWRNet value of the billing item in document currencydecimal152
130JKAKSales Order Header Data12NETWRNet Value of the Sales Order in Document Currencydecimal152
131JKEPSales Order: Schedule Line Data25NETWRIS-M: Net price in document currencydecimal152
132JLRKIS-M/SD: Settlement Header Data22NETWRNet Value in Document Currencydecimal152
133JLRPIS-M/SD: Item Data for Settlement13NETWRIS-M: Net Value of Settlement Item in Document Currencydecimal152
134JVTZAEM2Sales Order Header Data14NETWRNet Value of the Sales Order in Document Currencydecimal152
TOPProduction and Revenue Accounting
135OIUCM_CONTRACTPRA Contracts12NETWRNet Value of the Sales Order in Document Currencydecimal152
TOPProfitability Analysis
136CEERRORCO-PA: Incorrect records from SD65NETWRNet Value in Document Currencydecimal152
TOPPublic Sector
137PA0752HR Master Record: Infotype 075244NETWRCurrency Keynvarchar50
TOPPurchasing
138EBKNPurchase Requisition Account Assignment53NETWRNet Order Value in PO Currencydecimal132
139EKABRelease Documentation9NETWRNet Order Value in PO Currencydecimal132
140EKKNAccount Assignment in Purchasing Document10NETWRNet Order Value in PO Currencydecimal132
141EKPOPurchasing Document Item27NETWRNet Order Value in PO Currencydecimal132
142EREVVersion in Purchasing19NETWRNet Order Value in PO Currencydecimal132
143WDFR_POSPerishables Planninng Item48NETWRNet Order Value in PO Currencydecimal132
144WRF_PRCT_WL_ITEMOriginal Table for Worklist Items19NETWRNet Order Value in PO Currencydecimal132
145WRF_PRCT_WL_SHDWShadow Table for Worklist Items22NETWRNet Order Value in PO Currencydecimal132
TOPPurchasing Information System
146MCEKSR/2 PURCHIS Data (Status: Last Data Transmission)21NETWRNet purchase order value (base unit)decimal152
TOPRecycling Administration Core Functions
147J_7LV1KREA Document: Header Data29NETWRNet Value in Document Currencydecimal172
148J_7LV1PREA Document: Item Data7NETWRNet Value in Document Currencydecimal172
TOPRemaining Beverage - Obsolete Objects
149/BEV1/RBVBAKSales Document: Header Data17NETWRNet Value of the Sales Order in Document Currencydecimal152
150/BEV1/RBVBAPSales Document: Item Data44NETWRNet value of the order item in document currencydecimal152
151S468IS Beverage EM, Purchasing Information System Empties24NETWRNet purchase order value (base unit)decimal152
TOPSales
152VBAKSales Document: Header Data17NETWRNet Value of the Sales Order in Document Currencydecimal152
153VBAPSales Document: Item Data44NETWRNet value of the order item in document currencydecimal152
154VBPVSales Document: Product Proposal25NETWRNet value of the order item in document currencydecimal152
155VKDFSSD Index: Billing Initiator17NETWRNet Value in Document Currencydecimal152
TOPSAP Healthcare - Industry-Specific Components for Hospitals
156NLVERPRechnungregister-position11NETWRdecimal150
157NWCH80IS-H CH: ELACH Datenempfang; Ablage Nachrichten feldweise29NETWRValore netto nella divisa del documentodecimal152
TOPSelf-Billing Proced.
158VSBDITSelf-Billing Procedure Delivery Item w. Automatic Posting14NETWRNet value of the billing item in document currencydecimal152
159VSBPLGProcessing Log: Self-Billing Procedure w. Autom. Postings20NETWRNet Value in Document Currencydecimal152
TOPSelf-Service Procurement
160/SRMERP/D_ACC_ITAccount assignment item7NETWRNet Order Value in PO Currencydecimal132
161/SRMERP/D_SC_ITMShopping Cart Item30NETWRNet Value in Document Currencydecimal152
TOPShipping
162LIKPSD Document: Delivery Header Data97NETWRNet Value of the Sales Order in Document Currencydecimal152
163LIPSSD document: Delivery: Item data169NETWRNet Value in Document Currencydecimal152
TOPSimulation
164VSEBKN_CNVersion: Purchase requisition account assignment54NETWRNet Order Value in PO Currencydecimal132
165VSFPLT_CNVersion: Billing schedule: Dates38NETWRNet value of the order item in document currencydecimal152
166VSVBAK_CNVersion: Sales document: Header data18NETWRNet Value of the Sales Order in Document Currencydecimal152
167VSVBAP_CNVersion: Sales document: Item data45NETWRNet value of the order item in document currencydecimal152
TOPTraders and Schedulers Workbench
168S431PURCHIS: (OIL-TSW) Purchasing document stats by TSW object22NETWREffective order valuedecimal152
TOPVehicle Management System
169VLCBATCHACTVELO : Variant for Action Execution in Batch68NETWRNet Value of the Sales Order in Document Currencydecimal152
TOPVendor Evaluation
170EVAL_IV_PERS_ITMPersistent Key FIgures with Info About Indicator8NETWRNet order value in document currencydecimal132