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  | LKLAH
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
Cross-Application Components :: Classification :: Environment
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0LKLAH503Class Header (Special Objects)Environment
SQL:  selectupdate insert create

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

SELECT MANDT, CLINT, KLART, CLASS, STATU, KLAGR, BGRSE, BGRKL, BGRKP, ANAME, ADATU, VNAME, VDATU, VONDT, BISDT, ANZUO, PRAUS, SICHT, DOKNR, DOKAR, DOKTL, DOKVR, DINKZ, NNORM, NORMN, NORMB, NRMT1, NRMT2, AUSGD, VERSD, VERSI, LEIST, VERWE, SPART, LREF3, WWSKZ, WWSSI, POTPR, CLOBK, CLMUL, CVIEW, DISST, MEINS, CLMOD, VWSTL, VWPLA, CLALT, LBREI, BNAME, MAXBL FROM LKLAH
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2CLINTInternal class numbernvarchar100NUMC(N'0000000000')NoCLINTV Allow NULL? 
3KLARTClass Typenvarchar30CHAR(N' ')No*KLASSENART Allow NULL? 
4CLASSClass numbernvarchar180CHAR(N' ')NoKLASSE_D Allow NULL? 
5STATUClass statuschar10CHAR(N' ')No*KLSTATUS Allow NULL? 
6KLAGRClass Groupnvarchar100CHAR(N' ')No*KLASSENGR Allow NULL? 
7BGRSEAuthorization group for finding objectsnvarchar30CHAR(N' ')NoBGRSE Allow NULL? 
8BGRKLClassification authorization groupnvarchar30CHAR(N' ')NoBGRKL Allow NULL? 
9BGRKPClass maintenance authorization groupnvarchar30CHAR(N' ')NoBGRKP Allow NULL? 
10ANAMEName of Person who Created the Objectnvarchar120CHAR(N' ')NoERNAM Allow NULL? 
11ADATUDate on Which Record Was Creatednvarchar80DATS(N'00000000')NoERDAT Allow NULL? 
12VNAMEName of Person Who Changed Objectnvarchar120CHAR(N' ')NoAENAM Allow NULL? 
13VDATUChanged Onnvarchar80DATS(N'00000000')NoAEDAT Allow NULL? 
14VONDTValid-From Datenvarchar80DATS(N'00000000')NoVONDAT Allow NULL? 
15BISDTValid-to datenvarchar80DATS(N'00000000')NoBISDAT Allow NULL? 
16ANZUONumber of Assignmentsnvarchar50NUMC(N'00000')NoANZUOR Allow NULL? 
17PRAUSSame classificationchar10CHAR(N' ')NoGLKLAFZ Allow NULL? 
18SICHTOrganizational Areanvarchar100CHAR(N' ')NoABTEILUNG Allow NULL? 
19DOKNRDocument numbernvarchar250CHAR(N' ')No*DOKNR Allow NULL? 
20DOKARDocument Typenvarchar30CHAR(N' ')No*DOKAR Allow NULL? 
21DOKTLDocument Partnvarchar30CHAR(N' ')NoDOKTL_D Allow NULL? 
22DOKVRDocument Versionnvarchar20CHAR(N' ')NoDOKVR Allow NULL? 
23DINKZDIN class indicatorchar10CHAR(N' ')NoDINKEN Allow NULL? 
24NNORMName of standards organizationnvarchar100CHAR(N' ')NoNORM Allow NULL? 
25NORMNStandard Numbernvarchar200CHAR(N' ')NoNORMNR Allow NULL? 
26NORMBIndustry Standard Descriptionnvarchar700CHAR(N' ')NoNORMBE Allow NULL? 
27NRMT1Standard titlenvarchar700CHAR(N' ')NoNORMTITEL Allow NULL? 
28NRMT2Standard titlenvarchar700CHAR(N' ')NoNORMTITEL Allow NULL? 
29AUSGDIssue datenvarchar80DATS(N'00000000')NoAUSGDT Allow NULL? 
30VERSDVersion datenvarchar80DATS(N'00000000')NoVERSDT Allow NULL? 
31VERSIVersion Numbernvarchar20NUMC(N'00')NoVERSIO Allow NULL? 
32LEISTCharacteristics tablenvarchar200CHAR(N' ')NoLEISTE Allow NULL? 
33VERWEUsage in superior classeschar10CHAR(N' ')NoVERWENDUNG Allow NULL? 
34SPARTDivisionnvarchar20CHAR(N' ')No*SPART Allow NULL? 
35LREF3List object type for variable listsnvarchar30CHAR(N' ')NoLISTOBJ Allow NULL? 
36WWSKZMerchandize management system class typechar10CHAR(N' ')NoWWS_KLTYP Allow NULL? 
37WWSSIMMS view of collective materialchar10CHAR(N' ')NoWWS_SICHT Allow NULL? 
38POTPRResulting item categorychar10CHAR(N' ')No*POTPR Allow NULL? 
39CLOBKRequired Componentchar10CHAR(N' ')NoCLOBK Allow NULL? 
40CLMULMultiple Selection Allowedchar10CHAR(N' ')NoCLMULT Allow NULL? 
41CVIEWOrganizational Areanvarchar100CHAR(N' ')NoABTEILUNG Allow NULL? 
42DISSTLow-Level Codenvarchar30CHAR(N' ')NoDISST Allow NULL? 
43MEINSBase Unit of Measurenvarchar30UNIT(N' ')No*MEINS Allow NULL? 
44CLMODDefault Class Data - Can Be Overwritten in Componentchar10CHAR(N' ')NoCLMOD Allow NULL? 
45VWSTLCan Be Used in Bills of Materialchar10CHAR(N' ')NoVWSTL Allow NULL? 
46VWPLACan Be Used in Task Listschar10CHAR(N' ')NoVWPLA Allow NULL? 
47CLALTAlternative Display Formatchar10CHAR(N' ')NoCLALT Allow NULL? 
48LBREITotal width of listnvarchar30NUMC(N'000')NoLBREITE Allow NULL? 
49BNAMEBlock namenvarchar200CHAR(N' ')NoBLNAME Allow NULL? 
50MAXBLMaximum display block for variable listsnvarchar180CHAR(N' ')NoMAXBLOCK Allow NULL? 
NamePrimaryUniqueTypeColumns
LKLAH~0YesYesCLUSTEREDCLINT, MANDT
LKLAH~1NoNoNONCLUSTEREDMANDT, CLASS
LKLAH~2NoNoNONCLUSTEREDCLASS, KLART, 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