I_SettlementUnitPriceDetails

DDL: I_SETTLEMENTUNITPRICEDETAILS SQL: ISTLUNTPRCDET Type: view COMPOSITE
8 Fields 2 Data Sources

Interface layer for settlement Unit Price Details

I_SettlementUnitPriceDetails (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sales

I_SettlementUnitPriceDetails is a Composite CDS View that provides data about "Interface layer for settlement Unit Price Details" in SAP S/4HANA. It reads from 2 data sources (P_GenericDomainVH, I_SettlementUnitPrice) and exposes 8 fields with key field ACMSettlmtUnitPricingLotUUID.

SAP API Hub

StateC1
Line of BusinessSales
Application ComponentLO-AGR-STL
CapabilitiesData Source for Defining CDS Entities, Data Source in SQL Select
PackageSales for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (2)

SourceAliasJoin Type
P_GenericDomainVH P_GenericDomainVH left_outer
I_SettlementUnitPrice SettlementUnitPrice from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ISTLUNTPRCDET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Interface layer for settlement Unit Price Details view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ACMSettlmtUnitPricingLotUUID ACMSettlmtUnitPricingLotUUID Unique Identifier
SettlementDocHeaderUUID SettlementDocHeaderUUID Settlement Header GUID
ACMSettlementUnitPriceLotType ACMSettlementUnitPriceLotType Price Lot Type
ACMSettlmtUnitPriceLotTypeText PriceLotType DomainText Short Text for Fixed Values
ACMSettlementUnitPrice ACMSettlementUnitPrice Price in RAW Format
ACMSettlementPriceCurrency ACMSettlementPriceCurrency Valuation Crcy
ACMSettlmtUnitFullShipmentQty ACMSettlmtUnitFullShipmentQty Full Shipment Quantity
ACMSettlmtUnitFullShptQtyUnit ACMSettlmtUnitFullShptQtyUnit Unit of Measure

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_SettlementUnitPriceDetails.
-- 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: ISTLUNTPRCDET

CREATE VIEW I_SettlementUnitPriceDetails AS
SELECT
  ACMSettlmtUnitPricingLotUUID,
  SettlementDocHeaderUUID,
  ACMSettlementUnitPriceLotType,
  PriceLotType.DomainText AS ACMSettlmtUnitPriceLotTypeText,
  ACMSettlementUnitPrice,
  ACMSettlementPriceCurrency,
  ACMSettlmtUnitFullShipmentQty,
  ACMSettlmtUnitFullShptQtyUnit
FROM I_SettlementUnitPrice AS SettlementUnitPrice
LEFT OUTER JOIN P_GenericDomainVH ON /* join condition not captured in parsed metadata */
;

Learn More