SAP WGDS_TI_NUTRIENT Pricat Storage for TI related Nutrient Information Table
Overview
WGDS_TI_NUTRIENT is a standard SAP S/4HANA table that stores Pricat Storage for TI related Nutrient Information data. There are total 20 fields in the WGDS_TI_NUTRIENT table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WGDS_TI_NUTRIENT 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_NUTRIENT to other SAP tables and standard CDS views available based on WGDS_TI_NUTRIENT table in S/4HANA 2020.
Techincal Settings of WGDS_TI_NUTRIENT
Below are technical details of the table WGDS_TI_NUTRIENT
- Buffering allowed but switched off
- No buffering
- Storage type is Column Store
List of WGDS_TI_NUTRIENT Fields
The following table gives you an overview of the fields available in WGDS_TI_NUTRIENT
| 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 | |
| PREP_SEQNO | GDS TradeItem Attribute Sequence Number | WGDS_ATTR_SEQNO | NUMC | 3 | |
| PREP_STATE | GDS TradeItem Nutrient Preparation State | WGDS_NUTRI_PREP_STATE | CHAR | 12 | |
| SERV_SIZE_VALUE | GDS TradeItem Nutrient Serving Size Value | WGDS_NUTRI_SERV_VALUE | NUMC | 4 | |
| SERV_SIZE_UOM | GDS TradeItem Nutrient Serving Size UOM | WGDS_NUTRI_SERV_UOM | CHAR | 3 | |
| NUTR_TYPE_CODE | GDS TradeItem Nutrient Type Code | WGDS_NUTRI_TYPE | WGDS_TI_NUTR_TYP | CHAR | 35 |
| QUAN_UOM | GDS TradeItem Nutrient Quantity Contained UOM | WGDS_NUTRI_QUAN_UOM | UNIT | 3 | |
| QUAN_VALUE | GDS TradeItem Nutrient Quantity Contained Value | WGDS_NUTRI_QUAN_VALUE | DEC | 13 | |
| MEASURE_PRECISION | GDS TradeItem Nutrient Measurement Precision | WGDS_NUTRI_MEASURE_PREC | CHAR | 15 | |
| PERC_DAILY_INTAKE | GDS TradeItem Nutrient Percentage of daily value intake | WGDS_NUTRI_PERC_DAILY_INTAKE | DEC | 5 | |
| PERC_DAILY_INTAKE_LONG | GDS TradeItem Nutrient Percentage of daily value intake | WGDS_NUTRI_PERC_DAILY_INTAKE_L | DEC | 9 | |
| SERVING_SIZE_SV_UOM | Unit | UNIT | UNIT | 3 |
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_NUTRIENT
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WGDS_TI_NUTRIENT | NUTR_TYPE_CODE | 1: CN | WGDS_TI_NUTR_TYP |