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
Sales and Distribution :: Sales :: Part Load Lift Orders :: Remaining Beverage - Obsolete Objects
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/BEV3/CHCFMVARS71Formula variableRemaining Beverage - Obsolete Objects
SQL:  selectupdate insert create

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

SELECT MANDT, VARID, VBKL_FLNK, RI_FLNK, LINKTYPE, FIELD, REFFIELD FROM /BEV3/CHCFMVARS
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2VARIDIdentifiernvarchar40 Allow NULL? 
3VBKL_FLNKAgreement Classnvarchar40 Allow NULL? 
4RI_FLNKRule Identifiernvarchar60 Allow NULL? 
5LINKTYPELink Typenvarchar40 Allow NULL? 
6FIELDField Namenvarchar300 Allow NULL? 
7REFFIELDReference fieldnvarchar300 Allow NULL? 
NamePrimaryUniqueTypeColumns
/BEV3/CHCFMVARS~0YesYesCLUSTEREDVARID, MANDT