biuan SAP® BUSINESS ONE SDK
API SEWDV
SEWDV - SEWDV Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CompDbNam KEY UNIQUECompany Db NamenVarChar
100
PRIMARYYes
SmpTableIdSmp Table IDnVarChar
3
EwaSentDatEWA Sent DatenVarChar
10
CustNumberCustomer NumberVarChar
1
DocPeriodDoc PeriodnVarChar
32
SalesOrdrsSales OrdersInt
11
SalDlvDocsSales Delivery DocsInt
11
SalesInvsSales InvoicesInt
11
PurcOrdersPurchase OrdersInt
11
GoodRecptsGood ReceiptsInt
11
PurchAPInvPurchase AP InvoicesInt
11
ServicCallService CallsInt
11
MaterBillsMeterial BillsInt
11
WorkOrdersWork OrdersInt
11
SalesOpporOpportunitiesInt
11
ItmMasterDItem Master DataInt
11
CustBPMasDCustomer Bp Master DataInt
11
SuppBPMasDSupplier Bp Master DataInt
11
SalOrdMinRMin Rows Of Sales OrdersInt
11
SlDlvrMinRMin rows Of Sales DEliveryInt
11
SlsInvMinRMin rows Of InvoicesInt
11
PrcOrdMinRMin rows Of Purchase OrdersInt
11
GodRcpMinRMin rows Of Good ReceiptsInt
11
WrkOrdMinRMin rows Of work ordersInt
11
QuotMinRMin rows Of QUOTInt
11
RetMinRMin rows Of RETURNInt
11
DownMinRMin rows Of DOWNInt
11
ARCrdMinRMin rows Of ARCREDITInt
11
GodRecMinRMin rows Of GOODRECInt
11
APRetMinRMin rows Of APRETURNInt
11
APDwnMinRMin rows Of APDOWNInt
11
APInvMinRMin rows Of APINVOICEInt
11
APCrdMinRMin rows Of APCREDITInt
11
SalOrdMaxRMax Rows Of Sales OrdersInt
11
SlDlvrMaxRMax rows Of Sales DEliveryInt
11
SlsInvMaxRMax rows Of InvoicesInt
11
PrcOrdMaxRMax rows Of Purchase OrdersInt
11
GodRcpMaxRMax rows Of Good ReceiptsInt
11
WrkOrdMaxRMax rows Of work ordersInt
11
QuotMaxRMax rows Of QUOTInt
11
RetMaxRMax rows Of RETURNInt
11
DownMaxRMax rows Of DOWNInt
11
ARCrdMaxRMax rows Of ARCREDITInt
11
GodRecMaxRMax rows Of GOODRECInt
11
APRetMaxRMax rows Of APRETURNInt
11
APDwnMaxRMax rows Of APDOWNInt
11
APInvMaxRMax rows Of APINVOICEInt
11
APCrdMaxRMin rows Of APCREDITInt
11
NoPickLstNo of Picklists in systemInt
11
MaxLnPkLstMaximum Lines in Pick ListInt
11
MinLnPkLstMinimum Lines in Pick ListInt
11
MaxChldBmMaximum children per BOMInt
11
NoProdOrdNumber of Production orderInt
11
NoSrlNumNo of Serial number itemsInt
11
NoBatchNumNo of Batch number itemsInt
11
StockTrasNumber of Stock TransfersInt
11
MaxRStTrsMax num of rows per stock tranInt
11
MinRStTrsMin num of rows per stock tranInt
11
NoPriceLst'Number of Price ListsInt
11

SELECT statement

SELECT SEWDV.CompDbNam AS 'Company Db Name', SEWDV.SmpTableId AS 'Smp Table ID', SEWDV.EwaSentDat AS 'EWA Sent Date', SEWDV.CustNumber AS 'Customer Number', SEWDV.DocPeriod AS 'Doc Period', SEWDV.SalesOrdrs AS 'Sales Orders', SEWDV.SalDlvDocs AS 'Sales Delivery Docs', SEWDV.SalesInvs AS 'Sales Invoices', SEWDV.PurcOrders AS 'Purchase Orders', SEWDV.GoodRecpts AS 'Good Receipts', SEWDV.PurchAPInv AS 'Purchase AP Invoices', SEWDV.ServicCall AS 'Service Calls', SEWDV.MaterBills AS 'Meterial Bills', SEWDV.WorkOrders AS 'Work Orders', SEWDV.SalesOppor AS 'Opportunities', SEWDV.ItmMasterD AS 'Item Master Data', SEWDV.CustBPMasD AS 'Customer Bp Master Data', SEWDV.SuppBPMasD AS 'Supplier Bp Master Data', SEWDV.SalOrdMinR AS 'Min Rows Of Sales Orders', SEWDV.SlDlvrMinR AS 'Min rows Of Sales DElivery', SEWDV.SlsInvMinR AS 'Min rows Of Invoices', SEWDV.PrcOrdMinR AS 'Min rows Of Purchase Orders', SEWDV.GodRcpMinR AS 'Min rows Of Good Receipts', SEWDV.WrkOrdMinR AS 'Min rows Of work orders', SEWDV.QuotMinR AS 'Min rows Of QUOT', SEWDV.RetMinR AS 'Min rows Of RETURN', SEWDV.DownMinR AS 'Min rows Of DOWN', SEWDV.ARCrdMinR AS 'Min rows Of ARCREDIT', SEWDV.GodRecMinR AS 'Min rows Of GOODREC', SEWDV.APRetMinR AS 'Min rows Of APRETURN', SEWDV.APDwnMinR AS 'Min rows Of APDOWN', SEWDV.APInvMinR AS 'Min rows Of APINVOICE', SEWDV.APCrdMinR AS 'Min rows Of APCREDIT', SEWDV.SalOrdMaxR AS 'Max Rows Of Sales Orders', SEWDV.SlDlvrMaxR AS 'Max rows Of Sales DElivery', SEWDV.SlsInvMaxR AS 'Max rows Of Invoices', SEWDV.PrcOrdMaxR AS 'Max rows Of Purchase Orders', SEWDV.GodRcpMaxR AS 'Max rows Of Good Receipts', SEWDV.WrkOrdMaxR AS 'Max rows Of work orders', SEWDV.QuotMaxR AS 'Max rows Of QUOT', SEWDV.RetMaxR AS 'Max rows Of RETURN', SEWDV.DownMaxR AS 'Max rows Of DOWN', SEWDV.ARCrdMaxR AS 'Max rows Of ARCREDIT', SEWDV.GodRecMaxR AS 'Max rows Of GOODREC', SEWDV.APRetMaxR AS 'Max rows Of APRETURN', SEWDV.APDwnMaxR AS 'Max rows Of APDOWN', SEWDV.APInvMaxR AS 'Max rows Of APINVOICE', SEWDV.APCrdMaxR AS 'Min rows Of APCREDIT', SEWDV.NoPickLst AS 'No of Picklists in system', SEWDV.MaxLnPkLst AS 'Maximum Lines in Pick List', SEWDV.MinLnPkLst AS 'Minimum Lines in Pick List', SEWDV.MaxChldBm AS 'Maximum children per BOM', SEWDV.NoProdOrd AS 'Number of Production order', SEWDV.NoSrlNum AS 'No of Serial number items', SEWDV.NoBatchNum AS 'No of Batch number items', SEWDV.StockTras AS 'Number of Stock Transfers', SEWDV.MaxRStTrs AS 'Max num of rows per stock tran', SEWDV.MinRStTrs AS 'Min num of rows per stock tran', SEWDV.NoPriceLst AS ''Number of Price Lists' FROM SEWDV AS SEWDV

Related information




SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates