I_SupplierPurchasingData

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_SupplierPurchasingData.
-- 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_SupplierPurchasingData AS
SELECT
  lifnr AS Supplier,
  ekorg AS PurchasingOrganization,
  ltsnr AS SupplierSubrange,
  werks AS Plant,
  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
FROM lfm2
LEFT OUTER JOIN I_SupplierPurchasingOrg AS _SupplierPurchasingOrg ON Supplier = _SupplierPurchasingOrg.Supplier AND PurchasingOrganization = _SupplierPurchasingOrg.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_SupplierSubrange AS _SupplierSubrange ON Supplier = _SupplierSubrange.Supplier AND SupplierSubrange = _SupplierSubrange.SupplierSubrange  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
;