| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | GUID | GUID of Capacity Pot Instance | varbinary | 16 | 0 | RAW | | No | | /MRSS/T_POT_GUID | |
| 3 | GUID_MD_ATTR | GUID of Capacity Pot Master Data Attributes | varbinary | 16 | 0 | RAW | | Yes | | /MRSS/T_POT_GUID_MD_ATTR | |
| 4 | DATE_FROM_TS | Data From Timestamp | decimal | 15 | 0 | DEC | ((0)) | Yes | | /MRSS/T_POT_DATE_FROM_TS | |
| 5 | DATE_TO_TS | Data To Timestamp | decimal | 15 | 0 | DEC | ((0)) | Yes | | /MRSS/T_POT_DATE_TO_TS | |
| 6 | BEGIN_TSTMP | Begin Time Stamp | decimal | 15 | 0 | DEC | ((0)) | Yes | | /MRSS/T_POT_BEGIN_TIMESTAMP | |
| 7 | END_TSTMP | End Timestamp | decimal | 15 | 0 | DEC | ((0)) | Yes | | /MRSS/T_POT_END_TIMESTAMP | |
| 8 | RESOURCES | Resource (FTA) Amount | decimal | 10 | 2 | DEC | ((0)) | Yes | | /MRSS/T_POT_RESOURCES | |
| 9 | INTERVAL_ID | Time Interval ID | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | /MRSS/C_POT_INTV | /MRSS/T_POT_TIMEINTERVAL | Allow NULL? |
| 10 | CAPA_POT | Total Potential Capacity | decimal | 12 | 2 | QUAN | ((0)) | Yes | | /MRSS/T_POT_CAP_POTENTIAL | |
| 11 | CAPA_POT_UNIT | Unit of Potential Capacity | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | /MRSS/T_POT_CAPA_POTEN_UNIT | Allow NULL? |
| 12 | CAPA_REAL | Real Available Capacity | decimal | 12 | 2 | QUAN | ((0)) | Yes | | /MRSS/T_POT_CAPA_REAL | |
| 13 | CAPA_REAL_UNIT | Unit of Real Available Capacity | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | /MRSS/T_POT_CAPA_REAL_UNIT | Allow NULL? |
| 14 | CAPA_RES_CONS | Consumed Capacity Reserve | decimal | 7 | 2 | QUAN | ((0)) | Yes | | /MRSS/T_POT_CAPA_RESERVE_CONS | |
| 15 | CAPA_RES_CONS_UN | Unit for Forecast Capacity Reserve for an SLA | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | /MRSS/T_POT_CAP_RESERVE_S_UNIT | Allow NULL? |
| 16 | CAPA_CONS | Capacity Consumed | decimal | 12 | 2 | QUAN | ((0)) | Yes | | /MRSS/T_POT_CAPA_CONSUMED | |
| 17 | CAPA_CONS_UNIT | Unit of Capacity consumed | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | /MRSS/T_POT_CAPA_CONSUMED_UNIT | Allow NULL? |
| 18 | CREATED_BY | User who created Capacity Pot | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_POT_CREATE_BY | Allow NULL? |
| 19 | CREATED_ON | Creation Timestamp | decimal | 15 | 0 | DEC | ((0)) | Yes | | /MRSS/T_POT_CREATED_ON | |
| 20 | CHANGED_BY | User who changed Capacity Pot | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_POT_CHANGED_BY | Allow NULL? |
| 21 | CHANGED_ON | Change Timestamp | decimal | 15 | 0 | DEC | ((0)) | Yes | | /MRSS/T_POT_CHANGED_ON | |
