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.0JHAISZ682IS-M/AM: Assignment Table of Advertisers for OPM OrderAdvertising 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, INSERENT, XINSBLANK, INSZ_NR, INS_PROZ, AZGR_INS, ALTINSGPNR, REGULIERER, TAXK1, TAXK2, TAXK3, TAXK4, TAXK5, TAXK6, TAXK7, TAXK8, TAXK9, GPNR_RECH, RECH_ADRNR, RECH_ADVAR, RECH_ADHER, WAERG, FAKSPP, XSEPFKKOPF, ZTERM, VALDT, VALTG, PERFK, FAKDATUM, VORAUSKNZ, VORAUSRCH, XRECHN, XKFMAEND, KONDA, XORTSPREIS, KALKS, KUKARR_K, KARENZ, KARENZ_ME, KDGRP, KURST, PLTYP, ZLSCH, AE, BANKS, BANKL, BANKN, BKONT, BVTYP, XEINZUG, IBAN, XSPERR_BON, VKBUR_ZUST, CCINS, CCNUM, DATBI, CCNAME, CVVAL, CVVCT, CVVST, DATE_GEN_RULE_BI, BRAN1, ADV_AD_SIZE, CGUID, ENCTP, MNDID FROM JHAISZ
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? 
4INSERENTIS-M: Advertisernvarchar100CHAR(N' ')NoJJVDB_MK_FKINSERENT Allow NULL? 
5XINSBLANKIS-M: Agency Order Without Advertiser Indicatorchar10CHAR(N' ')YesXINSBLANK Allow NULL? 
6INSZ_NRIS-M: Advertiser assignment numbernvarchar40NUMC(N'0000')YesINSZ_NR Allow NULL? 
7INS_PROZIS-M: Percentage Figure for Cost Distributiondecimal63DEC((0))YesPAM_PROZ
8AZGR_INSColumn MM of the Ad Which the Advertiser is Involved Innvarchar40NUMC(N'0000')YesAZGR_INS Allow NULL? 
9ALTINSGPNRIS-M: Alternative Customer Number for Advertisernvarchar150CHAR(N' ')YesALTINSGPNR Allow NULL? 
10REGULIERERIS-M: Payernvarchar100CHAR(N' ')YesJGTGPNRREGULIERER Allow NULL? 
11TAXK1Tax classification 1 for customerchar10CHAR(N' ')Yes*TAXK1 Allow NULL? 
12TAXK2Tax classification 2 for customerchar10CHAR(N' ')Yes*TAXK2 Allow NULL? 
13TAXK3Tax classification 3 for customerchar10CHAR(N' ')Yes*TAXK3 Allow NULL? 
14TAXK4Tax Classification 4 Customerchar10CHAR(N' ')Yes*TAXK4 Allow NULL? 
15TAXK5Tax classification 5 for customerchar10CHAR(N' ')Yes*TAXK5 Allow NULL? 
16TAXK6Tax classification 6 for customerchar10CHAR(N' ')Yes*TAXK6 Allow NULL? 
17TAXK7Tax classification 7 for customerchar10CHAR(N' ')Yes*TAXK7 Allow NULL? 
18TAXK8Tax classification 8 for customerchar10CHAR(N' ')Yes*TAXK8 Allow NULL? 
19TAXK9Tax classification 9 for customerchar10CHAR(N' ')Yes*TAXK9 Allow NULL? 
20GPNR_RECHIS-M: Business Partner - Bill-To Partynvarchar100CHAR(N' ')YesJGTGPNRGPNR_RECH Allow NULL? 
21RECH_ADRNRAddressnvarchar100CHAR(N' ')Yes*ADRNR Allow NULL? 
22RECH_ADVARIS-M: Address Variantchar10CHAR(N' ')YesADRESSVAR Allow NULL? 
23RECH_ADHERIS-M: Use of Addresschar10CHAR(N' ')YesHERK Allow NULL? 
24WAERGSD Document Currencynvarchar50CUKY(N' ')YesTCURCWAERK Allow NULL? 
25FAKSPPIS-M: Billing Blocknvarchar20CHAR(N' ')YesTVFSPAM_FAKSP Allow NULL? 
26XSEPFKKOPFSeparate billing document for sales orderchar10CHAR(N' ')YesXSEPFKKOPF Allow NULL? 
27ZTERMTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
28VALDTFixed value datenvarchar80DATS(N'00000000')YesVALDT Allow NULL? 
29VALTGAdditional value daysnvarchar20NUMC(N'00')YesVALTG Allow NULL? 
30PERFKInvoice dates (calendar identification)nvarchar20CHAR(N' ')YesTFACDPERFK Allow NULL? 
31FAKDATUMIS-M: Planned Billing/Settlement Datenvarchar80DATS(N'00000000')YesJHFKTER Allow NULL? 
32VORAUSKNZIS-M: Indicates Whether Advance Billing Requiredchar10CHAR(N' ')YesVORAUSKNZ Allow NULL? 
33VORAUSRCHIS-M: "Advance billing required" indicatorchar10CHAR(N' ')YesVORAUSRCH Allow NULL? 
34XRECHNIS-M: Invoice Requested Indicatorchar10CHAR(N' ')YesXRECHN Allow NULL? 
35XKFMAENDIS-M: Business Data was Changed Manually Indicatorchar10CHAR(N' ')YesXKFMAEND Allow NULL? 
36KONDAPrice group (customer)nvarchar20CHAR(N' ')YesT188KONDA Allow NULL? 
37XORTSPREISIS-M/AM: Local Customer Indicatorchar10CHAR(N' ')YesXORTSPREIS Allow NULL? 
38KALKSPricing procedure assigned to this customerchar10CHAR(N' ')YesTVKDKALKS Allow NULL? 
39KUKARR_KIS-M: Customer Profilenvarchar20CHAR(N' ')YesTJJ95JKUKARR Allow NULL? 
40KARENZIS-M: Grace Period for Price Changesnvarchar40NUMC(N'0000')YesJKARENZ Allow NULL? 
41KARENZ_MEBase Unit of Measurenvarchar30UNIT(N' ')YesT006MEINS Allow NULL? 
42KDGRPCustomer groupnvarchar20CHAR(N' ')YesT151KDGRP Allow NULL? 
43KURSTExchange Rate Typenvarchar40CHAR(N' ')YesTCURVKURST Allow NULL? 
44PLTYPPrice list typenvarchar20CHAR(N' ')YesT189PLTYP Allow NULL? 
45ZLSCHPayment Methodchar10CHAR(N' ')YesT042ZSCHZW_BSEG Allow NULL? 
46AEIS-M: Agency Commission Entitlementchar10CHAR(N' ')YesAGEN_AE Allow NULL? 
47BANKSBank country keynvarchar30CHAR(N' ')YesT005BANKS Allow NULL? 
48BANKLBank Keysnvarchar150CHAR(N' ')YesBNKABANKK Allow NULL? 
49BANKNBank account numbernvarchar180CHAR(N' ')YesBANKN Allow NULL? 
50BKONTBank Control Keynvarchar20CHAR(N' ')YesBKONT Allow NULL? 
51BVTYPPartner Bank Typenvarchar40CHAR(N' ')YesBVTYP Allow NULL? 
52XEINZUGIndicator: Is there collection authorization ?char10CHAR(N' ')YesXEZER Allow NULL? 
53IBANIBAN (International Bank Account Number)nvarchar340CHAR(N' ')YesIBAN Allow NULL? 
54XSPERR_BONIS-M: "Blocked for reasons of creditworthiness" indicatorchar10CHAR(N' ')YesXSPERR_BON Allow NULL? 
55VKBUR_ZUSTSales office responsiblenvarchar40CHAR(N' ')Yes*VKBURZUS Allow NULL? 
56CCINSPayment cards: Card typenvarchar40CHAR(N' ')NoTVCINCCINS Allow NULL? 
57CCNUMPayment cards: Card numbernvarchar250CHAR(N' ')NoVCNUMCCNUM Allow NULL? 
58DATBIPayment Cards: Valid Tonvarchar80DATS(N'00000000')NoDATBI_CC Allow NULL? 
59CCNAMEPayment cards: Name of cardholdernvarchar400CHAR(N' ')NoCCNAME Allow NULL? 
60CVVALCard Verification Valuenvarchar60CHAR(N' ')NoISM_CVVAL Allow NULL? 
61CVVCTControl Field for Card Verification Valuechar10CHAR(N' ')NoISM_CVVCT Allow NULL? 
62CVVSTUsage Status of Card Verification Valuechar10CHAR(N' ')NoISM_CVVST Allow NULL? 
63DATE_GEN_RULE_BIIS-M: Date Rule for Generating Billing Datasetnvarchar20CHAR(N' ')NoTJHGENBIISM_DATE_GEN_RULE_BI Allow NULL? 
64BRAN1IS-M: Industry Sector for Advertisernvarchar100CHAR(N' ')YesTBRCBRAN_PAM Allow NULL? 
65ADV_AD_SIZEShare of Ad Size Belonging to the Advertiserdecimal133QUAN((0))YesISM_ADV_AD_SIZE
66CGUIDGUID of a Payment Cardvarbinary160RAWYesCARD_GUID
67ENCTPType of Encryptionchar10CHAR(N' ')YesCCSECA_ENCTYPE Allow NULL? 
68MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350CHAR(N' ')YesSEPA_MNDID Allow NULL? 
NamePrimaryUniqueTypeColumns
JHAISZ~0YesYesCLUSTEREDINSERENT, POS_NR, AVM_NR, MANDT
JHAISZ~001NoNoNONCLUSTEREDBVTYP, REGULIERER, MANDT