SAP WGDS_TI_ALLERGEN Pricat Storage for TI related Allergen Information Table
Overview
WGDS_TI_ALLERGEN is a standard SAP S/4HANA table that stores Pricat Storage for TI related Allergen Information data. There are total 13 fields in the WGDS_TI_ALLERGEN table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WGDS_TI_ALLERGEN belongs to Price Catalog Inbound (LO-RFM-MD-PCT-IN) module and is located in the package Enhancements to GDS, like nutrition facts (WGDS_ENHANCEMENTS).
In addition, following links provide an overview of foreign key relationships, if any, that link WGDS_TI_ALLERGEN to other SAP tables and standard CDS views available based on WGDS_TI_ALLERGEN table in S/4HANA 2020.
Techincal Settings of WGDS_TI_ALLERGEN
Below are technical details of the table WGDS_TI_ALLERGEN
- Buffering allowed but switched off
- No buffering
- Storage type is Column Store
List of WGDS_TI_ALLERGEN Fields
The following table gives you an overview of the fields available in WGDS_TI_ALLERGEN
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| TI_ID | Trade Item Identifier | WGDS_TI_ID | CHAR | 35 | |
| TI_ID_TYPE | Type of Trade Item ID | WGDS_TI_ID_TYPE | * | CHAR | 2 |
| GLN_INFO_PROVIDER | GLN Info Provider | WGDS_GLN_INFO_PROVIDER | CHAR | 35 | |
| WGDS_TM_COUNTRY | Target Market of a Trade Item | WGDS_TARGET_MARKET | CHAR | 3 | |
| WGDS_TM_SUBDIVIS | Region of a Trade Item | WGDS_REGION | CHAR | 3 | |
| VALIDITY | Validity Date of a Trade Item | WGDS_VALIDITY | DATS | 8 | |
| RECORD_TYPE | Price Catalog | WRF_PRODUCTGROUP_FLAG | CHAR | 1 | |
| VERSION | Time Stamp of Last Change by Data Provider | WGDS_TIMESTAMP_LAST_CHANGE | DEC | 15 | |
| ALLERG_TYPE_CODE | GDS TradeItem Allergen Type Code | WGDS_NUTRI_ALLERG_TYPE_CODE | WGDS_TI_AL_TYPCO | CHAR | 3 |
| LEVEL_CONTAIN | GDS TradeItem Allergen Level of containment | WGDS_NUTRI_ALLERG_LEVEL_CONT | CHAR | 12 | |
| SPEC_NAME | Allergen Specification Name | WGDS_NUTRI_ALLERG_SPEC_NAME | CHAR | 70 | |
| SPEC_AGENCY | Allergen Specification Agency | WGDS_NUTRI_ALLERG_SPEC_AGENCY | CHAR | 70 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WGDS_TI_ALLERGEN
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WGDS_TI_ALLERGEN | ALLERG_TYPE_CODE | 1: CN | WGDS_TI_AL_TYPCO |