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
Industry Specific :: SAP Media :: Media Sales and Distribution :: Periodical Sales and Distribution
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0JVTPOTNOTICE51IS-M/SD: Potential Carrier Change NotificationsPeriodical Sales and Distribution
SQL:  selectupdate insert create

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

SELECT MANDT, VBELN, POSNR_UR, DELIVSPLIT, CHGDATE FROM JVTPOTNOTICE
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2VBELNIS-M/SD: Publishing Sales Ordernvarchar100 Allow NULL? 
3POSNR_UROriginal Item in Publishing Sales Ordernvarchar60 Allow NULL? 
4DELIVSPLITIS-M/SD: Alternating Address Elementnvarchar80 Allow NULL? 
5CHGDATEPotential Date for Carrier Change Notificationnvarchar80 Allow NULL? 
NamePrimaryUniqueTypeColumns
JVTPOTNOTICE~0YesYesCLUSTEREDCHGDATE, DELIVSPLIT, POSNR_UR, VBELN, MANDT