biuan SAP® BUSINESS ONE SDK
SQL Sales Opportunities / Cost Center / Cost Center
DTW Financials / Cost Accounting / Profit Centers / Cost Center
API Profit Centers Service / Profit Center
OPRC - Cost Center Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
PrcCode KEY UNIQUECenter CodenVarChar
8
PRIMARYYes
PrcNameCenter NamenVarChar
30
GrpCodeGroup CodenVarChar
4
BalanceBalanceNum
20
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
DimCodeIn Which DimensionInt
6ODIM
Cost Accounting Dimension		1
CCTypeCodeCost Center Type CodenVarChar
8OCCT
Cost Center Type
ValidFromValid FromDate
8
ValidToValid ToDate
8
ActiveActiveVarChar
Y) Yes
N) No
1
Y
LogInstancLog InstanceInt
11
0
UserSign2Updating UserInt
6OUSR
Users
UpdateDateUpdate DateDate
8

Table relationship map

SELECT statement

SELECT OPRC.PrcCode AS 'Center Code', OPRC.PrcName AS 'Center Name', OPRC.GrpCode AS 'Group Code', OPRC.Balance AS 'Balance', OPRC.Locked AS 'Locked', OPRC.DataSource AS 'Data Source', OPRC.UserSign AS 'User Signature', OPRC.DimCode AS 'In Which Dimension', OPRC.CCTypeCode AS 'Cost Center Type Code', OPRC.ValidFrom AS 'Valid From', OPRC.ValidTo AS 'Valid To', OPRC.Active AS 'Active', OPRC.LogInstanc AS 'Log Instance', OPRC.UserSign2 AS 'Updating User', OPRC.UpdateDate AS 'Update Date' FROM OPRC AS OPRC

Related information


Profit Center ProfitCenter Object· Table: OPRC
Represents a profit center. Source table: OPRC Mandatory properties: CenterCode, CenterName
   Parent: Profit Centers Service ProfitCentersService Service· Table: OPRC

Profit Centers Service ProfitCentersService Service· Table: OPRC
The ProfitCentersService service enables you to add, look up and remove profit centers. To see the list of profit centers, select Financials --> Cost Accounting --> Cost Centers, and then choose Open Table. Source table: OPRC

OPRC SQL Table

Cost Center Type OCCT SQL Table

Cost Accounting Dimension ODIM 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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates