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

Home | ERP 6.0  | JHAK
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.0JHAK1173IS-M/AM: Order-Publishing-Media (Header Data)Advertising Management
SQL:  selectupdate insert create

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

SELECT MANDT, AVM_NR, GPAG, ANGDT, BNDDT, AUDAT, VBTYP, TRVOG, AUART, AUGRU, WAEHRG, VKORG, VTWEG, SPART, VKGRP, VKBUR, GSBER, GSKST, KNUMV, KALSM, FKARA, STAFO, STWAE, KKBER, KNKLI, GRUPP, SBGRP, CTLPC, CMWAE, CMFRE, MANUSERF, MAN_VKBUR, REF_AVM_NR, SUC_AVM_NR, FRD_AVM_NR, STATUSK, NOTIZKNZ, AENVERS_NR, AENVERS_NR_OL, AEVER_NR_OL_LAST, AVM_HRKNFT, VERMITTLER, VNR, BEDNR, PROSL, XUVKPV, ERFUSER, ERFDATE, ERFTIME, AENUSER, AENDATE, AENTIME, RAB1_BETR, RAB1_GRUND, RAB1_BKTYP, RAB2_BETR, RAB2_GRUND, RAB2_BKTYP, RAB3_BETR, RAB3_GRUND, RAB3_BKTYP, RAB4_BETR, RAB4_PEIN, RAB4_MEIN, RAB4_GRUND, RAB4_BKTYP, RAB5_BETR, RAB5_GRUND, RAB5_BKTYP, RABE_BETR, RABE_GRUND, RABE_BKTYP, ZUS1_BETR, ZUS1_GRUND, ZUS1_BKTYP, ZUS2_BETR, ZUS2_GRUND, ZUS2_BKTYP, ZUS3_BETR, ZUS3_GRUND, ZUS3_BKTYP, ZUS4_BETR, ZUS4_PEIN, ZUS4_MEIN, ZUS4_GRUND, ZUS4_BKTYP, ZUS5_BETR, ZUS5_GRUND, ZUS5_BKTYP, ZUSE_BETR, ZUSE_GRUND, ZUSE_BKTYP, FPRG_BETR, FPRG_PEIN, FPRG_MEIN, FPRG_GRUND, FPRG_BKTYP, FPR1_BETR, FPR1_GRUND, FPR1_BKTYP, XRABZU, WAER_IPZA, XUZUO_LOE, BSTNK, BSARK, BSTDK, BSTZD, IHREZ, BNAME, TELF1, TELFX, PARNR, ZUKOMM, AVMUPD_CAL, AVMUPD_EVN, SD_VBELN_VA, SD_NEWGL_STA FROM JHAK
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2AVM_NRIS-M/AM: Sales Document Numbernvarchar100CHAR(N' ')NoAVM_NR Allow NULL? 
3GPAGBusiness Partner: Sold-to Partynvarchar100CHAR(N' ')YesJGTGPNRGPAG Allow NULL? 
4ANGDTQuotation/Inquiry is valid fromnvarchar80DATS(N'00000000')YesANGDT_V Allow NULL? 
5BNDDTDate until which bid/quotation is binding (valid-to date)nvarchar80DATS(N'00000000')YesBNDDT Allow NULL? 
6AUDATDocument Date (Date Received/Sent)nvarchar80DATS(N'00000000')YesAUDAT Allow NULL? 
7VBTYPSD document categorychar10CHAR(N' ')YesVBTYP Allow NULL? 
8TRVOGIS-M: Transaction Process Group - Order Processingchar10CHAR(N' ')YesTRVOG_PAM Allow NULL? 
9AUARTIS-M: Sales Document Typenvarchar40CHAR(N' ')YesTJHAKAUART_PAM Allow NULL? 
10AUGRUOrder reason (reason for the business transaction)nvarchar30CHAR(N' ')Yes*AUGRU Allow NULL? 
11WAEHRGSD Document Currencynvarchar50CUKY(N' ')YesTCURCWAERK Allow NULL? 
12VKORGSales Organizationnvarchar40CHAR(N' ')YesTJHVBERVKORG Allow NULL? 
13VTWEGDistribution Channelnvarchar20CHAR(N' ')YesTJHVBERVTWEG Allow NULL? 
14SPARTDivisionnvarchar20CHAR(N' ')YesTJHVBERSPART Allow NULL? 
15VKGRPSales Groupnvarchar30CHAR(N' ')YesTVBVKVKGRP Allow NULL? 
16VKBURSales Officenvarchar40CHAR(N' ')YesTVKBZVKBUR Allow NULL? 
17GSBERBusiness Areanvarchar40CHAR(N' ')YesTGSBGSBER Allow NULL? 
18GSKSTBusiness area from cost centernvarchar40CHAR(N' ')YesTGSBGSKST Allow NULL? 
19KNUMVNumber of the document conditionnvarchar100CHAR(N' ')YesKNUMV Allow NULL? 
20KALSMSales and Distribution: Pricing Procedure in Pricingnvarchar60CHAR(N' ')YesT683KALSMASD Allow NULL? 
21FKARAProposed billing type for an order-related billing documentnvarchar40CHAR(N' ')Yes*FKARA Allow NULL? 
22STAFOIS-M: Update group for statistics updatenvarchar60CHAR(N' ')YesTMCBJHSTAFO Allow NULL? 
23STWAEStatistics currencynvarchar50CUKY(N' ')YesTCURCSTWAE Allow NULL? 
24KKBERCredit control areanvarchar40CHAR(N' ')NoT014KKBER Allow NULL? 
25KNKLICustomer's account number with credit limit referencenvarchar100CHAR(N' ')NoKNA1KNKLI Allow NULL? 
26GRUPPCustomer Credit Groupnvarchar40CHAR(N' ')NoT691BGRUPP_CM Allow NULL? 
27SBGRPCredit representative group for credit managementnvarchar30CHAR(N' ')NoT024BSBGRP_CM Allow NULL? 
28CTLPCCredit management: Risk categorynvarchar30CHAR(N' ')NoT691ACTLPC_CM Allow NULL? 
29CMWAECurrency key of credit control areanvarchar50CUKY(N' ')NoTCURCWAERS_CM Allow NULL? 
30CMFRERelease date of the document determined by credit managementnvarchar80DATS(N'00000000')NoCMFRE Allow NULL? 
31MANUSERFIS-M: Order data entered by (entry on paper)nvarchar120CHAR(N' ')YesMANUSERF Allow NULL? 
32MAN_VKBURIS-M/AM: Sales Office of Person who Entered Booking Detailsnvarchar40CHAR(N' ')YesTVBURMAN_VKBUR Allow NULL? 
33REF_AVM_NRIS-M: Reference Order Number of Preceding Ordernvarchar100CHAR(N' ')YesJHAKREF_AVM_NR Allow NULL? 
34SUC_AVM_NRIS-M: Order Number of Subsequent Documentnvarchar100CHAR(N' ')YesJHAKSUC_AVM_NR Allow NULL? 
35FRD_AVM_NRIS-M: Externally Assigned Order Numbernvarchar200CHAR(N' ')YesFRD_AVM_NR Allow NULL? 
36STATUSKIS-M: Statusnvarchar20CHAR(N' ')YesSTATUSK Allow NULL? 
37NOTIZKNZIS-M: Indicates Whether Notes are Available for an OPM Objctchar10CHAR(N' ')YesNOTIZKNZ Allow NULL? 
38AENVERS_NRIS-M: Last Change Version for Technical Systemnvarchar40NUMC(N'0000')YesAENVERS_NR Allow NULL? 
39AENVERS_NR_OLIS-M: Last Change Version for Technical Systemnvarchar40NUMC(N'0000')NoAENVERS_NR Allow NULL? 
40AEVER_NR_OL_LASTIS-M/AM: Last Change Version Number for Technical Systemnvarchar40NUMC(N'0000')NoAENVERS_NR_OL_LAST Allow NULL? 
41AVM_HRKNFTIS-M/AM: Order Originchar10CHAR(N' ')YesAVM_HRKNFT Allow NULL? 
42VERMITTLERIS-M: Sales Agent with ID Code for Screennvarchar100CHAR(N' ')Yes*VERMK Allow NULL? 
43VNRIS-M: Media Sales Agent Contract Numbernvarchar100CHAR(N' ')YesJJTVVJVMVVNR Allow NULL? 
44BEDNRIS-M: Number of Media Sales Agent Contract Requirementnvarchar60NUMC(N'000000')YesJJTVBVM_BEDNR Allow NULL? 
45PROSLIS-M/AM: Commission Key for Media Sales Agentnvarchar50CHAR(N' ')YesTJH23JPROVSCHL Allow NULL? 
46XUVKPVIS-M: Incomplete Manual Header/Item Sales Agent Assignmentchar10CHAR(N' ')YesXUVKPV Allow NULL? 
47ERFUSERCreated Bynvarchar120CHAR(N' ')YesERFUSER Allow NULL? 
48ERFDATECreated Onnvarchar80DATS(N'00000000')YesERFDATE Allow NULL? 
49ERFTIMETime Creatednvarchar60TIMS(N'000000')YesERFTIME Allow NULL? 
50AENUSERLast Changed Bynvarchar120CHAR(N' ')YesAENUSER Allow NULL? 
51AENDATEDate of Last Changenvarchar80DATS(N'00000000')YesAENDATE Allow NULL? 
52AENTIMETime of Last Changenvarchar60TIMS(N'000000')YesAENTIME Allow NULL? 
53RAB1_BETRIS-M/AM: Percentage discountdecimal73DEC((0))YesJRABPROZ
54RAB1_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
55RAB1_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
56RAB2_BETRIS-M/AM: Percentage discountdecimal73DEC((0))YesJRABPROZ
57RAB2_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
58RAB2_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
59RAB3_BETRIS-M/AM: Percentage discountdecimal73DEC((0))YesJRABPROZ
60RAB3_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
61RAB3_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
62RAB4_BETRIS-M/AM: Quantity-dependent discountdecimal112CURR((0))YesJRABMEIN
63RAB4_PEINIS-M: Price Unit (Surcharge Discount, Basic Price)decimal50DEC((0))YesPAMPEIN
64RAB4_MEINIS-M: Unit of Measure (Discount, Surcharge, Basic Price)nvarchar30UNIT(N' ')Yes*PAMMEIN Allow NULL? 
65RAB4_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
66RAB4_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
67RAB5_BETRIS-M/AM: Amount discountdecimal112CURR((0))YesJRABBETR
68RAB5_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
69RAB5_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
70RABE_BETRIS-M/AM: Amount discountdecimal112CURR((0))YesJRABBETR
71RABE_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
72RABE_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
73ZUS1_BETRIS-M/AM: Percentage Surchargedecimal73DEC((0))YesJZUSPROZ
74ZUS1_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
75ZUS1_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
76ZUS2_BETRIS-M/AM: Percentage Surchargedecimal73DEC((0))YesJZUSPROZ
77ZUS2_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
78ZUS2_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
79ZUS3_BETRIS-M/AM: Percentage Surchargedecimal73DEC((0))YesJZUSPROZ
80ZUS3_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
81ZUS3_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
82ZUS4_BETRIS-M/AM: Quantity-dependent surchargedecimal112CURR((0))YesJZUSMEIN
83ZUS4_PEINIS-M: Price Unit (Surcharge Discount, Basic Price)decimal50DEC((0))YesPAMPEIN
84ZUS4_MEINIS-M: Unit of Measure (Discount, Surcharge, Basic Price)nvarchar30UNIT(N' ')Yes*PAMMEIN Allow NULL? 
85ZUS4_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
86ZUS4_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
87ZUS5_BETRIS-M/AM: Amount Surchargedecimal112CURR((0))YesJZUSBETR
88ZUS5_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
89ZUS5_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
90ZUSE_BETRIS-M/AM: Amount Surchargedecimal112CURR((0))YesJZUSBETR
91ZUSE_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
92ZUSE_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
93FPRG_BETRIS-M/AM: Basic Pricedecimal112CURR((0))YesJGPRBETR
94FPRG_PEINIS-M: Price Unit (Surcharge Discount, Basic Price)decimal50DEC((0))YesPAMPEIN
95FPRG_MEINIS-M: Unit of Measure (Discount, Surcharge, Basic Price)nvarchar30UNIT(N' ')Yes*PAMMEIN Allow NULL? 
96FPRG_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
97FPRG_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
98FPR1_BETRIS-M/AM: Agreed pricedecimal112CURR((0))YesJVPRBETR
99FPR1_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
100FPR1_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
101XRABZUIS-M: Discount/Surcharge Exists Indicatorchar10CHAR(N' ')YesXRABZU Allow NULL? 
102WAER_IPZASD Document Currencynvarchar50CUKY(N' ')Yes*WAERK Allow NULL? 
103XUZUO_LOECheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
104BSTNKCustomer purchase order numbernvarchar200CHAR(N' ')YesBSTNK Allow NULL? 
105BSARKCustomer purchase order typenvarchar40CHAR(N' ')YesT176BSARK Allow NULL? 
106BSTDKCustomer purchase order datenvarchar80DATS(N'00000000')YesBSTDK Allow NULL? 
107BSTZDPurchase order number supplementnvarchar40CHAR(N' ')YesBSTZD Allow NULL? 
108IHREZYour Referencenvarchar120CHAR(N' ')YesIHREZ Allow NULL? 
109BNAMEName of orderernvarchar350CHAR(N' ')YesBNAME_V Allow NULL? 
110TELF1Telephone Numbernvarchar160CHAR(N' ')YesTELF1_VP Allow NULL? 
111TELFXFax Numbernvarchar310CHAR(N' ')YesTELFX Allow NULL? 
112PARNRIS-M: Contact Personnvarchar100CHAR(N' ')Yes*ISM_CNTCT_PRSN Allow NULL? 
113ZUKOMMIS-M: Additional Communication Datanvarchar500CHAR(N' ')YesJZUKOMM Allow NULL? 
114AVMUPD_CALIS-M: Order Updater - Initiatorchar10CHAR(N' ')YesTJHAVMUPDAVMUPD_CAL Allow NULL? 
115AVMUPD_EVNIS-M: Order Updater - Eventchar10CHAR(N' ')YesTJHAVMUPDAVMUPD_EVN Allow NULL? 
116SD_VBELN_VAIS-M: Referenced SD Order Numbernvarchar100CHAR(N' ')No*JHVBELN_VA Allow NULL? 
117SD_NEWGL_STAOrder Status newGL Enhancementchar10CHAR(N' ')YesISM_SPLIT_CRITERION_STATUS Allow NULL? 
NamePrimaryUniqueTypeColumns
JHAK~0YesYesCLUSTEREDAVM_NR, MANDT
JHAK~001NoNoNONCLUSTEREDAVM_HRKNFT, FRD_AVM_NR, MANDT
JHAK~002NoNoNONCLUSTEREDSPART, VTWEG, VKORG, GPAG, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy