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  | EINA
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
Materials Management :: Purchasing
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0EINA384Purchasing Info Record: General DataPurchasing
SQL:  selectupdate insert create

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

SELECT MANDT, INFNR, MATNR, MATKL, LIFNR, LOEKZ, ERDAT, ERNAM, TXZ01, SORTL, MEINS, UMREZ, UMREN, IDNLF, VERKF, TELF1, MAHN1, MAHN2, MAHN3, URZNR, URZDT, URZLA, URZTP, URZZT, LMEIN, REGIO, VABME, LTSNR, LTSSF, WGLIF, RUECK, LIFAB, LIFBI, KOLIF, ANZPU, PUNEI, RELIF, MFRNR FROM EINA
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2INFNRNumber of Purchasing Info Recordnvarchar100CHAR(N' ')NoINFNR Allow NULL? 
3MATNRMaterial Numbernvarchar180CHAR(N' ')YesMARAMATNR Allow NULL? 
4MATKLMaterial Groupnvarchar90CHAR(N' ')YesT023MATKL Allow NULL? 
5LIFNRVendor Account Numbernvarchar100CHAR(N' ')YesLFA1ELIFN Allow NULL? 
6LOEKZPurchasing info: General data flagged for deletionchar10CHAR(N' ')YesILOEA Allow NULL? 
7ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
8ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
9TXZ01Short Text for Purchasing Info Recordnvarchar400CHAR(N' ')YesEINATX Allow NULL? 
10SORTLSort Term for Non-Stock Info Recordsnvarchar100CHAR(N' ')YesSORTI Allow NULL? 
11MEINSPurchase Order Unit of Measurenvarchar30UNIT(N' ')YesT006BSTME Allow NULL? 
12UMREZNumerator for Conversion of Order Unit to Base Unitdecimal50DEC((0))YesUMBSZ
13UMRENDenominator for Conversion of Order Unit to Base Unitdecimal50DEC((0))YesUMBSN
14IDNLFMaterial Number Used by Vendornvarchar350CHAR(N' ')YesIDNLF Allow NULL? 
15VERKFSalesperson Responsible in the Event of Queriesnvarchar300CHAR(N' ')YesVERKF Allow NULL? 
16TELF1Vendor's Telephone Numbernvarchar160CHAR(N' ')YesTELF0 Allow NULL? 
17MAHN1Number of Days for First Reminder/Expediterdecimal30DEC((0))YesMAHN1
18MAHN2Number of Days for Second Reminder/Expediterdecimal30DEC((0))YesMAHN2
19MAHN3Number of Days for Third Reminder/Expediterdecimal30DEC((0))YesMAHN3
20URZNRCertificate Numbernvarchar100CHAR(N' ')YesURZNR Allow NULL? 
21URZDTCertificate of Origin Valid Untilnvarchar80DATS(N'00000000')YesURZDT Allow NULL? 
22URZLACountry of Issue of Certificate of Originnvarchar30CHAR(N' ')YesT005ULAND Allow NULL? 
23URZTPCertificate Categorychar10CHAR(N' ')YesT069URZTP Allow NULL? 
24URZZTNumbernvarchar160CHAR(N' ')YesURZZT Allow NULL? 
25LMEINBase Unit of Measurenvarchar30UNIT(N' ')YesT006MEINS Allow NULL? 
26REGIORegion (State, Province, County)nvarchar30CHAR(N' ')YesT005SREGIO Allow NULL? 
27VABMEVariable Purchase Order Unit Activechar10CHAR(N' ')YesVABME Allow NULL? 
28LTSNRVendor Subrangenvarchar60CHAR(N' ')YesWYT1LTSNR Allow NULL? 
29LTSSFSort Sequence Numbernvarchar50NUMC(N'00000')YesLTSSF Allow NULL? 
30WGLIFVendor Material Groupnvarchar180CHAR(N' ')YesWGLIF Allow NULL? 
31RUECKReturn Agreementnvarchar20CHAR(N' ')YesTWRVW_RUECKNV Allow NULL? 
32LIFABAvailable (Deliverable) Fromnvarchar80DATS(N'00000000')YesLIFAB Allow NULL? 
33LIFBIAvailable (Deliverable) Untilnvarchar80DATS(N'00000000')YesLIFBI Allow NULL? 
34KOLIFPrior Vendornvarchar100CHAR(N' ')YesLFA1KOLIF Allow NULL? 
35ANZPUNumber of Pointsdecimal133QUAN((0))YesANZPU
36PUNEIPoints unitnvarchar30UNIT(N' ')YesT006PUNEI Allow NULL? 
37RELIFRegular Vendorchar10CHAR(N' ')YesRELIF Allow NULL? 
38MFRNRManufacturernvarchar100CHAR(N' ')Yes*MFRNR1 Allow NULL? 
NamePrimaryUniqueTypeColumns
EINA~0YesYesCLUSTEREDINFNR, MANDT
EINA~1NoNoNONCLUSTEREDMATNR, LIFNR, MANDT
EINA~2NoNoNONCLUSTEREDRELIF, MATNR, MANDT
EINA~3NoNoNONCLUSTEREDMATKL, 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