I_CFinRpldPurchasingDocument

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_CFinRpldPurchasingDocument.
-- 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_CFinRpldPurchasingDocument AS
SELECT
  cfin_av_po_root.fins_logsys AS SenderLogicalSystem,
  cast( cfin_av_po_root.ebeln as fins_cfin_av_purchasing_doc preserving type ) AS CFinRpldPurchasingDocument,
  cfin_av_po_root.bukrs AS CompanyCode,
  cfin_av_po_root.bstyp AS PurchasingDocumentCategory,
  cfin_av_po_root.bsart AS PurchasingDocumentType,
  cfin_av_po_root.bsakz AS PurchasingDocumentSubtype,
  cfin_av_po_root.loekz AS PurchasingDocumentDeletionCode,
  cfin_av_po_root.aedat AS CreationDate,
  cast ( cfin_av_po_root.lifnr as md_supplier preserving type) AS Supplier,
  cast( cfin_av_po_root.zterm as farp_dzterm preserving type) AS PaymentTerms,
  cast (cfin_av_po_root.zbd1t as dzbd1t preserving type) AS CashDiscount1Days,
  cast (cfin_av_po_root.zbd2t as dzbd2t preserving type) AS CashDiscount2Days,
  cast (cfin_av_po_root.zbd3t as dzbd3t preserving type) AS NetPaymentDays,
  cfin_av_po_root.zbd1p AS CashDiscount1Percent,
  cfin_av_po_root.zbd2p AS CashDiscount2Percent,
  cfin_av_po_root.ekorg AS PurchasingOrganization,
  cfin_av_po_root.ekgrp AS PurchasingGroup,
  cfin_av_po_root.waers AS DocumentCurrency,
  cast(abs(cfin_av_po_root.wkurs) as fins_cfin_wkurs_no_conv preserving type) AS ExchangeRate,
  cfin_av_po_root.kufix AS ExchangeRateIsFixed,
  cfin_av_po_root.bedat AS PurchasingDocumentOrderDate,
  cfin_av_po_root.kdatb AS ValidityStartDate,
  cfin_av_po_root.kdate AS ValidityEndDate,
  cfin_av_po_root.llief AS SupplyingSupplier,
  cfin_av_po_root.reswk AS SupplyingPlant,
  cfin_av_po_root.knumv AS PricingDocument,
  cfin_av_po_root.kalsm AS PricingProcedure,
  cfin_av_po_root.lifre AS InvoicingParty,
  cfin_av_po_root.frgrl AS ReleaseIsNotCompleted,
  cfin_av_po_root.lands AS TaxReturnCountry,
  cfin_av_po_root.memory AS PurchasingCompletenessStatus,
  cfin_av_po_root.procstat AS PurchasingProcessingStatus,
  cfin_av_po_root.iuuc_operat_flag AS CFinRpldDeleteArchiveStatus,
  cfin_av_po_root.ernam AS CreatedByUser,
  cfin_av_po_root.iseopblocked AS IsEndOfPurposeBlocked,
  cfin_av_po_root.isaged AS PurchasingDocumentIsAged,
  cfin_av_po_root.revno AS PurchasingDocumentVersion,
  cfin_av_po_root.bukrs_sender AS SenderCompanyCode
FROM cfin_av_po_root
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _PurchasingDocumentCategory ON PurchasingDocumentCategory = _PurchasingDocumentCategory.PurchasingDocumentCategory  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurchasingDocumentType ON PurchasingDocumentCategory = _PurchasingDocumentType.PurchasingDocumentCategory AND PurchasingDocumentType = _PurchasingDocumentType.PurchasingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _SupplyingSupplier ON SupplyingSupplier = _SupplyingSupplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _InvoicingParty ON InvoicingParty = _InvoicingParty.Supplier  -- association [0..1]
LEFT OUTER JOIN I_PaymentTerms AS _PaymentTerms ON PaymentTerms = _PaymentTerms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON DocumentCurrency = _DocumentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _SupplyingPlant ON SupplyingPlant = _SupplyingPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_CFinRpldPurchasingDocItem AS _CFinRpldPurchasingDocItem ON CFinRpldPurchasingDocument = _CFinRpldPurchasingDocItem.CFinRpldPurchasingDocument AND SenderLogicalSystem = _CFinRpldPurchasingDocItem.SenderLogicalSystem  -- association [0..*]
LEFT OUTER JOIN I_TaxCalculationProcedure AS _PricingProcedure ON PricingProcedure = _PricingProcedure.TaxCalculationProcedure  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON SenderLogicalSystem = _LogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN E_CFinRpldPurchasingDocument AS _Extension ON CFinRpldPurchasingDocument = _Extension.CFinRpldPurchasingDocument AND SenderLogicalSystem = _Extension.SourceSystemLogicalSystem  -- association [1..1]
;