CRMS4_IU_C_PRD

Utilities Product | view: CRMS4IUVCPRD | Extraction: Not supported | Component: S4CRM: Utilities Industry
Tables used: MARACABNAUSPTSPATMARAMAKTETTAEAKLASSETCLF_HDRISUC_UIL_COMMON
Column Name Description
Product Product Number
Column Name Description
Column Name Description
Column Name Description
CreationDate Created On
LastChangeDate Date of Last Change
LastChangeTime Time of Last Change
SalesStatusValidityDate Date from which the X-distr.-chain material status is valid
ProductValidStartDate Lower Boundary for Date-Interval
ProductValidEndDate Lower Boundary for Date-Interval
Column Name Description
IsMarkedForDeletion Deletion Indicator Show values
ProductCategory Product Category Show values
ProductIsConfigurable Product is Configurable Show values
ArticleCategory Product Category Show values
ProductSeasonUsageCategory Indicator: Use of Season Show values
ProductIsLocked Material Is Locked Show values
DiscountInKindEligibility Material qualifies for discount in kind Show values
Column Name Description Domain name
ProductName Product Description TEXT40
ProductNameMatchCode Product Description in Uppercase for Matchcodes CHAR40
ProductSearchText Product Search Text in Uppercase for Matchcodes
ProductAuthorizationGroup Authorization Group BEGRU
UtilitiesRateCategory Characteristic Value ATWRT
UtilitiesReferenceProduct Product Number MATNR
ProductUUID Internal Key for Product SYSUUID
ProductExternalID External Representation of Material Number CHAR40
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
LastChangeDateTime Change Time Stamp TZNTSTMPL
AuthorizationGroup Authorization Group BEGRU
IndustryStandardName Industry Standard Description (such as ANSI or ISO) NORMT
ProductStandardID Global Trade Item Number (EAN/UPC/GTIN) EAN11
ProductConfiguration Internal object number CUOBJ
Master Data Relations Join Conditions
Basic Material
  • Basic Material
  • Client
  • CRMS4_IU_C_PRD.BASICMATERIAL == TWSPR.WRKST
  • CRMS4_IU_C_PRD.MANDT == TWSPR.MANDT
Division
  • Client
  • Division
  • CRMS4_IU_C_PRD.MANDT == TSPA.MANDT
  • CRMS4_IU_C_PRD.DIVISION == TSPA.SPART
External Product Group
  • External Product Group
  • Client
  • CRMS4_IU_C_PRD.EXTERNALPRODUCTGROUP == TWEW.EXTWG
  • CRMS4_IU_C_PRD.MANDT == TWEW.MANDT
Industry Sector
  • Client
  • Industry Sector
  • CRMS4_IU_C_PRD.MANDT == T137.MANDT
  • CRMS4_IU_C_PRD.INDUSTRYSECTOR == T137.MBRSH
General item category group
  • General item category group
  • Client
  • CRMS4_IU_C_PRD.ITEMCATEGORYGROUP == TPTM.MTPOS
  • CRMS4_IU_C_PRD.MANDT == TPTM.MANDT
Material Group
  • Client
  • Product Group
  • CRMS4_IU_C_PRD.MANDT == T023.MANDT
  • CRMS4_IU_C_PRD.PRODUCTGROUP == T023.MATKL
Product Type
  • Product Type
  • Client
  • CRMS4_IU_C_PRD.PRODUCTTYPE == T134.MTART
  • CRMS4_IU_C_PRD.MANDT == T134.MANDT
Material Number of a Sales Material
  • Material Number of a Sales Material
  • Client
  • CRMS4_IU_C_PRD.SALESPRODUCT == MARA.MATNR
  • CRMS4_IU_C_PRD.MANDT == MARA.MANDT
Cross-distribution-chain material status
  • Client
  • Cross-distribution-chain material status
  • CRMS4_IU_C_PRD.MANDT == TVMS.MANDT
  • CRMS4_IU_C_PRD.SALESSTATUS == TVMS.VMSTA