C_Amount

DDL: C_AMOUNT SQL: CAMOUNT Type: view CONSUMPTION
36 Fields 1 Data Sources

Amount Data

C_Amount is a Consumption CDS View that provides data about "Amount Data" in SAP S/4HANA. It reads from 1 data source (I_EHSAmountRoot) and exposes 36 fields with key field EHSAmountUUID.

Data Sources (1)

SourceAliasJoin Type
I_EHSAmountRoot I_EHSAmountRoot from

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CAMOUNT view
VDM.viewType #CONSUMPTION view
EndUserText.label Amount Data view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
UI.headerInfo.typeName Amount Data view
UI.headerInfo.typeNamePlural Amounts Data view
UI.headerInfo.title.value EHSAmountUUID view
AbapCatalog.compiler.compareFilter true view
Consumption.semanticObject EnvironmentalData view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY EHSAmountUUID EHSAmountUUID NodeID
SamplingHeaderUUID _SamplingDefinitionRoot SamplingHeaderUUID
EHSAmountSourceUUID EHSAmountSourceUUID Source
EHSAmountCategory EHSAmountCategory Category
EHSAmountSubjComponentType EHSAmountSubjComponentType Subject Type
EHSAmountSubjComponentUUID EHSAmountSubjComponentUUID Source
EHSAmountStatus EHSAmountStatus Status
EHSAmountHasWarning EHSAmountHasWarning Warning
EHSAmountIsFaulty EHSAmountIsFaulty Faulty Value
EHSAmountIsMissing EHSAmountIsMissing Missing Value
EHSAmountIsNotAvailable EHSAmountIsNotAvailable Not Available
EHSAmountSourceType EHSAmountSourceType Data Type
EHSAmountValue EHSAmountValue Value
EHSAmtOutOfPrecisenessOptr EHSAmtOutOfPrecisenessOptr Operator
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
Note Note TradeRequest Comment
EHSAmountStatusName EHSAmountStatusName Status
EHSAmountValueAsText Value
UnitOfMeasureName UnitOfMeasureName Unit Of Measurement
EHSAmountUTCDateTime EHSAmountUTCDateTime Period
_EHSAmountHistory _EHSAmountHistory
CreationDateTime CreationDateTime Date Entered
LastChangeDateTime LastChangeDateTime Last Changed
EHSAmountIsReplaced EHSAmountIsReplaced Replaced
EHSAmountIsPreliminary EHSAmountIsPreliminary Preliminary Result
EHSAmountDeviationID EHSAmountDeviationID Incident ID
EHSAmountExternalSource EHSAmountExternalSource External Source
EHSAmountNumberOfAttachments
CreatedByUserFullName _CreatedByUser UserDescription Responsible Person
_SamplingDefinitionRoot _SamplingDefinitionRoot
_EHSAmountStatus _EHSAmountStatus
_DataCollection _DataCollection
_LocationAggregation _LocationAggregation
_CalcDefResultHeader _CalcDefResultHeader
_EmittedSubstanceDataSet _EmittedSubstanceDataSet

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 C_Amount.
-- 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: CAMOUNT

CREATE VIEW C_Amount AS
SELECT
  EHSAmountUUID,
  _SamplingDefinitionRoot.SamplingHeaderUUID AS SamplingHeaderUUID,
  EHSAmountSourceUUID,
  EHSAmountCategory,
  EHSAmountSubjComponentType,
  EHSAmountSubjComponentUUID,
  EHSAmountStatus,
  EHSAmountHasWarning,
  EHSAmountIsFaulty,
  EHSAmountIsMissing,
  EHSAmountIsNotAvailable,
  EHSAmountSourceType,
  EHSAmountValue,
  EHSAmtOutOfPrecisenessOptr,
  CreatedByUser,
  LastChangedByUser,
  Note,
  EHSAmountStatusName,
  cast( '' as abap.char( 44 )) AS EHSAmountValueAsText,
  UnitOfMeasureName,
  EHSAmountUTCDateTime,
  CreationDateTime,
  LastChangeDateTime,
  EHSAmountIsReplaced,
  EHSAmountIsPreliminary,
  EHSAmountDeviationID,
  EHSAmountExternalSource,
  cast ( '' as abap.char( 2 ) ) AS EHSAmountNumberOfAttachments,
  _CreatedByUser.UserDescription AS CreatedByUserFullName
FROM I_EHSAmountRoot
;

Learn More