I_CentralPurchaseOrder

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_CentralPurchaseOrder.
-- 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: IMMCPURORDER

CREATE VIEW I_CentralPurchaseOrder AS
SELECT
  ekko.ebeln AS PurchaseOrder,
  ekko.extsourcesystem AS ExtSourceSystem,
  ekko.bstyp AS PurchasingDocumentCategory,
  ekko.bsart AS PurchaseOrderType,
  ekko.bsakz AS PurchaseOrderSubtype,
  ekko.bukrs AS CompanyCode,
  ekko.country_code AS CompanyCodeCountry,
  ekko.loekz AS PurchasingDocumentDeletionCode,
  ekko.isaged AS PurchasingDocumentIsAged,
  ekko.pincr AS ItemNumberInterval,
  ekko.upinc AS ItemNumberIntervalForSubItems,
  ekko.statu AS PurchasingDocumentOrigin,
  ekko.frgrl AS ReleaseIsNotCompleted,
  ekko.frgke AS ReleaseCode,
  ekko.frgzu AS PurgReleaseSequenceStatus,
  ekko.lands AS TaxReturnCountry,
  ekko.aedat AS CreationDate,
  ekko.lastchangedatetime AS LastChangeDateTime,
  ekko.extractiondatetime AS ProcmtHubLastExtractionTime,
  ekko.ernam AS CreatedByUser,
  ekko.userdescription AS CreatedByUserName,
  cast ( ekko.lifnr as md_supplier preserving type) AS Supplier,
  ekko.verkf AS SupplierRespSalesPersonName,
  ekko.telf1 AS SupplierPhoneNumber,
  ekko.adrnr AS SupplierAddressID,
  ekko.adrnr AS ManualSupplierAddressID,
  ekko.ekorg AS PurchasingOrganization,
  ekko.ekgrp AS PurchasingGroup,
  cast (ekko.bedat as bedat preserving type) AS PurchaseOrderDate,
  ekko.waers AS DocumentCurrency,
  cast( ekko.wkurs as fis_exchange_rate ) AS ExchangeRate,
  cast(abs(ekko.wkurs) as fis_absolute_exchangerate preserving type ) AS AbsoluteExchangeRate,
  cast(case when ekko.wkurs < 0 then 'X' else ' ' end as fis_indirect_quotation preserving type ) AS ExchRateIsIndirectQuotation,
  cast(case when ekko.wkurs < 0 then division(1, abs(ekko.wkurs), 5 ) else ekko.wkurs end as fis_effective_exchangerate ) AS EffectiveExchangeRate,
  ekko.bedat AS PurchasingDocumentOrderDate,
  ekko.llief AS SupplyingSupplier,
  ekko.reswk AS SupplyingPlant,
  ekko.lifre AS InvoicingParty,
  ekko.kunnr AS Customer,
  ekko.konnr AS PurchaseContract,
  ekko.spras AS Language,
  ekko.absgr AS PurgReasonForDocCancellation,
  ekko.memory AS PurchasingCompletenessStatus,
  ekko.memorytype AS PurchasingDocCompletionStatus,
  ekko.inco1 AS IncotermsClassification,
  ekko.inco2 AS IncotermsTransferLocation,
  cast( zterm as farp_dzterm preserving type) AS PaymentTerms,
  cast (ekko.zbd1t as dzbd1t preserving type) AS CashDiscount1Days,
  cast (ekko.zbd2t as dzbd2t preserving type) AS CashDiscount2Days,
  cast (ekko.zbd3t as dzbd3t preserving type) AS NetPaymentDays,
  ekko.zbd1p AS CashDiscount1Percent,
  ekko.zbd2p AS CashDiscount2Percent,
  ekko.kalsm AS PricingProcedure,
  ekko.ktwrt AS TargetAmount,
  ekko.knumv AS DeliveryDocumentCondition,
  ekko.kdatb AS ValidityStartDate,
  ekko.kdate AS ValidityEndDate,
  ekko.lphis AS ScheduleAgreementHasReleaseDoc,
  ekko.angdt AS QuotationLatestSubmissionDate,
  ekko.bnddt AS BindingPeriodValidityEndDate,
  ekko.ihran AS QuotationSubmissionDate,
  ekko.angnr AS SupplierQuotationExternalID,
  ekko.ausnr AS RequestForQuotation,
  ekko.kufix AS ExchangeRateIsFixed,
  ekko.incov AS IncotermsVersion,
  ekko.inco2_l AS IncotermsLocation1,
  ekko.inco3_l AS IncotermsLocation2,
  ekko.procstat AS PurchasingProcessingStatus,
  ekko.rlwrt AS PurgReleaseTimeTotalAmount,
  ekko.dptyp AS DownPaymentType,
  ekko.dppct AS DownPaymentPercentageOfTotAmt,
  ekko.dpamt AS DownPaymentAmount,
  ekko.dpdat AS DownPaymentDueDate,
  cast ( ekko.description as vdm_purgdoc_name preserving type ) AS PurchasingDocumentName,
  ekko.qtn_erlst_submsn_date AS QuotationEarliestSubmsnDate,
  ekko.bwbdt AS LatestRegistrationDate,
  ekko.ihrez AS CorrespncExternalReference,
  ekko.unsez AS CorrespncInternalReference,
  ekko.followon_doc_cat AS FollowOnDocumentCategory,
  ekko.followon_doc_type AS FollowOnDocumentType,
  ekko.stceg AS VATRegistration,
  ekko.stceg_l AS VATRegistrationCountry,
  ekko.intra_rel AS IsIntrastatReportingRelevant,
  ekko.intra_excl AS IsIntrastatReportingExcluded,
  ekko.iseopblocked AS IsEndOfPurposeBlocked,
  ekko.isnoteavailable AS HasNote,
  ekko.isattachmentavailable AS HasAttachment,
  ekko.numberofoverduepurorders AS NumberOfOverduePurOrders,
  ekko.numberofoverduepurorditm AS NumberOfOverduePurOrdItm,
  ekko.purchaseorderstatus AS PurchaseOrderStatus,
  ekko.purchaseorderstatusname AS PurchaseOrderStatusName,
  ekko.approveruser AS ApproverUser,
  ekko.approvername AS ApproverName,
  ekko.schedulelinedeliverydate AS ScheduleLineDeliveryDate,
  ekko.purordoutputctrltype AS PurOrdOutputCtrlType,
  ekko.purchaseorderoutputstatus AS PurchaseOrderOutputStatus,
  ekko.purchaseorderoutputstatusname AS PurchaseOrderOutputStatusName,
  ekko.purchaseorderoutputdatetime AS PurchaseOrderOutputDateTime,
  ekko.weightedrelevance AS WeightedRelevance,
  ekko.purchaseorderoutputindcode AS PurchaseOrderOutputIndCode,
  ekko.purchaseorderoutputinddesc AS PurchaseOrderOutputIndDesc,
  cast( concat(ekko.ebeln , ekko.extsourcesystem ) as char20 ) AS PrmtHbRpldPOUniqueID
FROM mmpur_ext_ekko AS ekko
LEFT OUTER JOIN I_CentralPurchaseOrderItem AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON DocumentCurrency = _DocumentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;