biuan SAP® BUSINESS ONE SDK
DTW States
API States Service / State
OCST - States Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CodeCodenVarChar
3
Country KEY UNIQUECountrynVarChar
3OCRY
Countries
PRIMARYYes
NameNamenVarChar
100
UserSignUser SignatureInt
6OUSR
Users
eCodeeCodeInt
6
GNRECodeGNRE CodenVarChar
4

Table relationship map

SELECT statement

SELECT OCST.Code AS 'Code', OCST.Country AS 'Country', OCST.Name AS 'Name', OCST.UserSign AS 'User Signature', OCST.eCode AS 'eCode', OCST.GNRECode AS 'GNRE Code' FROM OCST AS OCST

Related information


State State Object· Table: OCST
Represents a state that can be included, for example, in an address for a business partner. Source table: OCST All properties are mandatory.
   Parent: States Service StatesService Service· Table: OCST

States Service StatesService Service· Table: OCST
The StatesService service enables you to add, look up and remove states in the states master data table. States are assigned to business partners and other objects as part of the address information. Each state is associated with a specific...

OCST SQL Table

Countries OCRY SQL Table

Users OUSR 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