A_ACMSettlementUnitPricing

DDL: A_ACMSETTLEMENTUNITPRICING Type: view_entity CONSUMPTION

Acm Settlement Unit Price Details

A_ACMSettlementUnitPricing is a Consumption CDS View that provides data about "Acm Settlement Unit Price Details" in SAP S/4HANA. It reads from 1 data source (R_ACMSettlementUnitPricingTP) and exposes 25 fields with key fields ACMSettlementItemUUID, ACMPricingAspect, ACMPricingAspectValue.

Data Sources (1)

SourceAliasJoin Type
R_ACMSettlementUnitPricingTP R_ACMSettlementUnitPricingTP projection

Annotations (8)

NameValueLevelField
OData.entityType.name ACMSETLMTPRC_Type view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Acm Settlement Unit Price Details view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY ACMSettlementItemUUID ACMSettlementItemUUID
KEY ACMPricingAspect ACMPricingAspect
KEY ACMPricingAspectValue ACMPricingAspectValue
SettlementGroupId SettlementGroupId
SettlementGroupYear SettlementGroupYear
SettlmtDoc SettlmtDoc Settlement Doc.
SettlmtDocYear SettlmtDocYear
SettlementDocHeaderUUID SettlementDocHeaderUUID
ACMDocumentUnitOfMeasure ACMDocumentUnitOfMeasure
dec153
AssignmentQuantity AssignmentQuantity
dec153
SettlementFuturePriceValue SettlementFuturePriceValue
ACMFutureValueUnitCurrency ACMFutureValueUnitCurrency
ACMSettlmtFutureQuantityValue ACMSettlmtFutureQuantityValue
ACMSettlementPricingUoM ACMSettlementPricingUoM
dec153
SettlementBasisPriceValue SettlementBasisPriceValue
ACMPrcgCndnCumltvBasisCrcy ACMPrcgCndnCumltvBasisCrcy
ACMSettlementBasisUoM ACMSettlementBasisUoM
ACMSettlmtBasisQtyValue ACMSettlmtBasisQtyValue
ACMSettlementPriceTotalValue ACMSettlementPriceTotalValue
ACMSettlementTotalCurrency ACMSettlementTotalCurrency
ACMSettlementTotalUoM ACMSettlementTotalUoM
ACMSettlementTotalQtyValue ACMSettlementTotalQtyValue

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_ACMSettlementUnitPricing.
-- 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_ACMSettlementUnitPricing AS
SELECT
  ACMSettlementItemUUID,
  ACMPricingAspect,
  ACMPricingAspectValue,
  SettlementGroupId,
  SettlementGroupYear,
  SettlmtDoc,
  SettlmtDocYear,
  SettlementDocHeaderUUID,
  ACMDocumentUnitOfMeasure,
  virtual ACMSettlmtQtyAssignmentValue : abap.dec( 15, 3 ) AS dec153,
  AssignmentQuantity,
  SettlementFuturePriceValue,
  ACMFutureValueUnitCurrency,
  ACMSettlmtFutureQuantityValue,
  ACMSettlementPricingUoM,
  SettlementBasisPriceValue,
  ACMPrcgCndnCumltvBasisCrcy,
  ACMSettlementBasisUoM,
  ACMSettlmtBasisQtyValue,
  ACMSettlementPriceTotalValue,
  ACMSettlementTotalCurrency,
  ACMSettlementTotalUoM,
  ACMSettlementTotalQtyValue
FROM R_ACMSettlementUnitPricingTP
;