SAP table reference
FSH_COLLECTIONS
Database table for FSH CollectionsExplore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table FSH_COLLECTIONS.
SAP table FSH_COLLECTIONS has 4 primary key fields: MANDT,FSH_SEASON_YEAR,FSH_SEASON,FSH_COLLECTION.
When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.
/ Fields
FSH_COLLECTIONS fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |
|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | MANDT | ||
| Key FSH_SEASON_YEAR | Season Year | CHAR | 4 | 0 | FSH_SEASONS | FSH_SAISJ | |
| Key FSH_SEASON | Season | CHAR | 10 | 0 | FSH_SEASONS | FSH_SAISO | |
| Key FSH_COLLECTION | Fashion Collection | CHAR | 10 | 0 | FSH_COLLECTION | ||
| FSH_CREATEUSER | User Who Created the Object | CHAR | 12 | 0 | FSH_CREATEUSER | ||
| FSH_CREATEDATE | Date on Which the Object Was Created | DATS | 8 | 0 | FSH_CREATEDATE | ||
| FSH_CREATETIME | Time at Which the Object Was Created | TIMS | 6 | 0 | FSH_CREATETIME | ||
| FSH_CHANGEUSER | Last User to Change the Object | CHAR | 12 | 0 | FSH_CHANGEUSER | ||
| FSH_CHANGEDATE | Date on Which the Object Was Last Changed | DATS | 8 | 0 | FSH_CHANGEDATE | ||
| FSH_CHANGETIME | Time at Which the Object Was Last Changed | TIMS | 6 | 0 | FSH_CHANGETIME | ||
| RFM_PRIORITY | Priority | NUMC | 2 | 0 | RFM_PRIORITY | ||
| RFM_SEA_COMPLETNESS | Season Completeness Group | CHAR | 37 | 0 | RFM_SEASON_COMPLETNESS | ||
| RFM_SEASON_CATEGORY | Season Category | CHAR | 5 | 0 | RFM_SEA_CATGRY | RFM_SEASON_CATEGORY | |
| FSH_VALIDITY_FRM | Valid From Date | DATS | 8 | 0 | FSH_SEA_VALID_FROM | ||
| FSH_VALIDITY_TO | Valid To Date | DATS | 8 | 0 | FSH_SEA_VALID_TO |
/ Relationships
FSH_COLLECTIONS relationships.
| Table | Field | Check table | Description | Check field |
|---|---|---|---|---|
| FSH_COLLECTIONS | FSH_SEASON | FSH_SEASONS | Database table for FSH Seasons | FSH_SEASON_YEAR |
| FSH_COLLECTIONS | FSH_SEASON | FSH_SEASONS | Database table for FSH Seasons | FSH_SEASON |
| FSH_COLLECTIONS | FSH_SEASON_YEAR | FSH_SEASONS | Database table for FSH Seasons | FSH_SEASON_YEAR |
| FSH_COLLECTIONS | FSH_SEASON_YEAR | FSH_SEASONS | Database table for FSH Seasons | FSH_SEASON |
| FSH_COLLECTIONS | RFM_SEASON_CATEGORY | RFM_SEA_CATGRY | Season Category | MANDT |
| FSH_COLLECTIONS | RFM_SEASON_CATEGORY | RFM_SEA_CATGRY | Season Category | RFM_SEASON_CATEGORY |