|
|
API AWHS
AWHS - Warehouses - History Table
G/L Accounts OACT SQL Table
Business Place OBPL SQL Table
States OCST SQL Table
Counties OCNT SQL Table
Bin Location OBIN SQL Table
Location OLCT SQL Table
Business Partner OCRD SQL Table
Employees OHEM SQL Table
Users OUSR SQL Table
Sales Tax Codes OSTC SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | WhsCode KEY UNIQUE | Warehouse Code | nVarChar | 8 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| WhsName | Warehouse Name | nVarChar | 100 | |||||
| IntrnalKey | Internal Key | Int | 11 | |||||
| Grp_Code | Group Code | nVarChar | 4 | |||||
| BalInvntAc | Inventory Account | nVarChar | 15 | OACT G/L Accounts | ||||
| SaleCostAc | Cost of Goods Sold Account | nVarChar | 15 | OACT G/L Accounts | ||||
| TransferAc | Allocation Account | nVarChar | 15 | OACT G/L Accounts | ||||
| Locked | Locked | VarChar | N) Changeable Y) Locked | 1 | N | |||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| RevenuesAc | Revenue Account | nVarChar | 15 | OACT G/L Accounts | ||||
| VarianceAc | Variance Account | nVarChar | 15 | OACT G/L Accounts | ||||
| DecreasAc | Inventory Offset - Decrease Account | nVarChar | 15 | OACT G/L Accounts | ||||
| IncreasAc | Inventory Offset - Increase Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ReturnAc | Sales Returns Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ExpensesAc | Expense Account | nVarChar | 15 | OACT G/L Accounts | ||||
| EURevenuAc | Revenue Account - EU | nVarChar | 15 | OACT G/L Accounts | ||||
| EUExpensAc | Expense Account - EU | nVarChar | 15 | OACT G/L Accounts | ||||
| FrRevenuAc | Revenue Account - Foreign | nVarChar | 15 | OACT G/L Accounts | ||||
| FrExpensAc | Expense Account - Foreign | nVarChar | 15 | OACT G/L Accounts | ||||
| VatGroup | Tax Group | nVarChar | 8 | OSTC Sales Tax Codes | ||||
| Street | Street | nVarChar | 100 | |||||
| Block | Block | nVarChar | 100 | |||||
| ZipCode | Zip Code | nVarChar | 20 | |||||
| City | City | nVarChar | 100 | |||||
| County | County | nVarChar | 100 | OCNT Counties | ||||
| Country | Country | nVarChar | 3 | OCST States | ||||
| State | Status | nVarChar | 3 | |||||
| Location | Location | Int | 11 | OLCT Location | ||||
| DropShip | Drop-Ship | VarChar | N) No Y) Yes | 1 | N | |||
| ExmptIncom | Exempt Revenue Account | nVarChar | 15 | OACT G/L Accounts | ||||
| UseTax | Allow Use Tax | VarChar | Y) Yes N) No | 1 | N | |||
| PriceDifAc | Price Difference Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ExchangeAc | Exchange Rate Differences Account | nVarChar | 15 | OACT G/L Accounts | ||||
| BalanceAcc | Goods Clearing Account | nVarChar | 15 | OACT G/L Accounts | ||||
| PurchaseAc | Purchase Account | nVarChar | 15 | OACT G/L Accounts | ||||
| PAReturnAc | Purchase Return Account | nVarChar | 15 | OACT G/L Accounts | ||||
| PurchOfsAc | Purchase Offset Account | nVarChar | 15 | OACT G/L Accounts | ||||
| FedTaxID | Federal Tax ID | nVarChar | 32 | |||||
| Building | Building/Floor/Room | Text | 16 | |||||
| ShpdGdsAct | Shipped Goods Account | nVarChar | 15 | OACT G/L Accounts | ||||
| VatRevAct | VAT in Revenue Account | nVarChar | 15 | OACT G/L Accounts | ||||
| DecresGlAc | G/L Decrease Account | nVarChar | 15 | OACT G/L Accounts | ||||
| IncresGlAc | G/L Increase Account | nVarChar | 15 | OACT G/L Accounts | ||||
| Nettable | Nettable | VarChar | Y) Yes N) No | 1 | Y | |||
| StokRvlAct | Inventory Revaluation Account | nVarChar | 15 | OACT G/L Accounts | ||||
| StkOffsAct | Inventory Revaluation Offset Account | nVarChar | 15 | OACT G/L Accounts | ||||
| WipAcct | WIP Inventory Account | nVarChar | 15 | OACT G/L Accounts | ||||
| WipVarAcct | WIP Inventory Variance Account | nVarChar | 15 | OACT G/L Accounts | ||||
| CostRvlAct | COGS Revaluation Account | nVarChar | 15 | OACT G/L Accounts | ||||
| CstOffsAct | COGS Revaluation Offset Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| ExpClrAct | Expense Clearing Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ExpOfstAct | Expense Offset Account | nVarChar | 15 | OACT G/L Accounts | ||||
| objType | Object Type - History | nVarChar | 20 | 64 | ||||
| logInstanc | Log Instance - History | Int | 11 | |||||
| createDate | Creation Date - History | Date | 8 | |||||
| userSign2 | Updating User - History | Int | 6 | OUSR Users | ||||
| updateDate | Date of Update - History | Date | 8 | |||||
| ARCMAct | Sales Credit Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| ARCMFrnAct | Sales Credit Foreign Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| ARCMEUAct | Sales Credit EU Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| ARCMExpAct | Exempted Credits | nVarChar | 15 | OACT G/L Accounts | ||||
| APCMAct | Purchase Credit Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| APCMFrnAct | Foreign Purchase Credit Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| APCMEUAct | EU Purchase Credit Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| RevRetAct | Revenue Returns Account | nVarChar | 15 | OACT G/L Accounts | ||||
| BPLid | Business Place ID | Int | 11 | OBPL Business Place | ||||
| OwnerCode | Owner Code | VarChar | 1) Company Item Property 2) Third-Party Warehouse 3) Third-Party Warehouse | 1 | 1 | |||
| NegStckAct | Negative Stock Adjustment Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| StkInTnAct | Stock In Transit Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| AddrType | Address Type | nVarChar | 100 | |||||
| StreetNo | Street No. | nVarChar | 100 | |||||
| PurBalAct | Purchase Balance Account | nVarChar | 15 | OACT G/L Accounts | ||||
| Excisable | Excisable [Yes/No] | VarChar | Y) Yes N) No | 1 | N | |||
| WhICenAct | Incoming CENVAT Account (WH) | nVarChar | 15 | OACT G/L Accounts | ||||
| WhOCenAct | Outgoing CENVAT Account (WH) | nVarChar | 15 | OACT G/L Accounts | ||||
| WhShipTo | Ship-to Name (WH) | nVarChar | 100 | |||||
| WipOffset | WIP Offset P&L Account | nVarChar | 15 | OACT G/L Accounts | ||||
| StockOffst | Inventory Offset P&L Account | nVarChar | 15 | OACT G/L Accounts | ||||
| StorKeeper | Storekeeper | Int | 11 | OHEM Employees | ||||
| Shipper | Shipper | nVarChar | 15 | OCRD Business Partner | ||||
| BinActivat | Bin Activated [Y/N] | VarChar | Y) Yes N) No | 1 | N | |||
| BinSeptor | Bin Separator | nVarChar | 5 | |||||
| DftBinAbs | Default Bin Internal Number | Int | 11 | OBIN Bin Location | ||||
| DftBinEnfd | Default Bin Enforced [Y/N] | VarChar | Y) Yes N) No | 1 | N | |||
| AutoIssMtd | Auto. Issue Method | Int | 0 1) Bin Location Code Order 2) Alternative Sort Code Order 3) Descending Quantity 4) Ascending Quantity 5) FIFO 6) LIFO | 6 | 0 | |||
| ManageSnB | Drop-Ship Manage SnB | VarChar | N) No Y) Yes | 1 | N | |||
| RecItemsBy | Receiving Bin Locations Method | Int | 0 1) Alternative Sort Code Order | 6 | 0 | |||
| RecBinEnab | Enable Receiving Bin Locations | VarChar | Y) Yes N) No | 1 | N | |||
| GlblLocNum | Global Location Number | nVarChar | 50 | |||||
| RecvEmpBin | Restrict Receipts to Empty Bin | VarChar | Y) Yes N) No | 1 | Y | |||
| Inactive | Inactive [Y/N] | VarChar | Y) Yes N) No | 1 | N | |||
| RecvMaxQty | Recv. up to Max. Qty | VarChar | Y) Yes N) No | 1 | N | |||
| AutoRecvMd | Auto. Receipt Method | Int | 0 1) Last Bin Location That Received Item 2) Item's Current Bin Locations 3) Item's Current and Historical Bin Locations | 6 | 0 | |||
| RecvMaxWT | Recv. up to Max. Weight | VarChar | Y) Yes N) No | 1 | N | |||
| RecvUpTo | Receive up to | nVarChar | 0 1) Maximum Weight 2) Max. Qty and Weight | 6 | 0 | |||
| FreeChrgSA | Free of Charge Sales Account | nVarChar | 15 | |||||
| FreeChrgPU | Free of Charge Purchase Account | nVarChar | 15 |
Table relationship map
SELECT statement
SELECT
AWHS.WhsCode AS 'Warehouse Code',
AWHS.WhsName AS 'Warehouse Name',
AWHS.IntrnalKey AS 'Internal Key',
AWHS.Grp_Code AS 'Group Code',
AWHS.BalInvntAc AS 'Inventory Account',
AWHS.SaleCostAc AS 'Cost of Goods Sold Account',
AWHS.TransferAc AS 'Allocation Account',
AWHS.Locked AS 'Locked',
AWHS.DataSource AS 'Data Source',
AWHS.UserSign AS 'User Signature',
AWHS.RevenuesAc AS 'Revenue Account',
AWHS.VarianceAc AS 'Variance Account',
AWHS.DecreasAc AS 'Inventory Offset - Decrease Account',
AWHS.IncreasAc AS 'Inventory Offset - Increase Account',
AWHS.ReturnAc AS 'Sales Returns Account',
AWHS.ExpensesAc AS 'Expense Account',
AWHS.EURevenuAc AS 'Revenue Account - EU',
AWHS.EUExpensAc AS 'Expense Account - EU',
AWHS.FrRevenuAc AS 'Revenue Account - Foreign',
AWHS.FrExpensAc AS 'Expense Account - Foreign',
AWHS.VatGroup AS 'Tax Group',
AWHS.Street AS 'Street',
AWHS.Block AS 'Block',
AWHS.ZipCode AS 'Zip Code',
AWHS.City AS 'City',
AWHS.County AS 'County',
AWHS.Country AS 'Country',
AWHS.State AS 'Status',
AWHS.Location AS 'Location',
AWHS.DropShip AS 'Drop-Ship',
AWHS.ExmptIncom AS 'Exempt Revenue Account',
AWHS.UseTax AS 'Allow Use Tax',
AWHS.PriceDifAc AS 'Price Difference Account',
AWHS.ExchangeAc AS 'Exchange Rate Differences Account',
AWHS.BalanceAcc AS 'Goods Clearing Account',
AWHS.PurchaseAc AS 'Purchase Account',
AWHS.PAReturnAc AS 'Purchase Return Account',
AWHS.PurchOfsAc AS 'Purchase Offset Account',
AWHS.FedTaxID AS 'Federal Tax ID',
AWHS.Building AS 'Building/Floor/Room',
AWHS.ShpdGdsAct AS 'Shipped Goods Account',
AWHS.VatRevAct AS 'VAT in Revenue Account',
AWHS.DecresGlAc AS 'G/L Decrease Account',
AWHS.IncresGlAc AS 'G/L Increase Account',
AWHS.Nettable AS 'Nettable',
AWHS.StokRvlAct AS 'Inventory Revaluation Account',
AWHS.StkOffsAct AS 'Inventory Revaluation Offset Account',
AWHS.WipAcct AS 'WIP Inventory Account',
AWHS.WipVarAcct AS 'WIP Inventory Variance Account',
AWHS.CostRvlAct AS 'COGS Revaluation Account',
AWHS.CstOffsAct AS 'COGS Revaluation Offset Acct',
AWHS.ExpClrAct AS 'Expense Clearing Account',
AWHS.ExpOfstAct AS 'Expense Offset Account',
AWHS.objType AS 'Object Type - History',
AWHS.logInstanc AS 'Log Instance - History',
AWHS.createDate AS 'Creation Date - History',
AWHS.userSign2 AS 'Updating User - History',
AWHS.updateDate AS 'Date of Update - History',
AWHS.ARCMAct AS 'Sales Credit Acct',
AWHS.ARCMFrnAct AS 'Sales Credit Foreign Acct',
AWHS.ARCMEUAct AS 'Sales Credit EU Acct',
AWHS.ARCMExpAct AS 'Exempted Credits',
AWHS.APCMAct AS 'Purchase Credit Acct',
AWHS.APCMFrnAct AS 'Foreign Purchase Credit Acct',
AWHS.APCMEUAct AS 'EU Purchase Credit Acct',
AWHS.RevRetAct AS 'Revenue Returns Account',
AWHS.BPLid AS 'Business Place ID',
AWHS.OwnerCode AS 'Owner Code',
AWHS.NegStckAct AS 'Negative Stock Adjustment Acct',
AWHS.StkInTnAct AS 'Stock In Transit Acct',
AWHS.AddrType AS 'Address Type',
AWHS.StreetNo AS 'Street No.',
AWHS.PurBalAct AS 'Purchase Balance Account',
AWHS.Excisable AS 'Excisable [Yes/No]',
AWHS.WhICenAct AS 'Incoming CENVAT Account (WH)',
AWHS.WhOCenAct AS 'Outgoing CENVAT Account (WH)',
AWHS.WhShipTo AS 'Ship-to Name (WH)',
AWHS.WipOffset AS 'WIP Offset P&L Account',
AWHS.StockOffst AS 'Inventory Offset P&L Account',
AWHS.StorKeeper AS 'Storekeeper',
AWHS.Shipper AS 'Shipper',
AWHS.BinActivat AS 'Bin Activated [Y/N]',
AWHS.BinSeptor AS 'Bin Separator',
AWHS.DftBinAbs AS 'Default Bin Internal Number',
AWHS.DftBinEnfd AS 'Default Bin Enforced [Y/N]',
AWHS.AutoIssMtd AS 'Auto. Issue Method',
AWHS.ManageSnB AS 'Drop-Ship Manage SnB',
AWHS.RecItemsBy AS 'Receiving Bin Locations Method',
AWHS.RecBinEnab AS 'Enable Receiving Bin Locations',
AWHS.GlblLocNum AS 'Global Location Number',
AWHS.RecvEmpBin AS 'Restrict Receipts to Empty Bin',
AWHS.Inactive AS 'Inactive [Y/N]',
AWHS.RecvMaxQty AS 'Recv. up to Max. Qty',
AWHS.AutoRecvMd AS 'Auto. Receipt Method',
AWHS.RecvMaxWT AS 'Recv. up to Max. Weight',
AWHS.RecvUpTo AS 'Receive up to',
AWHS.FreeChrgSA AS 'Free of Charge Sales Account',
AWHS.FreeChrgPU AS 'Free of Charge Purchase Account'
FROM AWHS AS AWHS
Related information
G/L Accounts OACT SQL Table
Business Place OBPL SQL Table
States OCST SQL Table
Counties OCNT SQL Table
Bin Location OBIN SQL Table
Location OLCT SQL Table
Business Partner OCRD SQL Table
Employees OHEM SQL Table
Users OUSR SQL Table
Sales Tax Codes OSTC SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
