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  | HUWM_LOAD_PROT
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.0HUWM_LOAD_PROT772Log Table of Initial Data Transfer for Subsequent PostingBasic functions
SQL:  selectupdate insert create

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

SELECT MANDT, TOP_IDENT, LINE, EXIDV, ITEM_TYPE, EXIDA, VHILM, EXIDV2, BWLVS, SQUIT, LGNUM, TARAG, GEWEI, MAGEW, NTGEW, BRGEW, GEWEI_MAX, GEWTO, TAVOL, VOLEH, MAVOL, NTVOL, BTVOL, VOLEH_MAX, GEWFX, LAENG, BREIT, HOEHE, MEABM, LETYP, NLTYP, NLBER, NLPLA, INHALT, ERLKZ, SORTL, VEGR1, VEGR2, VEGR3, VEGR4, VEGR5, PACKVORSCH, PACKVORSCHR_ST, LABELTYP, ZUL_AUFL, SUB_HU_EXIDV, QUANTITY, ALTME, MATNR, CHARG, WERKS, LGORT, BESTQ, SOBKZ, SONUM, WDATU, VFDAT, ZEUGN, KZBEI, ANZSN, BWART, ITEM_ZEILE, HSDAT, ZEILE, SERNR, UII, EXIDV_NEW, SUB_HU_NEW, CREATED, POSTED, MSGID, MSGTY, MSGNO, MSGV1, MSGV2, MSGV3, MSGV4 FROM HUWM_LOAD_PROT
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2TOP_IDENTExternal Handling Unit Identificationnvarchar200CHAR(N' ')NoEXIDV Allow NULL? 
3LINEID for an HU Item Lineint100INT4((0))NoHUMZEILE Allow NULL? 
4EXIDVExternal Handling Unit Identificationnvarchar200CHAR(N' ')YesEXIDV Allow NULL? 
5ITEM_TYPERecord Typechar10CHAR(N' ')YesHUM_ITEM_TYPE Allow NULL? 
6EXIDAType of External Handling Unit Identifierchar10CHAR(N' ')YesEXIDA Allow NULL? 
7VHILMPackaging Materialsnvarchar180CHAR(N' ')Yes*VHILM Allow NULL? 
8EXIDV2Handling Unit's 2nd External Identificationnvarchar200CHAR(N' ')YesEXIDV2 Allow NULL? 
9BWLVSMovement Type for Warehouse Managementnvarchar30NUMC(N'000')Yes*BWLVS Allow NULL? 
10SQUITIndicator: confirmation of a transfer order itemchar10CHAR(N' ')YesRL03TSQUIT Allow NULL? 
11LGNUMWarehouse Number / Warehouse Complexnvarchar30CHAR(N' ')Yes*LGNUM Allow NULL? 
12TARAGTare weight of handling unitdecimal153QUAN((0))YesTARAG_VEKP
13GEWEIWeight Unitnvarchar30UNIT(N' ')Yes*GEWEI Allow NULL? 
14MAGEWAllowed Loading Weight of a Handling Unitdecimal153QUAN((0))YesMAGEW_VEKP
15NTGEWLoading Weight of Handling Unitdecimal153QUAN((0))YesNTGEW_VEKP
16BRGEWTotal Weight of Handling Unitdecimal153QUAN((0))YesBRGEW_VEKP
17GEWEI_MAXWeight Unitnvarchar30UNIT(N' ')Yes*GEWEI Allow NULL? 
18GEWTOExcess Weight Tolerance for Handling unitdecimal31DEC((0))YesGEWTO
19TAVOLTare volume of handling unitdecimal153QUAN((0))YesTAVOL_VEKP
20VOLEHVolume unitnvarchar30UNIT(N' ')Yes*VOLEH Allow NULL? 
21MAVOLAllowed Loading Volume for Handling Unitdecimal153QUAN((0))YesMAVOL_VEKP
22NTVOLLoading Volume of Handling Unitdecimal153QUAN((0))YesNTVOL_VEKP
23BTVOLTotal Volume of Handling Unitdecimal153QUAN((0))YesBTVOL_VEKP
24VOLEH_MAXVolume unitnvarchar30UNIT(N' ')Yes*VOLEH Allow NULL? 
25GEWFXWeight and Volume Fixedchar10CHAR(N' ')YesGEWFX Allow NULL? 
26LAENGLengthdecimal133QUAN((0))YesLAENG
27BREITWidthdecimal133QUAN((0))YesBREIT
28HOEHEHeightdecimal133QUAN((0))YesHOEHE
29MEABMUnit of Dimension for Length/Width/Heightnvarchar30UNIT(N' ')Yes*MEABM Allow NULL? 
30LETYPStorage Unit Typenvarchar30CHAR(N' ')Yes*LVS_LETYP Allow NULL? 
31NLTYPDestination Storage Typenvarchar30CHAR(N' ')Yes*LTAP_NLTYP Allow NULL? 
32NLBERDestination storage sectionnvarchar30CHAR(N' ')Yes*LTAP_NLBER Allow NULL? 
33NLPLADestination Storage Binnvarchar100CHAR(N' ')Yes*LTAP_NLPLA Allow NULL? 
34INHALTDescription of Handling Unit Contentnvarchar400CHAR(N' ')YesINHALT Allow NULL? 
35ERLKZStatus (at this time without functionality)char10CHAR(N' ')YesVOLLS Allow NULL? 
36SORTLSort fieldnvarchar100CHAR(N' ')YesSORTL Allow NULL? 
37VEGR1Handling Unit Group 1 (Freely Definable)nvarchar50CHAR(N' ')Yes*VEGR1 Allow NULL? 
38VEGR2Handling Unit Group 2 (Freely Definable)nvarchar50CHAR(N' ')Yes*VEGR2 Allow NULL? 
39VEGR3Handling Unit Group 3 (Freely Definable)nvarchar50CHAR(N' ')Yes*VEGR3 Allow NULL? 
40VEGR4Handling Unit Group 4 (Freely Definable)nvarchar50CHAR(N' ')Yes*VEGR4 Allow NULL? 
41VEGR5Handling Unit Group 5 (Freely Definable)nvarchar50CHAR(N' ')Yes*VEGR5 Allow NULL? 
42PACKVORSCHPacking instructionnvarchar220CHAR(N' ')YesPL_PACKNR_CONV Allow NULL? 
43PACKVORSCHR_STLocal packing status for a single HU (without sub HUs)char10CHAR(N' ')YesPL_PACKSTATUS_LOCAL Allow NULL? 
44LABELTYPIndicator: do not print external shipping labelchar10CHAR(N' ')YesPL_SHIPLABEL Allow NULL? 
45ZUL_AUFLAllowed loaddecimal153QUAN((0))YesPL_MAXSTWE
46SUB_HU_EXIDVExternal Handling Unit Identificationnvarchar200CHAR(N' ')YesEXIDV Allow NULL? 
47QUANTITYRequested quantity in alternative unit of measurenvarchar150CHAR(N' ')YesRLBESANFME Allow NULL? 
48ALTMEAlternative Unit of Measure for Stockkeeping Unitnvarchar30UNIT(N' ')Yes*LRMEI Allow NULL? 
49MATNRMaterial Numbernvarchar180CHAR(N' ')Yes*MATNR Allow NULL? 
50CHARGBatch Numbernvarchar100CHAR(N' ')Yes*CHARG_D Allow NULL? 
51WERKSPlantnvarchar40CHAR(N' ')Yes*WERKS_D Allow NULL? 
52LGORTStorage Locationnvarchar40CHAR(N' ')Yes*LGORT_D Allow NULL? 
53BESTQStock Category in the Warehouse Management Systemchar10CHAR(N' ')YesBESTQ Allow NULL? 
54SOBKZSpecial Stock Indicatorchar10CHAR(N' ')Yes*SOBKZ Allow NULL? 
55SONUMSpecial Stock Numbernvarchar160CHAR(N' ')YesLVS_SONUM Allow NULL? 
56WDATUDate of Goods Receiptnvarchar80DATS(N'00000000')YesLVS_WDATU Allow NULL? 
57VFDATShelf Life Expiration or Best-Before Datenvarchar80DATS(N'00000000')YesVFDAT Allow NULL? 
58ZEUGNCertificate Numbernvarchar100CHAR(N' ')YesLVS_ZEUGN Allow NULL? 
59KZBEIIndicator: Supplementary itemchar10CHAR(N' ')YesKZBEI Allow NULL? 
60ANZSNNumber of serial numbersint100INT4((0))YesANZSN Allow NULL? 
61BWARTMovement Type (Inventory Management)nvarchar30CHAR(N' ')Yes*BWART Allow NULL? 
62ITEM_ZEILEID for an HU Item Lineint100INT4((0))YesHUMZEILE Allow NULL? 
63HSDATDate of Manufacturenvarchar80DATS(N'00000000')YesHSDAT Allow NULL? 
64ZEILEID for an HU Item Lineint100INT4((0))YesHUMZEILE Allow NULL? 
65SERNRSerial Numbernvarchar180CHAR(N' ')YesGERNR Allow NULL? 
66UIIUnique Item Identifiernvarchar720CHAR(N' ')YesUII_CHAR72 Allow NULL? 
67EXIDV_NEWExternal Handling Unit Identificationnvarchar200CHAR(N' ')YesEXIDV Allow NULL? 
68SUB_HU_NEWExternal Handling Unit Identificationnvarchar200CHAR(N' ')YesEXIDV Allow NULL? 
69CREATEDCheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
70POSTEDCheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
71MSGIDMessage Classnvarchar200CHAR(N' ')Yes*SYMSGID Allow NULL? 
72MSGTYMessage Typechar10CHAR(N' ')YesSYMSGTY Allow NULL? 
73MSGNOMessage Numbernvarchar30NUMC(N'000')YesSYMSGNO Allow NULL? 
74MSGV1Message Variablenvarchar500CHAR(N' ')YesSYMSGV Allow NULL? 
75MSGV2Message Variablenvarchar500CHAR(N' ')YesSYMSGV Allow NULL? 
76MSGV3Message Variablenvarchar500CHAR(N' ')YesSYMSGV Allow NULL? 
77MSGV4Message Variablenvarchar500CHAR(N' ')YesSYMSGV Allow NULL? 
NamePrimaryUniqueTypeColumns
HUWM_LOAD_PROT~0YesYesCLUSTEREDLINE, TOP_IDENT, MANDT
HUWM_LOAD_PROT~001NoNoNONCLUSTEREDPOSTED, 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