I_UTILSPRODATTRIBUTES

CDS View
36 Fields 3 CDS Views

IS-U Product Attributes

I_UTILSPRODATTRIBUTES is a CDS View in S/4HANA. IS-U Product Attributes. It contains 36 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
CRMS4_IU_I_PRDA view from Utilities Product Attribute
I_UtilsProdBillingAttribute view from COMPOSITE Billing Attributes for a Utilities Product
I_UtilsProdSalesAttribute view from COMPOSITE Sales Attributes for Utilities Product

Fields (36)

KeyField CDS FieldsUsed in Views
KEY Characteristic Characteristic 3
KEY CharcValuePositionNumber CharcValuePositionNumber,ValuePositionNumber 3
KEY UtilitiesProduct UtilitiesProduct 2
_ProductGroup _ProductGroup 2
_ProductType _ProductType 2
_UtilsOperand _UtilsOperand 1
CharcCheckTable CharcCheckTable 1
CharcConversionRoutine CharcConversionRoutine 1
CharcDataType CharcDataType 2
CharcDecimals CharcDecimals 1
CharcFromAmount CharcFromAmount 1
CharcFromDate CharcFromDate 1
CharcFromDecimalValue CharcFromDecimalValue 1
CharcInternalID CharcInternalID 1
CharcLength CharcLength 2
CharcReferenceTable CharcReferenceTable 1
CharcReferenceTableField CharcReferenceTableField 1
CharcToAmount CharcToAmount 1
CharcToDate CharcToDate 1
CharcToDecimalValue CharcToDecimalValue 1
CharcValue CharcValue 1
CharcValueUnit CharcValueUnit 1
Currency Currency 2
ProductAuthorizationGroup ProductAuthorizationGroup 3
ProductGroup ProductGroup 2
ProductType ProductType 2
UtilitiesReferenceProduct UtilitiesReferenceProduct 1
UtilsBillingOperand UtilsBillingOperand 1
UtilsSemanticsName1 UtilsSemanticsName1 2
UtilsSemanticsName2 UtilsSemanticsName2 2
UtilsTimeSliceCharacteristicID UtilsTimeSliceCharacteristicID 1
UtilsTimeSliceDurationFrom UtilsTimeSliceDurationFrom 2
UtilsTimeSliceDurationTo UtilsTimeSliceDurationTo 2
UtilsTimeSliceDurationUoM UtilsTimeSliceDurationUoM 2
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- IS-U Product Attributes
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_UTILSPRODATTRIBUTES (
    CHARACTERISTIC,
    CHARCVALUEPOSITIONNUMBER,
    UTILITIESPRODUCT,
    _PRODUCTGROUP,
    _PRODUCTTYPE,
    _UTILSOPERAND,
    CHARCCHECKTABLE,
    CHARCCONVERSIONROUTINE,
    CHARCDATATYPE,
    CHARCDECIMALS,
    CHARCFROMAMOUNT,
    CHARCFROMDATE,
    CHARCFROMDECIMALVALUE,
    CHARCINTERNALID,
    CHARCLENGTH,
    CHARCREFERENCETABLE,
    CHARCREFERENCETABLEFIELD,
    CHARCTOAMOUNT,
    CHARCTODATE,
    CHARCTODECIMALVALUE,
    CHARCVALUE,
    CHARCVALUEUNIT,
    CURRENCY,
    PRODUCTAUTHORIZATIONGROUP,
    PRODUCTGROUP,
    PRODUCTTYPE,
    UTILITIESREFERENCEPRODUCT,
    UTILSBILLINGOPERAND,
    UTILSSEMANTICSNAME1,
    UTILSSEMANTICSNAME2,
    UTILSTIMESLICECHARACTERISTICID,
    UTILSTIMESLICEDURATIONFROM,
    UTILSTIMESLICEDURATIONTO,
    UTILSTIMESLICEDURATIONUOM,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (CHARACTERISTIC, CHARCVALUEPOSITIONNUMBER, UTILITIESPRODUCT)
);

Learn More