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  | EIPO
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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Sales and Distribution :: Foreign Trade :: Basic Functions
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0EIPO931Foreign Trade: Export/Import: Item DataBasic Functions
SQL:  selectupdate insert create

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

SELECT MANDT, EXNUM, EXPOS, STAWN, EXPRF, EXART, HERKL, HERKR, GRWRT, PREFPACOD, SEGAL, MOWNR, MOGRU, GPNUM, CASNR, STEUC, WZOLL, VERLD, HANLD, TEXT1, TEXT2, TEXT3, COKON, COPHA, COADI, PRONU, PRODA, VORPA, VORNU, VORDA, BEHOE, KENNU, VOISO, PREFA, PREFN, PREDU, PRISO, PRHOE, PRUEL, NACAR, NACNU, NACDA, NAISO, NAHOE, NAUEL, NACA2, NACN2, NACD2, NAIS2, NAHO2, NAUE2, NACA3, NACN3, NACD3, NAIS3, NAHO3, NAUE3, NACA4, NACN4, NACD4, NAIS4, NAHO4, NAUE4, NACA5, NACN5, NACD5, NAIS5, NAHO5, NAUE5, EXDAR, EXDAA, EXDAB, EXDTA, EXDT2, EXDTB, EXDPA, EXPRE, EXDT5, AUSOK, COIMP, HERSE, COBLD, EIOKW, EIOKA, GBNUM, RGNNR, PRENC, PRENO, PREND, KTNUM, PLNUM, POSAR, PSTYV FROM EIPO
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2EXNUMNumber of foreign trade data in MM and SD documentsnvarchar100CHAR(N' ')NoEIKPEXNUM Allow NULL? 
3EXPOSInternal item number for foreign trade data in MM and SDnvarchar60NUMC(N'000000')NoEXPOS Allow NULL? 
4STAWNCommodity Code/Import Code Number for Foreign Tradenvarchar170CHAR(N' ')YesT604STAWN Allow NULL? 
5EXPRFExport/Import Procedure for Foreign Tradenvarchar80CHAR(N' ')YesT616EXPRF Allow NULL? 
6EXARTBusiness Transaction Type for Foreign Tradenvarchar20CHAR(N' ')YesT605EXART Allow NULL? 
7HERKLCountry of origin of the materialnvarchar30CHAR(N' ')YesT005HERKL Allow NULL? 
8HERKRRegion of origin of material (non-preferential origin)nvarchar30CHAR(N' ')Yes*HERKR Allow NULL? 
9GRWRTStatistical value for foreign tradedecimal132CURR((0))YesGRWRT
10PREFPACODPreference code for foreign trade (decl.to author., import)nvarchar30CHAR(N' ')YesT604CPREFPACOD Allow NULL? 
11SEGALExclusion/Inclusion indicator for declara. to authoritiesnvarchar20CHAR(N' ')YesT609ASEGAL Allow NULL? 
12MOWNRCAP: Number of CAP products listnvarchar120CHAR(N' ')YesT618MMOWNR Allow NULL? 
13MOGRUCommon Agricultural Policy: CAP products group-Foreign Tradenvarchar60CHAR(N' ')YesT618GMOGRU Allow NULL? 
14GPNUMProduction statistics: PRODCOM number for foreign tradenvarchar90CHAR(N' ')YesT609GGPNUM Allow NULL? 
15CASNRCAS number for pharmaceutical products in foreign tradenvarchar150CHAR(N' ')YesT610CCASNR Allow NULL? 
16STEUCControl code for consumption taxes in foreign tradenvarchar160CHAR(N' ')YesT604FSTEUC Allow NULL? 
17WZOLLCustoms val. in doc.currency in imp.procg for foreign tradedecimal132CURR((0))YesWZOLL
18VERLDCountry of dispatch for Foreign Tradenvarchar30CHAR(N' ')YesT005VERLD Allow NULL? 
19HANLDTrading country for foreign tradenvarchar30CHAR(N' ')YesT005HANLD Allow NULL? 
20TEXT1Comments: Text for foreign trade processingnvarchar400CHAR(N' ')YesTXTFT Allow NULL? 
21TEXT2Comments: Text for foreign trade processingnvarchar400CHAR(N' ')YesTXTFT Allow NULL? 
22TEXT3Comments: Text for foreign trade processingnvarchar400CHAR(N' ')YesTXTFT Allow NULL? 
23COKONCustoms quota code for import processing in foreign tradenvarchar60CHAR(N' ')YesT610KCOKON Allow NULL? 
24COPHAPharmaceutical products code (Foreign Trade)nvarchar60CHAR(N' ')YesT610DCOPHA Allow NULL? 
25COADIAnti-dumping code for import processing in foreign tradenvarchar60CHAR(N' ')YesT610ACOADI Allow NULL? 
26PRONUInvoice: Number of invoice document for import processingnvarchar250CHAR(N' ')YesPRONU Allow NULL? 
27PRODAInvoice: Date of invoice document for import processingnvarchar80DATS(N'00000000')YesPRODA Allow NULL? 
28VORPAPreliminary document: Document type for foreign trade procgnvarchar100CHAR(N' ')YesT610VAVORPA Allow NULL? 
29VORNUPreliminary document: No. of preliminary doc.f.import procgnvarchar250CHAR(N' ')YesVORNU Allow NULL? 
30VORDAPreliminary document: Date of preliminary doc.f.import procgnvarchar80DATS(N'00000000')YesVORDA Allow NULL? 
31BEHOEPreliminary doc.: Issuing authority of relevant prelim.doc.nvarchar100CHAR(N' ')YesT610OVOHOE Allow NULL? 
32KENNUPreliminary document: Customs office/ID number for importnvarchar60CHAR(N' ')YesKENNU Allow NULL? 
33VOISOPrelim. doc.: ISO code of ctry issuing the preliminary doc.nvarchar20CHAR(N' ')YesVOISO Allow NULL? 
34PREFAPreference: Preference type for foreign tradenvarchar100CHAR(N' ')YesT610PAPREFA Allow NULL? 
35PREFNPreference: Official number of preference document - Importnvarchar250CHAR(N' ')YesPREFN Allow NULL? 
36PREDUPreference: Date of preference document for import procgnvarchar80DATS(N'00000000')YesPREDU Allow NULL? 
37PRISOPreference: ISO code of country issuing the preference doc.nvarchar20CHAR(N' ')YesPRISO Allow NULL? 
38PRHOEPreference: Issuing authoritiy for relevant preference doc.nvarchar100CHAR(N' ')YesT610OPRHOE Allow NULL? 
39PRUELPreference: Validity date of preference document for importnvarchar80DATS(N'00000000')YesPRUEL Allow NULL? 
40NACARVerification documents: Type of certificate for importnvarchar100CHAR(N' ')YesT610NANACAR Allow NULL? 
41NACNUVerification docs: Official no. of verific. doc. - Importnvarchar250CHAR(N' ')YesNACNU Allow NULL? 
42NACDAVerification documents: Date of verif.doc. for import procgnvarchar80DATS(N'00000000')YesNACDA Allow NULL? 
43NAISOVerification doc: ISO code of ctry supplying verific.doc.nvarchar20CHAR(N' ')YesNAISO Allow NULL? 
44NAHOEVerification documents: Issuing authority for relev. verif.nvarchar100CHAR(N' ')YesT610ONAHOE Allow NULL? 
45NAUELVerification docs: Validity date of verific.doc. for importnvarchar80DATS(N'00000000')YesNAUEL Allow NULL? 
46NACA2Verification documents: Type of certificate for importnvarchar100CHAR(N' ')YesT610NANACAR Allow NULL? 
47NACN2Verification docs: Official no. of verific. doc. - Importnvarchar250CHAR(N' ')YesNACNU Allow NULL? 
48NACD2Verification documents: Date of verif.doc. for import procgnvarchar80DATS(N'00000000')YesNACDA Allow NULL? 
49NAIS2Verification doc: ISO code of ctry supplying verific.doc.nvarchar20CHAR(N' ')YesNAISO Allow NULL? 
50NAHO2Verification documents: Issuing authority for relev. verif.nvarchar100CHAR(N' ')YesT610ONAHOE Allow NULL? 
51NAUE2Verification docs: Validity date of verific.doc. for importnvarchar80DATS(N'00000000')YesNAUEL Allow NULL? 
52NACA3Verification documents: Type of certificate for importnvarchar100CHAR(N' ')YesT610NANACAR Allow NULL? 
53NACN3Verification docs: Official no. of verific. doc. - Importnvarchar250CHAR(N' ')YesNACNU Allow NULL? 
54NACD3Verification documents: Date of verif.doc. for import procgnvarchar80DATS(N'00000000')YesNACDA Allow NULL? 
55NAIS3Verification doc: ISO code of ctry supplying verific.doc.nvarchar20CHAR(N' ')YesNAISO Allow NULL? 
56NAHO3Verification documents: Issuing authority for relev. verif.nvarchar100CHAR(N' ')YesT610ONAHOE Allow NULL? 
57NAUE3Verification docs: Validity date of verific.doc. for importnvarchar80DATS(N'00000000')YesNAUEL Allow NULL? 
58NACA4Verification documents: Type of certificate for importnvarchar100CHAR(N' ')YesT610NANACAR Allow NULL? 
59NACN4Verification docs: Official no. of verific. doc. - Importnvarchar250CHAR(N' ')YesNACNU Allow NULL? 
60NACD4Verification documents: Date of verif.doc. for import procgnvarchar80DATS(N'00000000')YesNACDA Allow NULL? 
61NAIS4Verification doc: ISO code of ctry supplying verific.doc.nvarchar20CHAR(N' ')YesNAISO Allow NULL? 
62NAHO4Verification documents: Issuing authority for relev. verif.nvarchar100CHAR(N' ')YesT610ONAHOE Allow NULL? 
63NAUE4Verification docs: Validity date of verific.doc. for importnvarchar80DATS(N'00000000')YesNAUEL Allow NULL? 
64NACA5Verification documents: Type of certificate for importnvarchar100CHAR(N' ')YesT610NANACAR Allow NULL? 
65NACN5Verification docs: Official no. of verific. doc. - Importnvarchar250CHAR(N' ')YesNACNU Allow NULL? 
66NACD5Verification documents: Date of verif.doc. for import procgnvarchar80DATS(N'00000000')YesNACDA Allow NULL? 
67NAIS5Verification doc: ISO code of ctry supplying verific.doc.nvarchar20CHAR(N' ')YesNAISO Allow NULL? 
68NAHO5Verification documents: Issuing authority for relev. verif.nvarchar100CHAR(N' ')YesT610ONAHOE Allow NULL? 
69NAUE5Verification docs: Validity date of verific.doc. for importnvarchar80DATS(N'00000000')YesNAUEL Allow NULL? 
70EXDARExport document: Export document type for foreign tradenvarchar100CHAR(N' ')YesT610VAEXDAR Allow NULL? 
71EXDAAExport document: Official number of export documentnvarchar250CHAR(N' ')YesEXDAA Allow NULL? 
72EXDABExport document: Valid-to number of export documentnvarchar250CHAR(N' ')YesEXDAB Allow NULL? 
73EXDTAT document: Type of T document for foreign tradenvarchar100CHAR(N' ')YesT610VAEXDTA Allow NULL? 
74EXDT2T document: Official number of T document for foreign tradenvarchar250CHAR(N' ')YesEXDT2 Allow NULL? 
75EXDTBT doc.: Official no. for next page of T doc. f.foreign tradenvarchar250CHAR(N' ')YesEXDTB Allow NULL? 
76EXDPAPreference: Preference type for foreign tradenvarchar100CHAR(N' ')YesT610PAEXDPA Allow NULL? 
77EXPREPreference: Official number of preference document - Exportnvarchar250CHAR(N' ')YesEXPRE Allow NULL? 
78EXDT5CAP: Official number of T5 document for foreign tradenvarchar250CHAR(N' ')YesEXDT5 Allow NULL? 
79AUSOKStatus: Document data in foreign trade complete (system)char10CHAR(N' ')YesAUSOK Allow NULL? 
80COIMPCode number for import processing in foreign tradenvarchar170CHAR(N' ')YesT604COIMP Allow NULL? 
81HERSEManufacturer number for import processing in foreign tradenvarchar100CHAR(N' ')YesLFA1HERSE Allow NULL? 
82COBLDImport code no. in destination country for foreign tradenvarchar170CHAR(N' ')YesT604COBLD Allow NULL? 
83EIOKWStatus: Complete document data in foreign trade (user)char10CHAR(N' ')YesEIOKW Allow NULL? 
84EIOKAEDI: Export/Import customs tariff number for foreign tradechar10CHAR(N' ')YesEIOKA Allow NULL? 
85GBNUMForeign Trade:Customs declaration list no. for Foreign Tradenvarchar200CHAR(N' ')YesGB_NR Allow NULL? 
86RGNNRRegistration number for import processing in foreign tradenvarchar200CHAR(N' ')YesRG_NR Allow NULL? 
87PRENCExemption certificate: Indicator for legal controlchar10CHAR(N' ')YesPRENC Allow NULL? 
88PRENOExemption certificate number for legal controlnvarchar80CHAR(N' ')YesPRENN Allow NULL? 
89PRENDExemption certificate: Issue date of exemption certificatenvarchar80DATS(N'00000000')YesPREND Allow NULL? 
90KTNUMQuota or Ceiling Number for Import Processingnvarchar100CHAR(N' ')YesT610KPKTPLN Allow NULL? 
91PLNUMQuota or Ceiling Number for Import Processingnvarchar100CHAR(N' ')YesT610KPKTPLN Allow NULL? 
92POSARItem typechar10CHAR(N' ')YesPOSAR Allow NULL? 
93PSTYVSales document item categorynvarchar40CHAR(N' ')Yes*PSTYV Allow NULL? 
NamePrimaryUniqueTypeColumns
EIPO~0YesYesCLUSTEREDEXPOS, EXNUM, 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