|
|
API ADPA
ADPA - Fixed Asset Depreciation Areas - History Table
Business Partner OCRD SQL Table
Fixed Asset Depreciation Areas ODPA SQL Table
Items OITM SQL Table
Sales Tax Authorities Type OSTT SQL Table
Users OUSR SQL Table
Usage of Nota Fiscal OUSG SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Code KEY UNIQUE | Code | nVarChar | 15 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Descr | Description | nVarChar | 100 | |||||
| DirectDpr | Direct Depreciation | VarChar | D) Direct Posting I) Indirect Posting | 1 | D | |||
| RetMeth | Retirement Method | VarChar | G) Gross N) Net | 1 | G | |||
| AreaType | Area Type | VarChar | L) Posting to G/L O) Additional Area D) Derived Area | 1 | O | |||
| DrvdArea | Derived Area | nVarChar | 15 | ODPA Fixed Asset Depreciation Areas | ||||
| DataSource | Data Source | VarChar | 1 | N | ||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| CreateDate | Creation Date | Date | 8 | |||||
| UserSign2 | Updating User | Int | 6 | |||||
| UpdateDate | Date of Update | Date | 8 | |||||
| MainArea | Main Booking Area | VarChar | Y) Yes N) No | 1 | N | |||
| CreditCtrl | Tax Credit Control | VarChar | Y) Yes N) No | 1 | N | |||
| TaxType | Tax Type | Int | 11 | OSTT Sales Tax Authorities Type | ||||
| DirRevPost | Direct Revenue Posting | VarChar | Y) Yes N) No | 1 | N | |||
| SnapshotId | Snapshot ID | Int | 11 | 0 | ||||
| BpTaxCorr | BP for Tax Correction | nVarChar | 15 | OCRD Business Partner | ||||
| ItmTaxCorr | Item for Tax Correction | nVarChar | 20 | OITM Items | ||||
| UsgTaxCorr | Usage for Tax Correction | Int | 11 | OUSG Usage of Nota Fiscal |
Table relationship map
SELECT statement
SELECT
ADPA.Code AS 'Code',
ADPA.Descr AS 'Description',
ADPA.DirectDpr AS 'Direct Depreciation',
ADPA.RetMeth AS 'Retirement Method',
ADPA.AreaType AS 'Area Type',
ADPA.DrvdArea AS 'Derived Area',
ADPA.DataSource AS 'Data Source',
ADPA.UserSign AS 'User Signature',
ADPA.LogInstanc AS 'Log Instance',
ADPA.CreateDate AS 'Creation Date',
ADPA.UserSign2 AS 'Updating User',
ADPA.UpdateDate AS 'Date of Update',
ADPA.MainArea AS 'Main Booking Area',
ADPA.CreditCtrl AS 'Tax Credit Control',
ADPA.TaxType AS 'Tax Type',
ADPA.DirRevPost AS 'Direct Revenue Posting',
ADPA.SnapshotId AS 'Snapshot ID',
ADPA.BpTaxCorr AS 'BP for Tax Correction',
ADPA.ItmTaxCorr AS 'Item for Tax Correction',
ADPA.UsgTaxCorr AS 'Usage for Tax Correction'
FROM ADPA AS ADPA
Related information
Business Partner OCRD SQL Table
Fixed Asset Depreciation Areas ODPA SQL Table
Items OITM SQL Table
Sales Tax Authorities Type OSTT SQL Table
Users OUSR SQL Table
Usage of Nota Fiscal OUSG SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
