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

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription

B1 9.2: Top 10 requests

TableColumnsDescription

B1 8.8: Top 10 requests

TableColumnsDescription
1ERP EHP76.0/BIC/B000028600081PSA for 0PERSON_TEXT T90CLNT090 Person
SQL:  selectupdate insert create

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

SELECT REQUEST, DATAPAKID, PARTNO, RECORD, DATEFROM, DATETO, PERNR, TXTMD FROM /BIC/B0000286000
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1REQUESTRequest number for the data transfernvarchar300 Allow NULL? 
2DATAPAKIDData packet numbernvarchar60 Allow NULL? 
3PARTNOPartition value for PSA tableint100 Allow NULL? 
4RECORDData record numberint100 Allow NULL? 
5DATEFROMnvarchar80 Allow NULL? 
6DATETOnvarchar80 Allow NULL? 
7PERNRnvarchar80 Allow NULL? 
8TXTMDnvarchar400 Allow NULL? 
NamePrimaryUniqueTypeColumns
/BIC/B0000286000~0YesYesCLUSTEREDRECORD, PARTNO, DATAPAKID, REQUEST