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
Logistics - General :: Merchandise and Assortment Planning
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TWISPC_BREAKDT41Text Table for Grouping Break-DownsMerchandise and Assortment Planning
SQL:  selectupdate insert create

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

SELECT MANDT, SPRAS, BREAKD, BREAKDTXT FROM TWISPC_BREAKDT
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2SPRASLanguage Keychar10LANG(N' ')NoT002SPRAS Allow NULL? 
3BREAKDGrouping Break-Downnvarchar200CHAR(N' ')NoTWISPC_BREAKDWISP_BREAKD Allow NULL? 
4BREAKDTXTDescription of Grouping Break-Downnvarchar500CHAR(N' ')YesWISP_BREAKDTXT Allow NULL? 
NamePrimaryUniqueTypeColumns
TWISPC_BREAKDT~0YesYesCLUSTEREDMANDT, SPRAS, BREAKD