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  | ESLL
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
Materials Management :: External Services
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0ESLL1015Lines of Service PackageExternal Services
SQL:  selectupdate insert create

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

SELECT MANDT, PACKNO, INTROW, EXTROW, DEL, SRVPOS, RANG, EXTGROUP, PACKAGE, SUB_PACKNO, LBNUM, AUSGB, STLVPOS, EXTSRVNO, MENGE, MEINS, UEBTO, UEBTK, WITH_LIM, SPINF, PEINH, BRTWR, NETWR, FROMPOS, TOPOS, KTEXT1, VRTKZ, TWRKZ, PERNR, MOLGA, LGART, LGTXT, STELL, IFTNR, BUDAT, INSDT, PLN_PACKNO, PLN_INTROW, KNT_PACKNO, KNT_INTROW, TMP_PACKNO, TMP_INTROW, STLV_LIM, LIMIT_ROW, ACT_MENGE, ACT_WERT, KNT_WERT, KNT_MENGE, ZIELWERT, UNG_WERT, UNG_MENGE, ALT_INTROW, BASIC, ALTERNAT, BIDDER, SUPPLE, FREEQTY, INFORM, PAUSCH, EVENTUAL, MWSKZ, TXJCD, PRS_CHG, MATKL, TBTWR, NAVNW, BASWR, KKNUMV, IWEIN, INT_WORK, EXTERNALID, KSTAR, ACT_WORK, MAPNO, SRVMAPKEY, TAXTARIFFCODE, SDATE, BEGTIME, ENDTIME, PERSEXT, CATSCOUNTE, STOKZ, BELNR, FORMELNR, FRMVAL1, FRMVAL2, FRMVAL3, FRMVAL4, FRMVAL5, USERF1_NUM, USERF2_NUM, USERF1_TXT, USERF2_TXT, KNOBJ, CHGTEXT, KALNR, KLVAR, EXTREFKEY, INV_MENGE, PER_SDATE, PER_EDATE FROM ESLL
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2PACKNOPackage numbernvarchar100NUMC(N'0000000000')NoESLHPACKNO Allow NULL? 
3INTROWLine Numbernvarchar100NUMC(N'0000000000')NoNUMZEILE Allow NULL? 
4EXTROWLine Numbernvarchar100NUMC(N'0000000000')NoEXTROW Allow NULL? 
5DELDeletion Indicatorchar10CHAR(N' ')NoDEL Allow NULL? 
6SRVPOSActivity Numbernvarchar180CHAR(N' ')NoASMDASNUM Allow NULL? 
7RANGHierarchy level of grouptinyint30INT1((0))NoRANG
8EXTGROUPOutline Levelnvarchar80CHAR(N' ')NoEXTGROUP Allow NULL? 
9PACKAGEService Assignmentchar10CHAR(N' ')NoPACKAGE Allow NULL? 
10SUB_PACKNOSubpackage numbernvarchar100NUMC(N'0000000000')NoESLHSUB_PACKNO Allow NULL? 
11LBNUMShort Description of Service Typenvarchar30CHAR(N' ')NoLBNUM Allow NULL? 
12AUSGBEdition of Service Typenvarchar40NUMC(N'0000')NoAUSGB Allow NULL? 
13STLVPOSStandard Service Catalog Itemnvarchar180CHAR(N' ')NoSTLVPOS Allow NULL? 
14EXTSRVNOVendor's Service Numbernvarchar180CHAR(N' ')NoEXTSRVNO Allow NULL? 
15MENGEQuantity with Signdecimal133QUAN((0))NoMENGEV
16MEINSBase Unit of Measurenvarchar30UNIT(N' ')NoT006MEINS Allow NULL? 
17UEBTOOverfulfillment Tolerancedecimal31DEC((0))NoSUEBTO
18UEBTKUnlimited Overfulfillmentchar10CHAR(N' ')NoSUEBTK Allow NULL? 
19WITH_LIMAlso Search in Limitschar10CHAR(N' ')NoWITH_LIM Allow NULL? 
20SPINFUpdate Conditionschar10CHAR(N' ')NoKUPDATE Allow NULL? 
21PEINHPrice Unitdecimal50DEC((0))YesEPEIN
22BRTWRGross Pricedecimal112CURR((0))NoSBRTWR
23NETWRNet Value of Itemdecimal112CURR((0))NoSNETWR
24FROMPOSLower Limitnvarchar60CHAR(N' ')NoFROMPOS Allow NULL? 
25TOPOSUpper Limitnvarchar60CHAR(N' ')NoTO_POS Allow NULL? 
26KTEXT1Short Textnvarchar400CHAR(N' ')NoSH_TEXT1 Allow NULL? 
27VRTKZDistribution indicator for multiple account assignmentchar10CHAR(N' ')NoVRTKZ Allow NULL? 
28TWRKZPartial Invoice Indicatorchar10CHAR(N' ')NoTWRKZ Allow NULL? 
29PERNRPersonnel Numbernvarchar80NUMC(N'00000000')NoPERNR_D Allow NULL? 
30MOLGACountry Groupingnvarchar20CHAR(N' ')No*MOLGA Allow NULL? 
31LGARTWage Typenvarchar40CHAR(N' ')No*LGART Allow NULL? 
32LGTXTWage Type Long Textnvarchar250CHAR(N' ')NoLGTXT Allow NULL? 
33STELLJobnvarchar80NUMC(N'00000000')No*STELL Allow NULL? 
34IFTNRSequence Number for CO/MM-SRV Interface Tablesnvarchar100NUMC(N'0000000000')NoIFTNR Allow NULL? 
35BUDATPosting Date in the Documentnvarchar80DATS(N'00000000')NoBUDAT Allow NULL? 
36INSDTDate on Which This Record was Stored in the Tablenvarchar80DATS(N'00000000')NoINSDT Allow NULL? 
37PLN_PACKNOSource package numbernvarchar100NUMC(N'0000000000')NoESLHPLN_PACKNO Allow NULL? 
38PLN_INTROWEntry: Planned package linenvarchar100NUMC(N'0000000000')No*PLN_INTROW Allow NULL? 
39KNT_PACKNOEntry: Unplanned from contractnvarchar100NUMC(N'0000000000')NoESLHKNT_PACKNO Allow NULL? 
40KNT_INTROWEntry: Unplanned from contractnvarchar100NUMC(N'0000000000')NoKNT_INTROW Allow NULL? 
41TMP_PACKNOEntry: Unplanned service from model specificationsnvarchar100NUMC(N'0000000000')YesTMP_PACKNO Allow NULL? 
42TMP_INTROWEntry: Unplanned service from model specificationsnvarchar100NUMC(N'0000000000')YesTMP_INTROW Allow NULL? 
43STLV_LIMService line refers to standard service catalog limitschar10CHAR(N' ')YesSTLV_LIM Allow NULL? 
44LIMIT_ROWEntry: Unplanned, limit linenvarchar100NUMC(N'0000000000')No*LIMIT_ROW Allow NULL? 
45ACT_MENGEPurchase Order: Entered Quantitydecimal133QUAN((0))NoACT_MENGE
46ACT_WERTEntered Valuedecimal112CURR((0))NoACT_WERT
47KNT_WERTContract: Value Released (via Release Orders)decimal112CURR((0))NoKNT_WERT
48KNT_MENGEContract: Quantity Released (by Issue of Release Orders)decimal133QUAN((0))NoKNT_MENGE
49ZIELWERTTarget Valuedecimal112CURR((0))NoWERT_ZIEL
50UNG_WERTContract: Unplanned Released Valuedecimal112CURR((0))NoUNG_WERT
51UNG_MENGEContract: Unplanned Released Quantitydecimal133QUAN((0))NoUNG_MENGE
52ALT_INTROWAlternatives: Reference to basic itemnvarchar100NUMC(N'0000000000')NoALT_INTROW Allow NULL? 
53BASICBasic Linechar10CHAR(N' ')NoGROUND Allow NULL? 
54ALTERNATAlternative Linechar10CHAR(N' ')NoALTERNAT Allow NULL? 
55BIDDERBidder's Linechar10CHAR(N' ')NoBIDDER Allow NULL? 
56SUPPLESupplementary Linechar10CHAR(N' ')NoSUPPLE Allow NULL? 
57FREEQTYLine with Open Quantitychar10CHAR(N' ')NoFREEQTY Allow NULL? 
58INFORMInformatory Linechar10CHAR(N' ')NoINFORM Allow NULL? 
59PAUSCHBlanket Linechar10CHAR(N' ')NoPAUSCHPOS Allow NULL? 
60EVENTUALContingency Linechar10CHAR(N' ')NoEVENTUAL Allow NULL? 
61MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')YesT007AMWSKZ Allow NULL? 
62TXJCDTax Jurisdictionnvarchar150CHAR(N' ')YesTTXJTXJCD Allow NULL? 
63PRS_CHGPrice Change in Entry Sheetchar10CHAR(N' ')YesPRS_CHG Allow NULL? 
64MATKLMaterial Groupnvarchar90CHAR(N' ')YesT023MATKL_SRV Allow NULL? 
65TBTWRGross Pricedecimal112CURR((0))YesSBRTWR
66NAVNWNon-deductible input taxdecimal112CURR((0))YesNAVNW_SRV
67BASWRTax base amountdecimal112CURR((0))YesBASWR
68KKNUMVNumber of the document conditionnvarchar100CHAR(N' ')YesKNUMV Allow NULL? 
69IWEINUnit for Worknvarchar30UNIT(N' ')YesT006IWEIN Allow NULL? 
70INT_WORKInternal Workdecimal82QUAN((0))YesINT_WORK
71EXTERNALIDSRM Reference Keynvarchar400CHAR(N' ')YesSRMID Allow NULL? 
72KSTARCost Elementnvarchar100CHAR(N' ')Yes*KSTAR Allow NULL? 
73ACT_WORKInternal Workdecimal82QUAN((0))YesINT_WORK
74MAPNOMapping Field f. PACKNO, INTROW at Item Level for Commitmentnvarchar40NUMC(N'0000')YesMAPNO Allow NULL? 
75SRVMAPKEYItem Key for eSOA Messagesnvarchar100NUMC(N'0000000000')YesSRVMAPKEY Allow NULL? 
76TAXTARIFFCODETax Tariff Codenvarchar160CHAR(N' ')YesT604FJ_1B_TAX_TARIFF_CODE Allow NULL? 
77SDATEDatenvarchar80DATS(N'00000000')YesSIDATE Allow NULL? 
78BEGTIMEStart Timenvarchar60TIMS(N'000000')YesBEGINUZ Allow NULL? 
79ENDTIMEEnd Timenvarchar60TIMS(N'000000')YesENDEUZ Allow NULL? 
80PERSEXTExternal Personnel Numbernvarchar400CHAR(N' ')YesPERSEXT Allow NULL? 
81CATSCOUNTECounter for Records in Time Recordingnvarchar120CHAR(N' ')YesCATSCOUNTE Allow NULL? 
82STOKZIndicator: Document Has Been Reversedchar10CHAR(N' ')YesCO_STOKZ Allow NULL? 
83BELNRDocument Numbernvarchar100CHAR(N' ')YesCATSBELNR Allow NULL? 
84FORMELNRFormula Numbernvarchar100CHAR(N' ')YesT167FFORMELNR Allow NULL? 
85FRMVAL1Formula Valuedecimal133QUAN((0))YesFRMVAL
86FRMVAL2Formula Valuedecimal133QUAN((0))YesFRMVAL
87FRMVAL3Formula Valuedecimal133QUAN((0))YesFRMVAL
88FRMVAL4Formula Valuedecimal133QUAN((0))YesFRMVAL
89FRMVAL5Formula Valuedecimal133QUAN((0))YesFRMVAL
90USERF1_NUMUser-Defined Fieldnvarchar100NUMC(N'0000000000')YesUSERF1_NUM Allow NULL? 
91USERF2_NUMUser-Defined Fielddecimal133QUAN((0))YesUSERF2_NUM
92USERF1_TXTUser-Defined Fieldnvarchar400CHAR(N' ')YesUSERF1_TXT Allow NULL? 
93USERF2_TXTUser-Defined Fieldnvarchar100CHAR(N' ')YesUSERF2_TXT Allow NULL? 
94KNOBJNumber of Object with Assigned Dependenciesnvarchar180NUMC(N'000000000000000000')YesKNOBJ Allow NULL? 
95CHGTEXTShort Text Change Allowedchar10CHAR(N' ')YesCHGTEXT Allow NULL? 
96KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120NUMC(N'000000000000')Yes*CK_KALNR Allow NULL? 
97KLVARCosting Variantnvarchar40CHAR(N' ')Yes*CK_KLVAR Allow NULL? 
98EXTREFKEYExternal Reference Key for Servicenvarchar400CHAR(N' ')YesEXTREFKEY Allow NULL? 
99INV_MENGEPurchase Order: Quantity Entered from the Invoicedecimal133QUAN((0))YesINV_MENGE
100PER_SDATEPeriod of Performance Start Datenvarchar80DATS(N'00000000')YesMMSRV_PEROP_SDATE Allow NULL? 
101PER_EDATEPeriod of Performance End Datenvarchar80DATS(N'00000000')YesMMSRV_PEROP_EDATE Allow NULL? 
NamePrimaryUniqueTypeColumns
ESLL~0YesYesCLUSTEREDINTROW, PACKNO, MANDT
ESLL~003NoNoNONCLUSTEREDINTROW, PACKNO, KTEXT1, MANDT
ESLL~1NoNoNONCLUSTEREDINTROW, PACKNO, SRVPOS, MANDT
ESLL~2NoNoNONCLUSTEREDINTROW, PACKNO, STLVPOS, AUSGB, LBNUM, MANDT
ESLL~4NoNoNONCLUSTEREDINTROW, PACKNO, SUB_PACKNO

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