I_TrdgContrPrvsnlSetldQtyDets

DDL: I_TRDGCONTRPRVSNLSETLDQTYDETS SQL: IPROVSTLQTYDETS Type: view COMPOSITE
12 Fields 1 Data Sources 2 Associations

Provisionally Settled Qty Details

I_TrdgContrPrvsnlSetldQtyDets is a Composite CDS View that provides data about "Provisionally Settled Qty Details" in SAP S/4HANA. It reads from 1 data source (P_TrdgContrItmPrvsnlSetldQty) and exposes 12 fields with key fields ContractNum, ContractItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_TrdgContrItmPrvsnlSetldQty StlQty from

Associations (2)

CardinalityTargetAliasCondition
[0..*] P_TrdgContrShadowData _shdw _shdw.ContractNum = StlQty.ContractNum and _shdw.ContractItem = StlQty.ContractItem
[0..1] I_ACMTrdgContrDetmPaidInvc _paidInvc StlQty.SettlementUnitUUID = _paidInvc.SettlementUnitUUID and StlQty.ContractNum = _paidInvc.TradingContractNumber and StlQty.ContractItem = _paidInvc.TradingContractItem

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPROVSTLQTYDETS view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Provisionally Settled Qty Details view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ContractNum P_TrdgContrItmPrvsnlSetldQty ContractNum
KEY ContractItem P_TrdgContrItmPrvsnlSetldQty ContractItem Purchase Contract Item
SettlementUnitUUID P_TrdgContrItmPrvsnlSetldQty SettlementUnitUUID
SettlementGroupId P_TrdgContrItmPrvsnlSetldQty SettlementGroupId
SettlmtDoc P_TrdgContrItmPrvsnlSetldQty SettlmtDoc Settlement Doc.
SettlmtDocYear P_TrdgContrItmPrvsnlSetldQty SettlmtDocYear
SettlmtCat P_TrdgContrItmPrvsnlSetldQty SettlmtCat Settl. Category
SettlementType P_TrdgContrItmPrvsnlSetldQty SettlementType Settlement Type
ReferenceApplicationDocument P_TrdgContrItmPrvsnlSetldQty ReferenceApplicationDocument Ref Preceeding Doc
ReferenceApplicationItem P_TrdgContrItmPrvsnlSetldQty ReferenceApplicationItem
TrdgContractItemUnitOfMeasure _shdw item_uom ItemUoM
SettlmtQuantityendasACMPaidQty

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_TrdgContrPrvsnlSetldQtyDets.
-- 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: IPROVSTLQTYDETS

CREATE VIEW I_TrdgContrPrvsnlSetldQtyDets AS
SELECT
  StlQty.ContractNum AS ContractNum,
  StlQty.ContractItem AS ContractItem,
  StlQty.SettlementUnitUUID AS SettlementUnitUUID,
  StlQty.SettlementGroupId AS SettlementGroupId,
  StlQty.SettlmtDoc AS SettlmtDoc,
  StlQty.SettlmtDocYear AS SettlmtDocYear,
  StlQty.SettlmtCat AS SettlmtCat,
  StlQty.SettlementType AS SettlementType,
  StlQty.ReferenceApplicationDocument AS ReferenceApplicationDocument,
  StlQty.ReferenceApplicationItem AS ReferenceApplicationItem,
  _shdw.item_uom AS TrdgContractItemUnitOfMeasure,
  case when _paidInvc.SettlmtQuantity is null or _paidInvc.SettlmtQuantity = 0 then 0 when StlQty.SettlementType = 'S' and _shdw.Numerator = 0 then 0 when StlQty.SettlementType = 'S' and _shdw.Numerator <> 0 and _paidInvc.SettlmtQuantity is not null and _paidInvc.SettlmtQuantity is not initial then division( ( _paidInvc.SettlmtQuantity * _shdw.Denominator ),_shdw.Numerator,9 ) else _paidInvc.SettlmtQuantity end as ACMPaidQty AS SettlmtQuantityendasACMPaidQty
FROM P_TrdgContrItmPrvsnlSetldQty AS StlQty
LEFT OUTER JOIN P_TrdgContrShadowData AS _shdw ON _shdw.ContractNum = StlQty.ContractNum AND _shdw.ContractItem = StlQty.ContractItem  -- association [0..*]
LEFT OUTER JOIN I_ACMTrdgContrDetmPaidInvc AS _paidInvc ON StlQty.SettlementUnitUUID = _paidInvc.SettlementUnitUUID AND StlQty.ContractNum = _paidInvc.TradingContractNumber AND StlQty.ContractItem = _paidInvc.TradingContractItem  -- association [0..1]
;

Learn More