SAP table TWSAI ((Annual) Seasons)
SAP table TWSAI has 4 primary key fields being MANDT,SAISO,KJAHR,SAITY.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| SAISO | Season Category | CHAR | 4 | 0 | T6WSP | SAISO | |
| KJAHR | Season Year | CHAR | 4 | 0 | SAISJ | ||
| SAITY | Rollout in a Season | CHAR | 2 | 0 | T6WSA | SAITY | |
| DATUV | Valid-From Date | DATS | 8 | 0 | DATUV | ||
| DATUB | Valid-to date | DATS | 8 | 0 | DATUB | ||
| UMSEZ | Status of season wind-up | CHAR | 1 | 0 | UMSETZ_KZ | ||
| DTLVF | Date from which listed in the store | DATS | 8 | 0 | LDVFL | ||
| DTLBF | Date to which listed in the store | DATS | 8 | 0 | LDBFL | ||
| DTLVV | Date from which listed in the distribution center | DATS | 8 | 0 | LDVZL | ||
| DTLBV | Date to which listed in the central warehouse/distr. center | DATS | 8 | 0 | LDBZL | ||
| DTVVF | Date from which sold in the store | DATS | 8 | 0 | VDVFL | ||
| DTVBF | Date to which sold in the store | DATS | 8 | 0 | VDBFL | ||
| DTVVV | Date from which sold in the distribution center | DATS | 8 | 0 | VDVZL | ||
| DTVBV | Date to which sold in the distribution center | DATS | 8 | 0 | VDBZL | ||
| TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | DEC | 15 | 0 | TIMESTAMP |
TWSAI foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TWSAI | SAISO | T6WSP | Check Table for Season Indicator | MANDT |
| 0 TWSAI | SAISO | T6WSP | Check Table for Season Indicator | SAISO |
| 1 TWSAI | SAITY | T6WSA | Categories of seasonal materials | MANDT |
| 1 TWSAI | SAITY | T6WSA | Categories of seasonal materials | SAITY |