I_ClfnCharcTimeIndep

DDL: I_CLFNCHARCTIMEINDEP SQL: INGCCHRTMINDEP Type: view COMPOSITE
14 Fields 1 Associations

Characteristic Header Time Independent

I_ClfnCharcTimeIndep is a Composite CDS View that provides data about "Characteristic Header Time Independent" in SAP S/4HANA. It has 1 association to related views.

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_ClfnCharcBasic _CharcBasic $projection.CharcInternalID = _CharcBasic.CharcInternalID

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName INGCCHRTMINDEP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Characteristic Header Time Independent view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CharcInternalID Characteristic CharcInternalID Characteristic Internal ID
Characteristic Characteristic Characteristic Field Name
CharcDataType Characteristic CharcDataType Format
CharcLength Characteristic CharcLength Number of Chars
CharcDecimals Characteristic CharcDecimals Decimal Places
CharcValueUnit Characteristic CharcValueUnit Internal UoM
CharcTemplate Characteristic CharcTemplate
CharcExponentFormat Characteristic CharcExponentFormat
CharcExponentValue Characteristic CharcExponentValue
MultipleValuesAreAllowed
NegativeValueIsAllowed Characteristic NegativeValueIsAllowed
Currency Characteristic Currency Valuation Crcy
ValueIsCaseSensitive Characteristic ValueIsCaseSensitive
_CharcBasic _CharcBasic

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 I_ClfnCharcTimeIndep.
-- 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: INGCCHRTMINDEP

CREATE VIEW I_ClfnCharcTimeIndep AS
SELECT
  Characteristic.CharcInternalID AS CharcInternalID,
  Characteristic.Characteristic AS Characteristic,
  Characteristic.CharcDataType AS CharcDataType,
  Characteristic.CharcLength AS CharcLength,
  Characteristic.CharcDecimals AS CharcDecimals,
  Characteristic.CharcValueUnit AS CharcValueUnit,
  Characteristic.CharcTemplate AS CharcTemplate,
  Characteristic.CharcExponentFormat AS CharcExponentFormat,
  Characteristic.CharcExponentValue AS CharcExponentValue,
  cast ( Characteristic.MultipleValuesAllowedCode as multiplevaluesareallowed preserving type ) AS MultipleValuesAreAllowed,
  Characteristic.NegativeValueIsAllowed AS NegativeValueIsAllowed,
  Characteristic.Currency AS Currency,
  Characteristic.ValueIsCaseSensitive AS ValueIsCaseSensitive
LEFT OUTER JOIN I_ClfnCharcBasic AS _CharcBasic ON CharcInternalID = _CharcBasic.CharcInternalID  -- association [1..*]
;

Learn More