|
|
API APRC
APRC - Cost Center Table
Cost Center Type OCCT SQL Table
Cost Accounting Dimension ODIM SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | PrcCode KEY UNIQUE | Center Code | nVarChar | 8 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| PrcName | Center Name | nVarChar | 30 | |||||
| GrpCode | Group Code | nVarChar | 4 | |||||
| Balance | Balance | Num | 20 | |||||
| Locked | Locked | VarChar | Y) Yes N) No | 1 | N | |||
| DataSource | Data Source | VarChar | 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 | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| DimCode | In Which Dimension | Int | 6 | ODIM Cost Accounting Dimension | 1 | |||
| CCTypeCode | Cost Center Type Code | nVarChar | 8 | OCCT Cost Center Type | ||||
| ValidFrom | Valid From | Date | 8 | |||||
| ValidTo | Valid To | Date | 8 | |||||
| Active | Active | VarChar | Y) Yes N) No | 1 | Y | |||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Update Date | Date | 8 |
Table relationship map
SELECT statement
SELECT
APRC.PrcCode AS 'Center Code',
APRC.PrcName AS 'Center Name',
APRC.GrpCode AS 'Group Code',
APRC.Balance AS 'Balance',
APRC.Locked AS 'Locked',
APRC.DataSource AS 'Data Source',
APRC.UserSign AS 'User Signature',
APRC.DimCode AS 'In Which Dimension',
APRC.CCTypeCode AS 'Cost Center Type Code',
APRC.ValidFrom AS 'Valid From',
APRC.ValidTo AS 'Valid To',
APRC.Active AS 'Active',
APRC.LogInstanc AS 'Log Instance',
APRC.UserSign2 AS 'Updating User',
APRC.UpdateDate AS 'Update Date'
FROM APRC AS APRC
Related information
Cost Center Type OCCT SQL Table
Cost Accounting Dimension ODIM SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates