P_SuplrInvcItmQtyVariancePred

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 P_SuplrInvcItmQtyVariancePred.
-- 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: PSIQTYVARPRED

CREATE VIEW P_SuplrInvcItmQtyVariancePred AS
SELECT
  rseg.belnr AS SupplierInvoice,
  rseg.gjahr AS FiscalYear,
  rseg.buzei AS SupplierInvoiceItem,
  rseg.ebeln AS PurchaseOrder,
  rseg.ebelp AS PurchaseOrderItem,
  rseg.matnr AS Material,
  rseg.bwkey AS ValuationArea,
  rseg.bwtar AS InventoryValuationType,
  rseg.bukrs AS CompanyCode,
  rseg.werks AS ReceivingPlant,
  rseg.wrbtr AS SupplierInvoiceItemAmount,
  rseg.shkzg AS DebitCreditCode,
  rseg.mwskz AS TaxCode,
  rseg.txjcd AS TaxJurisdiction,
  rseg.menge AS Quantity,
  rseg.bstme AS PurchaseOrderQuantityUnit,
  rseg.bpmng AS QtyInPurchaseOrderPriceUnit,
  rseg.bprme AS PurchaseOrderPriceUnit,
  rseg.pstyp AS PurchasingDocumentItemCategory,
  rseg.knttp AS AccountAssignmentCategory,
  rseg.bklas AS MaterialValuationClass,
  rseg.tbtkz AS IsSubsequentDebitCredit,
  rseg.spgrp AS SuplrInvcItemHasPriceVariance,
  rseg.spgrt AS SuplrInvcItemHasDateVariance,
  rseg.spgrg AS SuplrInvcItemHasOrdPrcQtyVarc,
  rseg.spgrv AS SuplrInvcItemHasProjBdgtVarc,
  rseg.spgrq AS SuplrInvcItemHasOtherVariance,
  rseg.spgrs AS SuplrInvcItemHasAmountOutsdTol,
  rseg.spgrc AS SuplrInvcItmHasQualityVariance,
  rseg.xlifo AS IsLIFOAndFIFORelevant,
  rseg.matbf AS StockIdentifyingMaterial,
  rseg.rbmng AS QuantityAsPerInvoicingParty,
  rseg.rbwwr AS AmountAsPerInvoicingParty,
  rseg.lfehl AS SuplrInvcVerificatSuplrErrType,
  rseg.sgtxt AS SupplierPostingLineItemText,
  rseg.kzmek AS SuplrInvcItemCorrectionInd,
  rseg.complaint_reason AS SupplierInvoiceComplaintReason,
  rseg.retamt_fc AS RetentionAmountInDocCurrency,
  rseg.retpc AS RetentionPercentage,
  rseg.retduedt AS RetentionDueDate,
  rseg.producttype AS ProductType,
  rseg.sgt_scat AS StockSegment,
  _SI_CASH_DISC_DATE.cpudt AS CreationDate,
  _SI_CASH_DISC_DATE.cputm AS CreationTime,
  _SI_CASH_DISC_DATE.zterm AS PaymentTerms,
  _SI_CASH_DISC_DATE.zfbdt AS DueCalculationBaseDate,
  _SI_CASH_DISC_DATE.zbd1t AS CashDiscount1Days,
  _SI_CASH_DISC_DATE.zbd1p AS CashDiscount1Percent,
  _SI_CASH_DISC_DATE.zbd2t AS CashDiscount2Days,
  _SI_CASH_DISC_DATE.zbd2p AS CashDiscount2Percent,
  _SI_CASH_DISC_DATE.zbd3t AS NetPaymentDays,
  _SI_CASH_DISC_DATE.LIFNR_RBKP AS InvoicingParty,
  ekko.aedat AS PurchaseOrderCreationDate,
  ekko.ekorg AS PurchasingOrganization,
  ekko.ekgrp AS PurchasingGroup,
  ekko.bedat AS PurchaseOrderDate,
  ekko.kdatb AS ValidityStartDate,
  ekko.kdate AS ValidityEndDate,
  ekko.llief AS SupplyingSupplier,
  ekko.kunnr AS Customer,
  ekko.inco1 AS IncotermsPart1,
  ekko.inco2 AS IncotermsPart2,
  ekko.inco2_l AS IncotermsLocation1,
  ekko.inco3_l AS IncotermsLocation2,
  ekko.lifre AS Supplier,
  ekko.dptyp AS DownPaymentType,
  ekko.dppct AS DownPaymentPercentageOfTotAmt,
  ekko.dpamt AS DownPaymentAmount,
  ekko.dpdat AS DownPaymentDueDate,
  ekko.vsart AS ShippingType,
  ekko.shipcond AS ShippingCondition,
  rseg.spgrm AS SuplrInvcItemHasQtyVariance,
  _SI_CASH_DISC_DATE.EarliestCashDiscountDate AS EarliestCashDiscountDate,
  cast('' as char1 ) AS SuplrInvcIsGROnTimeForCashDisc
FROM rseg
INNER JOIN P_SUPINV_CASH_DISCOUNT_DATE AS _SI_CASH_DISC_DATE ON /* join condition not captured in parsed metadata */
INNER JOIN ekpo ON /* join condition not captured in parsed metadata */
INNER JOIN ekko ON /* join condition not captured in parsed metadata */
;