| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIncident Recording |
1 | EHHSSD_INC_VIOLN | Incident - Violation Notice | 14 | REC_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
2 | /BEV3/CHCDPALLOC | CDP: R/3 Environment Data | 40 | REC_TIMESTAMP | CH: Time Stamp | nvarchar | 14 | 0 | | |
3 | /BEV3/CHCDPBEWSD | CDP: Contract Dates (SD Valuation) | 23 | REC_TIMESTAMP | CH: Time Stamp | nvarchar | 14 | 0 | | |
4 | /BEV3/CHCDPBK | CDP: Purchase Control Results | 31 | REC_TIMESTAMP | CH: Time Stamp | nvarchar | 14 | 0 | | |
5 | /BEV3/CHCDPCTR1 | CDP: Contract Data 1 - General Contract Data | 94 | REC_TIMESTAMP | CH: Time Stamp | nvarchar | 14 | 0 | | |
6 | /BEV3/CHCDPCTR2 | CDP: Contract Data 2 - Specific Contract Data | 137 | REC_TIMESTAMP | CH: Time Stamp | nvarchar | 14 | 0 | | |
7 | /BEV3/CHCDPCUST | CDP: Contract Data Customer | 25 | REC_TIMESTAMP | CH: Time Stamp | nvarchar | 14 | 0 | | |
8 | /BEV3/CHCDPLINK | CDP: Contract References | 16 | REC_TIMESTAMP | CH: Time Stamp | nvarchar | 14 | 0 | | |
9 | /BEV3/CHCDPOBJ1 | CDP: Object Partner | 14 | REC_TIMESTAMP | CH: Time Stamp | nvarchar | 14 | 0 | | |
10 | /BEV3/CHCDPOBJ2 | CDP: Object Partner | 10 | REC_TIMESTAMP | CH: Time Stamp | nvarchar | 14 | 0 | | |
11 | /BEV3/CHCDPOBJMD | CDP: Object Master Data | 24 | REC_TIMESTAMP | CH: Time Stamp | nvarchar | 14 | 0 | | |
12 | /BEV3/CHCDPOBLIG | CDP: Contractual Services | 34 | REC_TIMESTAMP | CH: Time Stamp | nvarchar | 14 | 0 | | |
13 | /BEV3/CHCDPSALDO | CDP: Contract Balances / Totals | 21 | REC_TIMESTAMP | CH: Time Stamp | nvarchar | 14 | 0 | | |
14 | /BEV3/CHCDPSALES | CDP: Contract Sales (Detailed) | 23 | REC_TIMESTAMP | CH: Time Stamp | nvarchar | 14 | 0 | | |
15 | /BEV3/CHCDPSORTM | CDP: Contract Assortments | 18 | REC_TIMESTAMP | CH: Time Stamp | nvarchar | 14 | 0 | | |
16 | /BEV3/CHCDPSTATE | CDP: Status of Contract Handling | 13 | REC_TIMESTAMP | CH: Time Stamp | nvarchar | 14 | 0 | | |
17 | /BEV3/CHCDPTERMI | CDP: Contract Dates (Dates and PC) | 40 | REC_TIMESTAMP | CH: Time Stamp | nvarchar | 14 | 0 | | |
18 | /BEV3/CHCDPTEXT | CDP: Contract Texts | 10 | REC_TIMESTAMP | CH: Time Stamp | nvarchar | 14 | 0 | | |