I_ACMTermInputGeneralData

DDL: I_ACMTERMINPUTGENERALDATA Type: view_entity BASIC
9 Fields 1 Data Sources

ACM CPE Term Input General Data

I_ACMTermInputGeneralData is a Basic CDS View that provides data about "ACM CPE Term Input General Data" in SAP S/4HANA. It reads from 1 data source (cped_terminput) and exposes 9 fields with key field ACMPrcgTermInputUUID.

Data Sources (1)

SourceAliasJoin Type
cped_terminput cped_terminput from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label ACM CPE Term Input General Data view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ACMPrcgTermInputUUID terminput_guid Term Input GUID
ACMTermCalcType termtype Term Type
PricingConditionQuotationKey quotkey Quotation Key
DerivativeContrSpecification dcsid DCSID
MarketIdentifierCode mic MIC
PriceQuotationType pricetype Price Type
BasisType basis_type Basis Type
MaturityKeyDate keydate Maturity Key Date
PrcgCndnTrmRateChangeDateTime Changed At

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_ACMTermInputGeneralData.
-- 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.

CREATE VIEW I_ACMTermInputGeneralData AS
SELECT
  terminput_guid AS ACMPrcgTermInputUUID,
  termtype AS ACMTermCalcType,
  quotkey AS PricingConditionQuotationKey,
  dcsid AS DerivativeContrSpecification,
  mic AS MarketIdentifierCode,
  pricetype AS PriceQuotationType,
  basis_type AS BasisType,
  keydate AS MaturityKeyDate,
  cast( rate_changed_at as wb2_timestamp preserving type ) AS PrcgCndnTrmRateChangeDateTime
FROM cped_terminput
;

Learn More