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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Industry Specific :: SAP Media :: Advertising Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0JHAPS701IS-M/AM: OPM Ad Insert ItemAdvertising Management
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, AVM_NR, POS_NR, BEARB, BLGMENGE, TZUSMENGE, DISPMENGE, BERMENGE, XBERMENGE_FIX, POSTMENGE, SIMENGE_RH, MUSTER_T, MUSTER_P, XFREMDBEIL, XBEILAGHW, XRESTHSHLT, RESTHSHLT_DATUM, XTRANZ, XTBEL_SI, SI_TYP, SI_GEWICHT, MEINHGEWBL, SI_ENTSPFL, SI_VERBWER, ANZSEITEN, TERM_TYP, ANFANG_PER, ENDE_PER, SELDAT_VON, SELDAT_BIS, BIS_PLUS, ANZ_SCHALT, TERM_ZYKL, TERMINART, ERSCH_T, WUNSCH_T, X_MONTAG, X_DIENSTAG, X_MITTWOCH, X_DONNERST, X_FREITAG, X_SAMSTAG, X_SONNTAG, XUVSI, XSI_WARTET, XDISPOSITI, XSI_PLAZ, XMUSTER_OK, XSI_VORH, XUVTECH, XTECH_MIN1, XTECH_EE, MERKMAL0, MERKMAL1, MERKMAL2, MERKMAL3, MERKMAL4, MERKMAL5, MERKMAL6, MERKMAL7, MERKMAL8, MERKMAL9, KONKAUS, KONKAUSKOM, PRODH, SORTWORT, STICHW, INHK_KFM, XTEXT_INT, XTEXT_EXT FROM JHAPS
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2AVM_NRIS-M/AM: Sales Document Numbernvarchar100CHAR(N' ')NoJHAKAVM_NR Allow NULL? 
3POS_NRIS-M: Order Item Numbernvarchar30NUMC(N'000')NoJHAPPOS_NR Allow NULL? 
4BEARBIS-M: Ad Insert Processing Typenvarchar20CHAR(N' ')YesTJH03SINSBEARB Allow NULL? 
5BLGMENGEIS-M: Delivery Quantity for Ad Insertdecimal90DEC((0))YesBLGMGE_PAM
6TZUSMENGEIS-M: Additional Tech.Quantity in % (Ad Insert)decimal52DEC((0))YesTZUSMENGE
7DISPMENGEIS-M: Planning Quantity for Ad Insertsdecimal90DEC((0))YesDSPMGE_PAM
8BERMENGEIS-M: Calculation Quantity (Ad Insert)decimal90DEC((0))YesBERMENGE
9XBERMENGE_FIXIS-M/AM: Calculation Quantity is Fixed indicatorchar10CHAR(N' ')NoJXBERMENGE_FIX Allow NULL? 
10POSTMENGEIS-M: Postal Circulation Quantitydecimal90DEC((0))YesPOSTMENGE
11SIMENGE_RHIS-M: Non-Reader Circulation for TMCdecimal90DEC((0))YesDSPMGE_RH
12MUSTER_TIS-M: Number of Samples (Technical)nvarchar40NUMC(N'0000')YesMUSTER_T Allow NULL? 
13MUSTER_PIS-M: Number of Samples for Trial Runs (Ad Insert)nvarchar40NUMC(N'0000')YesMUSTER_P Allow NULL? 
14XFREMDBEILIS-M: Indicator - subject to postal charges (ad insert)char10CHAR(N' ')YesXFREMDBEIL Allow NULL? 
15XBEILAGHWIS-M: Insert Note Required Indicatorchar10CHAR(N' ')YesXBLGHINW Allow NULL? 
16XRESTHSHLTIS-M: Total Market Coveragechar10CHAR(N' ')YesXRESTHSHLT Allow NULL? 
17RESTHSHLT_DATUMIS-M: Alternative Date for Total Market Coveragenvarchar80DATS(N'00000000')NoISM_DELTA_COVERAGE_DATE Allow NULL? 
18XTRANZIS-M: Carrier Ad Required Indicatorchar10CHAR(N' ')YesXTRANZEIGE Allow NULL? 
19XTBEL_SIIS-M: Selective Booking of an AI BUchar10CHAR(N' ')YesXTBEL_SI Allow NULL? 
20SI_TYPIS-M: Ad Insert Typenvarchar20CHAR(N' ')YesTJH29SITYP Allow NULL? 
21SI_GEWICHTIS-M: Ad Insert Weightdecimal93QUAN((0))YesISM_SI_GEWICHT
22MEINHGEWBLIS-M: Unit of Weight for Ad Insertnvarchar30UNIT(N' ')YesT006MEINHGEWBL Allow NULL? 
23SI_ENTSPFLIS-M: Waste Disposal Required Indicatorchar10CHAR(N' ')YesISM_SI_ENTSPFL Allow NULL? 
24SI_VERBWERIS-M: Tie-In Ads Indicatorchar10CHAR(N' ')YesISM_SI_VERBWER Allow NULL? 
25ANZSEITENNumber of Pages in Issuenvarchar80NUMC(N'00000000')YesANZSEITEN Allow NULL? 
26TERM_TYPIS-M/AM: Date Category Copy Number/Publication Datechar10CHAR(N' ')YesTJH55TERMINTYP Allow NULL? 
27ANFANG_PERIS-M: Start of Copy/Publication Date Periodnvarchar140CHAR(N' ')YesANFANG_PER Allow NULL? 
28ENDE_PERIS-M: End of Period - Issue/Publication Datenvarchar140CHAR(N' ')YesENDE_PER Allow NULL? 
29SELDAT_VONIS-M: Start Date for Itemnvarchar80DATS(N'00000000')YesSELDAT_VON Allow NULL? 
30SELDAT_BISIS-M: End Date for Itemsnvarchar80DATS(N'00000000')YesSELDAT_BIS Allow NULL? 
31BIS_PLUSIS-M: Indicates a Period ("-") or 2 Dates ("+")char10CHAR(N' ')YesBIS_PLUS Allow NULL? 
32ANZ_SCHALTIS-M: Number of Placementsnvarchar30NUMC(N'000')YesANZ_SCHALT Allow NULL? 
33TERM_ZYKLIS-M: Frequency for Ad Publicationnvarchar40CHAR(N' ')YesTJJ57ANZ_ZYKLUS Allow NULL? 
34TERMINARTIS-M/AM: Type of Publication Datechar10CHAR(N' ')YesTERMINART Allow NULL? 
35ERSCH_TIS-M: Publication Datenvarchar80DATS(N'00000000')YesERSCH_T Allow NULL? 
36WUNSCH_TIS-M/AM: Date Requirednvarchar80DATS(N'00000000')YesWUNSCH_T Allow NULL? 
37X_MONTAGIS-M: Date Field Indicator - Mondaychar10CHAR(N' ')YesJHT_MONTAG Allow NULL? 
38X_DIENSTAGIS-M: Date Field Indicator - Tuesdaychar10CHAR(N' ')YesJHT_DIENSTAG Allow NULL? 
39X_MITTWOCHIS-M: Date Field Indicator - Wednesdaychar10CHAR(N' ')YesJHT_MITTWOCH Allow NULL? 
40X_DONNERSTIS-M: Date Field Indicator - Thursdaychar10CHAR(N' ')YesJHT_DONNERST Allow NULL? 
41X_FREITAGIS-M: Date Field Indicator - Fridaychar10CHAR(N' ')YesJHT_FREITAG Allow NULL? 
42X_SAMSTAGIS-M: Date Field Indicator - Saturdaychar10CHAR(N' ')YesJHT_SAMSTAG Allow NULL? 
43X_SONNTAGIS-M: Date Field Indicator - Sundaychar10CHAR(N' ')YesJHT_SONNTAG Allow NULL? 
44XUVSIIS-M: Ad Insert Data Incomplete Indicatorchar10CHAR(N' ')YesXUVSI Allow NULL? 
45XSI_WARTETIS-M: Ad Insert Is On The Waiting List Indicatorchar10CHAR(N' ')YesXSI_WARTET Allow NULL? 
46XDISPOSITIIS-M: Planning Has Taken Place Indicatorchar10CHAR(N' ')YesXDISPOSITI Allow NULL? 
47XSI_PLAZIS-M: Ad insert "positioned" indicatorchar10CHAR(N' ')YesXSI_PLAZ Allow NULL? 
48XMUSTER_OKIS-M: Sample Received and Checked Indicatorchar10CHAR(N' ')YesXMUSTER_OK Allow NULL? 
49XSI_VORHIS-M: AI Copies Existchar10CHAR(N' ')YesXSI_VORH Allow NULL? 
50XUVTECHIS-M: Incomplete Regarding Technical System (Gen.)char10CHAR(N' ')YesXUVTECH Allow NULL? 
51XTECH_MIN1IS-M: Tech.process.started (for at least 1 schedule line)char10CHAR(N' ')YesXTECH_MIN1 Allow NULL? 
52XTECH_EEIS-M: Tech.Complete (All Schedule Lines Fully Processed)char10CHAR(N' ')YesXTECH_EE Allow NULL? 
53MERKMAL0IS-M: Characteristic 0 for Individual Use (Ad Insert Item)char10CHAR(N' ')YesMERK0_PS Allow NULL? 
54MERKMAL1IS-M: Characteristic 1 for Individual Use (Ad Insert Item)char10CHAR(N' ')YesMERK1_PS Allow NULL? 
55MERKMAL2IS-M: Characteristic 2 for Individual Use (Ad Insert Item)char10CHAR(N' ')YesMERK2_PS Allow NULL? 
56MERKMAL3IS-M: Characteristic 3 for Individual Use (Ad Insert Item)char10CHAR(N' ')YesMERK3_PS Allow NULL? 
57MERKMAL4IS-M: Characteristic 4 for Individual Use (Ad Insert Item)char10CHAR(N' ')YesMERK4_PS Allow NULL? 
58MERKMAL5IS-M: Characteristic 5 for Individual Use (Ad Insert Item)char10CHAR(N' ')YesMERK5_PS Allow NULL? 
59MERKMAL6IS-M: Characteristic 6 for Individual Use (Ad Insert Item)char10CHAR(N' ')YesMERK6_PS Allow NULL? 
60MERKMAL7IS-M: Characteristic 7 for Individual Use (Ad Insert Item)char10CHAR(N' ')YesMERK7_PS Allow NULL? 
61MERKMAL8IS-M: Characteristic 8 for Individual Use (Ad Insert Item)char10CHAR(N' ')YesMERK8_PS Allow NULL? 
62MERKMAL9IS-M: Characteristic 9 for Individual Use (Ad Insert Item)char10CHAR(N' ')YesMERK9_PS Allow NULL? 
63KONKAUSIS-M: Competitor exclusionnvarchar20CHAR(N' ')YesTJH89KONKAUS Allow NULL? 
64KONKAUSKOMIS-M: Comment on competitor exclusionnvarchar350CHAR(N' ')YesKONKAUSKOM Allow NULL? 
65PRODHIS-M/AM: Product Hierarchynvarchar180CHAR(N' ')YesJJT179J_PRODH Allow NULL? 
66SORTWORTIS-M: Sort Wordnvarchar100CHAR(N' ')YesSORTWORT Allow NULL? 
67STICHWIS-M: Keywordnvarchar400CHAR(N' ')YesSTICHW Allow NULL? 
68INHK_KFMIS-M: Business Content Componentnvarchar80CHAR(N' ')YesJJTIKOINHK_KFM Allow NULL? 
69XTEXT_INTIS-M: Internal positioning comment indicatorchar10CHAR(N' ')YesXTEXT_INT Allow NULL? 
70XTEXT_EXTIS-M: External positioning comment exists indicatorchar10CHAR(N' ')YesXTEXT_EXT Allow NULL? 
NamePrimaryUniqueTypeColumns
JHAPS~0YesYesCLUSTEREDPOS_NR, AVM_NR, MANDT