|
|
DTW Administration / Setup / Financials / Forms 1099
API ABP2
ABP2 - Branch Tributary Info. Log Table
Business Place OBPL SQL Table
Object Settings - History ADP1 SQL Table
Brazil Numeric Indexer OBNI SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | BPLId KEY UNIQUE | BPL ID | Int | 11 | OBPL Business Place | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| TributID | Tributary Info. ID | Int | 11 | |||||
| TributType | Tributary Type | Int | 11 | OBNI Brazil Numeric Indexer | -1 | |||
| TTStartDat | Tributary Type Start Date | Date | 8 | |||||
| TTEndDate | Tributary Type End Date | Date | 8 | |||||
| TribRegCod | Tributary Regime Code | Int | 11 | OBNI Brazil Numeric Indexer | -1 | |||
| TRCStartD | Tributary Reg. Code Start Date | Date | 8 | |||||
| TRCEndDate | Tributary Regime Code End Date | Date | 8 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 247 |
Table relationship map
SELECT statement
SELECT
ABP2.BPLId AS 'BPL ID',
ABP2.TributID AS 'Tributary Info. ID',
ABP2.TributType AS 'Tributary Type',
ABP2.TTStartDat AS 'Tributary Type Start Date',
ABP2.TTEndDate AS 'Tributary Type End Date',
ABP2.TribRegCod AS 'Tributary Regime Code',
ABP2.TRCStartD AS 'Tributary Reg. Code Start Date',
ABP2.TRCEndDate AS 'Tributary Regime Code End Date',
ABP2.LogInstanc AS 'Log Instance',
ABP2.ObjType AS 'Object Type'
FROM ABP2 AS ABP2
Related information
Business Place OBPL SQL Table
Object Settings - History ADP1 SQL Table
Brazil Numeric Indexer OBNI SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
