I_ACMTrdgContrDynQtyDetsExtn

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_ACMTrdgContrDynQtyDetsExtn.
-- 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: ICNTDQTDETSEXTN

CREATE VIEW I_ACMTrdgContrDynQtyDetsExtn AS
SELECT
  QtyBaseData.ContractNum AS ContractNum,
  QtyBaseData.ContractItem AS ContractItem,
  QtyBaseData.DocumentDate AS DocumentDate,
  QtyBaseData.TradingContractCreatedBy AS TradingContractCreatedBy,
  QtyBaseData.SalesOrganization AS SalesOrganization,
  QtyBaseData.DistributionChannel AS DistributionChannel,
  QtyBaseData.Division AS Division,
  QtyBaseData.PurchasingOrganization AS PurchasingOrganization,
  QtyBaseData.PurchasingGroup AS PurchasingGroup,
  QtyBaseData.ContractMaterial AS ContractMaterial,
  QtyBaseData.ContractPlant AS ContractPlant,
  QtyBaseData.TradingContractType AS TradingContractType,
  QtyBaseData.CompanyCode AS CompanyCode,
  QtyBaseData.CustomerName AS CustomerName,
  QtyBaseData.SupplierName AS SupplierName,
  QtyBaseData.Commodity AS Commodity,
  QtyBaseData.ACMOriginalTraderID AS ACMOriginalTraderID,
  QtyBaseData.TrdgContractItemUnitOfMeasure AS TrdgContractItemUnitOfMeasure,
  QtyBaseData.TradingContractItemQuantity AS TradingContractItemQuantity,
  QtyBaseData.ContractItemConsumedQuantity AS ContractItemConsumedQuantity,
  QtyBaseData.TradingContractItemOpenQty AS TradingContractItemOpenQty,
  QtyBaseData.LogisticallyAdjustedQuantity AS LogisticallyAdjustedQuantity,
  QtyBaseData.ProvisionalApplicationQuantity AS ProvisionalApplicationQuantity,
  QtyBaseData.ContrItmProvisionalOverFillQty AS ContrItmProvisionalOverFillQty,
  QtyBaseData.ACMContrItmPrvsnlUnderFillQty AS ACMContrItmPrvsnlUnderFillQty,
  QtyBaseData.FinalApplicationQuantity AS FinalApplicationQuantity,
  QtyBaseData.TrdgContrItemOverFillQuantity AS TrdgContrItemOverFillQuantity,
  QtyBaseData.TrdgContrItemUnderFillQuantity AS TrdgContrItemUnderFillQuantity,
  QtyBaseData.FinalSettledQuantity AS FinalSettledQuantity,
  QtyBaseData.TotalFinalSettledQuantity AS TotalFinalSettledQuantity,
  QtyBaseData.ACMPaidQty AS ACMPaidQty,
  QtyBaseData.ContrOverFillSettledQuantity AS ContrOverFillSettledQuantity,
  QtyBaseData.RevenueRecognizedQuantity AS RevenueRecognizedQuantity,
  QtyBaseData.ContrItemSoftAssignedQuantity AS ContrItemSoftAssignedQuantity,
  QtyBaseData.TrdgContrItemReturnQuantity AS TrdgContrItemReturnQuantity,
  QtyBaseData.TrdgContrItemCancelledQuantity AS TrdgContrItemCancelledQuantity,
  QtyBaseData.TrdgContrItemClosedQty AS TrdgContrItemClosedQty,
  QtyBaseData.ProvisionalSettledQuantity AS ProvisionalSettledQuantity,
  QtyBaseData.NonAppliedPrvsnlSettledQty AS NonAppliedPrvsnlSettledQty,
  QtyBaseData.TrdgContrItemWashoutQuantity AS TrdgContrItemWashoutQuantity,
  QtyBaseData.ContrOverFillFixationQuantity AS ContrOverFillFixationQuantity,
  QtyBaseData.ACMConfirmedPlannedQuantity AS ACMConfirmedPlannedQuantity,
  QtyBaseData.ACMTotalPlannedQuantity AS ACMTotalPlannedQuantity,
  QtyBaseData.ApplicationDocumentNumber AS ApplicationDocumentNumber,
  QtyBaseData.ApplicationDocumentItem AS ApplicationDocumentItem,
  QtyBaseData.OverfillID AS OverfillID,
  QtyBaseData.ACMTrdgContrUnderFillID AS ACMTrdgContrUnderFillID,
  QtyBaseData.SettlementGroupId AS SettlementGroupId,
  QtyBaseData.SettlmtDoc AS SettlmtDoc,
  QtyBaseData.SettlmtDocYear AS SettlmtDocYear,
  QtyBaseData.InvoiceNumber AS InvoiceNumber,
  QtyBaseData.ACMPricingLotCancellationID AS ACMPricingLotCancellationID,
  QtyBaseData.ACMWashoutID AS ACMWashoutID,
  QtyBaseData.TrdgContrPrcgAspectSrceLotID AS TrdgContrPrcgAspectSrceLotID,
  QtyBaseData.NominationNumber AS NominationNumber,
  QtyBaseData.NominationItem AS NominationItem,
  QtyBaseData.NumberOfOpenVehicles AS NumberOfOpenVehicles,
  QtyBaseData.NumberOfTotalPlannedVehicles AS NumberOfTotalPlannedVehicles,
  QtyBaseData.NumberOfPlannedVehicles AS NumberOfPlannedVehicles,
  QtyBaseData.NumberOfConsumedVehicles AS NumberOfConsumedVehicles,
  QtyBaseData.ContractApplicationUUID AS ContractApplicationUUID,
  QtyBaseData.ContractApplicationVersion AS ContractApplicationVersion,
  QtyBaseData.SettlementUnitUUID AS SettlementDocHeaderUUID
FROM I_ACMTrdgContrDynQtyDets AS QtyBaseData
LEFT OUTER JOIN E_ApplicationDocumentItem AS _ApplExtension ON ApplicationDocumentNumber = _ApplExtension.ApplicationDocument AND ApplicationDocumentItem = _ApplExtension.ApplicationDocumentItem  -- association [0..1]
LEFT OUTER JOIN E_ApplicationDocument AS _ApplDataExtension ON ContractApplicationUUID = _ApplDataExtension.ContractApplicationUUID AND ContractApplicationVersion = _ApplDataExtension.ContractApplicationVersion  -- association [0..1]
LEFT OUTER JOIN E_SettlmtDoc AS _SettlementHeaderExtension ON SettlementDocHeaderUUID = _SettlementHeaderExtension.SettlementDocHeaderUUID  -- association [0..1]
LEFT OUTER JOIN E_NominationHeader AS _NominationHeaderExtension ON NominationNumber = _NominationHeaderExtension.NominationDoc  -- association [0..1]
LEFT OUTER JOIN E_NominationItem AS _NominationItemExtension ON NominationNumber = _NominationItemExtension.NominationDoc AND NominationItem = _NominationItemExtension.NominationDocItem  -- association [0..1]
;