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

161 columns | Print definition?ERP 6.0  | DRERZ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdvertising Management
1JHAGAIS-M/AM: Order-Publishing-Media Billing Dataset187DRERZPublicationnvarchar80
2JHFREV2IS-M/AM: Key Dates for Billing Document Revenue Recognition50DRERZIS-M: Publicationnvarchar80
3JHFREV4IS-M/AM: Billing Document Revenue Recognition Key Date Qties47DRERZIS-M: Publicationnvarchar80
4JHTFPIS-M/AM: Billing/Settlement Documents - Item19DRERZIS-M: Publicationnvarchar80
5JJCPFREESUBIS-M: Free Subscription - Contact Person Relationship8DRERZPublicationnvarchar80
6JJCPRESPONSIBIS-M: Responsibility in Contact Person Relationship10DRERZPublicationnvarchar80
7JJTAFIS-M/AM: Free Subscription for Media Contact Person8DRERZPublicationnvarchar80
8JJTAZIS-M/AM: Media Contact Person Responsibility10DRERZPublicationnvarchar80
9JJTBEIS-M/AM: Booking Units65DRERZIS-M: AI Publication Elements for a Basic BUnvarchar80
10JJTBEPARTIS-M/AM: Booking Unit Elements (AI)7DRERZPublicationnvarchar80
11JJTPVAPEIS-M/AM: Edition Element3DRERZPublicationnvarchar80
12JJTVAPEIS-M/AM: Issue Element2DRERZPublicationnvarchar80
13TJHKDIS-M/AM: Voucher Shipping, Data for Sales Order3DRERZPublicationnvarchar80
TOPContract Accounts Receivable and Payable
14FKK_JLRPCM_SHORTItem Data for IS-M/SD Commission Settlement - Extracts20DRERZPublicationnvarchar80
TOPInformation System
15TJBW02IS-M/AM BW: Access to Time Slice Rule7DRERZPublicationnvarchar80
TOPMaster Data
16JSTROUPVAIS-M/SD: Truck Route-Publication/Edition Assignment4DRERZPublicationnvarchar80
TOPMedia Product Sales and Distribution
17JSDVA_MIGIS-M: Issue Worklist for Media Product Migration3DRERZPublicationnvarchar80
18JVTPACKGROUPPRODIS-M: Common Odd Bundle Group (Products Contained)4DRERZPublicationnvarchar80
19JYTGOLIVIS-M/SD: Data on Going Live2DRERZPublicationnvarchar80
TOPMedia Sales and Distribution
20/NAM/JKDISPATCHDispatching object6DRERZPublicationnvarchar80
21/NAM/TJKAPPL_CMPApplication Access for Complaint Charges6DRERZPublicationnvarchar80
22/NAM/TJKAPPL_MONApplication Access for Determination of Monitoring11DRERZPublicationnvarchar80
23/NAM/TJKAPPL_OFRApplication Access for Renewal Offers11DRERZPublicationnvarchar80
TOPPeriodical Sales and Distribution
24A448IS-M/SD: Promotion Rebate for WBZ Company5DRERZPublicationnvarchar80
25A449IS-M/SD: Lump Sum Promotion Rebate5DRERZPublicationnvarchar80
26A450IS-PSD: Versandkosten pauschal Ländergruppierung7DRERZPublicatienvarchar80
27A451Purchase Price6DRERZPublicationnvarchar80
28A452IS-M/SD: Lump Sum Shipping Costs f.Current Delivery Country7DRERZPublicationnvarchar80
29A455Customer Discount/Title7DRERZPublicationnvarchar80
30A456Conditions Per Publication and Price Group7DRERZPublicationnvarchar80
31A458IS-M/SD: Employee Renewal Commission6DRERZPublicationnvarchar80
32A459IS-M/SD: Employee Up-Front Commission6DRERZPublicationnvarchar80
33A461IS-M/SD: Employee Bonus for Sales Promotion7DRERZPublicationnvarchar80
34A462IS-M/SD: SC Commission Settlement - Renewal Commission6DRERZPublicationnvarchar80
35A463IS-M/SD: SC Commission Settlement - Bonus for Up-Front Comm.7DRERZPublicationnvarchar80
36A464IS-M/SD: SC Commission Settlement for Up-Front Commission6DRERZPublicationnvarchar80
37A465IS-M/SD: Special Retail Prices for Customer6DRERZPublicationnvarchar80
38A466IS-M/SD: Special Retail Prices6DRERZPublicationnvarchar80
39A467IS-M/SD: Retail Purchase Prices6DRERZPublicationnvarchar80
40A468IS-M/SD: Daily Shipping Costs for Current Delivery Country7DRERZPublicationnvarchar80
41A469IS-M/SD: Daily Shipping Costs for Country Grouping7DRERZPublicationnvarchar80
42A481IS-M/SD: Daily Purchase Prices6DRERZPublicationnvarchar80
43A482IS-M/SD: SC Commission Settlement - Bonus for Up-Front Comm.7DRERZPublicationnvarchar80
44A483IS-M/SD: Payment Method for Employee Bonus for Up-Front Com.7DRERZPublicationnvarchar80
45C450IS-M/SD: SOrg./Publ./Edit./CGrp./AKey/BFreq.6DRERZPublicationnvarchar80
46C451IS-M/SD: SOrg./Publ./CAccGrp./AccKey/BFreq.6DRERZPublicationnvarchar80
47C452IS-M/SD: SOrg./Publ./AKey/BFreq.6DRERZPublicationnvarchar80
48C460IS-M/SD: POrg./Publ./Edit./SC/AKey6DRERZPublicationnvarchar80
49C461IS-M/SD: POrg./Publ./Edit./AKey6DRERZPublicationnvarchar80
50C462IS-M/SD: POrg./Publ./AKey6DRERZPublicationnvarchar80
51C465IS-M/SD: SC/Publ./Edit./EEAcGrp./AKey6DRERZPublicationnvarchar80
52C466IS-M/SD: SC/Publ./Edit./AKey6DRERZPublicationnvarchar80
53C467IS-M/SD: SC/Publ./AKey6DRERZPublicationnvarchar80
54JDTBZANGIS-M/SD: Mix Offer2DRERZPublicationnvarchar80
55JDTDRERIS-M/SD: Publications2DRERZPublicationnvarchar80
56JDTMLANIS-M/SD: Tax Code for Publication2DRERZPublicationnvarchar80
57JDTPVAIS-M/SD: Editions2DRERZPublicationnvarchar80
58JDTPVAVTRIS-M/SD: Edition Sales Data2DRERZPublicationnvarchar80
59JDTPVAWERKIS-M/SD: Edition Plant (Printing Works) Data2DRERZPublicationnvarchar80
60JDTPVAWGRPIS-M/SD: Edition Plant Assignment to Bundle Group2DRERZPublicationnvarchar80
61JDTSTVOPAIS-M: Bundling Rule6DRERZPublicationnvarchar80
62JDTVAENQDummy Table for (Generic) Issue Lock2DRERZPublicationnvarchar80
63JDTVASYNCIS-M: Worklist for Issue Synchronization M/SD -> M/AM4DRERZPublicationnvarchar80
64JDTVAUSGBIS-M/SD: Issues3DRERZPublicationnvarchar80
65JDTWGHVOPAIS-M/SD: Bundling Rule - Weight Scale6DRERZPublicationnvarchar80
66JFDFSIS-M/SD: Billing/Settlement Index50DRERZPublicationnvarchar80
67JFREVVAIS-M/SD: Accr.Table for Issue-Rel.Revenue Dist.w/o Liab.Acct5DRERZPublicationnvarchar80
68JFREVVA_REVERSEIS-M/SD: Reverse Issue-Related Revenue Dist. w/o Liab. Acct8DRERZPublicationnvarchar80
69JFVAIS-M/SD: Accrual Table Revenue Distribution at Issue Level4DRERZPublicationnvarchar80
70JFXJFVADLIS-M: Backup Transfer Internal Table XJFVA6DRERZPublicationnvarchar80
71JITOMITTEDDAYSABC Exclusion2DRERZPublicationnvarchar80
72JITSTATIS-M/SD: Daily IVW Statistics17DRERZPublicationnvarchar80
73JITSTATMTIS-M/SD: Audit Reports to the Company Responsible2DRERZPublicationnvarchar80
74JKAMOPLANIS-M/SD: Amortization Plan for Billing Cycle6DRERZPublicationnvarchar80
75JKAPSales Order - Item Data14DRERZPublicationnvarchar80
76JKAPRENEWIS-M/SD: Index for Renewal of Subscriptions5DRERZPublicationnvarchar80
77JKAPRVIS-M/SD: Sales Order - Retroactive Shipping Data6DRERZPublicationnvarchar80
78JKAP_INACTIVEPublishing Sales Order: Inactive Item Data15DRERZPublicationnvarchar80
79JKDELIVOPTIS-M/SD: Delivery Viability Optimization4DRERZPublicationnvarchar80
80JKDELIVOPT_REFIS-M/SD: Delivery Viability Optimization4DRERZPublicationnvarchar80
81JKTGUIS-M/SD: Coupon Booklet3DRERZPublicationnvarchar80
82JKWWWTEMP_ORDERIS-M/SD: WWW Temporary Table for Order Data from Internet20DRERZPublicationnvarchar80
83JKWWWTEMP_SERVIS-M: Temporary Table for Changes from Internet54DRERZPublicationnvarchar80
84JLCOMMINDIS-M: Commission Index18DRERZPublicationnvarchar80
85JLRPIS-M/SD: Item Data for Settlement127DRERZPublicationnvarchar80
86JLTP1PVAIS-M/SD: Postal Settlement Data on an Issue (New)6DRERZPublicationnvarchar80
87JRENQABLGIS4DRERZPublicationnvarchar80
88JRTABLRGLIS-M/SD: Unloading Rule (no longer used)8DRERZPublicationnvarchar80
89JRTABLRGLAIS-M/SD: Unloading Rule for Unl.Point (Up to 5 Truck Routes)7DRERZPublicationnvarchar80
90JRTABLRGLBIS-M: Unloading Rule for Carrier Route (Up to 6 Unl.Pts)7DRERZPublicationnvarchar80
91JVTANN00IS-M: Technical Order Deadline Limit3DRERZPublicationnvarchar80
92JVTANNSTATIS-M/SD: Status Table for Order Finalization Deadline3DRERZPublicationnvarchar80
93JVTASTAT01IS-M/SD: Supplements to Shipping Status3DRERZPublicationnvarchar80
94JVTBEZHPVAIS-M/SD: Main Edition in Carrier Route3DRERZIS-M: Main Publication in Carrier Routenvarchar80
95JVTDSPTRIS-M/SD: Planning trigger3DRERZPublicationnvarchar80
96JVTFEHLERIS-M: Distribution Error Message13DRERZPublicationnvarchar80
97JVTFRGLARTIS-M/SD: Determination of Postal Packing Rule4DRERZPublicationnvarchar80
98JVTLFSTATIS-M/SD: Daily Delivery Statistics4DRERZPublicationnvarchar80
99JVTLIEFBARIS-M/SD: Delivery/Home Delivery/Pickup Viability Sets9DRERZPublicationnvarchar80
100JVTMCI_ITEMIS-M: TMCI Household Addresses for AI Schedule Lines12DRERZPublicationnvarchar80
101JVTMODZEBUIS-M/SD: Modified ZEBU Records6DRERZPublicationnvarchar80
102JVTNCT2IS-M/SD: Tab.2 in Coll.Netchange File (Change No.-Trig.Asgt)4DRERZPublicationnvarchar80
103JVTNCT3IS-M/SD: Tab.3 of Coll.Netch.File (ChNo.-OrItem-Tr.-Asgt)4DRERZPublicationnvarchar80
104JVTNCT4IS-M/SD: Tab.4 for Netchange (ChNo.Planng View)-see JKVDIS19DRERZPublicationnvarchar80
105JVTPRDGR03IS-M/SD: Fixed Elements of a Production Group3DRERZPublicationnvarchar80
106JVTPRODIS-M/SD: Production Units10DRERZActual Publication Deliverednvarchar80
107JVTPSQ0001IS-M/SD: Production Sequence - Elements: Publication/Edition3DRERZPublicationnvarchar80
108JVTPSQ0002IS-M/SD: Production Sequence - Elements: Publ./Edit./Insert3DRERZPublicationnvarchar80
109JVTREFPVAIS-M/SD: Reference Edition for Edition, Media Product or AI2DRERZPublicationnvarchar80
110JVTVARZPVAIS-M/SD: Assignment of Edition to Shipping Schedule Variant3DRERZPublicationnvarchar80
111JVTVSPDIRIS-M/SD: Shipping Document Directory10DRERZPublicationnvarchar80
112JVTZAEM1IS-M/SD: Carrier Change Notification - Order Change24DRERZPublicationnvarchar80
113JVTZUSTMIS-M/SD: Carrier Notification (Shipping Documents)5DRERZIS-M: Main Publication in Carrier Routenvarchar80
114JWAKTDRERIS-M/SD: Publications for Sales Promotion3DRERZPublicationnvarchar80
115JYTREORGIS-M/SD: Reorganization Periods and Areas3DRERZPublicationnvarchar80
116JYTSTREORGIS-M/SD: Reorganization Status3DRERZPublicationnvarchar80
117S450IS-M/SD: Customer Statistics12DRERZPublicationnvarchar80
118S450ES450 - Structural Data7DRERZPublicationnvarchar80
119S451IS-M/SD: Sales Office Statistics13DRERZPublicationnvarchar80
120S451ES451 - Structural Data8DRERZPublicationnvarchar80
121S452IS-M/SD: Product Statistics8DRERZPublicationnvarchar80
122S452ES452 - Structural Data3DRERZPublicationnvarchar80
123S453IS-M/SD: Plant/Country Statistics11DRERZPublicationnvarchar80
124S453ES453 - Structural Data6DRERZPublicationnvarchar80
125S454IS-M/SD: Sales Agents12DRERZPublicationnvarchar80
126S454ES454 - Structural Data7DRERZPublicationnvarchar80
127S455IS-M/SD: Promotion Statistics12DRERZPublicationnvarchar80
128S455ES455 - Structural Data7DRERZPublicationnvarchar80
129TJD45IS-M/SD: Edition-Odd Bundle Group Assignments3DRERZPublicationnvarchar80
130TJD53IS-M/SD: Bundling Group2DRERZPublicationnvarchar80
131TJD54IS-M/SD: Edition Bundling Group (Texts)3DRERZPublicationnvarchar80
132TJD66IS-M/SD: Address Alternation Offer4DRERZPublicationnvarchar80
133TJF50IS-M/SD: Wage Type Determination for Billing4DRERZPublicationnvarchar80
134TJIABCZONESDefinition of ABZ Zones per Edition3DRERZPublicationnvarchar80
135TJKABIS-M/SD: Sales Document Type-Mix Offer Assignment3DRERZPublicationnvarchar80
136TJKFAIS-M/SD: Billing Methods for Subscription4DRERZPublicationnvarchar80
137TJKWEIS-M/SD: WBZ, Order Data for Inbound Processing5DRERZPublicationnvarchar80
138TJKWVIS-M/SD: External Connection - Sales Area Determination2DRERZPublicationnvarchar80
139TJKWWIS-M/SD: Control Table for Creating Trial Subscriptions6DRERZPublicationnvarchar80
140TJKWWW_VARIS-M/SD: WWW, Combinations of Variable Order Values3DRERZPublicationnvarchar80
141TJL35IS-M/SD: Master Data for Contract Arrangement Determination7DRERZPublicationnvarchar80
142TJL39IS-M/SD: Master Data for Contract Arrangement Determination7DRERZPublicationnvarchar80
143TJL50IS-M/SD: Wage Type Determination for Home Delivery (new)4DRERZPublicationnvarchar80
144TJL52IS-M/SD: Wage Type Determination for Commission (new)4DRERZPublicationnvarchar80
145TJV41IS-M/SD: Type of Shipping Problem Message13DRERZIS-M: Relevancy of Publicationnvarchar10
146TJV53IS-M/SD: Destination Determination for Shipping Documents5DRERZPublicationnvarchar80
147TJV54IS-M/SD: Shipping Document Type Usage6DRERZPublicationnvarchar80
148TJV62IS-M/SD: Sales Data for Goods Arrival Record2DRERZPublicationnvarchar80
149TJV69IS-M/SD: Function Modules for Bundling (Customer)7DRERZPublicationnvarchar80
150TJWAKIS-M/SD: Sales Promotion5DRERZPublicationnvarchar80
TOPSAP Media
151J_1SGEWAULIS-M/SD CH: No.Taxable Issues by Weight Groups - Foreign2DRERZActual Publication Deliverednvarchar80
152J_1SGEWBTEIS-M/SD CH: No.Taxable Issues by Weight Groups - Domestic2DRERZActual Publication Deliverednvarchar80
153J_1SGEWINLIS-M/SD CH: No.Taxable Issues by Weight Groups - Domestic2DRERZActual Publication Deliverednvarchar80
154J_1SGEWPLAIS-M/SD CH: No.Taxable Issues by Weight Groups - Domestic2DRERZActual Publication Deliverednvarchar80
155J_1SMAHNFAIS-M/SD CH/F: Dunned Subscription Billing Documents6DRERZPublicationnvarchar80
156J_1SMAHNSTIS-M/SD CH/F: Control Table for Dunning Levels3DRERZPublicationnvarchar80
157J_1SPAUFGIS-M/SD-CH: Postal Dispatch Lists7DRERZPublicationnvarchar80
158J_1SPTAXPVAIS-M/SD-CH: Edition Data for Postal Charges2DRERZPublicationnvarchar80
159J_1SVARIEVIS-M/SD CH: Variants for Global Changes in Retail3DRERZPublicationnvarchar80
160J_1SWEMF00IS-M/SD CH/W: Daily WEMF Statistics17DRERZPublicationnvarchar80
161J_1S_AENDIS-M/SD CH/S: Orders Affected by Change Number9DRERZPublicationnvarchar80