SAP WGDS_TI_ITEM Pricat Storage for TI related Simple Attributes Table

Overview

WGDS_TI_ITEM is a standard SAP S/4HANA table that stores Pricat Storage for TI related Simple Attributes data. There are total 20 fields in the WGDS_TI_ITEM table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table WGDS_TI_ITEM 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_ITEM to other SAP tables and standard CDS views available based on WGDS_TI_ITEM table in S/4HANA 2020.

Techincal Settings of WGDS_TI_ITEM

Below are technical details of the table WGDS_TI_ITEM

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of WGDS_TI_ITEM Fields

The following table gives you an overview of the fields available in WGDS_TI_ITEM

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTCLNT3
TI_IDTrade Item IdentifierWGDS_TI_IDCHAR35
TI_ID_TYPEType of Trade Item IDWGDS_TI_ID_TYPECHAR2
GLN_INFO_PROVIDERGLN Info ProviderWGDS_GLN_INFO_PROVIDERCHAR35
WGDS_TM_COUNTRYTarget Market of a Trade ItemWGDS_TARGET_MARKETCHAR3
WGDS_TM_SUBDIVISRegion of a Trade ItemWGDS_REGIONCHAR3
VALIDITYValidity Date of a Trade ItemWGDS_VALIDITYDATS8
RECORD_TYPEPrice CatalogWRF_PRODUCTGROUP_FLAGCHAR1
VERSIONTime Stamp of Last Change by Data ProviderWGDS_TIMESTAMP_LAST_CHANGEDEC15
BRANDOWNER_NAMEGDS TradeItem Name of BrandownerWGDS_BRANDOWNER_NAMECHAR70
SERVING_PER_PKGGDS TradeItem number of servings per packageWGDS_SERVING_PER_PKGINT25
BRAND_NAMEBrand NameWGDS_BRAND_NAMECHAR70
PRODUCTSERVINGSIZEProduct Serving SizeWGDS_PRODUCT_SERVING_SIZEDEC9
PRODUCTSERVINGSIZEUOMProduct Serving sSze Unit Of MeasureWGDS_PRODUCTSERVINGSIZEUOMUNIT3
DRAINED_WEIGHTGDS TradeItem Drained weightWGDS_DRAINED_WEIGHTDEC13
DRAINED_WEIGHT_UOMGDS TradeItem Drained weight UOMWGDS_DRAINED_WEIGHT_UOMCHAR3
NETCONTENTUOMNet Content Weight Unit Of MeasureWGDS_NETC_WEIGHT_UOMUNIT3
MATNRMaterial NumberMATNRCHAR40
BATCHBatch NumberCHARG_DCHAR10
MEINHUnit of Measure for DisplayMEINHUNIT3

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_ITEM

Other References