I_TrdgContItemApplQtyDetsData

DDL: I_TRDGCONTITEMAPPLQTYDETSDATA SQL: ITRCOAPPLDETQTY Type: view COMPOSITE
13 Fields 1 Data Sources 2 Associations

Trading Contract Item Application Qty

I_TrdgContItemApplQtyDetsData is a Composite CDS View that provides data about "Trading Contract Item Application Qty" in SAP S/4HANA. It reads from 1 data source (I_TrdgContrItemApplLinkDets) and exposes 13 fields with key fields ContractNum, ContractItem, ContractApplicationUUID, ContractApplicationVersion, ReferenceApplicationDocument. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_TrdgContrItemApplLinkDets ApplQty from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_ACMContrToleranceHeader _tolerance ApplQty.ContractNum = _tolerance.TradingContractNumber and ApplQty.TradingContractItem = _tolerance.TradingContractItem
[0..*] P_TrdgContrShadowData _shdw ApplQty.ContractNum = _shdw.ContractNum and ApplQty.TradingContractItem = _shdw.ContractItem

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ITRCOAPPLDETQTY 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 #XL view
EndUserText.label Trading Contract Item Application Qty view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ContractNum I_TrdgContrItemApplLinkDets ContractNum
KEY ContractItem I_TrdgContrItemApplLinkDets TradingContractItem Item Number
KEY ContractApplicationUUID ContractApplicationUUID
KEY ContractApplicationVersion ContractApplicationVersion
KEY ReferenceApplicationDocument I_TrdgContrItemApplLinkDets ReferenceApplicationDocument Ref Preceeding Doc
KEY ReferenceApplicationItem I_TrdgContrItemApplLinkDets ReferenceApplicationItem
ACMTrdgContrUnderFillID I_TrdgContrItemApplLinkDets ACMTrdgContrUnderFillID
InvoiceNumber I_TrdgContrItemApplLinkDets InvoiceNumber Invoice Number
NominationNumber I_TrdgContrItemApplLinkDets NominationNumber
NominationItem I_TrdgContrItemApplLinkDets NominationItem
ACMToleranceTypeID _tolerance ACMToleranceTypeID
TrdgContractItemUnitOfMeasure _shdw item_uom ItemUoM
Numerator11endasFinalApplicationQuantity

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_TrdgContItemApplQtyDetsData.
-- 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: ITRCOAPPLDETQTY

CREATE VIEW I_TrdgContItemApplQtyDetsData AS
SELECT
  ApplQty.ContractNum AS ContractNum,
  ApplQty.TradingContractItem AS ContractItem,
  ContractApplicationUUID,
  ContractApplicationVersion,
  ApplQty.ReferenceApplicationDocument AS ReferenceApplicationDocument,
  ApplQty.ReferenceApplicationItem AS ReferenceApplicationItem,
  ApplQty.ACMTrdgContrUnderFillID AS ACMTrdgContrUnderFillID,
  ApplQty.InvoiceNumber AS InvoiceNumber,
  ApplQty.NominationNumber AS NominationNumber,
  ApplQty.NominationItem AS NominationItem,
  _tolerance.ACMToleranceTypeID AS ACMToleranceTypeID,
  _shdw.item_uom AS TrdgContractItemUnitOfMeasure,
  case when ApplQty.FinalApplicationQuantity is null or ApplQty.FinalApplicationQuantity = 0 or _shdw.Numerator = 0 then 0 else division( ( ApplQty.FinalApplicationQuantity * _shdw.Denominator ),_shdw.Numerator,11 ) end as FinalApplicationQuantity AS Numerator11endasFinalApplicationQuantity
FROM I_TrdgContrItemApplLinkDets AS ApplQty
LEFT OUTER JOIN I_ACMContrToleranceHeader AS _tolerance ON ApplQty.ContractNum = _tolerance.TradingContractNumber AND ApplQty.TradingContractItem = _tolerance.TradingContractItem  -- association [0..*]
LEFT OUTER JOIN P_TrdgContrShadowData AS _shdw ON ApplQty.ContractNum = _shdw.ContractNum AND ApplQty.TradingContractItem = _shdw.ContractItem  -- association [0..*]
;

Learn More