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  | HRT1719
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
1ERP EHP76.0HRT1719771Table Section for Infotype 1719
SQL:  selectupdate insert create

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

SELECT MANDT, TABNR, TABSEQNR, DATATYPE, DEGREENR, DEGREEID, PROGRAMID, DEGERNFLAG, DEGDATE, DEGEXTGRADE, DEGEXTGRADENORM, DEGEXTSCALEID, DEGMANFLAG, DEGINTGRADE, DEGINTGRADENORM, DEGINTSCALEID, DEGHONORS, SPECDEGREENR, SPECID, SPECTYPE, SESSIONID, SESSIONYEAR, SESBEGDATE, SESENDDATE, SESWITHDRDATE, SESDEGREEID, SESPROGRAMID, STAGEID, PROGCLASSID, PROGACST, PROGSTAT, EXTSESGPA, EXTSESGPANORM, EXTSESGPASCALE, SESGPAMANFLAG, INTSESGPA, INTSESGPANORM, INTSESGPASCALE, EXTSESATMCRED, EXTSESGRDCRED, EXTSESERNCRED, EXTSESCREDTYPE, SESCREDMANFLAG, INTSESATMCRED, INTSESGRDCRED, INTSESERNCRED, INTSESCREDTYPE, COURSEID, EXTGRADE, EXTGRADENORM, EXTGRADESCALE, GRADEMANFLAG, INTGRADE, INTGRADENORM, INTGRADESCALE, COREPEATFLAG, HONORSINDIC, EXTCOATMCRED, EXTCOGRDCRED, EXTCOERNCRED, EXTCOCREDTYPE, COCREDMANFLAG, INTCOATMCRED, INTCOGRDCRED, INTCOERNCRED, INTCOCREDTYPE, BASFORCOCRED, COREFLAG, COWITHDRDATE, COSESID, COSESYEAR, COBEGDATE, COENDDATE, CODEDNOTEID, COMMENTLINE, LINENR, FREETEXTLINE FROM HRT1719
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2TABNRReference Number to Table Partnvarchar320CHAR(N' ')NoHRITABNRHRTABNR Allow NULL? 
3TABSEQNRSequence Number in Table Part of Table Infotypenvarchar60NUMC(N'000000')NoHRTABSEQNR Allow NULL? 
4DATATYPERecord Typenvarchar20NUMC(N'00')YesPIQTRDATATYPE Allow NULL? 
5DEGREENRNumber of Degree/Qualificationnvarchar20NUMC(N'00')YesPIQTRDEGREENR Allow NULL? 
6DEGREEIDDegree/Qualificationnvarchar80NUMC(N'00000000')Yes*PIQTRDEGREEID Allow NULL? 
7PROGRAMIDRegistered Programnvarchar120CHAR(N' ')YesPIQTRPROGRAMID Allow NULL? 
8DEGERNFLAGIndicator: Degree or Qualification Earnedchar10CHAR(N' ')YesPIQTRDEGERNFLAG Allow NULL? 
9DEGDATE(Anticipated) Completion Datenvarchar80DATS(N'00000000')YesPIQTRDEGDATE Allow NULL? 
10DEGEXTGRADEExternal Grade Achieved in Qualificationnvarchar100CHAR(N' ')YesPIQTRDEGEXTMARK Allow NULL? 
11DEGEXTGRADENORMExternal Grade of Achieved Qualification (Std Value)decimal82DEC((0))YesPIQTRDEGEXTGRADENORM
12DEGEXTSCALEIDAcademic Scale Identification (ID)nvarchar40CHAR(N' ')YesT7PIQSCALEPIQSCALE_ID Allow NULL? 
13DEGMANFLAGOverwrite Internal Grade of Qualification Manuallychar10CHAR(N' ')YesPIQTRDEGMANFLAG Allow NULL? 
14DEGINTGRADEInternal Grade of Achieved Qualificationnvarchar100CHAR(N' ')YesPIQTRDEGINTGRADE Allow NULL? 
15DEGINTGRADENORMInternal Grade of Achieved Qualification (Std Value)decimal82DEC((0))YesPIQTRDEGINTGRADENORM
16DEGINTSCALEIDAcademic Scale Identification (ID)nvarchar40CHAR(N' ')YesT7PIQSCALEPIQSCALE_ID Allow NULL? 
17DEGHONORSAcademic Honors in Qualificationnvarchar40CHAR(N' ')YesT7PIQTRDEGHONPIQTRDEGHONORS Allow NULL? 
18SPECDEGREENRNumber of Degree/Qualificationnvarchar20NUMC(N'00')YesPIQTRDEGREENR Allow NULL? 
19SPECIDChosen Program Specializationnvarchar160CHAR(N' ')YesT7PIQSMDISZIPPIQTRDEGSPECID Allow NULL? 
20SPECTYPESpecialization Typenvarchar40CHAR(N' ')YesT7PIQMODGRPCATPIQTRDEGSPECTYPE Allow NULL? 
21SESSIONIDExternal Academic Sessionnvarchar40CHAR(N' ')YesT7PIQTREXTSESPIQTRSESSIONID Allow NULL? 
22SESSIONYEARYear of Registrationnvarchar40NUMC(N'0000')YesPIQTRSESSIONYEAR Allow NULL? 
23SESBEGDATEStart Date of Academic Sessionnvarchar80DATS(N'00000000')YesPIQTRSESBEGDATE Allow NULL? 
24SESENDDATEEnd Date of Academic Sessionnvarchar80DATS(N'00000000')YesPIQTRSESENDDATE Allow NULL? 
25SESWITHDRDATEDe-registration Datenvarchar80DATS(N'00000000')YesPIQTRSESWITHDRDATE Allow NULL? 
26SESDEGREEIDDegree/Qualificationnvarchar80NUMC(N'00000000')Yes*PIQTRDEGREEID Allow NULL? 
27SESPROGRAMIDRegistered Programnvarchar120CHAR(N' ')YesPIQTRPROGRAMID Allow NULL? 
28STAGEIDRegistered Program Stagenvarchar20NUMC(N'00')YesT7PIQLEVELPIQTRSTAGEID Allow NULL? 
29PROGCLASSIDProgress Classificationnvarchar40CHAR(N' ')YesT7PIQPROGCLASSPIQTRPROGCLASSID Allow NULL? 
30PROGACSTExternal Academic Standingnvarchar40CHAR(N' ')YesT7PIQTRPROGASPIQTRPROGACST Allow NULL? 
31PROGSTATProgram Progression Statusnvarchar30NUMC(N'000')YesT7PIQPROGSTATUSPIQPROGSTATUS Allow NULL? 
32EXTSESGPAExternal Sessional Averagenvarchar100CHAR(N' ')YesPIQTREXTSESGPA Allow NULL? 
33EXTSESGPANORMOriginal Sessional Average Standard Value)decimal82DEC((0))YesPIQTREXTSESGPANORM
34EXTSESGPASCALEGrading Scale for Original Sessional Averagenvarchar40CHAR(N' ')YesT7PIQSCALEPIQTREXTSESGPASCALE Allow NULL? 
35SESGPAMANFLAGOverwrite Internal Sessional Average Manuallychar10CHAR(N' ')YesTRPIQSESGPAMANFLAG Allow NULL? 
36INTSESGPAInternal Sessional Averagenvarchar100CHAR(N' ')YesPIQTRINTSESGPA Allow NULL? 
37INTSESGPANORMInternal Sessional Average (Standard Value)decimal82DEC((0))YesPIQTRINTSESGPANORM
38INTSESGPASCALEGrading Scale for Internal Sessional Averagenvarchar40CHAR(N' ')YesT7PIQSCALEPIQTRINTSESGPASCALE Allow NULL? 
39EXTSESATMCREDAttempted Credits Per Academic Sessiondecimal105QUAN((0))YesPIQTREXTSESATMCRED
40EXTSESGRDCREDGraded Credits Per Academic Sessiondecimal105QUAN((0))YesPIQTREXTSESGRDCRED
41EXTSESERNCREDEarned Credits Per Academic Sessiondecimal105QUAN((0))YesPIQTREXTSESERNCRED
42EXTSESCREDTYPEExternal Credit Type of Sessional Creditsnvarchar30UNIT(N' ')YesT7PIQCPPIQTREXTSESCREDTYPE Allow NULL? 
43SESCREDMANFLAGOverwrite Converted Sessional Credits Manuallychar10CHAR(N' ')YesPIQTRSESCREDMANFLAG Allow NULL? 
44INTSESATMCREDAttempted Credits Per Session In Internal Credit Typedecimal105QUAN((0))YesPIQTRINTSESATMCRED
45INTSESGRDCREDGraded Credits Per Session In Internal Credit Typedecimal105QUAN((0))YesPIQTRINTSESGRDCRED
46INTSESERNCREDEarned Credits Per Session In Internal Credit Typedecimal105QUAN((0))YesPIQTRINTSESERNCRED
47INTSESCREDTYPECredit Type of Converted Sessional Creditsnvarchar30UNIT(N' ')YesT7PIQCPPIQTRINTSESCREDTYPE Allow NULL? 
48COURSEIDRegistered Subjectnvarchar80NUMC(N'00000000')Yes*PIQTRCOURSEID Allow NULL? 
49EXTGRADEOriginal Grade in External Subjectnvarchar100CHAR(N' ')YesPIQTREXTGRADE Allow NULL? 
50EXTGRADENORMOriginal Grade per Subject (Standard Value)decimal82DEC((0))YesPIQTREXTGRADENORM
51EXTGRADESCALEGrading Scale for Original Gradenvarchar40CHAR(N' ')YesT7PIQSCALEPIQTREXTGRADESCALE Allow NULL? 
52GRADEMANFLAGOverwrite Converted Original Grade of External Subjectchar10CHAR(N' ')YesPIQTRGRADEMANFLAG Allow NULL? 
53INTGRADEOriginal Grade in External Subject on Internal Grading Scalenvarchar100CHAR(N' ')YesPIQTRINTGRADE Allow NULL? 
54INTGRADENORMConverted Grade per Subject (Standard Value)decimal82DEC((0))YesPIQTRINTGRADENORM
55INTGRADESCALEInternal Grading Scale for Converted Grade per Subjectnvarchar40CHAR(N' ')YesT7PIQSCALEPIQTRINTGRADESCALE Allow NULL? 
56COREPEATFLAGIndicator: Repeated Subjectchar10CHAR(N' ')YesPIQTRCOREPEATFLAG Allow NULL? 
57HONORSINDICIndicator: Honors Subjectchar10CHAR(N' ')YesPIQTRHONORSINDIC Allow NULL? 
58EXTCOATMCREDAttempted Credits in External Subjectdecimal105QUAN((0))YesPIQTREXTCOATMCRED
59EXTCOGRDCREDGraded Credits in External Subjectdecimal105QUAN((0))YesPIQTREXTCOGRDCRED
60EXTCOERNCREDEarned Credits in External Subjectdecimal105QUAN((0))YesPIQTREXTCOERNCRED
61EXTCOCREDTYPEOriginal Credit Type of External Subjectnvarchar30UNIT(N' ')YesT7PIQCPPIQTREXTCOCREDTYPE Allow NULL? 
62COCREDMANFLAGOverwrite Converted Credits Per External Subject Manuallychar10CHAR(N' ')YesPIQTRCOCREDMANFLAG Allow NULL? 
63INTCOATMCREDAttempted Credits in Ext. Subject in Internal Credit Typedecimal105QUAN((0))YesPIQTRINTCOATMCRED
64INTCOGRDCREDGraded Credits in Ext. Subject in Internal Credit Typedecimal105QUAN((0))YesPIQTRINTCOGRDCRED
65INTCOERNCREDEarned Credits in Ext. Subject in Internal Credit Typedecimal105QUAN((0))YesPIQTRINTCOERNCRED
66INTCOCREDTYPEInternal Credit Typenvarchar30UNIT(N' ')YesT7PIQCPPIQTRINTCOCREDTYPE Allow NULL? 
67BASFORCOCREDBasis for Accomplished Creditsnvarchar40CHAR(N' ')YesT7PIQTRBASFORCPPIQTRBASFORCOCRED Allow NULL? 
68COREFLAGIndicator for Core Subjectchar10CHAR(N' ')YesPIQTRCOREFLAG Allow NULL? 
69COWITHDRDATEDate of Withdrawalnvarchar80DATS(N'00000000')YesPIQTRCOWITHDRDATE Allow NULL? 
70COSESIDSession In Which External Subject Was Takennvarchar40CHAR(N' ')YesT7PIQTREXTSESPIQTRCOSESID Allow NULL? 
71COSESYEARYear In Which Subject Was Takennvarchar40NUMC(N'0000')YesPIQTRCOSESYEAR Allow NULL? 
72COBEGDATEStart Date of Subjectnvarchar80DATS(N'00000000')YesPIQTRCOBEGDATE Allow NULL? 
73COENDDATEEnd Date of Subjectnvarchar80DATS(N'00000000')YesPIQTRCOENDDATE Allow NULL? 
74CODEDNOTEIDCoded Notenvarchar120CHAR(N' ')YesT7PIQTRCODNOTEPIQTRCODEDNOTEID Allow NULL? 
75COMMENTLINECommentnvarchar800CHAR(N' ')YesPIQTRCOMMENT Allow NULL? 
76LINENRLine Number in SAP TextEditnvarchar40NUMC(N'0000')YesPIQTRLINENR Allow NULL? 
77FREETEXTLINECommentsnvarchar790CHAR(N' ')YesPIQTRFREETEXTLINE Allow NULL? 
NamePrimaryUniqueTypeColumns
HRT1719~0YesYesCLUSTEREDTABSEQNR, TABNR, 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