A_SupplierInvoice

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_SupplierInvoice.
-- 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: ASUPPLIERINVOICE

CREATE VIEW A_SupplierInvoice AS
SELECT
  SupplierInvoice,
  FiscalYear,
  CompanyCode,
  DocumentDate,
  PostingDate,
  CreationDate,
  cast( SuplrInvcLastChangeDateTime as mmiv_si_lastchangedatetime_txt ) AS SuplrInvcLstChgDteTmeTxt,
  SupplierInvoiceIDByInvcgParty,
  InvoicingParty,
  DocumentCurrency,
  InvoiceGrossAmount,
  UnplannedDeliveryCost,
  DocumentHeaderText,
  ReconciliationAccount,
  ManualCashDiscount,
  PaymentTerms,
  DueCalculationBaseDate,
  CashDiscount1Percent,
  CashDiscount1Days,
  CashDiscount2Percent,
  CashDiscount2Days,
  NetPaymentDays,
  PaymentBlockingReason,
  AccountingDocumentType,
  BPBankAccountInternalID,
  SupplierInvoiceStatus,
  StateCentralBankPaymentReason,
  SupplyingCountry,
  PaymentMethod,
  PaymentMethodSupplement,
  PaymentReference,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  FixedCashDiscount,
  UnplannedDeliveryCostTaxCode,
  UnplndDelivCostTaxJurisdiction,
  UnplndDeliveryCostTaxCountry,
  AssignmentReference,
  SupplierPostingLineItemText,
  TaxIsCalculatedAutomatically,
  BusinessPlace,
  BusinessSectionCode,
  BusinessArea,
  SuplrInvcIsCapitalGoodsRelated,
  PaytSlipWthRefSubscriber,
  PaytSlipWthRefCheckDigit,
  PaytSlipWthRefReference,
  TaxDeterminationDate,
  TaxReportingDate,
  TaxFulfillmentDate,
  InvoiceReceiptDate,
  DeliveryOfGoodsReportingCntry,
  SupplierVATRegistration,
  IsEUTriangularDeal,
  SuplrInvcDebitCrdtCodeDelivery,
  SuplrInvcDebitCrdtCodeReturns,
  RetentionDueDate,
  PaymentReason,
  HouseBank,
  HouseBankAccount,
  AlternativePayeePayer,
  IsEndOfPurposeBlocked,
  SupplierInvoiceOrigin,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  cast( '' as mmiv_is_reversal ) AS IsReversal,
  cast( '' as mmiv_is_reversed ) AS IsReversed,
  cast( '' as mmiv_payment_status ) AS SupplierInvoicePaymentStatus,
  cast( '' as mm_approval_status ) AS SupplierInvoiceApprovalStatus,
  IN_GSTPartner,
  IN_GSTPlaceOfSupply,
  IN_InvoiceReferenceNumber,
  JrnlEntryCntrySpecificRef1,
  JrnlEntryCntrySpecificDate1,
  JrnlEntryCntrySpecificRef2,
  JrnlEntryCntrySpecificDate2,
  JrnlEntryCntrySpecificRef3,
  JrnlEntryCntrySpecificDate3,
  JrnlEntryCntrySpecificRef4,
  JrnlEntryCntrySpecificDate4,
  JrnlEntryCntrySpecificRef5,
  JrnlEntryCntrySpecificDate5,
  JrnlEntryCntrySpecificBP1,
  JrnlEntryCntrySpecificBP2
FROM I_SupplierInvoice
LEFT OUTER JOIN A_SupplierInvoiceTax AS _SupplierInvoiceTax ON SupplierInvoice = _SupplierInvoiceTax.SupplierInvoice AND FiscalYear = _SupplierInvoiceTax.FiscalYear  -- association [0..*]
LEFT OUTER JOIN A_SuplrInvcHeaderWhldgTax AS _SupplierInvoiceWhldgTax ON SupplierInvoice = _SupplierInvoiceWhldgTax.SupplierInvoice AND FiscalYear = _SupplierInvoiceWhldgTax.FiscalYear  -- association [0..*]
LEFT OUTER JOIN A_SupplierInvoiceItemGLAcct AS _SupplierInvoiceItemGLAcct ON SupplierInvoice = _SupplierInvoiceItemGLAcct.SupplierInvoice AND FiscalYear = _SupplierInvoiceItemGLAcct.FiscalYear  -- association [0..*]
LEFT OUTER JOIN A_SuplrInvcItemPurOrdRef AS _SuplrInvcItemPurOrdRef ON SupplierInvoice = _SuplrInvcItemPurOrdRef.SupplierInvoice AND FiscalYear = _SuplrInvcItemPurOrdRef.FiscalYear  -- association [0..*]
LEFT OUTER JOIN A_SupplierInvoiceItemMaterial AS _SuplrInvcItemMaterial ON SupplierInvoice = _SuplrInvcItemMaterial.SupplierInvoice AND FiscalYear = _SuplrInvcItemMaterial.FiscalYear  -- association [0..*]
LEFT OUTER JOIN A_SupplierInvoiceItemAsset AS _SuplrInvcItemAsset ON SupplierInvoice = _SuplrInvcItemAsset.SupplierInvoice AND FiscalYear = _SuplrInvcItemAsset.FiscalYear  -- association [0..*]
LEFT OUTER JOIN A_SuplrInvcSeldPurgDocument AS _SelectedPurchaseOrders ON SupplierInvoice = _SelectedPurchaseOrders.SupplierInvoice AND FiscalYear = _SelectedPurchaseOrders.FiscalYear  -- association [0..*]
LEFT OUTER JOIN A_SuplrInvcSeldInbDeliveryNote AS _SelectedDeliveryNotes ON SupplierInvoice = _SelectedDeliveryNotes.SupplierInvoice AND FiscalYear = _SelectedDeliveryNotes.FiscalYear  -- association [0..*]
LEFT OUTER JOIN A_SuplrInvcSeldSrvcEntrShtLean AS _SelectedServiceEntrySheets ON SupplierInvoice = _SelectedServiceEntrySheets.SupplierInvoice AND FiscalYear = _SelectedServiceEntrySheets.FiscalYear  -- association [0..*]
LEFT OUTER JOIN A_SuplrInvoiceAdditionalData AS _SuplrInvoiceAdditionalData ON SupplierInvoice = _SuplrInvoiceAdditionalData.SupplierInvoice AND FiscalYear = _SuplrInvoiceAdditionalData.FiscalYear  -- association [1..1]
LEFT OUTER JOIN A_SupplierInvoiceODN AS _SupplierInvoiceODN ON SupplierInvoice = _SupplierInvoiceODN.SupplierInvoice AND FiscalYear = _SupplierInvoiceODN.FiscalYear  -- association [1..*]
LEFT OUTER JOIN A_BR_SupplierInvoiceNFDocument AS _BR_SupplierInvoiceNFDocument ON SupplierInvoice = _BR_SupplierInvoiceNFDocument.SupplierInvoice AND FiscalYear = _BR_SupplierInvoiceNFDocument.FiscalYear  -- association [0..1]
LEFT OUTER JOIN E_SupplierInvoice AS _HeaderExtension ON SupplierInvoice = _HeaderExtension.SupplierInvoice AND FiscalYear = _HeaderExtension.FiscalYear  -- association [0..1]
;