| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | /OPT/APPR_COA | Approval COA | 16 | INTERNAL_ORDER | Order Number | nvarchar | 12 | 0 | ||
| 2 | /OPT/AT_APPR_HIS | Approval History for Level Based Approvals | 23 | INTERNAL_ORDER | Order Number | nvarchar | 12 | 0 | ||
| 3 | /OPT/AT_LBA_LOG | Approval History for Level Based Approvals | 24 | INTERNAL_ORDER | Order Number | nvarchar | 12 | 0 | ||
| 4 | /OPT/LIAP_MATX | Line Item Approval Matrix Table | 30 | INTERNAL_ORDER | Order Number | nvarchar | 12 | 0 | ||
| 5 | CIAP_D_RECORD | CIAP Record | 11 | INTERNAL_ORDER | Order Number | nvarchar | 12 | 0 | ||
| Financial Accounting | ||||||||||
| 6 | /OPT/BL_APPCOA | Approval COA | 11 | INTERNAL_ORDER | Order Number | nvarchar | 12 | 0 | ||
| Joint Venture und Production Sharing Accounting | ||||||||||
| 7 | T8JOH_COST_OBJS | Table of cost centers, projects and orders for each overhead | 6 | INTERNAL_ORDER | Order Number | nvarchar | 12 | 0 | ||
| Supply Chain Management | ||||||||||
| 8 | TCM_ORG_INO_MAP | Mapping TCM Organizational Units -> Account Assignment obj | 5 | INTERNAL_ORDER | Order Number | nvarchar | 12 | 0 | ||
| Travel Expenses | ||||||||||
| 9 | PTRV_SCOS | Trip Statistics - Cost Assignment | 10 | INTERNAL_ORDER | Order Number | nvarchar | 12 | 0 | ||