I_PayablesFinancingOrder

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_PayablesFinancingOrder.
-- 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_PayablesFinancingOrder AS
SELECT
  finord_uuid AS PayablesFinancingOrderUUID,
  finord_id AS PayablesFinancingOrder,
  financing_type AS PayablesFinancingType,
  financing_system AS PayablesFinancingSystem,
  finord_status AS PayablesFinancingOrderStatus,
  finord_amt AS PyblsFinancedAmtInFincgOrdCrcy,
  finord_curr AS PayablesFinancingOrderCurrency,
  external_id AS PyblsFinancingOrderExternalID,
  is_crdit_note_netting AS PyblsFincgOrdIsCrdtNoteNetting,
  supplier_id AS Supplier,
  paying_company_code AS PayingCompanyCode,
  _PayingCompanyCode.Country AS CompanyCodeCountry,
  net_due_date AS NetDueDate,
  funder_id AS PayablesFinancingFunder,
  funder_bank_type AS PayablesFinancingFunderBkType,
  funder_bank_hash AS PayablesFinancingFunderBkHash,
  financing_discount_type AS PayablesFinancingDiscountType,
  payment_terms AS PaymentTerms,
  finord_cshdisc_amt AS PyblsFincgOrdCshDiscAmt,
  baseline_date AS DueCalculationBaseDate,
  cash_discount_1days AS CashDiscount1Days,
  cash_discount_2days AS CashDiscount2Days,
  net_payment_days AS NetPaymentDays,
  cash_discount_1percent AS CashDiscount1Percent,
  cash_discount_2percent AS CashDiscount2Percent,
  document_reference_id AS DocumentReferenceID,
  payment_method AS PaymentMethod,
  createdby AS CreatedByUser,
  creationat AS CreationDateTime,
  lastchangedby AS LastChangedByUser,
  lastchangedat AS LastChangeDateTime,
  xblocked AS PyblsFincgBizPrpsIsCmpltd
FROM fpf_order
LEFT OUTER JOIN I_PayablesFinancingOrderStatus AS _PayablesFinancingOrderStatus ON PayablesFinancingOrderStatus = _PayablesFinancingOrderStatus.PayablesFinancingOrderStatus  -- association [0..1]
LEFT OUTER JOIN I_PayablesFinancingType AS _PayablesFinancingType ON PayablesFinancingType = _PayablesFinancingType.PayablesFinancingType  -- association [0..1]
LEFT OUTER JOIN I_PyblsFincgDiscountType AS _PyblsFincgDiscountType ON PayablesFinancingDiscountType = _PyblsFincgDiscountType.PayablesFinancingDiscountType  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _PayingCompanyCode ON PayingCompanyCode = _PayingCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByContactCard ON CreatedByUser = _CreatedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByContactCard ON LastChangedByUser = _LastChangedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Funder ON PayablesFinancingFunder = _Funder.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON PayablesFinancingOrderCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_PaymentTerms AS _PaymentTerms ON PaymentTerms = _PaymentTerms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_PaymentMethod AS _PaymentMethod ON CompanyCodeCountry = _PaymentMethod.Country AND PaymentMethod = _PaymentMethod.PaymentMethod  -- association [0..1]
LEFT OUTER JOIN I_Country AS _CompanyCodeCountry ON CompanyCodeCountry = _CompanyCodeCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_SupplierBankDetails AS _FunderBankDetails ON PayablesFinancingFunder = _FunderBankDetails.Supplier AND PayablesFinancingFunderBkType = _FunderBankDetails.BPBankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_PayablesFinancingOrderItem AS _PayablesFinancingOrderItem ON /* condition not available in parsed metadata */  -- association [0..*]
;