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

162 columns | Print definition?ERP 6.0  | WAERK

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000176000PSA for 2LIS_11_VAHDR T90CLNT090 Sales Doc. Header41WAERKnvarchar50
2/BIC/B0000177000PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item59WAERKnvarchar50
3/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item111WAERKnvarchar50
4/BIC/B0000179000PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule94WAERKnvarchar50
5/BIC/B0000180000PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch.68WAERKnvarchar50
6/BIC/B0000181000PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond.59WAERKnvarchar50
7/BIC/B0000184000PSA for 2LIS_13_VDHDR T90CLNT090 Bill.Doc.Header Data32WAERKnvarchar50
8/BIC/B0000185000PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item24WAERKnvarchar50
9/BIC/B0000186000PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond.23WAERKnvarchar50
10A006Price List Type/Currency/Material7WAERKSD Document Currencynvarchar50
11CMM_MTM_POMtM per Purchase Order47WAERKSD Document Currencynvarchar50
12CMM_MTM_SOMtM per Sales Order44WAERKSD Document Currencynvarchar50
13J_1I_LICHDREXIM : License Header24WAERKSD Document Currencynvarchar50
14S953ES953 - Strukturinformationen14WAERKWährung des Vertriebsbelegsnvarchar50
15S954ES954 - Strukturinformationen12WAERKWährung des Vertriebsbelegsnvarchar50
16S955ES955 - Strukturinformationen13WAERKWährung des Vertriebsbelegsnvarchar50
17S958ES958 - Structural information13WAERKSD Document Currencynvarchar50
18WB2B_CMM_MTM_TCMtM per Trading Contract54WAERKSD Document Currencynvarchar50
19ZCMM_MTM_01MtM Persistency per Transaction54WAERKSD Document Currencynvarchar50
20ZCMM_MTM_TCMtM per TC53WAERKSD Document Currencynvarchar50
21ZEIM_VBAKSales Document: Header Data18WAERKSD Document Currencynvarchar50
22ZEIM_VBAPSales Document: Item Data45WAERKSD Document Currencynvarchar50
TOPAdvertising Management
23JHTAKIS-M/AM: Settlement Run Sales Document Header16WAERKIS-M: Collective Processing Currencynvarchar50
24JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header36WAERKSD Document Currencynvarchar50
TOPBasic Functions
25FDS1Cash Management & Forecast: Line Items of SD Documents8WAERKSD Document Currencynvarchar50
TOPBasis Components
26ZSALES_ORD_ITEMSales Order Item(IDES Demo)9WAERKSD Document Currencynvarchar50
TOPBilling
27VBRKBilling Document: Header Data6WAERKSD Document Currencynvarchar50
TOPConditions
28A106Price List/Material Group7WAERKSD Document Currencynvarchar50
29A306Price list category/currency/material with release status7WAERKSD Document Currencynvarchar50
30A504SalesOrg/DistrChannel/Currency/SalesDocType6WAERKSD Document Currencynvarchar50
TOPContract Accounts Receivable and Payable
31FKK_JFRK_SHORTHeader Data for IS-M/SD Billing Document - Extracts7WAERKSD Document Currencynvarchar50
32FKK_JLRK_SHORTHeader Data for IS-M/SD Service Settlement - Extracts7WAERKSD Document Currencynvarchar50
TOPContract Handling
33S462IS-BEV-CH: Sales in BUn19WAERKSD Document Currencynvarchar50
34S462ES462 - Structure Information12WAERKSD Document Currencynvarchar50
35S463IS-BEV-CH: Sales in Stat. UoM19WAERKSD Document Currencynvarchar50
36S463ES463 - Structure Information12WAERKSD Document Currencynvarchar50
TOPCross-Application Components
37VVBAKSales Document: Header Data18WAERKSD Document Currencynvarchar50
38VVBAPSales Document: Item Data45WAERKSD Document Currencynvarchar50
TOPData Collection
39S008Communications Table SD -> CO/Projects91WAERKCurrency Keynvarchar50
40S092Resource Requirements: Material14WAERKSD Document Currencynvarchar50
41S092ES092 - Structural Information7WAERKSD Document Currencynvarchar50
42S117Receipt/article21WAERKSD Document Currencynvarchar50
43S117ES117 - Structural Information14WAERKSD Document Currencynvarchar50
44S119Transaction Number (Till Receipt)19WAERKSD Document Currencynvarchar50
45S119ES119 - Structural Information12WAERKSD Document Currencynvarchar50
46S120Sales as per receipts21WAERKSD Document Currencynvarchar50
47S120BIW1S120BIW1 * Sales as Per Receipts21WAERKSD Document Currencynvarchar50
48S120BIW2S120BIW2 * Sales as Per Receipts21WAERKSD Document Currencynvarchar50
49S120ES120 - Structural Information14WAERKSD Document Currencynvarchar50
50S121Material aggregation - POS16WAERKSD Document Currencynvarchar50
51S121ES121 - Structural Information9WAERKSD Document Currencynvarchar50
52S122Cashier16WAERKSD Document Currencynvarchar50
53S122BIW1S122BIW1 * Cashier16WAERKSD Document Currencynvarchar50
54S122BIW2S122BIW2 * Cashier16WAERKSD Document Currencynvarchar50
55S122ES122 - Structural Information9WAERKSD Document Currencynvarchar50
56S260SD - Sales order13WAERKSD Document Currencynvarchar50
57S260BIW1SD - Sales order13WAERKSD Document Currencynvarchar50
58S260BIW2SD - Sales order13WAERKSD Document Currencynvarchar50
59S262SD - Billing document12WAERKSD Document Currencynvarchar50
60S262BIW1SD - Billing document12WAERKSD Document Currencynvarchar50
61S262BIW2SD - Billing document12WAERKSD Document Currencynvarchar50
62S263SD - Sales order/delivery note13WAERKSD Document Currencynvarchar50
63S263BIW1SD - Sales order/delivery note13WAERKSD Document Currencynvarchar50
64S263BIW2SD - Sales order/delivery note13WAERKSD Document Currencynvarchar50
65S264SD- Offer13WAERKSD Document Currencynvarchar50
66S264BIW1S264BIW1 * SD - Quotation13WAERKSD Document Currencynvarchar50
67S264BIW2S264BIW2 * SD - Quotation13WAERKSD Document Currencynvarchar50
68S272Do not use!19WAERKSD Document Currencynvarchar50
69S272BIW1Do not use!19WAERKSD Document Currencynvarchar50
70S272BIW2Do not use!19WAERKSD Document Currencynvarchar50
71S272ES272 - Structural Information12WAERKSD Document Currencynvarchar50
72S276Transfer BW: Vertriebsdaten17WAERKValuta van verkoopdocumentnvarchar50
73S276BIW1S276BIW1 * Transfer to BW: Sales and Distribution Data17WAERKSD Document Currencynvarchar50
74S276BIW2S276BIW2 * BW Transfer: Sales and Distribution Data17WAERKSD Document Currencynvarchar50
75S953BW Vorl.für BON/Artikel S11721WAERKWährung des Vertriebsbelegsnvarchar50
76S954BW Vorl.für BON S11919WAERKWährung des Vertriebsbelegsnvarchar50
77S955Istdatenspeicher MAP - BW20WAERKWährung des Vertriebsbelegsnvarchar50
78S958Reference Structure for Generating Info Structures20WAERKSD Document Currencynvarchar50
TOPData Retention Tool
79TXW_S_LIKPRetrieve LIKP from archive11WAERKSD Document Currencynvarchar50
80TXW_S_VBAPRetrieve VBAP from archive21WAERKSD Document Currencynvarchar50
81TXW_S_VBRKRetrieve VBRK from archive10WAERKSD Document Currencynvarchar50
TOPDistributor-Reseller-Management
82S490CEM Settlement14WAERKSD Document Currencynvarchar50
83S490ES490 - Structure Information7WAERKSD Document Currencynvarchar50
TOPDSD Connector
84/DSD/ME_PRO_FBAMMDSD Promotions - Feedback Amounts in Connector9WAERKSD Document Currencynvarchar50
TOPFinancial Accounting
85/CCEE/SIFIPE7Pro forma invoice for temporary export of goods10WAERKSD Document Currencynvarchar50
86UKSDUser Control Totals (Online)13WAERKCurrency Keynvarchar50
TOPHandheld Connectivity
87/DSD/PR_FBAMMDSD Promotions - Feedback Amounts13WAERKSD Document Currencynvarchar50
TOPInformation System
88S135Value contract, target/release order value12WAERKSD Document Currencynvarchar50
TOPIntegration
89FKK_VBRK_SHORTHeader Data for SD Billing Document - Extracts7WAERKSD Document Currencynvarchar50
TOPLocalization
90J_1BNFDOCNota Fiscal Header25WAERKSD Document Currencynvarchar50
TOPPatient Accounting
91NFAGIS-H: Case accrual8WAERKSD Document Currencynvarchar50
92NVBRKIS-H: Billing document header data7WAERKSD Document Currencynvarchar50
TOPPendulum List Indirect Sales
93S474Pendulum List - Confirmation19WAERKSD Document Currencynvarchar50
94S474ES474 - Structure Information12WAERKSD Document Currencynvarchar50
TOPPeriodical Sales and Distribution
95JFGBZPIS-M/SD: Minimum/Maximum Amounts for Payment Program4WAERKSD Document Currencynvarchar50
96JFLIABACCREVERSEIS-M/SD: Revenue Log for Reversal of Liability Acct Transfer11WAERKSD Document Currencynvarchar50
97JFREVACCIS-M/SD: Pl.Cir.f.Rev. - Revenue per Liab.Acct + G/L Account10WAERKSD Document Currencynvarchar50
98JFREVLIABACCIS-M/SD: Accr.Table for Rev.Dist.w/Liab.Acct for Transfer10WAERKSD Document Currencynvarchar50
99JFREVLIABACC_REVIS-M/SD: Reverse Revenue Dist. w/Liability Acct for Trans.13WAERKSD Document Currencynvarchar50
100JFREVPERIS-M/SD: Accrual Table for Period-Related Revenue Dist.10WAERKSD Document Currencynvarchar50
101JFREVPER_REVERSEIS-M/SD: Reverse Period-Related Revenue Distribution13WAERKSD Document Currencynvarchar50
102JFREVVAIS-M/SD: Accr.Table for Issue-Rel.Revenue Dist.w/o Liab.Acct10WAERKSD Document Currencynvarchar50
103JFREVVAACCIS-M/SD: Accr.Table for Issue-Related Rev.Dist.w/Liab.Acct10WAERKSD Document Currencynvarchar50
104JFREVVAACC_REVERIS-M/SD: Reverse Issue-Related Revenue Dist. w/Liab. Account13WAERKSD Document Currencynvarchar50
105JFREVVA_REVERSEIS-M/SD: Reverse Issue-Related Revenue Dist. w/o Liab. Acct13WAERKSD Document Currencynvarchar50
106JFRKIS-M/SD: Billing - Header Data5WAERKSD Document Currencynvarchar50
107JFTXIS-M/SD: Period Grid for VAT Accrual6WAERKSD Document Currencynvarchar50
108JFVAIS-M/SD: Accrual Table Revenue Distribution at Issue Level12WAERKSD Document Currencynvarchar50
109JFXJFTXDLIS-M: Backup Transfer Internal Table XJFTX8WAERKSD Document Currencynvarchar50
110JFXJFVADLIS-M: Backup Transfer Internal Table XJFVA14WAERKSD Document Currencynvarchar50
111JKACCADDIS-M/SD: Additional Payments for Renewal Cycle8WAERKSD Document Currencynvarchar50
112JKACCADDTIS-M/SD: Template Data for Add. Payments for Renewal Cycle6WAERKSD Document Currencynvarchar50
113JKACCOUNTIS-M/SD: Liability Account for Subscription15WAERKSD Document Currencynvarchar50
114JKACCOUNT_GOLIVEIS-M/SD: Shadow Table for JKACCOUNT After Data Transfer14WAERKSD Document Currencynvarchar50
115JKAKSales Order Header Data11WAERKSD Document Currencynvarchar50
116JKWWWTEMP_COMPLIS-M/SD: Temporary Table for Complaints in Internet15WAERKSD Document Currencynvarchar50
117JLRKIS-M/SD: Settlement Header Data4WAERKSD Document Currencynvarchar50
118JLSKIS-M/SD: Header for Settlement in Collective Processing18WAERKSD Document Currencynvarchar50
119JLSSIS-M/SD: Settlements in Collective Processing6WAERKSD Document Currencynvarchar50
120JNTRECHIS-M/SD: Research35WAERKSD Document Currencynvarchar50
121JVTZAEM2Sales Order Header Data13WAERKSD Document Currencynvarchar50
122TJK14IS-M/SD: Lock Limit - Release for Returns/Complaint7WAERKSD Document Currencynvarchar50
TOPPricing
123PRCD_HEADPrice Condition Set (Header)7WAERKDocument Currency of Price Determinationnvarchar50
TOPProduction and Revenue Accounting
124OIUCM_CONTRACTPRA Contracts13WAERKSD Document Currencynvarchar50
TOPProfitability Analysis
125CEERRORCO-PA: Incorrect records from SD24WAERKCurrency Keynvarchar50
TOPRecycling Administration Core Functions
126J_7LV1KREA Document: Header Data28WAERKSD Document Currencynvarchar50
127J_7LVBRKNON-SD Interface: Billing: Header Data6WAERKSD Document Currencynvarchar50
TOPRemaining Beverage - Obsolete Objects
128/BEV1/RBVBAKSales Document: Header Data18WAERKSD Document Currencynvarchar50
129/BEV1/RBVBAPSales Document: Item Data45WAERKSD Document Currencynvarchar50
130/BEV3/CHBKERGRSLPurchase control results25WAERKCurrency indicatornvarchar50
131/BEV3/CHBKRESHISPurchase Control Results - History25WAERKCurrency indicatornvarchar50
132/BEV3/CHBKRESULTPurchase control results25WAERKCurrency indicatornvarchar50
133/BEV3/CHBKTMPTemp. Purchase Control Results25WAERKCurrency indicatornvarchar50
134/BEV3/CHBWAERAgreement Currency7WAERKCurrency indicatornvarchar50
135/BEV3/CHKACNTRCTCustomer Evaluation Table: Contract33WAERKCurrency indicatornvarchar50
136/BEV3/CHKAOBLIGACustomer Evaluation Table: Contract Performances20WAERKCurrency indicatornvarchar50
137/BEV3/CHKATERMINCustomer Evaluation Table: Dates General54WAERKCurrency indicatornvarchar50
138/BEV3/CHKATMABUMCustomer Evaluation Table: Sales per Date25WAERKCurrency indicatornvarchar50
139/BEV3/CHKA_SALDOCustomer Evaluation Table: Balances from FI Ledger4WAERKCurrency indicatornvarchar50
140/BEV3/CHLERFExternal Amount: Performances Entered10WAERKCurrencynvarchar50
141/BEV3/CHRGBTRGAmount Rule10WAERKCurrency indicatornvarchar50
142/BEV3/CHRGWAERKCurrency Code Rule10WAERKCurrency indicatornvarchar50
TOPRetail Pricing
143TWEGOSales Price Calculation: Assignment of price point group6WAERKPrice point currencynvarchar50
144TWKAOSales Price Calculation: Assignment of pricing type5WAERKSD Document Currencynvarchar50
TOPRevenue recognition
145VBREVACRevenue Recognition: Compression of FI Revenue Postings13WAERKCurrency Keynvarchar50
146VBREVERevenue Recognition: Revenue Recognition Lines11WAERKCurrency Keynvarchar50
147VBREVKRevenue Recognition: Control Lines9WAERKCurrency Keynvarchar50
148VBREVRRevenue Recognition: Reference Document Lines12WAERKCurrency Keynvarchar50
TOPSales
149VBAKSales Document: Header Data18WAERKSD Document Currencynvarchar50
150VBAPSales Document: Item Data45WAERKSD Document Currencynvarchar50
151VBPVSales Document: Product Proposal26WAERKSD Document Currencynvarchar50
152VKDFSSD Index: Billing Initiator18WAERKSD Document Currencynvarchar50
TOPSAP Media
153J_1SMWSBTRIS-M/SD CH/F: VAT Amounts for VAT Deduction by Agreement4WAERKSD Document Currencynvarchar50
154J_1SMWSNWSIS-M/SD CH/F: VAT Statement for VAT Deduction by Agreement4WAERKSD Document Currencynvarchar50
TOPService Station Retailing
155S412SSR Margin Report31WAERKSD Document Currencynvarchar50
156S413SSR - Monthly/Daily Loc.Inv.26WAERKSD Document Currencynvarchar50
TOPShipping
157LIKPSD Document: Delivery Header Data53WAERKSD Document Currencynvarchar50
TOPSimulation
158VSVBAK_CNVersion: Sales document: Header data19WAERKSD Document Currencynvarchar50
159VSVBAP_CNVersion: Sales document: Item data46WAERKSD Document Currencynvarchar50
TOPUnique Identification
160IUID_MAN_DATAManually Maintained Values for IUID Messages25WAERKSD Document Currencynvarchar50
161IUID_PEDIGREEUII IDoc Message Data for Supporting Supplier Collaboration25WAERKSD Document Currencynvarchar50
TOPVehicle Management System
162VLCBATCHACTVELO : Variant for Action Execution in Batch69WAERKCurrency Keynvarchar50