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  | EKKO
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
Materials Management :: Purchasing
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0EKKO1297Purchasing Document HeaderPurchasing
SQL:  selectupdate insert create

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

SELECT MANDT, EBELN, BUKRS, BSTYP, BSART, BSAKZ, LOEKZ, STATU, AEDAT, ERNAM, PINCR, LPONR, LIFNR, SPRAS, ZTERM, ZBD1T, ZBD2T, ZBD3T, ZBD1P, ZBD2P, EKORG, EKGRP, WAERS, WKURS, KUFIX, BEDAT, KDATB, KDATE, BWBDT, ANGDT, BNDDT, GWLDT, AUSNR, ANGNR, IHRAN, IHREZ, VERKF, TELF1, LLIEF, KUNNR, KONNR, ABGRU, AUTLF, WEAKT, RESWK, LBLIF, INCO1, INCO2, KTWRT, SUBMI, KNUMV, KALSM, STAFO, LIFRE, EXNUM, UNSEZ, LOGSY, UPINC, STAKO, FRGGR, FRGSX, FRGKE, FRGZU, FRGRL, LANDS, LPHIS, ADRNR, STCEG_L, STCEG, ABSGR, ADDNR, KORNR, MEMORY, PROCSTAT, RLWRT, REVNO, SCMPROC, REASON_CODE, MEMORYTYPE, RETTP, RETPC, DPTYP, DPPCT, DPAMT, DPDAT, MSR_ID, HIERARCHY_EXISTS, THRESHOLD_EXISTS, LEGAL_CONTRACT, DESCRIPTION, RELEASE_DATE, VSART, HANDOVERLOC, SHIPCOND, FORCE_ID, FORCE_CNT, RELOC_ID, RELOC_SEQ_ID, SOURCE_LOGSYS, VZSKZ, POHF_TYPE, EQ_EINDT, EQ_WERKS, FIXPO, EKGRP_ALLOW, WERKS_ALLOW, CONTRACT_ALLOW, PSTYP_ALLOW, FIXPO_ALLOW, KEY_ID_ALLOW, AUREL_ALLOW, DELPER_ALLOW, EINDT_ALLOW, LTSNR_ALLOW, OTB_LEVEL, OTB_COND_TYPE, KEY_ID, OTB_VALUE, OTB_CURR, OTB_RES_VALUE, OTB_SPEC_VALUE, SPR_RSN_PROFILE, BUDG_TYPE, OTB_STATUS, OTB_REASON, CHECK_TYPE, CON_OTB_REQ, CON_PREBOOK_LEV, CON_DISTR_LEV FROM EKKO
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2EBELNPurchasing Document Numbernvarchar100CHAR(N' ')NoEBELN Allow NULL? 
3BUKRSCompany Codenvarchar40CHAR(N' ')YesT001BUKRS Allow NULL? 
4BSTYPPurchasing Document Categorychar10CHAR(N' ')YesEBSTYP Allow NULL? 
5BSARTPurchasing Document Typenvarchar40CHAR(N' ')YesT161ESART Allow NULL? 
6BSAKZControl indicator for purchasing document typechar10CHAR(N' ')YesBSAKZ Allow NULL? 
7LOEKZDeletion Indicator in Purchasing Documentchar10CHAR(N' ')YesELOEK Allow NULL? 
8STATUStatus of Purchasing Documentchar10CHAR(N' ')YesESTAK Allow NULL? 
9AEDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
10ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
11PINCRItem Number Intervalnvarchar50NUMC(N'00000')YesPINCR Allow NULL? 
12LPONRLast Item Numbernvarchar50NUMC(N'00000')YesEKPOLPONR Allow NULL? 
13LIFNRVendor Account Numbernvarchar100CHAR(N' ')YesLFA1ELIFN Allow NULL? 
14SPRASLanguage Keychar10LANG(N' ')YesT002SPRAS Allow NULL? 
15ZTERMTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
16ZBD1TCash (Prompt Payment) Discount Daysdecimal30DEC((0))YesDZBDET
17ZBD2TCash (Prompt Payment) Discount Daysdecimal30DEC((0))YesDZBDET
18ZBD3TCash (Prompt Payment) Discount Daysdecimal30DEC((0))YesDZBDET
19ZBD1PCash Discount Percentage 1decimal53DEC((0))YesDZBD1P
20ZBD2PCash Discount Percentage 2decimal53DEC((0))YesDZBD2P
21EKORGPurchasing Organizationnvarchar40CHAR(N' ')YesT024EEKORG Allow NULL? 
22EKGRPPurchasing Groupnvarchar30CHAR(N' ')YesT024BKGRP Allow NULL? 
23WAERSCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
24WKURSExchange Ratedecimal95DEC((0))YesWKURS
25KUFIXIndicator: Fixing of Exchange Ratechar10CHAR(N' ')YesKUFIX Allow NULL? 
26BEDATPurchasing Document Datenvarchar80DATS(N'00000000')YesEBDAT Allow NULL? 
27KDATBStart of Validity Periodnvarchar80DATS(N'00000000')YesKDATB Allow NULL? 
28KDATEEnd of Validity Periodnvarchar80DATS(N'00000000')YesKDATE Allow NULL? 
29BWBDTClosing Date for Applicationsnvarchar80DATS(N'00000000')YesBWBDT Allow NULL? 
30ANGDTDeadline for Submission of Bid/Quotationnvarchar80DATS(N'00000000')YesANGAB Allow NULL? 
31BNDDTBinding Period for Quotationnvarchar80DATS(N'00000000')YesEBNDT Allow NULL? 
32GWLDTWarranty Datenvarchar80DATS(N'00000000')YesMM_GWLDT Allow NULL? 
33AUSNRBid invitation numbernvarchar100CHAR(N' ')YesEKKOAUSCH Allow NULL? 
34ANGNRQuotation Numbernvarchar100CHAR(N' ')YesANGNR Allow NULL? 
35IHRANQuotation Submission Datenvarchar80DATS(N'00000000')YesIHRAN Allow NULL? 
36IHREZYour Referencenvarchar120CHAR(N' ')YesIHREZ Allow NULL? 
37VERKFResponsible Salesperson at Vendor's Officenvarchar300CHAR(N' ')YesEVERK Allow NULL? 
38TELF1Vendor's Telephone Numbernvarchar160CHAR(N' ')YesTELF0 Allow NULL? 
39LLIEFSupplying Vendornvarchar100CHAR(N' ')YesLFA1LLIEF Allow NULL? 
40KUNNRCustomer Numbernvarchar100CHAR(N' ')YesKNA1KUNNR Allow NULL? 
41KONNRNumber of Principal Purchase Agreementnvarchar100CHAR(N' ')YesEKKOKONNR Allow NULL? 
42ABGRUField Not Usednvarchar20CHAR(N' ')YesABDUM Allow NULL? 
43AUTLFComplete Delivery Stipulated for Each Purchase Orderchar10CHAR(N' ')YesKMPLF Allow NULL? 
44WEAKTIndicator: Goods Receipt Messagechar10CHAR(N' ')YesWEAKT Allow NULL? 
45RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40CHAR(N' ')YesT001WRESWK Allow NULL? 
46LBLIFField not usednvarchar100CHAR(N' ')YesLFA1LBLIF Allow NULL? 
47INCO1Incoterms (Part 1)nvarchar30CHAR(N' ')YesTINCINCO1 Allow NULL? 
48INCO2Incoterms (Part 2)nvarchar280CHAR(N' ')YesINCO2 Allow NULL? 
49KTWRTTarget Value for Header Area per Distributiondecimal152CURR((0))YesKTWRT
50SUBMICollective Numbernvarchar100CHAR(N' ')YesSUBMI Allow NULL? 
51KNUMVNumber of the document conditionnvarchar100CHAR(N' ')YesKNUMV Allow NULL? 
52KALSMProcedure (Pricing, Output Control, Acct. Det., Costing,...)nvarchar60CHAR(N' ')YesT683KALSM_D Allow NULL? 
53STAFOUpdate group for statistics updatenvarchar60CHAR(N' ')Yes*STAFO Allow NULL? 
54LIFREDifferent Invoicing Partynvarchar100CHAR(N' ')YesLFA1LIFRE Allow NULL? 
55EXNUMNumber of foreign trade data in MM and SD documentsnvarchar100CHAR(N' ')YesEIKPEXNUM Allow NULL? 
56UNSEZOur Referencenvarchar120CHAR(N' ')YesUNSEZ Allow NULL? 
57LOGSYLogical Systemnvarchar100CHAR(N' ')Yes*LOGSYSTEM Allow NULL? 
58UPINCItem Number Interval for Subitemsnvarchar50NUMC(N'00000')YesUPINC Allow NULL? 
59STAKODocument with time-dependent conditionschar10CHAR(N' ')YesSTAKO Allow NULL? 
60FRGGRRelease groupnvarchar20CHAR(N' ')YesT16FGFRGGR Allow NULL? 
61FRGSXRelease Strategynvarchar20CHAR(N' ')YesT16FSFRGSX Allow NULL? 
62FRGKERelease Indicator: Purchasing Documentchar10CHAR(N' ')YesT16FBFRGKE Allow NULL? 
63FRGZURelease statusnvarchar80CHAR(N' ')YesFRGZU Allow NULL? 
64FRGRLRelease Not Yet Completely Effectedchar10CHAR(N' ')YesFRGRL Allow NULL? 
65LANDSCountry for Tax Returnnvarchar30CHAR(N' ')YesT005LAND1_STML Allow NULL? 
66LPHISIndicator for scheduling agreement release documentationchar10CHAR(N' ')YesLPHIS Allow NULL? 
67ADRNRAddress numbernvarchar100CHAR(N' ')Yes*AD_ADDRNUM Allow NULL? 
68STCEG_LCountry of Sales Tax ID Numbernvarchar30CHAR(N' ')Yes*STCEG_L Allow NULL? 
69STCEGVAT Registration Numbernvarchar200CHAR(N' ')YesSTCEG Allow NULL? 
70ABSGRReason for Cancellationnvarchar20NUMC(N'00')YesT165RABSGR Allow NULL? 
71ADDNRDocument number for additionalnvarchar100CHAR(N' ')YesADDI_BELNR Allow NULL? 
72KORNRCorrection of miscellaneous provisionschar10CHAR(N' ')YesKORNR Allow NULL? 
73MEMORYPurchase order not yet completechar10CHAR(N' ')YesMEMER Allow NULL? 
74PROCSTATPurchasing document processing statenvarchar20CHAR(N' ')YesMEPROCSTATE Allow NULL? 
75RLWRTTotal value at time of releasedecimal152CURR((0))YesRLWRT
76REVNOVersion number in Purchasingnvarchar80CHAR(N' ')YesREVNO Allow NULL? 
77SCMPROCSCM Process That Created the Purchase Orderchar10CHAR(N' ')YesSCMPROC Allow NULL? 
78REASON_CODEGoods Receipt Reason Codenvarchar40CHAR(N' ')Yes/SAPPSPRO/_GR_REASON_CODE Allow NULL? 
79MEMORYTYPECategory of Incompletenesschar10CHAR(N' ')YesMEMORYTYPE Allow NULL? 
80RETTPRetention Indicatorchar10CHAR(N' ')YesRETTP Allow NULL? 
81RETPCRetention in Percentdecimal52DEC((0))YesRETPZ
82DPTYPDown Payment Indicatornvarchar40CHAR(N' ')YesME_DPTYP Allow NULL? 
83DPPCTDown Payment Percentagedecimal52DEC((0))YesME_DPPCNT
84DPAMTDown Payment Amount in Document Currencydecimal112CURR((0))YesME_DPAMNT
85DPDATDue Date for Down Paymentnvarchar80DATS(N'00000000')YesME_DPDDAT Allow NULL? 
86MSR_IDProcess Identification Numbernvarchar100CHAR(N' ')YesMSR_PROCESS_ID Allow NULL? 
87HIERARCHY_EXISTSPart of a Contract Hierarchychar10CHAR(N' ')YesHIERARCHY_EXISTS Allow NULL? 
88THRESHOLD_EXISTSThreshold Value for Exchange Rates Existschar10CHAR(N' ')YesEX_RATE_THRESHOLD Allow NULL? 
89LEGAL_CONTRACTLegal Contract Numbernvarchar400CHAR(N' ')YesLEGAL_CONTRACT_ID Allow NULL? 
90DESCRIPTIONContract Namenvarchar400CHAR(N' ')YesCONTRACT_DESCRIPTION Allow NULL? 
91RELEASE_DATERelease Date of Contractnvarchar80DATS(N'00000000')YesRELEASE_DATE Allow NULL? 
92VSARTShipping typenvarchar20CHAR(N' ')Yes*VERSART Allow NULL? 
93HANDOVERLOCLocation for a physical handover of goodsnvarchar100CHAR(N' ')YesHANDOVER_LOC Allow NULL? 
94SHIPCONDShipping Conditionsnvarchar20CHAR(N' ')Yes*VSBED Allow NULL? 
95FORCE_IDInternal Key for Force Elementnvarchar320CHAR(N' ')Yes/ISDFPS/FORCE_ID Allow NULL? 
96FORCE_CNTInternal (Version) Counternvarchar60NUMC(N'000000')Yes/ISDFPS/FORCE_CNT Allow NULL? 
97RELOC_IDRelocation IDnvarchar100CHAR(N' ')Yes/ISDFPS/REL/ISDFPS/RELOC_ID Allow NULL? 
98RELOC_SEQ_IDRelocation Step IDnvarchar40CHAR(N' ')Yes/ISDFPS/RELSEQ/ISDFPS/RELOC_SEQ_ID Allow NULL? 
99SOURCE_LOGSYSLogical systemnvarchar100CHAR(N' ')Yes*LOGSYS Allow NULL? 
100VZSKZInterest calculation indicatornvarchar20CHAR(N' ')Yes*VZSKZ Allow NULL? 
101POHF_TYPEDocument for Seasonal Purchase Order Processingchar10CHAR(N' ')YesWRF_POHF_TYPE Allow NULL? 
102EQ_EINDTDelivery Date Header: All Items Have Same Delivery Datenvarchar80DATS(N'00000000')YesWRF_POHF_EQ_EINDT Allow NULL? 
103EQ_WERKSPlant Header: All Items Have Same Receiving Plantnvarchar40CHAR(N' ')Yes*WRF_POHF_EQ_EWERK Allow NULL? 
104FIXPOFirm Deal Indicatorchar10CHAR(N' ')YesWRF_POHF_FIXPO Allow NULL? 
105EKGRP_ALLOWTake Account of Purch. Groupchar10CHAR(N' ')YesWRF_POHF_EKGRP_ALLOW Allow NULL? 
106WERKS_ALLOWTake Account of Plantschar10CHAR(N' ')YesWRF_POHF_WERKS_ALLOW Allow NULL? 
107CONTRACT_ALLOWTake Account of Contractschar10CHAR(N' ')YesWRF_POHF_CONTRACT_ALLOW Allow NULL? 
108PSTYP_ALLOWTake Account of Item Categorieschar10CHAR(N' ')YesWRF_POHF_PSTYP_ALLOW Allow NULL? 
109FIXPO_ALLOWTake Account of Fixed-Date Purchases Indicatorchar10CHAR(N' ')YesWRF_POHF_FIXPO_ALLOW Allow NULL? 
110KEY_ID_ALLOWConsider Budgetchar10CHAR(N' ')YesWRF_POHF_KEY_ID_ALLOW Allow NULL? 
111AUREL_ALLOWTake Account of Alloc. Table Relevancechar10CHAR(N' ')YesWRF_POHF_AUREL_ALLOW Allow NULL? 
112DELPER_ALLOWTake Account of Dlvy Periodchar10CHAR(N' ')YesWRF_POHF_DELPER_ALLOW Allow NULL? 
113EINDT_ALLOWTake Account of Delivery Datechar10CHAR(N' ')YesWRF_POHF_EINDT_ALLOW Allow NULL? 
114LTSNR_ALLOWInclude Vendor Subrangechar10CHAR(N' ')YesWRF_POHF_LTSNR_ALLOW Allow NULL? 
115OTB_LEVELOTB Check Levelchar10CHAR(N' ')YesWRF_POTB_CHECK_LEVEL Allow NULL? 
116OTB_COND_TYPEOTB Condition Typenvarchar40CHAR(N' ')Yes*WRF_POTB_COND_TYPE Allow NULL? 
117KEY_IDUnique Number of Budgetnvarchar160NUMC(N'0000000000000000')YesWRF_BUDG_KEY_ID Allow NULL? 
118OTB_VALUERequired Budgetdecimal172CURR((0))YesWRF_POTB_VALUE
119OTB_CURROTB Currencynvarchar50CUKY(N' ')Yes*WRF_POTB_CURRENCY Allow NULL? 
120OTB_RES_VALUEReserved Budget for OTB-Relevant Purchasing Documentdecimal172CURR((0))YesWRF_POTB_RES_VALUE
121OTB_SPEC_VALUESpecial Release Budgetdecimal172CURR((0))YesWRF_POTB_SPECIAL_VALUE
122SPR_RSN_PROFILEReason Profile for OTB Special Releasenvarchar40CHAR(N' ')YesWRF_POTB_SPR_RSN_PROFILE Allow NULL? 
123BUDG_TYPEBudget Typenvarchar20CHAR(N' ')YesWRF_BUDG_TYPE Allow NULL? 
124OTB_STATUSOTB Check Statuschar10CHAR(N' ')YesWRF_POTB_STATUS Allow NULL? 
125OTB_REASONReason Indicator for OTB Check Statusnvarchar30CHAR(N' ')YesWRF_POTB_STATUS_REASON Allow NULL? 
126CHECK_TYPEType of OTB Checkchar10CHAR(N' ')YesWRF_BUDG_OTB_CHECK Allow NULL? 
127CON_OTB_REQOTB-Relevant Contractchar10CHAR(N' ')YesWRF_POTB_CON_REQ Allow NULL? 
128CON_PREBOOK_LEVOTB Indicator Level for Contractschar10CHAR(N' ')YesWRF_POTB_PREBOOK_LEVEL Allow NULL? 
129CON_DISTR_LEVDistribution Using Target Value or Item Datachar10CHAR(N' ')YesWRF_POTB_DISTRIB_LEVEL Allow NULL? 
NamePrimaryUniqueTypeColumns
EKKO~0YesYesCLUSTEREDEBELN, MANDT
EKKO~1NoNoNONCLUSTEREDBEDAT, EKGRP, EKORG, LIFNR, MANDT
EKKO~2NoNoNONCLUSTEREDFRGSX, FRGGR, FRGRL, MANDT
EKKO~DNoNoNONCLUSTEREDBEDAT, BSTYP, MANDT
EKKO~ENoNoNONCLUSTEREDBSTYP, ERNAM, MANDT
EKKO~SNoNoNONCLUSTEREDSUBMI, MANDT
EKKO~WNoNoNONCLUSTEREDBSTYP, EKORG, RESWK, 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