I_BPSuplrPurchasingDataProcess

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_BPSuplrPurchasingDataProcess.
-- 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_BPSuplrPurchasingDataProcess AS
SELECT
  process_id AS MasterDataChangeProcess,
  process_step_no AS MDChgProcessStep,
  source_system AS MDChgProcessSrceSystem,
  source_id AS MDChgProcessSrceObject,
  ekorg AS PurchasingOrganization,
  ltsnr AS SupplierSubrange,
  werks AS Plant,
  assignment_id AS BPAssignmentID,
  lifnr AS Supplier,
  sperm AS PurchasingIsBlockedForSupplier,
  loevm AS DeletionIndicator,
  lfabc AS SupplierABCClassificationCode,
  waers AS PurchaseOrderCurrency,
  verkf AS SupplierRespSalesPersonName,
  minbw AS MinimumOrderAmount,
  zterm AS PaymentTerms,
  inco1 AS IncotermsClassification,
  inco2 AS IncotermsTransferLocation,
  webre AS InvoiceIsGoodsReceiptBased,
  kzabs AS IsOrderAcknRqd,
  kalsk AS CalculationSchemaGroupCode,
  kzaut AS PurOrdAutoGenerationIsAllowed,
  expvz AS IntrastatCrsBorderTrMode,
  zolla AS PurgOutlineAgrmtCustomsOffice,
  meprf AS PricingDateControl,
  ekgrp AS PurchasingGroup,
  xersy AS EvaldReceiptSettlementIsActive,
  plifz AS PlannedDeliveryDurationInDays,
  mrppp AS MRPPlanningCalendar,
  lfrhy AS PlanningCycle,
  libes AS OrderEntryIsBySupplier,
  lipre AS PriceMarkingAgreement,
  liser AS SupplierIsRackJobbing,
  incov AS IncotermsVersion,
  inco2_l AS IncotermsLocation1,
  inco3_l AS IncotermsLocation2,
  dispo AS MRPResponsible,
  bstae AS SupplierConfirmationControlKey,
  rdprf AS RoundingProfile,
  megru AS ProductUnitGroup,
  xersr AS AutomaticEvaluatedRcptSettlmt,
  paprf AS ProdStockAndSlsDataTransfPrfl,
  xnbwy AS SuplrInvcRevalIsAllowed,
  lebre AS InvoiceIsMMServiceEntryBased,
  bolre AS SuplrIsSubjToSubsqntSettlement,
  umsae AS SuplrPurgOrgAgrmtOfBusVolIsRqd,
  telf1 AS SupplierPhoneNumber,
  source_modified AS MDChgProcessSourceModified,
  source_modification_blip AS MDChgProcessSourceModifBinary,
  source_recency AS MDChgProcSrceLastChgdDateTime
FROM lfm2_prc
LEFT OUTER JOIN I_SupplierPurchasingOrg AS _SupplierPurchasingOrg ON Supplier = _SupplierPurchasingOrg.Supplier AND PurchasingOrganization = _SupplierPurchasingOrg.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_SupplierPurchasingData AS _SupplierPurchasingData ON PurchasingOrganization = _SupplierPurchasingData.PurchasingOrganization AND SupplierSubrange = _SupplierPurchasingData.SupplierSubrange AND Plant = _SupplierPurchasingData.Plant  -- association [1..1]
LEFT OUTER JOIN I_BPSupplierProcess AS _Supplier ON lfm2_prc.process_id = _Supplier.MasterDataChangeProcess AND lfm2_prc.process_step_no = _Supplier.MDChgProcessStep AND lfm2_prc.source_system = _Supplier.MDChgProcessSrceSystem AND lfm2_prc.source_id = _Supplier.MDChgProcessSrceObject  -- association [1..1]
;