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  | EQUI
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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Plant Maintenance :: Technical Objects :: Equipment
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0EQUI907Equipment master dataEquipment
SQL:  selectupdate insert create

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

SELECT MANDT, EQUNR, ERDAT, ERNAM, EQASP, AEDAT, AENAM, BEGRU, EQTYP, EQART, LVORM, INVNR, GROES, BRGEW, GEWEI, ANSDT, ANSWT, WAERS, ELIEF, GWLEN, GWLDT, WDBWT, HERST, HERLD, HZEIN, SERGE, TYPBZ, BAUJJ, BAUMM, APLKZ, AULDT, INBDT, GERNR, EQLFN, GWLDV, EQDAT, EQBER, EQNUM, OBJNR, EQSNR, CUOBJ, KRFKZ, KMATN, MATNR, SERNR, WERK, LAGER, CHARGE, KUNDE, WARPL, IMRC_POINT, REVLV, MGANR, BEGRUI, S_EQUI, S_SERIAL, S_KONFI, S_SALE, S_FHM, S_ELSE, S_ISU, S_EQBS, S_FLEET, BSTVP, SPARTE, HANDLE, TSEGTP, EMATN, ACT_CHANGE_AA, S_CC, DATLWB, UII, IUID_TYPE, UII_PLANT, /GEP/PASSENGER, /GEP/AUTOM, /GEP/KLIMA, /GEP/DACHG, /GEP/SCHNEEK, /GEP/WINTERR, /GEP/VHCAT, EQEXT_ACTIVE, /MRSS/ID_PROFILE, /MRSS/PROF_GUID, /MRSS/PROF_KEY, /MRSS/DATACHANGE, EQUI_SRTYPE, EQUI_SNTYPE, EQLB_DUTY, EQLB_HIDE FROM EQUI
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2EQUNREquipment Numbernvarchar180CHAR(N' ')NoEQUNR Allow NULL? 
3ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
4ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
5EQASPLanguage in Which the Piece of Equipment was Enteredchar10LANG(N' ')YesT002EQASP Allow NULL? 
6AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
7AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
8BEGRUTechnical object authorization groupnvarchar40CHAR(N' ')YesT370BIAUTG Allow NULL? 
9EQTYPEquipment categorychar10CHAR(N' ')YesT370TEQTYP Allow NULL? 
10EQARTType of Technical Objectnvarchar100CHAR(N' ')YesT370KEQART Allow NULL? 
11LVORMSAP Development Reserve: Format CHAR, Length 1char10CHAR(N' ')YesRESERVE_CHAR_001 Allow NULL? 
12INVNRInventory numbernvarchar250CHAR(N' ')YesINVNR Allow NULL? 
13GROESSize/dimensionnvarchar180CHAR(N' ')YesGROSS Allow NULL? 
14BRGEWWeight of objectdecimal133QUAN((0))YesOBJ_WEIGHT
15GEWEIUnit of weightnvarchar30UNIT(N' ')YesT006WEIGHT_UNIT Allow NULL? 
16ANSDTAcquisition datenvarchar80DATS(N'00000000')YesANDTI Allow NULL? 
17ANSWTAcquisition Valuedecimal132CURR((0))YesANSWT
18WAERSCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
19ELIEFVendor numbernvarchar100CHAR(N' ')YesLFA1ELIEF Allow NULL? 
20GWLENDate on which the warranty endsnvarchar80DATS(N'00000000')YesGWLEN Allow NULL? 
21GWLDTWarranty Datenvarchar80DATS(N'00000000')YesGWLDT Allow NULL? 
22WDBWTEquipment replacement valuedecimal132CURR((0))YesWDBWT
23HERSTManufacturer of assetnvarchar300CHAR(N' ')YesHERST Allow NULL? 
24HERLDCountry of manufacturenvarchar30CHAR(N' ')YesT005HERLD Allow NULL? 
25HZEINManufacturer drawing numbernvarchar300CHAR(N' ')YesHZEIN Allow NULL? 
26SERGEManufacturer serial numbernvarchar300CHAR(N' ')YesSERGE Allow NULL? 
27TYPBZManufacturer model numbernvarchar200CHAR(N' ')YesTYPBZ Allow NULL? 
28BAUJJYear of constructionnvarchar40CHAR(N' ')YesBAUJJ Allow NULL? 
29BAUMMMonth of constructionnvarchar20CHAR(N' ')YesBAUMM Allow NULL? 
30APLKZIndicator: Task List Existschar10CHAR(N' ')YesAPLKZ Allow NULL? 
31AULDTFirst delivery date of the equipmentnvarchar80DATS(N'00000000')YesAULDT Allow NULL? 
32INBDTStart-up Date of the Technical Objectnvarchar80DATS(N'00000000')YesILOM_DATAB Allow NULL? 
33GERNRSerial Numbernvarchar180CHAR(N' ')YesGERNR Allow NULL? 
34EQLFNConsecutive numbering of EquipUsagePeriods on same daynvarchar30NUMC(N'000')YesEQLFN Allow NULL? 
35GWLDVWarranty date for Sales and Distributionnvarchar80DATS(N'00000000')YesGWLDV Allow NULL? 
36EQDATDate, intended for SAP internal usenvarchar80DATS(N'00000000')YesEQDAT Allow NULL? 
37EQBERTechnical information, intended for SAP internal usenvarchar300CHAR(N' ')YesEQBER Allow NULL? 
38EQNUMNumerical field, intended for SAP internal usenvarchar90NUMC(N'000000000')YesEQNUM Allow NULL? 
39OBJNRObject numbernvarchar220CHAR(N' ')Yes*J_OBJNR Allow NULL? 
40EQSNREQSE Numbernvarchar180CHAR(N' ')YesEQSEEQSNR Allow NULL? 
41CUOBJConfiguration (internal object number)nvarchar180NUMC(N'000000000000000000')YesCUOBJ Allow NULL? 
42KRFKZReferenced Configurationchar10CHAR(N' ')YesKRFKZ Allow NULL? 
43KMATNConfigurable Materialnvarchar180CHAR(N' ')YesMARAKMATN Allow NULL? 
44MATNRMaterial Numbernvarchar180CHAR(N' ')YesMARAMATNR Allow NULL? 
45SERNRSerial Numbernvarchar180CHAR(N' ')YesGERNR Allow NULL? 
46WERKPlantnvarchar40CHAR(N' ')YesT001WWERKS_D Allow NULL? 
47LAGERStorage Locationnvarchar40CHAR(N' ')YesT001LLGORT_D Allow NULL? 
48CHARGEBatch Numbernvarchar100CHAR(N' ')YesMCH1CHARG_D Allow NULL? 
49KUNDECustomer to Whom Serial Number was Deliverednvarchar100CHAR(N' ')YesKNA1KUNDSE Allow NULL? 
50WARPLMaintenance Plannvarchar120CHAR(N' ')YesMPLAWARPL Allow NULL? 
51IMRC_POINTMeasuring Pointnvarchar120CHAR(N' ')YesIMPTTIMRC_POINT Allow NULL? 
52REVLVRevision Levelnvarchar20CHAR(N' ')YesREVLV Allow NULL? 
53MGANRMaster warranty numbernvarchar200CHAR(N' ')YesBGMKMGANR Allow NULL? 
54BEGRUIData origin for authorization group fieldchar10CHAR(N' ')YesINH_BEGRUI Allow NULL? 
55S_EQUIEquipment data existschar10CHAR(N' ')YesEQUIP_KNZ Allow NULL? 
56S_SERIALSerial data when maintaining equipmentchar10CHAR(N' ')YesKZKSD Allow NULL? 
57S_KONFIConfiguration supportedchar10CHAR(N' ')YesKONFKNZ Allow NULL? 
58S_SALESales equipmentchar10CHAR(N' ')YesSDKNZ Allow NULL? 
59S_FHMEquip. category relevant to production resources and toolschar10CHAR(N' ')YesFHMKZ Allow NULL? 
60S_ELSEIndicator: Other Data Activechar10CHAR(N' ')YesELSE_KNZ Allow NULL? 
61S_ISUIS-U datachar10CHAR(N' ')YesISU_KNZ Allow NULL? 
62S_EQBSEQSI Existschar10CHAR(N' ')YesKZEQBS Allow NULL? 
63S_FLEETIndicator: Fleet object activechar10CHAR(N' ')NoFLEET_KNZ Allow NULL? 
64BSTVPStock Check for Serial Numberschar10CHAR(N' ')YesBSTVP Allow NULL? 
65SPARTEDivisionnvarchar20CHAR(N' ')YesTSPASPARTE Allow NULL? 
66HANDLESAP Development Reserve: Integration of Date Segment (Key)nvarchar220CHAR(N' ')YesITOBTMP_TSEGGUID Allow NULL? 
67TSEGTPSAP Development Reserve: Integration Date Segment (Tempate)nvarchar100CHAR(N' ')Yes*ITOBTMP_TSEGTEMPLA Allow NULL? 
68EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180CHAR(N' ')Yes*EMATN Allow NULL? 
69ACT_CHANGE_AAChange Equipment Master when Changing Assetchar10CHAR(N' ')YesAAPM_ACT_CHANGE_AA Allow NULL? 
70S_CCConfiguration Control Datachar10CHAR(N' ')YesCCC_KNZ Allow NULL? 
71DATLWBDate of Last Goods Movementnvarchar80DATS(N'00000000')YesDATLWB Allow NULL? 
72UIIUnique Item Identifiernvarchar720CHAR(N' ')YesUII_CHAR72 Allow NULL? 
73IUID_TYPEStructure Type of UIInvarchar100CHAR(N' ')YesTIUID_TYPEIUID_TYPE Allow NULL? 
74UII_PLANTPlant Responsible for UIInvarchar40CHAR(N' ')Yes*UII_PLANT Allow NULL? 
75/GEP/PASSENGERNumber of Passengersnvarchar20NUMC(N'00')Yes/GEP/FLEET_D_PASSENGER Allow NULL? 
76/GEP/AUTOMVehicle Equipment: Automatic Transmissionchar10CHAR(N' ')Yes/GEP/FLEET_D_AUTOM Allow NULL? 
77/GEP/KLIMAVehicle Equipment: Air Conditioningchar10CHAR(N' ')Yes/GEP/FLEET_D_KLIMA Allow NULL? 
78/GEP/DACHGVehicle Equipment: Roof Rackchar10CHAR(N' ')Yes/GEP/FLEET_D_DACHG Allow NULL? 
79/GEP/SCHNEEKVehicle Equipment: Snow Chainschar10CHAR(N' ')Yes/GEP/FLEET_D_SCHNEEK Allow NULL? 
80/GEP/WINTERRVehicle Equipment: Snow Tyreschar10CHAR(N' ')Yes/GEP/FLEET_D_WINTERR Allow NULL? 
81/GEP/VHCATVehicle Typenvarchar20CHAR(N' ')Yes/GEP/FLEET_D_VHCAT Allow NULL? 
82EQEXT_ACTIVEBackpack Table /isdfps/lmeqext Activechar10CHAR(N' ')Yes/ISDFPS/DE_LM_DB_EQEXT_ACTIVE Allow NULL? 
83/MRSS/ID_PROFILERequirements Profile Was Changed Manuallychar10CHAR(N' ')Yes/MRSS/T_REQU_UPD Allow NULL? 
84/MRSS/PROF_GUIDGUIDvarbinary160RAWYes/MRSS/T_RSG_GUID
85/MRSS/PROF_KEYProfile Keynvarchar100CHAR(N' ')Yes/MRSS/T_RSG_REQUID Allow NULL? 
86/MRSS/DATACHANGEData was changed in the controls on the user screenchar10CHAR(N' ')Yes/MRSS/T_USCREENCTL_DATACHANGED Allow NULL? 
87EQUI_SRTYPEShift Report Typenvarchar100CHAR(N' ')YesCOCF_CU_SRTYPECOCF_SR_SRTYPE Allow NULL? 
88EQUI_SNTYPEShift Note Typenvarchar20CHAR(N' ')YesTQ80COCF_SN_SNTYPE Allow NULL? 
89EQLB_DUTYLogbook Dutychar10CHAR(N' ')YesDIACL_DUTY Allow NULL? 
90EQLB_HIDEHide Logbook Displaychar10CHAR(N' ')YesDIACL_HIDE Allow NULL? 
NamePrimaryUniqueTypeColumns
EQUI~0YesYesCLUSTEREDEQUNR, MANDT
EQUI~ANoNoNONCLUSTEREDMATNR, SERNR
EQUI~B40NoNoNONCLUSTEREDEQUNR, SERNR, S_EQBS, MATNR
EQUI~CNoNoNONCLUSTEREDKRFKZ, KMATN, MANDT
EQUI~HSSNoNoNONCLUSTEREDEQART, EQUNR
EQUI~ONoNoNONCLUSTEREDOBJNR
EQUI~UIINoNoNONCLUSTEREDUII

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