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  | VEXAV
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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
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
10OINM101Whse Journal
Sales and Distribution :: Foreign Trade :: Basic Functions
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VEXAV772EXTRASTAT / VAR Export/ImportBasic Functions
SQL:  selectupdate insert create

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

SELECT MANDT, DATUMJAHR, DATUMMONA, ARRIVDEPA, LFDNRVEIA, NUMMBUKRS, USERNNAME, SATZERDAT, VERKAUFOR, BELEGNUMR, HAUPTPOSI, MATERIALN, FIRMENNUM, VERSENDER, HANDELSLD, BESTILAND, CONTAINER, STAATSZUG, ARTGESCHA, VERKEHRZW, EINLADFGH, STATWAREN, URSPRSLND, URSPRSREG, VERFAHREN, EIGENMASS, BESONMASS, GRENZWERT, RECHNWERT, VERAMONAT, RUECKERST, BEWIPFLIC, BEWINUMME, RETOURCOD, POSTLEITZ, NUMMWERKS, WERKSLAND, INLAIEVER, LIEFERBED, BESTIREGI, VERSENDLD, EINKAUFOR, FAKTDATUM, PREFPACOD, THIERISCH, RECHNWEAK, RECHNWEEH, GRENZWEAK, GRENZWEEH, EIGENMAAK, EIGENMAEH, BESONMAAK, BESONMAEH, IREFBELEG, IREFPOSIT, IREFMONAT, IREFEJAHR, BELEGIDEN, GENES, P_LANDKEY, FLAGEUROC, KUNDEUINR, EIGENUINR, WARENORTE, STAATSABG, SPANIENID, PLISO, DOMCODENR, MATNR, LIFNR, KUNNR, ORDPA, ISESSIONE, CNTRYDECLN, EUBELAND, INVOICECY, ZOLLVERFA FROM VEXAV
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2DATUMJAHRReporting year of declaration to authoritiesnvarchar40NUMC(N'0000')NoDATUMJAHR Allow NULL? 
3DATUMMONAReporting month of declaration to authoritiesnvarchar20NUMC(N'00')NoDATUMMONA Allow NULL? 
4ARRIVDEPAIndicator: Goods direction for declarations to authoritieschar10NUMC(N'0')NoVEREI Allow NULL? 
5LFDNRVEIASequential no.for Extrastat declarationnvarchar70NUMC(N'0000000')NoLFDNR_VEEA Allow NULL? 
6NUMMBUKRSCompany Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
7USERNNAMEName of Person who Created the Objectnvarchar120CHAR(N' ')NoERNAM Allow NULL? 
8SATZERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')NoERDAT Allow NULL? 
9VERKAUFORSales Organizationnvarchar40CHAR(N' ')NoTVKOVKORG Allow NULL? 
10BELEGNUMRDocument numbernvarchar100CHAR(N' ')No*BELEGNUMR Allow NULL? 
11HAUPTPOSIItemnvarchar60NUMC(N'000000')No*HAUPTPOSI Allow NULL? 
12MATERIALNEXTRASTAT material no. for decl. to auth. for Foreign Tradenvarchar60CHAR(N' ')NoEXMNR Allow NULL? 
13FIRMENNUMCompany no. EXTRASTAT for declar. to auth. for Foreign Tradenvarchar70CHAR(N' ')NoEXFNR Allow NULL? 
14VERSENDERImporter HQ / Exporter HQchar10CHAR(N' ')NoVERSENDER Allow NULL? 
15HANDELSLDTrading countrynvarchar30CHAR(N' ')NoT005HANDELSLD Allow NULL? 
16BESTILANDCountry of destination of materialnvarchar30CHAR(N' ')NoT005BESTILAND Allow NULL? 
17CONTAINERID: Goods cross border in a containerchar10CHAR(N' ')NoCONTA Allow NULL? 
18STAATSZUGOrigin of Means of Transport when Crossing the Bordernvarchar30CHAR(N' ')NoT005STGBE Allow NULL? 
19ARTGESCHABusiness Transaction Type for Foreign Tradenvarchar20CHAR(N' ')NoT605EXART Allow NULL? 
20VERKEHRZWMode of Transport for Foreign Tradechar10CHAR(N' ')NoT618EXPVZ Allow NULL? 
21EINLADFGHCustoms Office: Office of Exit/Entry for Foreign Tradenvarchar60CHAR(N' ')NoT615DZOLLS Allow NULL? 
22STATWARENCommodity Code/Import Code Number for Foreign Tradenvarchar170CHAR(N' ')NoT604STAWN Allow NULL? 
23URSPRSLNDCountry of origin of the materialnvarchar30CHAR(N' ')NoT005HERKL Allow NULL? 
24URSPRSREGRegion of originnvarchar30CHAR(N' ')No*URSPRSREG Allow NULL? 
25VERFAHRENExport/Import Procedure for Foreign Tradenvarchar80CHAR(N' ')NoT616EXPRF Allow NULL? 
26EIGENMASSTare mass in kilogramsnvarchar150NUMC(N'000000000000000')NoEIGENMASS Allow NULL? 
27BESONMASSSupplementary unitnvarchar150NUMC(N'000000000000000')NoBESONMASS Allow NULL? 
28GRENZWERTStatistical valuenvarchar150NUMC(N'000000000000000')NoGRENZWERT Allow NULL? 
29RECHNWERTInvoice valuenvarchar150NUMC(N'000000000000000')NoRECHNWERT Allow NULL? 
30VERAMONATProcessing month (Switzerland)char10CHAR(N' ')NoVERAMONAT Allow NULL? 
31RUECKERSTReimbursement code (Confederation Helvetica)char10NUMC(N'0')NoRUECKERST Allow NULL? 
32BEWIPFLICLicense requirement (CH only)char10NUMC(N'0')NoBEWIPFLIC Allow NULL? 
33BEWINUMMEApproval numbernvarchar50NUMC(N'00000')NoBEWINUMME Allow NULL? 
34RETOURCODReturns ID for official declarationschar10CHAR(N' ')NoRETOURCOD Allow NULL? 
35POSTLEITZPostal Codenvarchar100CHAR(N' ')NoPSTLZ Allow NULL? 
36NUMMWERKSPlantnvarchar40CHAR(N' ')NoT001WWERKS_D Allow NULL? 
37WERKSLANDDeclaration to authorities: Country of Plantnvarchar30CHAR(N' ')YesT005WERKSLAND Allow NULL? 
38INLAIEVERDomestic Mode of Transport for Foreign Tradechar10CHAR(N' ')YesT618IEVER Allow NULL? 
39LIEFERBEDIncoterms (Part 1)nvarchar30CHAR(N' ')YesTINCINCO1 Allow NULL? 
40BESTIREGIDestination regionnvarchar30CHAR(N' ')Yes*BESTIREGI Allow NULL? 
41VERSENDLDCountry of dispatchnvarchar30CHAR(N' ')YesT005VERSENDLD Allow NULL? 
42EINKAUFORPurchasing Organizationnvarchar40CHAR(N' ')YesT024EEKORG Allow NULL? 
43FAKTDATUMBilling date for billing index and printoutnvarchar80DATS(N'00000000')YesFKDAT Allow NULL? 
44PREFPACODPreference code for foreign trade (decl.to author., import)nvarchar30CHAR(N' ')YesT604CPREFPACOD Allow NULL? 
45THIERISCHID type for creating recordschar10CHAR(N' ')YesTHIERISCH Allow NULL? 
46RECHNWEAKInvoice valuedecimal152CURR((0))YesRECHNWEAK
47RECHNWEEHCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
48GRENZWEAKStatistical valuedecimal132CURR((0))YesGRENZWEAK
49GRENZWEEHCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
50EIGENMAAKTare massdecimal133QUAN((0))YesEIGENMAAK
51EIGENMAEHWeight Unitnvarchar30UNIT(N' ')YesT006GEWEI Allow NULL? 
52BESONMAAKSpecial unit of measuredecimal133QUAN((0))YesBESONMAAK
53BESONMAEHWeight Unitnvarchar30UNIT(N' ')YesT006GEWEI Allow NULL? 
54IREFBELEGReference documentnvarchar100CHAR(N' ')Yes*IREFBELEG Allow NULL? 
55IREFPOSITReference itemnvarchar60NUMC(N'000000')Yes*IREFPOSIT Allow NULL? 
56IREFMONATReference month for correctionnvarchar20NUMC(N'00')YesIREFMONAT Allow NULL? 
57IREFEJAHRReference year for correctionnvarchar40NUMC(N'0000')YesIREFEJAHR Allow NULL? 
58BELEGIDENSD document categorychar10CHAR(N' ')YesVBTYP Allow NULL? 
59GENESData origin indicator for declarations to the authoritieschar10CHAR(N' ')YesGENES Allow NULL? 
60P_LANDKEYCountry keychar10CHAR(N' ')YesP_LANDKEY Allow NULL? 
61FLAGEUROCDeclarations to the authorities: Ind. for decl. crcy = Eurochar10CHAR(N' ')YesFTEUR Allow NULL? 
62KUNDEUINRVAT Registration Numbernvarchar200CHAR(N' ')YesSTCEG Allow NULL? 
63EIGENUINRVAT Registration Numbernvarchar200CHAR(N' ')YesSTCEG Allow NULL? 
64WARENORTEDescriptionnvarchar200CHAR(N' ')YesBEZEI20 Allow NULL? 
65STAATSABGCountry of Origin of the Means of Transport at Departurenvarchar30CHAR(N' ')YesT005STABE Allow NULL? 
66SPANIENIDIndicator: Domestic / Foreignchar10CHAR(N' ')YesINAUKZ Allow NULL? 
67PLISOPeriodic Declarations: ISO country code of business partnernvarchar20CHAR(N' ')YesFTPLISO Allow NULL? 
68DOMCODENROverseas areas France (DoM)char10CHAR(N' ')YesDOMCODE Allow NULL? 
69MATNRMaterial Numbernvarchar180CHAR(N' ')YesMARAMATNR Allow NULL? 
70LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')YesLFA1LIFNR Allow NULL? 
71KUNNRCustomer Numbernvarchar100CHAR(N' ')YesKNA1KUNNR Allow NULL? 
72ORDPAClassification Key for Periodic Declarations in For. Tradenvarchar100CHAR(N' ')YesORDPA Allow NULL? 
73ISESSIONEIndicator for normal business transactions and correctionchar10CHAR(N' ')YesISESSIONE Allow NULL? 
74CNTRYDECLNCountry of Export Declarationnvarchar30CHAR(N' ')YesT005CODECL Allow NULL? 
75EUBELANDEU Country of Departure/Destinationnvarchar30CHAR(N' ')YesT005EUBELAND Allow NULL? 
76INVOICECYInvoice Currencynvarchar50CUKY(N' ')YesTCURCINVOICECY Allow NULL? 
77ZOLLVERFAExport/Import Procedure for Foreign Tradenvarchar80CHAR(N' ')Yes*EXPRF Allow NULL? 
NamePrimaryUniqueTypeColumns
VEXAV~0YesYesCLUSTEREDMANDT, DATUMJAHR, DATUMMONA, ARRIVDEPA, LFDNRVEIA
VEXAV~BNoNoNONCLUSTEREDMANDT, NUMMBUKRS, NUMMWERKS

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