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  | VEKP
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
Logistics - General :: Handling Unit Management :: Basic functions
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VEKP1414Handling Unit - Header TableBasic functions
SQL:  selectupdate insert create

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

SELECT MANDT, VENUM, EXIDV, EXIDA, VSTEL, LSTEL, BRGEW, NTGEW, MAGEW, TARAG, GEWEI, BTVOL, NTVOL, MAVOL, TAVOL, VOLEH, ANZGL, ERNAM, ERDAT, ERUHR, AENAM, AEDAT, AEZET, SORTL, VEGR1, VEGR2, VEGR3, VEGR4, VEGR5, VHILM, LAENG, BREIT, HOEHE, MEABM, ERLKZ, GEWTO, VOLTO, MEINS, VOLEH_MAX, GEWEI_MAX, VBELN_GEN, POSNR_GEN, INHALT, VHART, KAPPL, KALSM, KSCHL, MAGRV, WERKS, PSTYV, VKORG, VTWEG, LADLG, LADEH, FARZT, FAREH, ENTFE, EHENT, LGORT, GEWFX, VELTP, EXIDV2, LANDT, LANDF, NAMEF, NAMBE, VHILM_KU, VPOBJ, VPOBJKEY, HANDLE, WMSTA, LGNUM, SAPRL, KZGVH, ADGE_DG, ADGE_DGPR, UEVEL, PACKVORSCHR, PACKVORSCHR_ST, LABELTYP, ZUL_AUFL, STATUS, HU_LGORT, HU_SYSTEM, SPE_HDALL, SPE_VLSTK, SPE_DELDEC, SPE_IDART_01, SPE_IDENT_01, SPE_IDART_02, SPE_IDENT_02, SPE_IDART_03, SPE_IDENT_03, SPE_IDART_04, SPE_IDENT_04, SPE_LOGPOS, SPE_CHK_COUNTER, EPC1, EPC2, PACKAGE_CAT, TRANSP_INDEX, CRIT_SAF_INDEX, FLG_DG_PACKAGE, DG_PACKAGE_LEVEL, PACKCODE, INSTR_ENCL_CAT, MAT_DAMAGED_CL7, DOSE_RATE_BULK, DOSE_RATE_BULK_U, DOSE_RATE_PACK, U_DOSE_RATE_PACK, LEADING_LWDG, MAX_GROSS_WEIGHT, U_MAX_GROSS_WGHT, LYARD, YLCCL, YLOCT, STATS, PRRTY, FWAGN, SCACD, OWNER, TRNPD, SEALN1, SEALN2, SEALN3, SEALN4, SEALN5, BLIND, RSNCD, RFTYP, REFER, PTMST, ATMST, YDOOR, YSTGA, URGFL, PRFLG, SLFLG, SIGNI, LTEXT FROM VEKP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VENUMInternal Handling Unit Numbernvarchar100CHAR(N' ')NoVENUM Allow NULL? 
3EXIDVExternal Handling Unit Identificationnvarchar200CHAR(N' ')YesEXIDV Allow NULL? 
4EXIDAType of External Handling Unit Identifierchar10CHAR(N' ')YesEXIDA Allow NULL? 
5VSTELShipping Point/Receiving Pointnvarchar40CHAR(N' ')YesTVSTVSTEL Allow NULL? 
6LSTELLoading Pointnvarchar20CHAR(N' ')YesTVLALSTEL Allow NULL? 
7BRGEWTotal Weight of Handling Unitdecimal153QUAN((0))YesBRGEW_VEKP
8NTGEWLoading Weight of Handling Unitdecimal153QUAN((0))YesNTGEW_VEKP
9MAGEWAllowed Loading Weight of a Handling Unitdecimal153QUAN((0))YesMAGEW_VEKP
10TARAGTare weight of handling unitdecimal153QUAN((0))YesTARAG_VEKP
11GEWEIWeight Unitnvarchar30UNIT(N' ')YesT006GEWEI Allow NULL? 
12BTVOLTotal Volume of Handling Unitdecimal153QUAN((0))YesBTVOL_VEKP
13NTVOLLoading Volume of Handling Unitdecimal153QUAN((0))YesNTVOL_VEKP
14MAVOLAllowed Loading Volume for Handling Unitdecimal153QUAN((0))YesMAVOL_VEKP
15TAVOLTare volume of handling unitdecimal153QUAN((0))YesTAVOL_VEKP
16VOLEHVolume unitnvarchar30UNIT(N' ')YesT006VOLEH Allow NULL? 
17ANZGLNumber of Similar Packaging Materialsint100INT4((0))YesANZGL Allow NULL? 
18ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
19ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
20ERUHREntry timenvarchar60TIMS(N'000000')YesERZET Allow NULL? 
21AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
22AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
23AEZETTime last change was madenvarchar60TIMS(N'000000')YesAEZET Allow NULL? 
24SORTLSort fieldnvarchar100CHAR(N' ')YesSORTL Allow NULL? 
25VEGR1Handling Unit Group 1 (Freely Definable)nvarchar50CHAR(N' ')YesTVE1VEGR1 Allow NULL? 
26VEGR2Handling Unit Group 2 (Freely Definable)nvarchar50CHAR(N' ')YesTVE2VEGR2 Allow NULL? 
27VEGR3Handling Unit Group 3 (Freely Definable)nvarchar50CHAR(N' ')YesTVE3VEGR3 Allow NULL? 
28VEGR4Handling Unit Group 4 (Freely Definable)nvarchar50CHAR(N' ')YesTVE4VEGR4 Allow NULL? 
29VEGR5Handling Unit Group 5 (Freely Definable)nvarchar50CHAR(N' ')YesTVE5VEGR5 Allow NULL? 
30VHILMPackaging Materialsnvarchar180CHAR(N' ')YesMARAVHILM Allow NULL? 
31LAENGLengthdecimal133QUAN((0))YesLAENG
32BREITWidthdecimal133QUAN((0))YesBREIT
33HOEHEHeightdecimal133QUAN((0))YesHOEHE
34MEABMUnit of Dimension for Length/Width/Heightnvarchar30UNIT(N' ')YesT006MEABM Allow NULL? 
35ERLKZStatus (at this time without functionality)char10CHAR(N' ')YesVOLLS Allow NULL? 
36GEWTOExcess Weight Tolerance for Handling unitdecimal31DEC((0))YesGEWTO
37VOLTOExcess Volume Tolerance of the Handling Unitdecimal31DEC((0))YesVOLTO
38MEINSBase Unit of Measurenvarchar30UNIT(N' ')YesT006MEINS Allow NULL? 
39VOLEH_MAXVolume unitnvarchar30UNIT(N' ')YesT006VOLEH Allow NULL? 
40GEWEI_MAXWeight Unitnvarchar30UNIT(N' ')YesT006GEWEI Allow NULL? 
41VBELN_GENDelivery in Which Packaging Material Is Generated as an Itemnvarchar100CHAR(N' ')Yes*VBELN_GEN Allow NULL? 
42POSNR_GENGenerated delivery itemnvarchar60NUMC(N'000000')Yes*POSNR_GEN Allow NULL? 
43INHALTDescription of Handling Unit Contentnvarchar400CHAR(N' ')YesINHALT Allow NULL? 
44VHARTPackaging Material Typenvarchar40CHAR(N' ')YesTVTYVHIART Allow NULL? 
45KAPPLApplication for output conditionsnvarchar20CHAR(N' ')Yes*NA_KAPPL Allow NULL? 
46KALSMOutput determination procedurenvarchar60CHAR(N' ')Yes*KALSMB Allow NULL? 
47KSCHLOutput Typenvarchar40CHAR(N' ')Yes*NA_KSCHL Allow NULL? 
48MAGRVMaterial Group: Packaging Materialsnvarchar40CHAR(N' ')YesTVEGRMAGRV Allow NULL? 
49WERKSPlantnvarchar40CHAR(N' ')YesMARCHUM_WERKS Allow NULL? 
50PSTYVSales document item categorynvarchar40CHAR(N' ')YesTVPTPSTYV Allow NULL? 
51VKORGSales Organizationnvarchar40CHAR(N' ')Yes*VKORG Allow NULL? 
52VTWEGReference distrib.channel for cust.and material mastersnvarchar20CHAR(N' ')Yes*VTWKU Allow NULL? 
53LADLGLgth of loading platform in lgth of LdPlat measurement unitsdecimal60QUAN((0))YesLADLG
54LADEHUnit of measure to measure the length of loading platformnvarchar30UNIT(N' ')YesT006LADEH Allow NULL? 
55FARZTTravel Timedecimal30QUAN((0))YesFARZT
56FAREHUnit of travel timenvarchar30UNIT(N' ')YesT006FAREH Allow NULL? 
57ENTFEDistance Travelleddecimal60QUAN((0))YesENTFE
58EHENTUnit of distancenvarchar30UNIT(N' ')YesT006EHENT Allow NULL? 
59LGORTStorage Locationnvarchar40CHAR(N' ')YesMARDHUM_LGORT Allow NULL? 
60GEWFXWeight and Volume Fixedchar10CHAR(N' ')YesGEWFX Allow NULL? 
61VELTPPackaging Material Categorychar10CHAR(N' ')YesVELTP Allow NULL? 
62EXIDV2Handling Unit's 2nd External Identificationnvarchar200CHAR(N' ')YesEXIDV2 Allow NULL? 
63LANDTCountry providing means of transportnvarchar30CHAR(N' ')YesT005LANDT Allow NULL? 
64LANDFDriver's Nationalitynvarchar30CHAR(N' ')YesT005LANDF Allow NULL? 
65NAMEFDriver namenvarchar350CHAR(N' ')YesNAMEF Allow NULL? 
66NAMBEAlternate Driver's Namenvarchar350CHAR(N' ')YesNAMBE Allow NULL? 
67VHILM_KUPartner's (Customer's or Vendor's) Packaging Materialnvarchar350CHAR(N' ')YesVHILM_KU Allow NULL? 
68VPOBJPacking Objectnvarchar20CHAR(N' ')YesVPOBJ Allow NULL? 
69VPOBJKEYKey for Object to Which the Handling Unit is Assignednvarchar200CHAR(N' ')YesVPOBJKEY Allow NULL? 
70HANDLEWorldwide unique key for VEKP-VENUMnvarchar220CHAR(N' ')YesGUID_VEKP Allow NULL? 
71WMSTAWM status for container materialchar10CHAR(N' ')YesLVS_WMSTA Allow NULL? 
72LGNUMWarehouse Number / Warehouse Complexnvarchar30CHAR(N' ')YesT300HUM_LGNUM Allow NULL? 
73SAPRLSAP Releasenvarchar40CHAR(N' ')YesSAPRL Allow NULL? 
74KZGVHPackaging Material is Closed Packagingchar10CHAR(N' ')YesKZGVH Allow NULL? 
75ADGE_DGPacking Level is Relevant for Dangerous Goodschar10CHAR(N' ')YesADGE_DG Allow NULL? 
76ADGE_DGPRIndicator: Packing level is relevant for printingchar10CHAR(N' ')YesADGE_DGPR Allow NULL? 
77UEVELHigher-Level Handling Unitnvarchar100CHAR(N' ')Yes*UEVEL Allow NULL? 
78PACKVORSCHRPacking instructionnvarchar220CHAR(N' ')YesPL_PACKNR_CONV Allow NULL? 
79PACKVORSCHR_STLocal packing status for a single HU (without sub HUs)char10CHAR(N' ')YesPL_PACKSTATUS_LOCAL Allow NULL? 
80LABELTYPIndicator: do not print external shipping labelchar10CHAR(N' ')YesPL_SHIPLABEL Allow NULL? 
81ZUL_AUFLAllowed loaddecimal153QUAN((0))YesPL_MAXSTWE
82STATUSHandling unit statusnvarchar40CHAR(N' ')YesHU_STATUS Allow NULL? 
83HU_LGORTContent is Located at an HU-managed Storage Locationchar10CHAR(N' ')YesHU_LGORT Allow NULL? 
84HU_SYSTEMHU and IM Stock in Separate Systemschar10CHAR(N' ')YesHUMSYS Allow NULL? 
85SPE_HDALLInbound delivery header not yet complete (on Hold)char10CHAR(N' ')Yes/SPE/INB_HDALL Allow NULL? 
86SPE_VLSTKDistribution Status (Decentralized Warehouse Processing)char10CHAR(N' ')YesVLSTK Allow NULL? 
87SPE_DELDECDelete indicator for the confirmation of deleted HUschar10CHAR(N' ')Yes/SPE/INB_DELDEC Allow NULL? 
88SPE_IDART_01Handling Unit Identification Typechar10CHAR(N' ')Yes/SPE/DE_HUIDART Allow NULL? 
89SPE_IDENT_01Alternative HU Identificationnvarchar400CHAR(N' ')Yes/SPE/DE_IDENT Allow NULL? 
90SPE_IDART_02Handling Unit Identification Typechar10CHAR(N' ')Yes/SPE/DE_HUIDART Allow NULL? 
91SPE_IDENT_02Alternative HU Identificationnvarchar400CHAR(N' ')Yes/SPE/DE_IDENT Allow NULL? 
92SPE_IDART_03Handling Unit Identification Typechar10CHAR(N' ')Yes/SPE/DE_HUIDART Allow NULL? 
93SPE_IDENT_03Alternative HU Identificationnvarchar400CHAR(N' ')Yes/SPE/DE_IDENT Allow NULL? 
94SPE_IDART_04Handling Unit Identification Typechar10CHAR(N' ')Yes/SPE/DE_HUIDART Allow NULL? 
95SPE_IDENT_04Alternative HU Identificationnvarchar400CHAR(N' ')Yes/SPE/DE_IDENT Allow NULL? 
96SPE_LOGPOSLogical Position of Handling Unitnvarchar20CHAR(N' ')Yes/SPE/DE_LOGPOS Allow NULL? 
97SPE_CHK_COUNTERCheck number for cross-delivery handling unitsnvarchar50NUMC(N'00000')Yes/SPE/DE_CHK_CTR Allow NULL? 
98EPC1Electronic Product Code 1nvarchar960CHAR(N' ')YesABI_EPC1 Allow NULL? 
99EPC2Electronic Product Code 2nvarchar960CHAR(N' ')YesABI_EPC2 Allow NULL? 
100PACKAGE_CATCategory of Packagenvarchar150CHAR(N' ')YesEHS_ADGE_PACKAGE_CAT Allow NULL? 
101TRANSP_INDEXTransport Indexdecimal72DEC((0))YesEHS_ADGE_TRANSP_INDEX
102CRIT_SAF_INDEXCriticality Safety Indexdecimal72DEC((0))YesEHS_ADGE_CRIT_SAF_INDEX
103FLG_DG_PACKAGEDangerous Goods Packagechar10CHAR(N' ')YesADGE_FLG_DG_PACKAGE Allow NULL? 
104DG_PACKAGE_LEVELLevel of Dangerous Goods Packagingnvarchar30CHAR(N' ')YesTDG95ADGE_DG_PACKAGE_LEVEL Allow NULL? 
105PACKCODEActual Packaging Codenvarchar100CHAR(N' ')YesCCUNC121CBDUE_PACOD Allow NULL? 
106INSTR_ENCL_CATCategory of Instruction for Enclosurenvarchar150CHAR(N' ')YesCCUNC113CBUNE_INSTR_ENCL_CAT Allow NULL? 
107MAT_DAMAGED_CL7Damaged Material (Class 7)char10CHAR(N' ')YesADGE_MAT_DAMAGED_CL7 Allow NULL? 
108DOSE_RATE_BULKRadiation Level (Unpacked)decimal95QUAN((0))YesADGE_DOSE_RATE
109DOSE_RATE_BULK_UUnit of Radiation Level (Unpacked)nvarchar30UNIT(N' ')YesT006ADGE_DOSE_RATE_U Allow NULL? 
110DOSE_RATE_PACKRadation Level Packeddecimal95QUAN((0))YesADGE_DOSE_RATE_PACKAGED
111U_DOSE_RATE_PACKUnit of Radiation Level Packednvarchar30UNIT(N' ')YesT006ADGE_DOSE_RATE_PACKAGED_U Allow NULL? 
112LEADING_LWDGLeading Dangerous Goods Regulationnvarchar120CHAR(N' ')YesTHM063ADGE_LEADING_LWDG Allow NULL? 
113MAX_GROSS_WEIGHTMaximum Gross Massdecimal82QUAN((0))YesADGE_MAX_GROSS_WEIGHT
114U_MAX_GROSS_WGHTUnit for Maximum Gross Massnvarchar30UNIT(N' ')YesT006ADGE_U_MAX_GROSS_WGHT Allow NULL? 
115LYARDYardnvarchar30CHAR(N' ')Yes*LXYRD_YARD Allow NULL? 
116YLCCLLocation Classnvarchar20CHAR(N' ')YesLXYRDM_YLCCL Allow NULL? 
117YLOCTLocationnvarchar100CHAR(N' ')YesLXYRD_YLOCT Allow NULL? 
118STATSVehicle Stock Statusnvarchar20CHAR(N' ')YesLXYRD_OBSTS Allow NULL? 
119PRRTYVehicle Prioritynvarchar20CHAR(N' ')YesLXYRD_PRRTY Allow NULL? 
120FWAGNForwarding Agentnvarchar100CHAR(N' ')Yes*LXYRD_FWAGN Allow NULL? 
121SCACDStandard carrier access codenvarchar40CHAR(N' ')YesLEINT_SCACD Allow NULL? 
122OWNERVehicle Ownernvarchar100CHAR(N' ')YesLXYRD_OWNER Allow NULL? 
123TRNPDTranspondernvarchar200CHAR(N' ')YesLXYRD_TRNPD Allow NULL? 
124SEALN1Sealing Numbernvarchar100CHAR(N' ')YesLXYRD_SEALN Allow NULL? 
125SEALN2Sealing Numbernvarchar100CHAR(N' ')YesLXYRD_SEALN Allow NULL? 
126SEALN3Sealing Numbernvarchar100CHAR(N' ')YesLXYRD_SEALN Allow NULL? 
127SEALN4Sealing Numbernvarchar100CHAR(N' ')YesLXYRD_SEALN Allow NULL? 
128SEALN5Sealing Numbernvarchar100CHAR(N' ')YesLXYRD_SEALN Allow NULL? 
129BLINDBlockchar10CHAR(N' ')YesLXYRD_BLOCK Allow NULL? 
130RSNCDReason Codenvarchar20CHAR(N' ')YesLYRSNLXYRD_RSNCD Allow NULL? 
131RFTYPReference Document Typenvarchar20CHAR(N' ')YesLXYRD_RFDTY Allow NULL? 
132REFERReference Documentnvarchar100CHAR(N' ')YesLXYRD_DOCRF Allow NULL? 
133PTMSTPlanned End Timedecimal150DEC((0))YesLXYRD_PTMST
134ATMSTActual Start Timedecimal150DEC((0))YesLXYRD_ATMSF
135YDOORDoornvarchar30CHAR(N' ')Yes*LEINT_LGTOR Allow NULL? 
136YSTGAStaging Areanvarchar100CHAR(N' ')Yes*LEINT_LGBZO Allow NULL? 
137URGFLUrgent (Relevant for Cross-Docking)char10CHAR(N' ')YesLXYRD_URGFL Allow NULL? 
138PRFLGPermanence of Vehicle in Yardchar10CHAR(N' ')YesLXYRD_PRFLG Allow NULL? 
139SLFLGSealing Requiredchar10CHAR(N' ')YesLXYRD_SLFLG Allow NULL? 
140SIGNIContainer IDnvarchar200CHAR(N' ')YesLEINT_SIGNI Allow NULL? 
141LTEXTTextnvarchar400CHAR(N' ')YesLXYRD_TEXT_DE Allow NULL? 
NamePrimaryUniqueTypeColumns
VEKP~0YesYesCLUSTEREDMANDT, VENUM
VEKP~001NoNoNONCLUSTEREDMANDT, HANDLE
VEKP~BNoNoNONCLUSTEREDMANDT, VPOBJ, VPOBJKEY
VEKP~CNoNoNONCLUSTEREDMANDT, EXIDV

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