CRMS4_IU_I_PRD

DDL: CRMS4_IU_I_PRD SQL: CRMS4IUVIPRD Type: view
52 Fields 1 Data Sources

Utilities Product

CRMS4_IU_I_PRD is a CDS View that provides data about "Utilities Product" in SAP S/4HANA. It reads from 1 data source (I_UtilitiesProduct) and exposes 52 fields with key field UtilitiesProduct.

Data Sources (1)

SourceAliasJoin Type
I_UtilitiesProduct I_UtilitiesProduct from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CRMS4IUVIPRD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Utilities Product view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #REQUIRED view

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesProduct UtilitiesProduct Product Sold
Division Division Internal Division ID
UtilitiesRateCategory UtilitiesRateCategory
UtilitiesReferenceProduct UtilitiesReferenceProduct
ProductType ProductType Product Type Group
ProductGroup ProductGroup Product Sold Group
ProductAuthorizationGroup ProductAuthorizationGroup AuthorizGroup
ProductName ProductDescription Description
ProductNameMatchCode
Product _Product Product Product Sold
ProductUUID _Product ProductUUID UUID
ProductExternalID _Product ProductExternalID Material
CreationDate _Product CreationDate Time Stamp
CreatedByUser _Product CreatedByUser User Name
LastChangeDate _Product LastChangeDate Time Stamp
LastChangedByUser _Product LastChangedByUser User Name
LastChangeDateTime _Product LastChangeDateTime Timestamp
LastChangeTime _Product LastChangeTime Time changed
IsMarkedForDeletion _Product IsMarkedForDeletion Purch.org. data
CompetitorID _Product CompetitorID Customer Number
ItemCategoryGroup _Product ItemCategoryGroup Item Cat. Group
SalesStatus _Product SalesStatus X-DChain status
SalesStatusValidityDate _Product SalesStatusValidityDate Valid from
AuthorizationGroup _Product AuthorizationGroup AuthorizGroup
ProductCategory _Product ProductCategory Prod Category
IndustryStandardName _Product IndustryStandardName Ind. Std Desc.
ProductStandardID _Product ProductStandardID GTIN
ProductIsConfigurable _Product ProductIsConfigurable Configurable
ExternalProductGroup _Product ExternalProductGroup Ext. prod group
ProductValidStartDate ValidityStartDate Validity Start Date
ProductValidEndDate ValidityEndDate ValidTo
ArticleCategory _Product ArticleCategory Prod Category
ProductSeasonUsageCategory _Product ProductSeasonUsageCategory Season Usage
IndustrySector _Product IndustrySector Industry
ProductIsLocked _Product ProductIsLocked
DiscountInKindEligibility _Product DiscountInKindEligibility Disc. in kind
BasicMaterial _Product BasicMaterial Basic Material
ProductConfiguration _Product ProductConfiguration
SalesProduct _Product SalesProduct
_Product _Product
_RecurringCharge _RecurringCharge
_UsageCharge _UsageCharge
_Discount _Discount
_BillingAttribute _BillingAttribute
_SalesAttribute _SalesAttribute
_OneTimeCharge _OneTimeCharge
_Division _Division
_ReferenceProductValue _ReferenceProductValue
_ProductType _ProductType
_ProductGroup _ProductGroup
_Characteristics _Characteristics
_Text _Product _Text

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view CRMS4_IU_I_PRD.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CRMS4IUVIPRD

CREATE VIEW CRMS4_IU_I_PRD AS
SELECT
  UtilitiesProduct,
  Division,
  UtilitiesRateCategory,
  UtilitiesReferenceProduct,
  ProductType,
  ProductGroup,
  ProductAuthorizationGroup,
  ProductDescription AS ProductName,
  upper(ProductDescription) AS ProductNameMatchCode,
  _Product.Product AS Product,
  _Product.ProductUUID AS ProductUUID,
  _Product.ProductExternalID AS ProductExternalID,
  _Product.CreationDate AS CreationDate,
  _Product.CreatedByUser AS CreatedByUser,
  _Product.LastChangeDate AS LastChangeDate,
  _Product.LastChangedByUser AS LastChangedByUser,
  _Product.LastChangeDateTime AS LastChangeDateTime,
  _Product.LastChangeTime AS LastChangeTime,
  _Product.IsMarkedForDeletion AS IsMarkedForDeletion,
  _Product.CompetitorID AS CompetitorID,
  _Product.ItemCategoryGroup AS ItemCategoryGroup,
  _Product.SalesStatus AS SalesStatus,
  _Product.SalesStatusValidityDate AS SalesStatusValidityDate,
  _Product.AuthorizationGroup AS AuthorizationGroup,
  _Product.ProductCategory AS ProductCategory,
  _Product.IndustryStandardName AS IndustryStandardName,
  _Product.ProductStandardID AS ProductStandardID,
  _Product.ProductIsConfigurable AS ProductIsConfigurable,
  _Product.ExternalProductGroup AS ExternalProductGroup,
  ValidityStartDate AS ProductValidStartDate,
  ValidityEndDate AS ProductValidEndDate,
  _Product.ArticleCategory AS ArticleCategory,
  _Product.ProductSeasonUsageCategory AS ProductSeasonUsageCategory,
  _Product.IndustrySector AS IndustrySector,
  _Product.ProductIsLocked AS ProductIsLocked,
  _Product.DiscountInKindEligibility AS DiscountInKindEligibility,
  _Product.BasicMaterial AS BasicMaterial,
  _Product.ProductConfiguration AS ProductConfiguration,
  _Product.SalesProduct AS SalesProduct,
  _Product._Text AS _Text
FROM I_UtilitiesProduct
;

Learn More