A_ACMContrPrcgCndnTP

DDL: A_ACMCONTRPRCGCNDNTP Type: view_entity CONSUMPTION
18 Fields 1 Data Sources

Projection view for R_ACMContrPrcgCndnTP

A_ACMContrPrcgCndnTP is a Consumption CDS View that provides data about "Projection view for R_ACMContrPrcgCndnTP" in SAP S/4HANA. It reads from 1 data source (R_ACMContrPrcgCndnTP) and exposes 18 fields with key fields TradingContractNumber, TradingContractItem, ACMConditionTermNumber, ConditionType.

Data Sources (1)

SourceAliasJoin Type
R_ACMContrPrcgCndnTP R_ACMContrPrcgCndnTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Projection view for R_ACMContrPrcgCndnTP view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name PricingCondition_Type view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY TradingContractNumber TradingContractNumber Trading Contract
KEY TradingContractItem TradingContractItem Item Number
KEY ACMConditionTermNumber ACMConditionTermNumber
KEY ConditionType ConditionType Condition type
PricingConditionTermFixedRate PricingConditionTermFixedRate Fixed Rate
PrcgCndnTermFixedRateQtyUnit PrcgCndnTermFixedRateQtyUnit UoM for Fixed Value
PrcgConditionTermFixedRateQty PrcgConditionTermFixedRateQty PrcUnit Fixed Value
DerivativeContrSpecification DerivativeContrSpecification DCS ID
ACMPricingMarketIdentifierCode ACMPricingMarketIdentifierCode MIC
ACMPrcgRefMaturityCode ACMPrcgRefMaturityCode
MaturityKeyDate MaturityKeyDate Maturity Key Date
PricingConditionQuotationKey PricingConditionQuotationKey Quot. Key Type
ConditionTermQuantity ConditionTermQuantity
ConditionTermUnit ConditionTermUnit
PrcgCndnTermCnvrsnSourceCrcy PrcgCndnTermCnvrsnSourceCrcy
PrcgCndnTermCnvrsnTargetCrcy PrcgCndnTermCnvrsnTargetCrcy
PrcgCndnTermCnvrsnFxdExchRate PrcgCndnTermCnvrsnFxdExchRate
ACMIsOverfillPricingLot _PricingInfo ACMIsOverfillPricingLot

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 A_ACMContrPrcgCndnTP.
-- 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 A_ACMContrPrcgCndnTP AS
SELECT
  TradingContractNumber,
  TradingContractItem,
  ACMConditionTermNumber,
  ConditionType,
  PricingConditionTermFixedRate,
  PrcgCndnTermFixedRateQtyUnit,
  PrcgConditionTermFixedRateQty,
  DerivativeContrSpecification,
  ACMPricingMarketIdentifierCode,
  ACMPrcgRefMaturityCode,
  MaturityKeyDate,
  PricingConditionQuotationKey,
  ConditionTermQuantity,
  ConditionTermUnit,
  PrcgCndnTermCnvrsnSourceCrcy,
  PrcgCndnTermCnvrsnTargetCrcy,
  PrcgCndnTermCnvrsnFxdExchRate,
  _PricingInfo.ACMIsOverfillPricingLot AS ACMIsOverfillPricingLot
FROM R_ACMContrPrcgCndnTP
;

Learn More