| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DTW Financials / Cost Accounting / Profit Centers / Cost Center API Profit Centers Service / Profit Center | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
OPRC - Cost Center Table SBO SQL database table details
Table relationship mapSELECT statementSELECT
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 informationProfit Center ProfitCenter Object· Table: OPRC Represents a profit center.
Source table: OPRC
Mandatory properties: CenterCode, CenterName ![]() 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 |