SAP-tabelreferentie
FSH_COLLECTIONS
Database table for FSH CollectionsBekijk een andere tabel
Vul een tabelcode of zoekwoord in om verder te zoeken.
Bekijk de structuur, velden en relaties van SAP-tabel FSH_COLLECTIONS.
SAP-tabel FSH_COLLECTIONS heeft 4 primaire sleutelvelden: MANDT,FSH_SEASON_YEAR,FSH_SEASON,FSH_COLLECTION.
Bij analyse van data uit één SAP-instance is MANDT normaal overal gelijk en kun je dit veld weglaten uit relaties. Combineer je meerdere instances, neem MANDT dan wel op.
/ Velden
FSH_COLLECTIONS velden.
| Veld | Omschrijving | Datatype | Lengte | Decimalen | Checktabel | Data-element | |
|---|---|---|---|---|---|---|---|
| Sleutel MANDT | Client | CLNT | 3 | 0 | MANDT | ||
| Sleutel FSH_SEASON_YEAR | Season Year | CHAR | 4 | 0 | FSH_SEASONS | FSH_SAISJ | |
| Sleutel FSH_SEASON | Season | CHAR | 10 | 0 | FSH_SEASONS | FSH_SAISO | |
| Sleutel 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 |
/ Relaties
FSH_COLLECTIONS relaties.
| Tabel | Veld | Checktabel | Omschrijving | Checkveld |
|---|---|---|---|---|
| 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 |