C_SuplrInvcItm

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 C_SuplrInvcItm.
-- 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: CPURGDOCITMINV

CREATE VIEW C_SuplrInvcItm AS
SELECT
  SupplierInvoice,
  SupplierInvoiceItem,
  FiscalYear,
  OrdinalNumber,
  SupplierInvoiceWithItem,
  MaterialDocumentItemText,
  Material,
  _Material._Text[1: Language = $session.system_language ].MaterialName AS MaterialName,
  PurchaseOrder,
  FormattedPurchaseOrderItem,
  PurchaseOrderHistIsDisplayed,
  PurgDocItemInvoicedQuantity,
  SupplierInvoiceItemAmount,
  Quantity,
  InvoicedAmount,
  _SupplierInvoiceStsAndOrign.InvoiceStatusAndOrigin AS Status,
  ObjectType,
  CostCenter,
  _CostCenter._Text[1: Language = $session.system_language ].CostCenterName AS CostCenterName,
  ControllingArea,
  SalesOrder,
  SalesOrderItem,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  DebitCreditCode,
  _DebitCreditText._Text[1: Language = $session.system_language ].DebitCreditCodeName AS DebitCreditCodeName,
  case when _PurOrdItem._PurchaseOrder.Supplier is null or _PurOrdItem._PurchaseOrder.Supplier = '' then InvoicingParty else _PurOrdItem._PurchaseOrder.Supplier end as Supplier AS SupplierendasSupplier,
  _PurOrdItem.IncotermsClassification AS IncotermsClassification,
  _PurOrdItem._IncotermsClassification._Text[1: Language = $session.system_language ].IncotermsClassificationName AS IncotermsClassificationName,
  _PurOrdItem.OverallLimitAmount AS OverallLimitAmount,
  _PurOrdItem.Plant AS Plant,
  _PurOrdItem._Plant.PlantName AS PlantName,
  _PurOrdItem.IsReturnsItem AS IsReturnsItem,
  TaxCode,
  TaxJurisdiction,
  _PurOrdItem.OrderQuantity AS OrderQuantity,
  _GRCalc.GoodsReceiptQuantity AS GoodsReceiptQty,
  WBSElementExternalID,
  _CustProjectWorkPackagerbco.CustProjWorkPackageFullName AS CustProjWorkPackageFullName,
  PurchaseOrderQuantityUnit,
  DocumentCurrency,
  CompanyCodeCurrency,
  _PurOrdItem.MaterialGroup AS MaterialGroup,
  _PurOrdItem._PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  _PurOrdItem._PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  ServicePerformer,
  PurchaseOrderItem,
  IsEndOfPurposeBlocked,
  WorkItem,
  SupplyingPlant,
  AccountAssignmentCategory,
  PurchasingDocumentItemCategory,
  DeliveryDate,
  PurchasingDocument,
  _PurOrdItem._PurchaseOrder.PurchaseOrderType AS PurchasingDocumentType,
  _PurOrdItem._PurchaseOrder._PurchaseOrderType._Text[1:Language = $session.system_language].PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  _PurOrdItem._Plant AS _Plant,
  _PurOrdItem._IncotermsClassification AS _IncotermsClassification
FROM P_SuplrInvcItm
LEFT OUTER JOIN C_POItemQtyAndValueCalc AS _QtyAndValueCalc ON PurchaseOrder = _QtyAndValueCalc.PurchaseOrder AND PurchaseOrderItem = _QtyAndValueCalc.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN R_PurgDocGoodsReceiptCalc AS _GRCalc ON PurchaseOrder = _GRCalc.PurchaseOrder AND PurchaseOrderItem = _GRCalc.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderItem AS _PurOrdItem ON PurchaseOrder = _PurOrdItem.PurchaseOrder AND PurchaseOrderItem = _PurOrdItem.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_CustomerProjectWorkPackage AS _CustProjectWorkPackagerbco ON WBSElementExternalID = _CustProjectWorkPackagerbco.WBSElementObject  -- association [0..1]
LEFT OUTER JOIN I_SupplierInvoiceStsAndOrign AS _SupplierInvoiceStsAndOrign ON SupplierInvoice = _SupplierInvoiceStsAndOrign.SupplierInvoice AND FiscalYear = _SupplierInvoiceStsAndOrign.FiscalYear  -- association [1..1]
LEFT OUTER JOIN I_SupplierInvoiceStsOriginText AS _SupplierInvoiceStsOriginText ON _SupplierInvoiceStsAndOrign.InvoiceStatusAndOrigin = _SupplierInvoiceStsOriginText.InvoiceStatusAndOrigin AND _SupplierInvoiceStsOriginText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditText ON _DebitCreditText.DebitCreditCode = DebitCreditCode  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea AND _CostCenter.ValidityStartDate <= $session.system_date AND _CostCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
;