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  | VESED
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.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 TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT 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 number for Intrastat declarationnvarchar70NUMC(N'0000000')NoLFDNR_VEIA Allow NULL? 
6USERNNAMEName of Person who Created the Objectnvarchar120CHAR(N' ')NoERNAM Allow NULL? 
7SATZERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')NoERDAT Allow NULL? 
8NUMMBUKRSCompany Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
9VERKAUFORSales Organizationnvarchar40CHAR(N' ')No*VKORG Allow NULL? 
10EIGENUINRVAT Registration Numbernvarchar200CHAR(N' ')NoSTCEG Allow NULL? 
11EIGENBLNDState of manufacturenvarchar20CHAR(N' ')NoHERBL Allow NULL? 
12BELEGNUMRBilling Documentnvarchar100CHAR(N' ')No*VBELN_VF Allow NULL? 
13HAUPTPOSIBilling itemnvarchar60NUMC(N'000000')No*POSNR_VF Allow NULL? 
14MATERIALNMaterial Numbernvarchar60CHAR(N' ')NoMATNR_INTR Allow NULL? 
15FAKTDATUMBilling date for billing index and printoutnvarchar80DATS(N'00000000')NoFKDAT Allow NULL? 
16VERSENDERImporter HQ / Exporter HQchar10CHAR(N' ')NoVERSENDER Allow NULL? 
17BESTILANDCountry of destination of materialnvarchar30CHAR(N' ')No*BESTILAND Allow NULL? 
18BESTIREGIDestination regionnvarchar30CHAR(N' ')No*BESTIREGI Allow NULL? 
19ARTGESCHABusiness Transaction Type for Foreign Tradenvarchar20CHAR(N' ')No*EXART Allow NULL? 
20VERKEHRZWMode of Transport for Foreign Tradechar10CHAR(N' ')No*EXPVZ Allow NULL? 
21EINLADFGHCustoms Office: Office of Exit/Entry for Foreign Tradenvarchar60CHAR(N' ')No*DZOLLS Allow NULL? 
22STATWARENCommodity Code/Import Code Number for Foreign Tradenvarchar170CHAR(N' ')No*STAWN Allow NULL? 
23URSPRSLNDCountry Keynvarchar30CHAR(N' ')No*LAND1 Allow NULL? 
24URSPRSREGRegion of origin of material (non-preferential origin)nvarchar30CHAR(N' ')No*HERKR Allow NULL? 
25VERFAHRENExport/Import Procedure for Foreign Tradenvarchar80CHAR(N' ')No*EXPRF Allow NULL? 
26EIGENMASSTare mass in kilogramsnvarchar150NUMC(N'000000000000000')NoEIGENMASS Allow NULL? 
27BESONMASSSupplementary unitnvarchar150NUMC(N'000000000000000')NoBESONMASS Allow NULL? 
28BESOEINHESupplementary unitnvarchar30UNIT(N' ')No*BEMEH Allow NULL? 
29BRUTTOGEWDeclaration to the Authority: Gross weightnvarchar150NUMC(N'000000000000000')NoBRUTTOGEW Allow NULL? 
30EIGENEINHWeight Unitnvarchar30UNIT(N' ')No*GEWEI Allow NULL? 
31RECHNWERTInvoice valuenvarchar150NUMC(N'000000000000000')NoRECHNWERT Allow NULL? 
32GRENZWERTStatistical valuenvarchar150NUMC(N'000000000000000')NoGRENZWERT Allow NULL? 
33VERBUNDFICompany ID of trading partnernvarchar60CHAR(N' ')No*RASSC Allow NULL? 
34CONTAINERID: Goods cross border in a containerchar10CHAR(N' ')NoCONTA Allow NULL? 
35AUSLADFGHCustoms office: Office of destination for foreign tradenvarchar60CHAR(N' ')No*DZOLLB Allow NULL? 
36GENEHMIDEAERP/SED: Relevance for AERP/SED message, NAFTAchar10CHAR(N' ')NoSEDSP Allow NULL? 
37SPECIIDFISED: Special record ID for transmitting to customsnvarchar20CHAR(N' ')NoSPECIIDFI Allow NULL? 
38MEXICOSTAExport declaration: description of region (Mexico)nvarchar30CHAR(N' ')No*MEXICOSTA Allow NULL? 
39AIRCARCODSED: Air Carrier Codenvarchar40CHAR(N' ')NoAIRCARCOD Allow NULL? 
40FTZNUMEROExport control: Membership of an economic areanvarchar60CHAR(N' ')NoINDWR Allow NULL? 
41ECCNNUMERExport control class according the legal reg. for legal ctrlnvarchar140CHAR(N' ')No*ALNUM Allow NULL? 
42EXGENEHMNExternal license numbernvarchar200CHAR(N' ')NoEXGEN Allow NULL? 
43POSTLEITZPostal Codenvarchar100CHAR(N' ')NoPSTLZ Allow NULL? 
44FIRMAUTHOSED: Official ID for export companies (S.A.S.)nvarchar20CHAR(N' ')NoFIRMAUTHO Allow NULL? 
45BEFOERLNDCountry of Origin of the Means of Transport at Departurenvarchar30CHAR(N' ')No*STABE Allow NULL? 
46AUSGALANDDeparture country (country from which the goods are sent)nvarchar30CHAR(N' ')No*ALAND Allow NULL? 
47INTRANSITSED: ID for export in transitchar10CHAR(N' ')NoINTRANSIT Allow NULL? 
48FHAUSLANDDelivering countrynvarchar30CHAR(N' ')No*HLAND Allow NULL? 
49VESSELNAMIndicator for the means of transport at departurenvarchar300CHAR(N' ')NoKZABE Allow NULL? 
50EINKAUFORPurchasing Organizationnvarchar40CHAR(N' ')No*EKORG Allow NULL? 
51BELEGIDENSD document categorychar10CHAR(N' ')NoVBTYP Allow NULL? 
52RETOURCODReturns ID for official declarationschar10CHAR(N' ')NoRETOURCOD Allow NULL? 
53SERVAGENTNAFTA: Definition of data record for exporter/fwd. agentchar10CHAR(N' ')NoSERVAGENT Allow NULL? 
54AIRWAYBILMeans of Transport IDnvarchar200CHAR(N' ')NoTRAID Allow NULL? 
55STATWAERSStatistics currencynvarchar50CUKY(N' ')No*STWAE Allow NULL? 
56BESTIAERPSED: Country of destinationnvarchar50CHAR(N' ')NoBESTI_SED Allow NULL? 
57ALANDAERPSED: Delivery countrynvarchar50CHAR(N' ')NoALAND_SED Allow NULL? 
58HLANDAERPSED: Base countrynvarchar50CHAR(N' ')NoHLAND_SED Allow NULL? 
59URSPRAERPSED: Country of origin for USA declarationnvarchar50CHAR(N' ')NoLAND1_SED Allow NULL? 
60GENEHMCODAERP/SED: Official code for type of control master recordnvarchar40CHAR(N' ')NoSEDIM Allow NULL? 
61NUMMWERKSPlantnvarchar40CHAR(N' ')NoT001WWERKS_D Allow NULL? 
62WERKSLANDDeclaration to authorities: Country of Plantnvarchar30CHAR(N' ')No*WERKSLAND Allow NULL? 
63RECHNWEAKInvoice valuedecimal152CURR((0))YesRECHNWEAK
64RECHNWEEHCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
65GRENZWEAKStatistical valuedecimal132CURR((0))YesGRENZWEAK
66GRENZWEEHCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
67EIGENMAAKTare massdecimal133QUAN((0))YesEIGENMAAK
68EIGENMAEHWeight Unitnvarchar30UNIT(N' ')YesT006GEWEI Allow NULL? 
69BESONMAAKSpecial unit of measuredecimal133QUAN((0))YesBESONMAAK
70BESONMAEHWeight Unitnvarchar30UNIT(N' ')YesT006GEWEI Allow NULL? 
71IREFBELEGReference documentnvarchar100CHAR(N' ')Yes*IREFBELEG Allow NULL? 
72IREFPOSITReference itemnvarchar60NUMC(N'000000')Yes*IREFPOSIT Allow NULL? 
73IREFMONATReference month for correctionnvarchar20NUMC(N'00')YesIREFMONAT Allow NULL? 
74IREFEJAHRReference year for correctionnvarchar40NUMC(N'0000')YesIREFEJAHR Allow NULL? 
75ORDPAClassification Key for Periodic Declarations in For. Tradenvarchar100CHAR(N' ')YesORDPA Allow NULL? 
76THIERISCHID type for creating recordschar10CHAR(N' ')YesTHIERISCH Allow NULL? 
77ISESSIONEIndicator for normal business transactions and correctionchar10CHAR(N' ')YesISESSIONE Allow NULL? 
NamePrimaryUniqueTypeColumns
VESED~0YesYesCLUSTEREDMANDT, DATUMJAHR, DATUMMONA, ARRIVDEPA, LFDNRVEIA
VESED~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