biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Business Partners / Business Partner Groups
API OCRG / / Business Partner Groups
OCRG - Card Groups Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
GroupCode KEY UNIQUEGroup No.Int
6
PRIMARYYes
GroupName KEY UNIQUEGroup NamenVarChar
20
GROUP_NAMEYes
GroupType KEYGroup TypeVarChar
C) Customer Group
S) Vendor Group
1
CGROUP_TYPENo
LockedLockedVarChar
Y) Yes
N) No
1
N
DataSourceData SourceVarChar
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
UserSignUser SignatureInt
6OUSR
Users
PriceListPrice ListInt
6OPLN
Price Lists
DiscRelEffective DiscountVarChar
L) Lowest Discount
H) Highest Discount
A) Average
S) Total
M) Discount Multiples
1
L

Table relationship map

SELECT statement

SELECT OCRG.GroupCode AS 'Group No.', OCRG.GroupName AS 'Group Name', OCRG.GroupType AS 'Group Type', OCRG.Locked AS 'Locked', OCRG.DataSource AS 'Data Source', OCRG.UserSign AS 'User Signature', OCRG.PriceList AS 'Price List', OCRG.DiscRel AS 'Effective Discount' FROM OCRG AS OCRG

Related information


Business Partner Groups BusinessPartnerGroups Object· Table: OCRG
BusinessPartnerGroups represents the setup of customer and vendor Groups. Used for classifing business partners according to groups, such as, sector or size. Source table: OCRG.

OCRG SQL Table

Price Lists OPLN 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