biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / General / Territories
API OTER / Territories
OTER - Territories Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
territryID KEY UNIQUETerritory IDInt
11
PRIMARYYes
descript KEYDescriptionnVarChar
127
DESCRIPTNo
parent KEY UNIQUESuperordinate ObjectInt
11OTER
Territories
-1LOCATIONYes
lindexLocation IndexInt
11
inactiveInactiveVarChar
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



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