|
|
SQL Business Partners / Territories
DTW Administration / Setup / General / Territories
API OTER / Territories
OTER - Territories Table
Territories Territories Object· Table: OTER
Territories OTER SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | territryID KEY UNIQUE | Territory ID | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| descript KEY | Description | nVarChar | 127 | DESCRIPT | No | |||
| parent KEY UNIQUE | Superordinate Object | Int | 11 | OTER Territories | -1 | LOCATION | Yes | |
| lindex | Location Index | Int | 11 | |||||
| inactive | Inactive | VarChar | Y) Yes N) No | 1 | N |
SELECT statement
SELECT
OTER.territryID AS 'Territory ID',
OTER.descript AS 'Description',
OTER.parent AS 'Superordinate Object',
OTER.lindex AS 'Location Index',
OTER.inactive AS 'Inactive'
FROM OTER AS OTER
Related information
Territories Territories Object· Table: OTER
Territories is a business object that represents the territory segmentation. This object is part of the Business Partners module. Territories are segments of the market that are defined by attributes such as geographical locations, product lines,...
Territories OTER SQL Table
Territories
Method
Property
Description
DTW DB
Inactive
DTW DB
LocationIndex
DTW DB
Parent
DTW DB
TerritoryID
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
