I_InvoiceList

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_InvoiceList.
-- 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_InvoiceList AS
SELECT
  cast(BillingDocument as vbeln_rl preserving type) AS InvoiceList,
  SDDocumentCategory,
  cast(BillingDocumentType as invoicelisttype preserving type) AS InvoiceListType,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  LastChangeDateTime,
  LogicalSystem,
  SalesOrganization,
  DistributionChannel,
  Division,
  BillingDocumentDate AS InvoiceListBillingDate,
  cast(BillingDocumentIsCancelled as invoice_list_is_canceled preserving type) AS InvoiceListIsCancelled,
  cast(CancelledBillingDocument as canceled_invoice_list preserving type) AS CancelledInvoiceList,
  cast(BillingDocCombinationCriteria as invoice_list_comb_criteria preserving type) AS InvoiceListCombinationCriteria,
  TotalNetAmount,
  TransactionCurrency,
  StatisticsCurrency,
  TotalTaxAmount,
  CustomerPriceGroup,
  PriceListType,
  TaxDepartureCountry,
  VATRegistration,
  VATRegistrationOrigin,
  VATRegistrationCountry,
  CustomerTaxClassification1,
  CustomerTaxClassification2,
  CustomerTaxClassification3,
  CustomerTaxClassification4,
  CustomerTaxClassification5,
  CustomerTaxClassification6,
  CustomerTaxClassification7,
  CustomerTaxClassification8,
  CustomerTaxClassification9,
  IsEUTriangularDeal,
  SDPricingProcedure,
  ShippingCondition,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  PayerParty,
  ContractAccount,
  CustomerPaymentTerms,
  PaymentMethod,
  PaymentReference,
  FixedValueDate,
  AdditionalValueDays,
  SEPAMandate,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  FiscalPeriod,
  CustomerAccountAssignmentGroup,
  AccountingExchangeRateIsSet,
  AccountingExchangeRate,
  ExchangeRateDate,
  ExchangeRateType,
  DocumentReferenceID,
  AssignmentReference,
  DunningArea,
  DunningBlockingReason,
  DunningKey,
  InternalFinancialDocument,
  SoldToParty,
  PartnerCompany,
  PurchaseOrderByCustomer,
  CustomerGroup,
  Country,
  CityCode,
  SalesDistrict,
  Region,
  County,
  CreditControlArea,
  PricingDocument,
  OverallSDProcessStatus,
  AccountingPostingStatus,
  AccountingTransferStatus,
  OvrlItmGeneralIncompletionSts,
  OverallPricingIncompletionSts
FROM I_BillingDocumentBasic
LEFT OUTER JOIN I_InvoiceListItem AS _Item ON InvoiceList = _Item.InvoiceList  -- association [0..*]
LEFT OUTER JOIN I_InvoiceListPartner AS _Partner ON InvoiceList = _Partner.InvoiceList  -- association [1..*]
LEFT OUTER JOIN I_InvoiceListPrcgElmnt AS _PricingElement ON InvoiceList = _PricingElement.InvoiceList  -- association [0..*]
LEFT OUTER JOIN I_InvoiceListType AS _InvoiceListType ON InvoiceListType = _InvoiceListType.InvoiceListType  -- association [1..1]
LEFT OUTER JOIN I_InvoiceList AS _CancelledInvoiceList ON CancelledInvoiceList = _CancelledInvoiceList.InvoiceList  -- association [0..1]
LEFT OUTER JOIN I_InvoiceListEnhancedFields AS _EnhancedFields ON InvoiceList = _EnhancedFields.InvoiceList  -- association [1..1]
;