R_SuplrBillgDoc

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 R_SuplrBillgDoc.
-- 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 R_SuplrBillgDoc AS
SELECT
  cast( SettlmtMgmtDoc as wlf_suplr_billg_doc preserving type ) AS SuplrBillgDoc,
  SettlmtDocType,
  SettlmtDocCat,
  SettlmtProcessType,
  LogisticsDataEntryCat,
  SettlmtCat,
  PostingDate,
  SettlmtMgmtAcctgTransfSts AS SuplrBillgDocAcctgTransfSts,
  DocumentDate,
  DocumentReferenceID,
  AssignmentReference,
  SettlmtApplSts,
  SettlmtApplStsGrp,
  cast( SupplierPricingProcedure as wlf_kalsm preserving type ) AS PricingProcedure,
  cast( SupplierPricingDocument as wlf_knumv preserving type ) AS PricingDocument,
  InvoicingParty,
  PayeeParty,
  AlternativeInvoicingParty,
  cast( CompanyCode as fis_bukrs preserving type ) AS CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  SettlmtDocCurrency AS SuplrBillgDocCurrency,
  ExchangeRate,
  ExchangeRateType,
  ExchangeRateIsFixed,
  ExchangeRateDate,
  cast( SupplierTotalGrossAmount as brtwr_lf preserving type ) AS SuplrBillgDocTotalGrossAmount,
  cast( SupplierTotalNetAmount as netwr_lf preserving type ) AS SuplrBillgDocTotalNetAmount,
  cast( SupplierTotalTaxAmount as wlf_mwsbk preserving type ) AS SuplrBillgDocTotalTaxAmount,
  SupplierPaymentTerms AS PaymentTerms,
  SupplierCashDiscount1Days AS CashDiscount1Days,
  SupplierCashDiscount2Days AS CashDiscount2Days,
  SupplierNetPaymentDays AS NetPaymentDays,
  SupplierCashDiscount1Percent AS CashDiscount1Percent,
  SupplierCashDiscount2Percent AS CashDiscount2Percent,
  SupplierPaymentMethod AS PaymentMethod,
  cast( SuplrTotEligibleAmtForCshDisc as wlf_total_skfbp preserving type ) AS SuplrTotEligibleAmtForCshDisc,
  cast( SettlmtMgmtDocIsCancelled as wlf_fksto_a preserving type ) AS SuplrBillgDocIsReversed,
  CancelledSettlmtMgmtDoc AS RvsdSuplrBillgDoc,
  cast( SupplierAdditionalValueDays as wlf_valtg preserving type ) AS AdditionalValueDays,
  cast( SupplierFixedValueDate as wlf_valdt preserving type ) AS FixedValueDate,
  SupplyingCountry,
  StateCentralBankPaymentReason,
  TaxDepartureCountry,
  TaxDestinationCountry,
  IsEUTriangularDeal,
  SettlmtCoCodeTaxCountry,
  cast( SupplierVATRegistration as farp_stceg preserving type ) AS VATRegistration,
  CreditControlArea,
  SettlmtDocActivityReason AS SuplrBillgDocActivityReason,
  PaymentReference,
  cast( SupplierPaymentCurrency as wlf_pycur preserving type ) AS SuplrBillgDocPaymentCurrency,
  cast( SupplierPaytCurrencyExchRate as wlf_kurs_py_no_cnext preserving type ) AS SuplrBillgDocPaytCrcyExchRate,
  OneTimeSupplierAddressID,
  SettlmtReltdRefDocCat,
  SettlmtReltdRefDoc,
  CndnContrType,
  SettlmtReltdCndnContr,
  SettlmtReltdTrdgContr,
  FiscalPeriod,
  SettlmtDate,
  SettlmtMgmtDocIncmpltnsRsn AS SuplrBillgDocIncmpltnsRsn,
  SettlmtDocSmmrznCat,
  TrdgExpnSettlmtDoc,
  SettlmtClassificationCat,
  TrdgExpnDocSettled,
  TrdgExpnCurrency,
  TrdgExpnAmount,
  TrdgExpnSupplier,
  DocIntrastatRelevance,
  IntrastatDeclnGdsFlwCat,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  SettlmtBusProcVar,
  SettlmtBusProcCat,
  SEPAMandate,
  TotalSettlmtQuantityUnit,
  TotalSettlmtWeightUnit,
  TotalSettlmtVolumeUnit,
  TotalSettlmtPointsQtyUnit,
  TotalSettlmtQuantity,
  TotalSettlmtNetWeight,
  TotalSettlmtGrossWeight,
  TotalSettlmtVolume,
  TotalSettlmtPointsQty,
  SettlmtMgmtOutpCat AS SuplrBillgDocOutpCat
FROM R_SettlmtMgmtDoc
LEFT OUTER JOIN R_SuplrBillgDocItem AS _SuplrBillgDocItem ON SuplrBillgDoc = _SuplrBillgDocItem.SuplrBillgDoc  -- association [0..*]
LEFT OUTER JOIN I_SuplrBillgDocPlainLongText AS _SuplrBillgDocPlainLongText ON SuplrBillgDoc = _SuplrBillgDocPlainLongText.SuplrBillgDoc  -- association [0..*]
LEFT OUTER JOIN I_SettlmtMgmtAcctgTransfSts AS _SuplrBillgDocAcctgTransfSts ON SuplrBillgDocAcctgTransfSts = _SuplrBillgDocAcctgTransfSts.SettlmtMgmtAcctgTransfSts  -- association [0..1]
LEFT OUTER JOIN R_SuplrBillgDocPartner AS _SuplrBillgDocPartner ON SuplrBillgDoc = _SuplrBillgDocPartner.SuplrBillgDoc  -- association [0..*]
LEFT OUTER JOIN R_SuplrBillgDocBankData AS _SuplrBillgDocBankData ON SuplrBillgDoc = _SuplrBillgDocBankData.SuplrBillgDoc  -- association [0..*]
LEFT OUTER JOIN R_SuplrBillgDocPrcgElmnt AS _SuplrBillgDocPrcgElmnt ON SuplrBillgDoc = _SuplrBillgDocPrcgElmnt.SuplrBillgDoc  -- association [0..*]
LEFT OUTER JOIN I_SupplierCompany AS _InvoicingPartyCompany ON InvoicingParty = _InvoicingPartyCompany.Supplier AND CompanyCode = _InvoicingPartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _PayeePartyCompany ON PayeeParty = _PayeePartyCompany.Supplier AND CompanyCode = _PayeePartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _AltvInvoicingPartyCompany ON AlternativeInvoicingParty = _AltvInvoicingPartyCompany.Supplier AND CompanyCode = _AltvInvoicingPartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _SuplrBillgDocCurrency ON SuplrBillgDocCurrency = _SuplrBillgDocCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_PaymentTerms AS _PaymentTerms ON PaymentTerms = _PaymentTerms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN R_SuplrBillgDoc AS _RvsdSuplrBillgDoc ON RvsdSuplrBillgDoc = _RvsdSuplrBillgDoc.SuplrBillgDoc  -- association [0..1]
LEFT OUTER JOIN I_CreditControlAreaText AS _CreditControlAreaText ON CreditControlArea = _CreditControlAreaText.CreditControlArea  -- association [0..*]
LEFT OUTER JOIN I_SettlmtActivityReasonCode AS _SuplrBillgDocActivityReason ON SuplrBillgDocActivityReason = _SuplrBillgDocActivityReason.SettlmtActivityReason  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _SuplrBillgDocPaymentCurrency ON SuplrBillgDocPaymentCurrency = _SuplrBillgDocPaymentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtDocIncmpltnsRsnCd AS _SuplrBillgDocIncmpltnsRsn ON SuplrBillgDocIncmpltnsRsn = _SuplrBillgDocIncmpltnsRsn.SettlmtMgmtDocIncmpltnsRsn  -- association [0..1]
LEFT OUTER JOIN R_SuplrBillgDoc AS _TrdgExpnSettlmtDoc ON TrdgExpnSettlmtDoc = _TrdgExpnSettlmtDoc.SuplrBillgDoc  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtOutpCat AS _SuplrBillgDocOutpCat ON SuplrBillgDocOutpCat = _SuplrBillgDocOutpCat.SettlmtMgmtOutpCat  -- association [0..1]
LEFT OUTER JOIN E_SettlmtMgmtDoc AS _Extension ON SuplrBillgDoc = _Extension.SettlmtMgmtDoc  -- association [1..1]
;