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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data
Sales and Distribution :: Foreign Trade :: Basic Functions
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VESED772SED / AERP ExportBasic 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, USERNNAME, SATZERDAT, NUMMBUKRS, VERKAUFOR, EIGENUINR, EIGENBLND, BELEGNUMR, HAUPTPOSI, MATERIALN, FAKTDATUM, VERSENDER, BESTILAND, BESTIREGI, ARTGESCHA, VERKEHRZW, EINLADFGH, STATWAREN, URSPRSLND, URSPRSREG, VERFAHREN, EIGENMASS, BESONMASS, BESOEINHE, BRUTTOGEW, EIGENEINH, RECHNWERT, GRENZWERT, VERBUNDFI, CONTAINER, AUSLADFGH, GENEHMIDE, SPECIIDFI, MEXICOSTA, AIRCARCOD, FTZNUMERO, ECCNNUMER, EXGENEHMN, POSTLEITZ, FIRMAUTHO, BEFOERLND, AUSGALAND, INTRANSIT, FHAUSLAND, VESSELNAM, EINKAUFOR, BELEGIDEN, RETOURCOD, SERVAGENT, AIRWAYBIL, STATWAERS, BESTIAERP, ALANDAERP, HLANDAERP, URSPRAERP, GENEHMCOD, NUMMWERKS, WERKSLAND, RECHNWEAK, RECHNWEEH, GRENZWEAK, GRENZWEEH, EIGENMAAK, EIGENMAEH, BESONMAAK, BESONMAEH, IREFBELEG, IREFPOSIT, IREFMONAT, IREFEJAHR, ORDPA, THIERISCH, ISESSIONE FROM VESED
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2DATUMJAHRReporting year of declaration to authoritiesnvarchar40 Allow NULL? 
3DATUMMONAReporting month of declaration to authoritiesnvarchar20 Allow NULL? 
4ARRIVDEPAIndicator: Goods direction for declarations to authoritieschar10 Allow NULL? 
5LFDNRVEIASequential number for Intrastat declarationnvarchar70 Allow NULL? 
6USERNNAMEName of Person who Created the Objectnvarchar120 Allow NULL? 
7SATZERDATDate on Which Record Was Creatednvarchar80 Allow NULL? 
8NUMMBUKRSCompany Codenvarchar40 Allow NULL? 
9VERKAUFORSales Organizationnvarchar40 Allow NULL? 
10EIGENUINRVAT Registration Numbernvarchar200 Allow NULL? 
11EIGENBLNDState of manufacturenvarchar20 Allow NULL? 
12BELEGNUMRBilling Documentnvarchar100 Allow NULL? 
13HAUPTPOSIBilling itemnvarchar60 Allow NULL? 
14MATERIALNMaterial Numbernvarchar60 Allow NULL? 
15FAKTDATUMBilling date for billing index and printoutnvarchar80 Allow NULL? 
16VERSENDERImporter HQ / Exporter HQchar10 Allow NULL? 
17BESTILANDCountry of destination of materialnvarchar30 Allow NULL? 
18BESTIREGIDestination regionnvarchar30 Allow NULL? 
19ARTGESCHABusiness Transaction Type for Foreign Tradenvarchar20 Allow NULL? 
20VERKEHRZWMode of Transport for Foreign Tradechar10 Allow NULL? 
21EINLADFGHCustoms Office: Office of Exit/Entry for Foreign Tradenvarchar60 Allow NULL? 
22STATWARENCommodity Code/Import Code Number for Foreign Tradenvarchar170 Allow NULL? 
23URSPRSLNDCountry Keynvarchar30 Allow NULL? 
24URSPRSREGRegion of origin of material (non-preferential origin)nvarchar30 Allow NULL? 
25VERFAHRENExport/Import Procedure for Foreign Tradenvarchar80 Allow NULL? 
26EIGENMASSTare mass in kilogramsnvarchar150 Allow NULL? 
27BESONMASSSupplementary unitnvarchar150 Allow NULL? 
28BESOEINHESupplementary unitnvarchar30 Allow NULL? 
29BRUTTOGEWDeclaration to the Authority: Gross weightnvarchar150 Allow NULL? 
30EIGENEINHWeight Unitnvarchar30 Allow NULL? 
31RECHNWERTInvoice valuenvarchar150 Allow NULL? 
32GRENZWERTStatistical valuenvarchar150 Allow NULL? 
33VERBUNDFICompany ID of trading partnernvarchar60 Allow NULL? 
34CONTAINERID: Goods cross border in a containerchar10 Allow NULL? 
35AUSLADFGHCustoms office: Office of destination for foreign tradenvarchar60 Allow NULL? 
36GENEHMIDEAERP/SED: Relevance for AERP/SED message, NAFTAchar10 Allow NULL? 
37SPECIIDFISED: Special record ID for transmitting to customsnvarchar20 Allow NULL? 
38MEXICOSTAExport declaration: description of region (Mexico)nvarchar30 Allow NULL? 
39AIRCARCODSED: Air Carrier Codenvarchar40 Allow NULL? 
40FTZNUMEROExport control: Membership of an economic areanvarchar60 Allow NULL? 
41ECCNNUMERExport control class according the legal reg. for legal ctrlnvarchar140 Allow NULL? 
42EXGENEHMNExternal license numbernvarchar200 Allow NULL? 
43POSTLEITZPostal Codenvarchar100 Allow NULL? 
44FIRMAUTHOSED: Official ID for export companies (S.A.S.)nvarchar20 Allow NULL? 
45BEFOERLNDCountry of Origin of the Means of Transport at Departurenvarchar30 Allow NULL? 
46AUSGALANDDeparture country (country from which the goods are sent)nvarchar30 Allow NULL? 
47INTRANSITSED: ID for export in transitchar10 Allow NULL? 
48FHAUSLANDDelivering countrynvarchar30 Allow NULL? 
49VESSELNAMIndicator for the means of transport at departurenvarchar300 Allow NULL? 
50EINKAUFORPurchasing Organizationnvarchar40 Allow NULL? 
51BELEGIDENSD document categorychar10 Allow NULL? 
52RETOURCODReturns ID for official declarationschar10 Allow NULL? 
53SERVAGENTNAFTA: Definition of data record for exporter/fwd. agentchar10 Allow NULL? 
54AIRWAYBILMeans of Transport IDnvarchar200 Allow NULL? 
55STATWAERSStatistics currencynvarchar50 Allow NULL? 
56BESTIAERPSED: Country of destinationnvarchar50 Allow NULL? 
57ALANDAERPSED: Delivery countrynvarchar50 Allow NULL? 
58HLANDAERPSED: Base countrynvarchar50 Allow NULL? 
59URSPRAERPSED: Country of origin for USA declarationnvarchar50 Allow NULL? 
60GENEHMCODAERP/SED: Official code for type of control master recordnvarchar40 Allow NULL? 
61NUMMWERKSPlantnvarchar40 Allow NULL? 
62WERKSLANDDeclaration to authorities: Country of Plantnvarchar30 Allow NULL? 
63RECHNWEAKInvoice valuedecimal152
64RECHNWEEHCurrency Keynvarchar50 Allow NULL? 
65GRENZWEAKStatistical valuedecimal132
66GRENZWEEHCurrency Keynvarchar50 Allow NULL? 
67EIGENMAAKTare massdecimal133
68EIGENMAEHWeight Unitnvarchar30 Allow NULL? 
69BESONMAAKSpecial unit of measuredecimal133
70BESONMAEHWeight Unitnvarchar30 Allow NULL? 
71IREFBELEGReference documentnvarchar100 Allow NULL? 
72IREFPOSITReference itemnvarchar60 Allow NULL? 
73IREFMONATReference month for correctionnvarchar20 Allow NULL? 
74IREFEJAHRReference year for correctionnvarchar40 Allow NULL? 
75ORDPAClassification Key for Periodic Declarations in For. Tradenvarchar100 Allow NULL? 
76THIERISCHID type for creating recordschar10 Allow NULL? 
77ISESSIONEIndicator for normal business transactions and correctionchar10 Allow NULL? 
NamePrimaryUniqueTypeColumns
VESED~0YesYesCLUSTEREDMANDT, DATUMJAHR, DATUMMONA, ARRIVDEPA, LFDNRVEIA
VESED~BNoNoNONCLUSTEREDMANDT, NUMMBUKRS, NUMMWERKS