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  | KLAH
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 :: Classes
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0KLAH557Class Header DataClasses
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, KNOBJ, LOCLA, KATALOG, KDOKAZ, GENRKZ FROM KLAH
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2CLINTInternal Class Numbernvarchar100NUMC(N'0000000000')NoCLINT Allow NULL? 
3KLARTClass Typenvarchar30CHAR(N' ')YesTCLAKLASSENART Allow NULL? 
4CLASSClass numbernvarchar180CHAR(N' ')YesKLASSE_D Allow NULL? 
5STATUClass statuschar10CHAR(N' ')YesTCLUKLSTATUS Allow NULL? 
6KLAGRClass Groupnvarchar100CHAR(N' ')YesTCLGKLASSENGR Allow NULL? 
7BGRSEAuthorization group for finding objectsnvarchar30CHAR(N' ')YesBGRSE Allow NULL? 
8BGRKLClassification authorization groupnvarchar30CHAR(N' ')YesBGRKL Allow NULL? 
9BGRKPClass maintenance authorization groupnvarchar30CHAR(N' ')YesBGRKP Allow NULL? 
10ANAMEName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
11ADATUDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
12VNAMEName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
13VDATUChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
14VONDTValid-From Datenvarchar80DATS(N'00000000')YesVONDAT Allow NULL? 
15BISDTValid-to datenvarchar80DATS(N'00000000')YesBISDAT Allow NULL? 
16ANZUONumber of Assignmentsnvarchar50NUMC(N'00000')YesANZUOR Allow NULL? 
17PRAUSSame classificationchar10CHAR(N' ')YesGLKLAFZ Allow NULL? 
18SICHTOrganizational Areanvarchar100CHAR(N' ')YesABTEILUNG Allow NULL? 
19DOKNRDocument numbernvarchar250CHAR(N' ')Yes*DOKNR Allow NULL? 
20DOKARDocument Typenvarchar30CHAR(N' ')Yes*DOKAR Allow NULL? 
21DOKTLDocument Partnvarchar30CHAR(N' ')YesDOKTL_D Allow NULL? 
22DOKVRDocument Versionnvarchar20CHAR(N' ')YesDOKVR Allow NULL? 
23DINKZDIN class indicatorchar10CHAR(N' ')YesDINKEN Allow NULL? 
24NNORMName of standards organizationnvarchar100CHAR(N' ')YesNORM Allow NULL? 
25NORMNStandard Numbernvarchar200CHAR(N' ')YesNORMNR Allow NULL? 
26NORMBIndustry Standard Descriptionnvarchar700CHAR(N' ')YesNORMBE Allow NULL? 
27NRMT1Standard titlenvarchar700CHAR(N' ')YesNORMTITEL Allow NULL? 
28NRMT2Standard titlenvarchar700CHAR(N' ')YesNORMTITEL Allow NULL? 
29AUSGDIssue datenvarchar80DATS(N'00000000')YesAUSGDT Allow NULL? 
30VERSDVersion datenvarchar80DATS(N'00000000')YesVERSDT Allow NULL? 
31VERSIVersion Numbernvarchar20NUMC(N'00')YesVERSIO Allow NULL? 
32LEISTCharacteristics tablenvarchar200CHAR(N' ')YesLEISTE Allow NULL? 
33VERWEUsage in superior classeschar10CHAR(N' ')YesVERWENDUNG Allow NULL? 
34SPARTDivisionnvarchar20CHAR(N' ')Yes*SPART Allow NULL? 
35LREF3List object type for variable listsnvarchar30CHAR(N' ')YesLISTOBJ Allow NULL? 
36WWSKZMerchandize management system class typechar10CHAR(N' ')YesWWS_KLTYP Allow NULL? 
37WWSSIMMS view of collective materialchar10CHAR(N' ')YesWWS_SICHT Allow NULL? 
38POTPRResulting item categorychar10CHAR(N' ')Yes*POTPR_CL Allow NULL? 
39CLOBKRequired Componentchar10CHAR(N' ')YesCLOBK Allow NULL? 
40CLMULMultiple Selection Allowedchar10CHAR(N' ')YesCLMULT Allow NULL? 
41CVIEWOrganizational Areanvarchar100CHAR(N' ')YesABTEILUNG Allow NULL? 
42DISSTLow-Level Codenvarchar30CHAR(N' ')YesDISST_CL Allow NULL? 
43MEINSBase Unit of Measurenvarchar30UNIT(N' ')YesT006MEINS Allow NULL? 
44CLMODDefault Class Data - Can Be Overwritten in Componentchar10CHAR(N' ')YesCLMOD Allow NULL? 
45VWSTLCan Be Used in Bills of Materialchar10CHAR(N' ')YesVWSTL Allow NULL? 
46VWPLACan Be Used in Task Listschar10CHAR(N' ')YesVWPLA Allow NULL? 
47CLALTAlternative Display Formatchar10CHAR(N' ')YesCLALT Allow NULL? 
48LBREITotal width of listnvarchar30NUMC(N'000')YesLBREITE Allow NULL? 
49BNAMEBlock namenvarchar200CHAR(N' ')YesBLNAME Allow NULL? 
50MAXBLMaximum display block for variable listsnvarchar180CHAR(N' ')YesMAXBLOCK Allow NULL? 
51KNOBJNumber of Object with Assigned Dependenciesnvarchar180NUMC(N'000000000000000000')YesKNOBJ Allow NULL? 
52LOCLALocal classchar10CHAR(N' ')YesLOCAL_CLASS Allow NULL? 
53KATALOGName of External Catalognvarchar300CHAR(N' ')YesKATALOGNAME Allow NULL? 
54KDOKAZAlways Display Document for Classchar10CHAR(N' ')YesKDOKAZ Allow NULL? 
55GENRKZTable for Finding Objects: To Be Generated=X, Generated=Rchar10CHAR(N' ')YesGENRKZ Allow NULL? 
NamePrimaryUniqueTypeColumns
KLAH~0YesYesCLUSTEREDCLINT, MANDT
KLAH~1NoNoNONCLUSTEREDCLASS, KLART, MANDT
KLAH~2NoNoNONCLUSTEREDKLAGR, MANDT
KLAH~3NoNoNONCLUSTEREDDINKZ, MANDT
KLAH~4NoNoNONCLUSTEREDNNORM, MANDT
KLAH~5NoNoNONCLUSTEREDDOKNR, KLART, MANDT
KLAH~6NoNoNONCLUSTEREDWWSKZ, 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