|
|
SQL Administration / Delivery Types
DTW Administration / Setup / Inventory / Shipping Types
API OSHP / / Shipping Types
OSHP - Delivery Types Table
Shipping Types ShippingTypes Object· Table: OSHP
OSHP SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | TrnspCode KEY UNIQUE | Code | Int | 6 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| TrnspName KEY UNIQUE | Name | nVarChar | 40 | NAME | Yes | |||
| 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 | ||||
| WebSite | Web Site | nVarChar | 50 |
Table relationship map
SELECT statement
SELECT
OSHP.TrnspCode AS 'Code',
OSHP.TrnspName AS 'Name',
OSHP.DataSource AS 'Data Source',
OSHP.UserSign AS 'User Signature',
OSHP.WebSite AS 'Web Site'
FROM OSHP AS OSHP
Related information
Shipping Types ShippingTypes Object· Table: OSHP
The ShippingTypes object enables to define transportation methods (for example, air cargo and courier) to carry out deliveries. A shipping type can be assigned to a document, item master data, and business partner master data.
Source table:...
OSHP SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates