I_NonFerrousMatBillgDocItm

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_NonFerrousMatBillgDocItm.
-- 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 I_NonFerrousMatBillgDocItm AS
SELECT
  _NonFerrousMatBilDocItemCalc.NonFerrousMatlDocumentCategory AS NonFerrousMatlDocumentCategory,
  _NonFerrousMatBilDocItemCalc.CompanyCode AS CompanyCode,
  _NonFerrousMatBilDocItemCalc.SalesOrganization AS SalesOrganization,
  _NonFerrousMatBilDocItemCalc.NonFerrousCode AS NonFerrousCode,
  _NonFerrousMatBilDocItemCalc.NonFerrousMatlDocumentRef AS NonFerrousMatlDocumentRef,
  _NonFerrousMatBilDocItemCalc.NonFerrousMatlDocumentRefItem AS NonFerrousMatlDocumentRefItem,
  _NonFerrousMatBilDocItemCalc.PostingFiscalYear AS PostingFiscalYear,
  NonFerrousWeight,
  _NonFerrousMatBilDocItemCalc.MaterialBaseUnit AS MaterialBaseUnit,
  round(cast( case when _NonFerrousMatBilDocItemCalc.NonFerrousRateBasisQuantity != 0 then case when _NonFerrousMatBilDocItemCalc.ReturnItemProcessingType = 'A' or _NonFerrousMatBilDocItemCalc.ReturnItemProcessingType = 'B' or _NonFerrousMatBilDocItemCalc.ReturnItemProcessingType = 'X' then ( cast( _NonFerrousMatBilDocItemCalc.NonFerrousRateInCCrcy as abap.dec( 15,3 ) ) * _NonFerrousMatBilDocItemCalc.TotalNonFerrousChargeWeight * ( - 1 ) ) / _NonFerrousMatBilDocItemCalc.NonFerrousRateBasisQuantity else ( cast( _NonFerrousMatBilDocItemCalc.NonFerrousRateInCCrcy as abap.dec( 15,3 ) ) * _NonFerrousMatBilDocItemCalc.TotalNonFerrousChargeWeight ) / _NonFerrousMatBilDocItemCalc.NonFerrousRateBasisQuantity end else null end as abap.dec(15,3)),2) as NonFerrousChargeValueInCCCrcy AS dec1532asNonFerrousChargeValueInCCCrcy,
  _NonFerrousMatBilDocItemCalc.Currency AS Currency,
  _NonFerrousMatBilDocItemCalc.NonFerrousBaseValueInCCCrcy AS NonFerrousBaseValueInCCCrcy,
  _NonFerrousMatBilDocItemCalc.NonFerrousRateBasisQuantity AS NonFerrousRateBasisQuantity,
  round(cast( case when _NonFerrousMatBilDocItemCalc.NonFerrousRateBasisQuantity != 0 then ( cast ( _NonFerrousMatBilDocItemCalc.NonFerrousRateInCCrcy as abap.dec( 15,3 ) ) * _NonFerrousMatBilDocItemCalc.NonFerrousPurchasingWeight ) / _NonFerrousMatBilDocItemCalc.NonFerrousRateBasisQuantity else null end as abap.dec(15,3)), 2) as NonFerrousPurValueInCCCrcy AS dec1532asNonFerrousPurValueInCCCrcy,
  _NonFerrousMatBilDocItemCalc.CreationDate AS CreationDate,
  round(cast( case when _NonFerrousMatBilDocItemCalc.NonFerrousRateBasisQuantity!= 0 then ( cast ( _NonFerrousMatBilDocItemCalc.NonFerrousRateInCCrcy as abap.dec( 15,3 )) * _NonFerrousMatBilDocItemCalc.NonFerrousPhysicalWeight ) / _NonFerrousMatBilDocItemCalc.NonFerrousRateBasisQuantity else null end as abap.dec(15,3) ),2) as NonFerrousStrucValueInCCCrcy AS dec1532asNonFerrousStrucValueInCCCrcy,
  _NonFerrousMatBilDocItemCalc.Material AS Material,
  _NonFerrousMatBilDocItemCalc.OriginSDDocument AS OriginSDDocument,
  _NonFerrousMatBilDocItemCalc.BillingQuantity AS BillingQuantity,
  _NonFerrousMatBilDocItemCalc.BillingQuantityUnit AS BillingQuantityUnit,
  _NonFerrousMatBilDocItemCalc.PayerParty AS PayerParty,
  _NonFerrousMatBilDocItemCalc.Division AS Division,
  _SalesOrganizationText.SalesOrganizationName AS SalesOrganizationName,
  _NonFerrousMatBilDocItemCalc.DistributionChannel AS DistributionChannel,
  _NonFerrousMatBilDocItemCalc.Plant AS Plant,
  _NonFerrousMatBilDocItemCalc.BaseUnit AS BaseUnit,
  _NonFerrousMatBilDocItemCalc.BillingDocumentType AS BillingDocumentType,
  _NonFerrousMatBilDocItemCalc.NonFerrousRateDeterminationKey AS NonFerrousRateDeterminationKey,
  _NonFerrousMatBilDocItemCalc.NonFerrousLastRateDate AS NonFerrousLastRateDate,
  _NonFerrousMatBilDocItemCalc.NonFerrousRDKDate AS NonFerrousRDKDate,
  _NonFerrousMatBilDocItemCalc.EntryDateYearMonth AS EntryDateYearMonth,
  _NonFerrousMatBilDocItemCalc.ReturnItemProcessingType AS ReturnItemProcessingType,
  _NonFerrousMatBilDocItemCalc.NonFerrousRateIsStatistical AS NonFerrousRateIsStatistical,
  _NonFerrousMatBilDocItemCalc.NonFerrousBillgAndInvcgBlkgRsn AS NonFerrousBillgAndInvcgBlkgRsn,
  _NonFerrousMatBilDocItemCalc.NonFerrousCoverageCode AS NonFerrousCoverageCode,
  _NonFerrousMatBilDocItemCalc.NonFerrousCoverageQuantity AS NonFerrousCoverageQuantity,
  _NonFerrousMatBilDocItemCalc.NonFerrousBaseCode AS NonFerrousBaseCode,
  _NonFerrousMatBilDocItemCalc.NonFerrousBaseAmtInDocCrcy AS NonFerrousBaseAmtInDocCrcy,
  _NonFerrousMatBilDocItemCalc.NonFerrousBaseAmtIsStstclPrice AS NonFerrousBaseAmtIsStstclPrice,
  _NonFerrousMatBilDocItemCalc.NonFerrousBaseAmtDocCurrency AS NonFerrousBaseAmtDocCurrency,
  _NonFerrousMatBilDocItemCalc.NonFerrousRateProcSurchrgInPct AS NonFerrousRateProcSurchrgInPct,
  _NonFerrousMatBilDocItemCalc.NonFerrousNetRateAmount AS NonFerrousNetRateAmount,
  _NonFerrousMatBilDocItemCalc.NonFerrousWgtBsRefQtyInBaseUoM AS NonFerrousWgtBsRefQtyInBaseUoM,
  _NonFerrousMatBilDocItemCalc.NonFerrousBaseAmtIsChgdManual AS NonFerrousBaseAmtIsChgdManual,
  _NonFerrousMatBilDocItemCalc.NonFerrousPreviousBaseAmount AS NonFerrousPreviousBaseAmount,
  _NonFerrousMatBilDocItemCalc.NonFerrousProvisionedQuantity AS NonFerrousProvisionedQuantity,
  _NonFerrousMatBilDocItemCalc.NonFerrousCoverageBusPartner AS NonFerrousCoverageBusPartner,
  _NonFerrousMatBilDocItemCalc.NonFerrousProvisionBusPartner AS NonFerrousProvisionBusPartner,
  _NonFerrousMatBilDocItemCalc.NonFerrousProvisionDiscount AS NonFerrousProvisionDiscount,
  _NonFerrousMatBilDocItemCalc.NonFerrousIsProvisioned AS NonFerrousIsProvisioned,
  _NonFerrousMatBilDocItemCalc.NonFerrousBaseAmountCurrency AS NonFerrousBaseAmountCurrency,
  _NonFerrousMatBilDocItemCalc.NonFerrousBaseAmount AS NonFerrousBaseAmount,
  _NonFerrousMatBilDocItemCalc.NonFerrousBaseAmtCnvrsnRate AS NonFerrousBaseAmtCnvrsnRate,
  _NonFerrousMatBilDocItemCalc.NonFerrousBaseRateIsIndrctQtan AS NonFerrousBaseRateIsIndrctQtan,
  _NonFerrousMatBilDocItemCalc.NonFerrousRateAmountCurrency AS NonFerrousRateAmountCurrency,
  _NonFerrousMatBilDocItemCalc.NonFerrousRateAmount AS NonFerrousRateAmount,
  _NonFerrousMatBilDocItemCalc.NonFerrousRateCnvrsnFactor AS NonFerrousRateCnvrsnFactor,
  _NonFerrousMatBilDocItemCalc.NonFerrousRateIsIndrctQtan AS NonFerrousRateIsIndrctQtan,
  _NonFerrousMatBilDocItemCalc.NonFerrousCurrencyCnvrsnRate AS NonFerrousCurrencyCnvrsnRate,
  _NonFerrousMatBilDocItemCalc.NonFerrousExchRateIsIndrctQtan AS NonFerrousExchRateIsIndrctQtan,
  _NonFerrousMatBilDocItemCalc.NonFerrousReportingBaseAmount AS NonFerrousReportingBaseAmount,
  _NonFerrousMatBilDocItemCalc.NonFerrousNumberOfPostingDays AS NonFerrousNumberOfPostingDays,
  cast(_NonFerrousMatBilDocItemCalc.NonFerrousPhysicalWeight as /nfm/kgw) AS NonFerrousPhysicalWeight,
  _NonFerrousMatBilDocItemCalc.NonFerrousPhysWgtRefQty AS NonFerrousPhysWgtRefQty,
  _NonFerrousMatBilDocItemCalc.NonFerrousCvrgIsUsingPhysWgt AS NonFerrousCvrgIsUsingPhysWgt,
  _NonFerrousMatBilDocItemCalc.NonFerrousCommodityExchCode AS NonFerrousCommodityExchCode,
  _NonFerrousMatBilDocItemCalc.NonFerrousPurDocItemIsDeleted AS NonFerrousPurDocItemIsDeleted,
  _NonFerrousMatBilDocItemCalc.NonFerrousRateDetnIsCompleted AS NonFerrousRateDetnIsCompleted,
  _NonFerrousMatBilDocItemCalc.NonFerrousSurchargeBaseAmount AS NonFerrousSurchargeBaseAmount,
  _NonFerrousMatBilDocItemCalc.PricingDocumentItem AS PricingDocumentItem,
  _NonFerrousMatBilDocItemCalc.NonFerrousPhysicalWeightIsMiss AS NonFerrousPhysicalWeightIsMiss,
  _NonFerrousMatBilDocItemCalc.NonFerrousPostgIsBlkdByMisgWgt AS NonFerrousPostgIsBlkdByMisgWgt
FROM I_NonFerrousMatBillgDocItmCalc AS _NonFerrousMatBilDocItemCalc
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrganizationText ON _SalesOrganizationText.SalesOrganization = _NonFerrousMatBilDocItemCalc.SalesOrganization AND _SalesOrganizationText.Language = $session.system_language  -- association [0..1]
;