SAP Tables - SAP Business One/ERP Table Definition reference

 Module:  Table: 

icon of database logic symbol SAP  TABLESv1Made in Britain - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10BSEG345Accounting Document Segment

B1 9.2: Top 10 requests

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

2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OINM101Whse Journal
1Business One9.3ITMR1025ITMRGeneral
SQL:  selectupdate insert create

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

SELECT DocCode, ItemId, Container, Type, VISIBLE, SupZeros, ItemLeft, ItemTop, Width, Height, LMargin, RMargin, TMargin, BMargin, LeftLine, RightLine, TopLine, BottomLine, Shadow, BGRed, BGGreen, BGBlue, FGRed, FGGreen, FGBlue, MrkrRed, MrkrGreen, MrkrBlue, BrdrRed, BrdrGreen, BrdrBlue, FromPane, ToPane, ItemGroup, FontName, FontSize, TextStyle, Justific, WRAP, PictSize, DataSource, ItemStr, VarNum, FileName, FieldNum, ShowDescr, CalcType, ChangFlags, ApplID, CalcCol, YJustific, SortLevel, RevOrder, SortType, IsUnique, IsGroup, NewPage, BarCode, Condition, LinkTo, Operator1, Operator2, Operation, BCStandard, SumInWords, ExcFonting, StrIndex, ContIndex, ItemIndex, StrLength, StrFiller, RelatedTo, NextSeg, HightAdjst, DupRpttAre, LnsRpttAre, RptDupDist, ItemDesc, ExportXml, DocType, Local, Numerator, Language, Created, Updated, UsrSgnStr, UsrSgnAttr, IsRef, FieldId, FGEnabled, BGEnabled, MKEnabled, BDEnabled, HidEmpRptt, RpttFtrAll, GbiDataTyp, GbiDataLen, PageBreak, IsLogo, VarDefName, ResCode, RevCode FROM ITMR


ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1DocCodeReportnvarchar80 Allow NULL? 
2ItemIdItem IDint60 Allow NULL? 
3ContainerParent Typeint60 Allow NULL? 
4TypeTypeint6010=Text field, 11=Picture field, 12=User field, 1=Page header, 2=Start of report, 3=Repetitive area header, 4=Repetitive area, 5=Repetitive area footer, 6=End of report, 7=Page footer Allow NULL? 
5VISIBLEVisiblechar1010=No, 1=Yes Allow NULL? 
6SupZerosSuppress Zeroschar1000=No, 1=Yes Allow NULL? 
7ItemLeftLeft Itemint60 Allow NULL? 
8ItemTopTopint60 Allow NULL? 
9WidthWidthint60 Allow NULL? 
10HeightHeightint60 Allow NULL? 
11LMarginLeft Marginint600 Allow NULL? 
12RMarginRight Marginint600 Allow NULL? 
13TMarginTop Marginint600 Allow NULL? 
14BMarginBottom Marginint600 Allow NULL? 
15LeftLineLeft Border Line Thicknessint600 Allow NULL? 
16RightLineRight Border Line Thicknessint600 Allow NULL? 
17TopLineTop Border Line Thicknessint600 Allow NULL? 
18BottomLineBottom Border Line Thicknessint600 Allow NULL? 
19ShadowShadow Thicknessint600 Allow NULL? 
20BGRedBackground - Redint11065535 Allow NULL? 
21BGGreenBackground - Greenint11065535 Allow NULL? 
22BGBlueBackground - Blueint11065535 Allow NULL? 
23FGRedText - Redint1100 Allow NULL? 
24FGGreenText - Greenint1100 Allow NULL? 
25FGBlueText - Blueint1100 Allow NULL? 
26MrkrRedBold - Redint11065535 Allow NULL? 
27MrkrGreenBold - Greenint11065535 Allow NULL? 
28MrkrBlueBold - Blueint11065535 Allow NULL? 
29BrdrRedBorder - Redint1100 Allow NULL? 
30BrdrGreenBorder - Greenint1100 Allow NULL? 
31BrdrBlueBorder - Blueint1100 Allow NULL? 
32FromPaneFrom Areaint600 Allow NULL? 
33ToPaneTo Areaint600 Allow NULL? 
34ItemGroupGroup No.int600 Allow NULL? 
35FontNameFont Namenvarchar500Arial Allow NULL? 
36FontSizeFont Sizeint6012 Allow NULL? 
37TextStyleText Styleint110 Allow NULL? 
38JustificHorizontal Justificationchar1021=Right, 2=Left, 3=Center, 4=Language Dependent Allow NULL? 
39WRAPSegmentchar1010=Allow overflow, 1=Fit to cell, 2=Devide to lines Allow NULL? 
40PictSizePicture Sizechar1010=Original size, 1=Size of box, 2=Adjust to box, 3=Adjust to box height, 4=Adjust to box width Allow NULL? 
41DataSourceData Sourcechar1011=Static, 2=Var, 3=Data, 4=Calculation Allow NULL? 
43VarNumVariable No.int60 Allow NULL? 
44FileNameFile Namenvarchar200 Allow NULL? 
45FieldNumField No.nvarchar100 Allow NULL? 
46ShowDescrDisplay Descriptionchar1000=No, 1=Yes Allow NULL? 
47CalcTypeCalculation Typenvarchar201-1=[new formula String], 0=Formula, 10=Continue, 11=Continued on next page, 12=Generation message, 13=Column summary for page, 14=Column average for page, 15=Column summary for report, 16=Column average for report, 17=Total Pages, 1=Page number, 2=Date, 3=Time, 4=Column total, 5=Column average, 6=General row no., 7=Group row no., 8=Sort fi Allow NULL? 
48ChangFlagsChangeableint110 Allow NULL? 
49ApplIDItem No.int60 Allow NULL? 
50CalcColCalculation Columnint60 Allow NULL? 
51YJustificVertical Alignmentchar1031=Top, 2=Bottom, 3=Center Allow NULL? 
52SortLevelSort Levelint600 Allow NULL? 
53RevOrderReverse Sortchar1000=Ascending, 1=Descending Allow NULL? 
54SortTypeSort Typechar1000=Alpha, 1=Numeric, 2=Money, 3=Date Allow NULL? 
55IsUniqueUniquechar1000=No, 1=Yes Allow NULL? 
56IsGroupSet as Groupchar1000=No, 1=Yes Allow NULL? 
57NewPageNew Pagechar1000=No, 1=Yes Allow NULL? 
58BarCodePrint as Barcodechar1000=No, 1=Yes Allow NULL? 
60LinkToLink to Itemint600 Allow NULL? 
61Operator1Operator 1int60 Allow NULL? 
62Operator2Operator 2int60 Allow NULL? 
63OperationOperationint6000, 10=Less, 11=LessEq, 12=Equally, 13=Not eq, 14=GrEq, 15=Greater, 16=$Len, 17=Left, 18=Right, 19=Round, 1=+, 20=$Currency, 21=$Number, 2=-, 3=x, 4=/, 5=%, 6=$Concat, 7=$Right, 8=$Left, 9=$Sentence Allow NULL? 
64BCStandardBarcode Standardint6000=EAN-13, 1=Code 39, 2=Code 128 Allow NULL? 
65SumInWordsDisplay Total as a Wordchar1000=No, 1=Yes Allow NULL? 
66ExcFontingBlock Font Changechar1000=No, 1=Yes Allow NULL? 
67StrIndexString Indexint1100 Allow NULL? 
68ContIndexContainer Indexint600 Allow NULL? 
69ItemIndexItem Indexint600 Allow NULL? 
70StrLengthString Lengthint60 Allow NULL? 
71StrFillerString Fillerchar10 Allow NULL? 
72RelatedToRelated to Itemint600 Allow NULL? 
73NextSegNext Segment Item Numint600 Allow NULL? 
74HightAdjstHeight Adjustmentschar10NN=No, Y=Yes Allow NULL? 
75DupRpttAreDuplicate Repeatative Areachar10NN=No, Y=Yes Allow NULL? 
76LnsRpttAreNum Lines In Repeatative Areaint1100 Allow NULL? 
77RptDupDistDistanse To Rptt Dup (pixels)int1100 Allow NULL? 
78ItemDescItem Descriptionnvarchar500 Allow NULL? 
79ExportXmlExport to xmlchar10YN=No, Y=Yes Allow NULL? 
80DocTypeDocument Typenvarchar40 Allow NULL? 
81LocalLocalizationnvarchar20 Allow NULL? 
82NumeratorNumeratorint60 Allow NULL? 
83LanguageLanguageint60 Allow NULL? 
84CreatedCreation Datedate80
85UpdatedUpdated Datedate80
86UsrSgnStrUser Sign For Strings Changeint110-1 Allow NULL? 
87UsrSgnAttrUser Sign For Attribs Changeint110-1 Allow NULL? 
88IsRefIs the item refered by anotherchar10NN=No, Y=Yes Allow NULL? 
89FieldIdField Identifiernvarchar200 Allow NULL? 
90FGEnabledGrid Enabledchar10YN=No, Y=Yes Allow NULL? 
91BGEnabledBackground Enabledchar10YN=No, Y=Yes Allow NULL? 
92MKEnabledHighlight Enabledchar10YN=No, Y=Yes Allow NULL? 
93BDEnabledFrame Enabledchar10YN=No, Y=Yes Allow NULL? 
94HidEmpRpttHide Empty Areachar10NN=No, Y=Yes Allow NULL? 
95RpttFtrAllDisplay Rep. Footer on Allchar10NN=No, Y=Yes Allow NULL? 
96GbiDataTypData Typeint6000, 1=C n, 2=C.. n, 3=I.. n, 4=D w.d Allow NULL? 
97GbiDataLenData Lengthnvarchar60 Allow NULL? 
98PageBreakPage Breakint6000=None, 1=Before Area, 2=After Area Allow NULL? 
99IsLogoIs Logochar10NN=No, Y=Yes Allow NULL? 
100VarDefNameVariable Definition Namenvarchar500 Allow NULL? 
101ResCodeResource Code from RSBDint110-1 Allow NULL? 
102RevCodeRevision Codeint110-1 Allow NULL? 


PRIMARYNoYesDocType, Local, Numerator, Language, ApplID, ResCode, RevCode
TP_LC_NM_LNoNoDocType, Local, Numerator, Language
TYP_LOC_NMNoNoDocType, Local, Numerator
TYPE_LOCNoNoDocType, Local