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

43 columns | Print definition?ERP 6.0  | BELEGEINH

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdvertising Management
1/NAM/TJHSORTWSort Word Generation Function Module7BELEGEINHIS-M/AM: Booking Unitnvarchar100
2JHABPZIS-M/AM: Assign Booking Units to an Item4BELEGEINHIS-M/AM: Booking Unitnvarchar100
3JHAEAIS-M/AM: Order-Publishing-Media Ad Schedule Line7BELEGEINHIS-M: Basic Booking Unitnvarchar100
4JHAEGENIS-M/AM: Schedule Lines Generation Period2BELEGEINHIS-M/AM: Booking Unitnvarchar100
5JHAEOIS-M/AM: Online Schedule Line7BELEGEINHIS-M: Basic Booking Unitnvarchar100
6JHAESIS-M/AM: OPM Ad Insert Schedule Line7BELEGEINHIS-M: Basic Booking Unitnvarchar100
7JHAEVIS-M/AM: OPM Distribution Schedule Line7BELEGEINHIS-M: Basic Booking Unitnvarchar100
8JHAEWIS-M/AM: OPM Commercial Schedule Line7BELEGEINHIS-M: Basic Booking Unitnvarchar100
9JHAGAIS-M/AM: Order-Publishing-Media Billing Dataset5BELEGEINHIS-M: Basic Booking Unitnvarchar100
10JHAIKZIS-M/AM: Item/Booking Unit/Technical Content Comp.Assignment4BELEGEINHIS-M/AM: Booking Unitnvarchar100
11JHAMEZIS-M/AM: Order Item Schedule Line Data (Manual) Assignment4BELEGEINHIS-M: Basic Booking Unitnvarchar100
12JHAREV1IS-M/AM: Order Revenue Recognition Key Date Values29BELEGEINHIS-M/AM: Booking Unitnvarchar100
13JHAREV3IS-M/AM: Order Revenue Recognition Key Date Quantities26BELEGEINHIS-M/AM: Booking Unitnvarchar100
14JHATPSIOPM Prod.Sched.Line - Actual Message with Plnd/Act Variation13BELEGEINHIS-M: Basic Booking Unitnvarchar100
15JHATPSITDAd Production Schedule Line - Actual Message Todo12BELEGEINHIS-M: Basic Booking Unitnvarchar100
16JHAUAIS-M/AM: Order-Publishing-Media Ad Sub-Item6BELEGEINHIS-M: Basic Booking Unitnvarchar100
17JHAUOIS-M/AM: OPM Online Sub-Item6BELEGEINHIS-M: Basic Booking Unitnvarchar100
18JHAUWIS-M/AM: Order-Publishing-Media Ad Sub-Item6BELEGEINHIS-M: Basic Booking Unitnvarchar100
19JHTFXIS-M/AM: Billing Index - Order Billing6BELEGEINHIS-M/AM: Booking Unitnvarchar100
20JHWWWTEMP_ORDERIS-M/AM: Temporary Table for Order Data from the Internet17BELEGEINHIS-M/AM: Booking Unitnvarchar100
21JJTBEATERMIS-M/AM: Alternative Dates for Booking Units2BELEGEINHIS-M/AM: Booking Unitnvarchar100
22JJTBEDZULAIS-M/AM: Booking Unit Admissibility for Specific Date3BELEGEINHIS-M/AM: Booking Unitnvarchar100
23JJTBESTIS-M/AM: Booking Unit Element2BELEGEINHIS-M: Basic Booking Unitnvarchar100
24JJTBEZULASIS-M/AM: Booking Unit Admissibility3BELEGEINHIS-M/AM: Booking Unitnvarchar100
25JJTINSSERT_DETIS-M/AM: Series Creation Rule Determination5BELEGEINHIS-M/AM: Booking Unitnvarchar100
26JJTKONZUIS-M/AM: Sales Activity Assignments5BELEGEINHIS-M/AM: Booking Unitnvarchar100
27JJTUPSELL_BEIS-M/AM: Upselling Proposals Booking Unit Assignment3BELEGEINHIS-M/AM: Booking Unitnvarchar100
28S481IS-M/AM: View of BP Sales Areas16BELEGEINHIS-M/AM: Booking Unitnvarchar100
29S481ES481 - Structural Information11BELEGEINHIS-M/AM: Booking Unitnvarchar100
30S482IS-M/AM: Ad Quantities9BELEGEINHIS-M: Basic Booking Unitnvarchar100
31S482ES482 - Structural Information4BELEGEINHIS-M: Basic Booking Unitnvarchar100
32S483IS-M/AM: Agent Assignment16BELEGEINHIS-M/AM: Booking Unitnvarchar100
33S483ES483 - Structural Information11BELEGEINHIS-M/AM: Booking Unitnvarchar100
34TJHAZARTGRIS-M/AM: BU Grouping For Ad.Type Admissibility2BELEGEINHIS-M/AM: Booking Unitnvarchar100
35TJHEDITIS-M/AM: Technical Editor In the Order3BELEGEINHIS-M/AM: Booking Unitnvarchar100
36TJHVSW02IS-M/AM: VSW Output Code Depending on Booking Unit2BELEGEINHIS-M/AM: Booking Unitnvarchar100
37TJHWWW_JHAW_BEIS-M/AM: IAC Enter Classified Ad: Admissible Booking Unit3BELEGEINHIS-M/AM: Booking Unitnvarchar100
38TJHWWW_JHB4_BBEIS-M: Booking Unit Admissibility - Fixed Spaces Planning I3BELEGEINHIS-M/AM: Booking Unitnvarchar100
39TJJ45IS-M/AM: Minimum and Maximum Sizes for Ads5BELEGEINHIS-M/AM: Booking Unitnvarchar100
TOPMaster Data
40JGTBKUSIS-M: Note to Payee for Bank Details5BELEGEINHIS-M/AM: Booking Unitnvarchar100
41JGTBKVWIS-M: Note to Payee for Banks7BELEGEINHIS-M/AM: Booking Unitnvarchar100
TOPPeriodical Sales and Distribution
42JVTSIANZUOIS-M: Assignment of Insert Mix to AI Orders7BELEGEINHIS-M: Basic Booking Unitnvarchar100
43JVTSIBLZUOIS-M: Assignment of Insert Mix to AI Orders7BELEGEINHIS-M: Basic Booking Unitnvarchar100