| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPConditions |
1 | A095 | Activities + Purchasing Organization | 5 | SRVPOS | Activity Number | nvarchar | 18 | 0 | | |
2 | A096 | Activities for Vendor | 6 | SRVPOS | Activity Number | nvarchar | 18 | 0 | | |
3 | A097 | Activities for Vendor with Plant | 7 | SRVPOS | Activity Number | nvarchar | 18 | 0 | | |
4 | A104 | Service Conditions (Own Estimate) | 4 | SRVPOS | Activity Number | nvarchar | 18 | 0 | | |
5 | KOTF004 | Service No./Plant/PurchOrg/Vendor/Package Number/Line Number | 3 | SRVPOS | Activity Number | nvarchar | 18 | 0 | | |
TOPCustomer Bill of Services |
6 | A370 | Customer/Service | 5 | SRVPOS | Activity Number | nvarchar | 18 | 0 | | |
TOPData Collection |
7 | S174 | Services | 8 | SRVPOS | Activity Number | nvarchar | 18 | 0 | | |
8 | S174BIW1 | S174BIW1 * Activities | 8 | SRVPOS | Activity Number | nvarchar | 18 | 0 | | |
9 | S174BIW2 | S174BIW2 * Activities | 8 | SRVPOS | Activity Number | nvarchar | 18 | 0 | | |
10 | S174E | S174 - Structural Information | 3 | SRVPOS | Activity Number | nvarchar | 18 | 0 | | |
TOPExternal Services |
11 | ESLL | Lines of Service Package | 6 | SRVPOS | Activity Number | nvarchar | 18 | 0 | | |
12 | ESLP | Service Item | 2 | SRVPOS | Activity Number | nvarchar | 18 | 0 | | |
13 | ESUP | Ext. Services Management: Unpl. Limits on Service Package | 5 | SRVPOS | Activity Number | nvarchar | 18 | 0 | | |
TOPInvoice Verification |
14 | RBDRSEG | Batch IV: Invoice Document Items | 86 | SRVPOS | Service number | nvarchar | 18 | 0 | | |
TOPPurchasing |
15 | EKBE | History per Purchasing Document | 50 | SRVPOS | Service number | nvarchar | 18 | 0 | | |
16 | EKBEH | Removed PO History Records | 50 | SRVPOS | Service number | nvarchar | 18 | 0 | | |