A_SuplrInvcItemPurOrdRef

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 A_SuplrInvcItemPurOrdRef.
-- 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: ASIITPURORDREF

CREATE VIEW A_SuplrInvcItemPurOrdRef AS
SELECT
  item.SupplierInvoice AS SupplierInvoice,
  item.FiscalYear AS FiscalYear,
  item.SupplierInvoiceItem AS SupplierInvoiceItem,
  item.PurchaseOrder AS PurchaseOrder,
  item.PurchaseOrderItem AS PurchaseOrderItem,
  item.Plant AS Plant,
  item.ReferenceDocument AS ReferenceDocument,
  item.ReferenceDocumentFiscalYear AS ReferenceDocumentFiscalYear,
  item.ReferenceDocumentItem AS ReferenceDocumentItem,
  item.IsSubsequentDebitCredit AS IsSubsequentDebitCredit,
  item.TaxCode AS TaxCode,
  item.TaxJurisdiction AS TaxJurisdiction,
  _SupplierInvoice.DocumentCurrency AS DocumentCurrency,
  item.SupplierInvoiceItemAmount AS SupplierInvoiceItemAmount,
  item.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  item.PurchaseOrderQuantityUnit AS PurchaseOrderQtyUnitSAPCode,
  _UnitOfMeasure.UnitOfMeasureISOCode AS PurchaseOrderQtyUnitISOCode,
  item.QuantityInPurchaseOrderUnit AS QuantityInPurchaseOrderUnit,
  item.PurchaseOrderPriceUnit AS PurchaseOrderPriceUnit,
  item.PurchaseOrderPriceUnit AS PurchaseOrderPriceUnitSAPCode,
  _PurOrdPriceUnitOfMeasure.UnitOfMeasureISOCode AS PurchaseOrderPriceUnitISOCode,
  item.QtyInPurchaseOrderPriceUnit AS QtyInPurchaseOrderPriceUnit,
  item.SuplrInvcDeliveryCostCndnType AS SuplrInvcDeliveryCostCndnType,
  item.SuplrInvcDeliveryCostCndnStep AS SuplrInvcDeliveryCostCndnStep,
  item.SuplrInvcDeliveryCostCndnCount AS SuplrInvcDeliveryCostCndnCount,
  item.SupplierInvoiceItemText AS SupplierInvoiceItemText,
  item.FreightSupplier AS FreightSupplier,
  item.IsNotCashDiscountLiable AS IsNotCashDiscountLiable,
  item.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  item.ProductType AS ProductType,
  item.RetentionAmountInDocCurrency AS RetentionAmountInDocCurrency,
  item.RetentionPercentage AS RetentionPercentage,
  item.RetentionDueDate AS RetentionDueDate,
  cast( '' as mm_no_retention ) AS SuplrInvcItmIsNotRlvtForRtntn,
  cast( '' as lblni ) AS ServiceEntrySheet,
  cast( '' as extrow ) AS ServiceEntrySheetItem,
  TaxCountry,
  IsFinallyInvoiced,
  TaxDeterminationDate,
  IN_HSNOrSACCode,
  IN_CustomDutyAssessableValue,
  item.NL_ChainLiabilityStartDate AS NL_ChainLiabilityStartDate,
  item.NL_ChainLiabilityEndDate AS NL_ChainLiabilityEndDate,
  item.NL_ChainLiabilityDescription AS NL_ChainLiabilityDescription,
  item.NL_ChainLbltyCnstrctnSiteDesc AS NL_ChainLbltyCnstrctnSiteDesc,
  item.NL_ChainLiabilityDuration AS NL_ChainLiabilityDuration,
  item.NL_ChainLiabilityPercent AS NL_ChainLiabilityPercent
FROM I_SupplierInvoiceItemPurOrdRef AS item
LEFT OUTER JOIN A_SupplierInvoice AS _SupplierInvoice ON SupplierInvoice = _SupplierInvoice.SupplierInvoice AND FiscalYear = _SupplierInvoice.FiscalYear  -- association [1..1]
LEFT OUTER JOIN A_SuplrInvcItemAcctAssgmt AS _SupplierInvoiceItmAcctAssgmt ON SupplierInvoice = _SupplierInvoiceItmAcctAssgmt.SupplierInvoice AND FiscalYear = _SupplierInvoiceItmAcctAssgmt.FiscalYear AND SupplierInvoiceItem = _SupplierInvoiceItmAcctAssgmt.SupplierInvoiceItem  -- association [0..*]
;