P_Prchinforecords_FS

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 P_Prchinforecords_FS.
-- 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: PPRCHINFORECORDS

CREATE VIEW P_Prchinforecords_FS AS
SELECT
  infnr AS PurchasingInfoRecord,
  UserName.PersonFullName AS PersonFullName,
  cast(Manufacturer.name1 as migo_mfrname preserving type) AS ManufacturerName,
  MaterialGroupText.MaterialGroupName AS MaterialGroupName,
  ProductDescription.ProductDescription AS ProductDescription,
  PriorSupplier.name1 AS PriorSupplierName,
  PrchinInfoRecords.lifnr AS Supplier,
  Material.ProductGroup AS MaterialGroup,
  PrchinInfoRecords.matnr AS Material,
  PrchinInfoRecords.erdat AS CreationDate,
  loekz AS IsDeleted,
  txz01 AS PurchasingInfoRecordDesc,
  PrchinInfoRecords.meins AS PurgDocOrderQuantityUnit,
  umrez AS OrderItemQtyToBaseQtyNmrtr,
  umren AS OrderItemQtyToBaseQtyDnmntr,
  idnlf AS SupplierMaterialNumber,
  verkf AS SupplierRespSalesPersonName,
  PrchinInfoRecords.telf1 AS SupplierPhoneNumber,
  lmein AS BaseUnit,
  wglif AS SupplierMaterialGroup,
  kolif AS PriorSupplier,
  lifab AS AvailibilityStartDate,
  lifbi AS AvailibilityEndDate,
  PrchinInfoRecords.vabme AS VarblPurOrdUnitStatus,
  PrchinInfoRecords.mfrnr AS Manufacturer,
  relif AS IsRegularSupplier,
  PrchinInfoRecords.ernam AS CreatedByUser,
  anzpu AS ProductPurchasePointsQty,
  punei AS ProductPurchasePointsQtyUnit,
  ltsnr AS SupplierSubrange,
  Language.Language AS Language,
  Concat(concat(concat_with_space(Language.SupplierName , '(', 1),ltrim(Supplier, '0')),')') AS PreferredSupplierName,
  Material.AuthorizationGroup AS AuthorizationGroup
FROM eina AS PrchinInfoRecords
LEFT OUTER JOIN I_Product AS Material ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Usercontactcard_Fs AS UserName ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN lfa1 AS PriorSupplier ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN lfa1 AS Manufacturer ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Prchinforecordslang_Fs AS Language ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductDescription AS ProductDescription ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialGroupText AS MaterialGroupText ON /* join condition not captured in parsed metadata */
;